SchemaSpy Analysis of dellstore2.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Tue May 24 11:41 EDT 2016 |
| ||||||
|
dellstore2.public contains 52 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
products | actor | varchar | 50 | |||
customers | address1 | varchar | 50 | |||
customers | address2 | varchar | 50 | √ | null | |
customers | age | int2 | 5 | √ | null | |
categories | category | serial | 10 | √ | nextval('categories_category_seq'::regclass) | |
products | category | int4 | 10 | |||
categories | categoryname | varchar | 50 | |||
customers | city | varchar | 50 | |||
products | common_prod_id | int4 | 10 | |||
customers | country | varchar | 50 | |||
customers | creditcard | varchar | 50 | |||
customers | creditcardexpiration | varchar | 50 | |||
customers | creditcardtype | int4 | 10 | |||
cust_hist | customerid | int4 | 10 | |||
customers | customerid | serial | 10 | √ | nextval('customers_customerid_seq'::regclass) | |
orders | customerid | int4 | 10 | √ | null | |
reorder | date_expected | date | 13 | √ | null | |
reorder | date_low | date | 13 | |||
reorder | date_reordered | date | 13 | √ | null | |
customers | varchar | 50 | √ | null | ||
customers | firstname | varchar | 50 | |||
customers | gender | varchar | 1 | √ | null | |
customers | income | int4 | 10 | √ | null | |
customers | lastname | varchar | 50 | |||
orders | netamount | numeric | 12,2 | |||
orderlines | orderdate | date | 13 | |||
orders | orderdate | date | 13 | |||
cust_hist | orderid | int4 | 10 | |||
orderlines | orderid | int4 | 10 | |||
orders | orderid | serial | 10 | √ | nextval('orders_orderid_seq'::regclass) | |
orderlines | orderlineid | int4 | 10 | |||
customers | password | varchar | 50 | |||
customers | phone | varchar | 50 | √ | null | |
products | price | numeric | 12,2 | |||
cust_hist | prod_id | int4 | 10 | |||
inventory | prod_id | int4 | 10 | |||
orderlines | prod_id | int4 | 10 | |||
products | prod_id | serial | 10 | √ | nextval('products_prod_id_seq'::regclass) | |
reorder | prod_id | int4 | 10 | |||
inventory | quan_in_stock | int4 | 10 | |||
reorder | quan_low | int4 | 10 | |||
reorder | quan_reordered | int4 | 10 | √ | null | |
orderlines | quantity | int2 | 5 | |||
customers | region | int2 | 5 | |||
inventory | sales | int4 | 10 | |||
products | special | int2 | 5 | √ | null | |
customers | state | varchar | 50 | √ | null | |
orders | tax | numeric | 12,2 | |||
products | title | varchar | 50 | |||
orders | totalamount | numeric | 12,2 | |||
customers | username | varchar | 50 | |||
customers | zip | int4 | 10 | √ | null |