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 | Comments |
---|---|---|---|---|---|---|---|
categories | category | serial | 10 | √ | nextval('categories_category_seq'::regclass) | ||
categories | categoryname | varchar | 50 | ||||
cust_hist | customerid | int4 | 10 | ||||
cust_hist | orderid | int4 | 10 | ||||
cust_hist | prod_id | int4 | 10 | ||||
customers | address1 | varchar | 50 | ||||
customers | address2 | varchar | 50 | √ | null | ||
customers | age | int2 | 5 | √ | null | ||
customers | city | varchar | 50 | ||||
customers | country | varchar | 50 | ||||
customers | creditcard | varchar | 50 | ||||
customers | creditcardexpiration | varchar | 50 | ||||
customers | creditcardtype | int4 | 10 | ||||
customers | customerid | serial | 10 | √ | nextval('customers_customerid_seq'::regclass) | ||
customers | varchar | 50 | √ | null | |||
customers | firstname | varchar | 50 | ||||
customers | gender | varchar | 1 | √ | null | ||
customers | income | int4 | 10 | √ | null | ||
customers | lastname | varchar | 50 | ||||
customers | password | varchar | 50 | ||||
customers | phone | varchar | 50 | √ | null | ||
customers | region | int2 | 5 | ||||
customers | state | varchar | 50 | √ | null | ||
customers | username | varchar | 50 | ||||
customers | zip | int4 | 10 | √ | null | ||
inventory | prod_id | int4 | 10 | ||||
inventory | quan_in_stock | int4 | 10 | ||||
inventory | sales | int4 | 10 | ||||
orderlines | orderdate | date | 13 | ||||
orderlines | orderid | int4 | 10 | ||||
orderlines | orderlineid | int4 | 10 | ||||
orderlines | prod_id | int4 | 10 | ||||
orderlines | quantity | int2 | 5 | ||||
orders | customerid | int4 | 10 | √ | null | ||
orders | netamount | numeric | 12,2 | ||||
orders | orderdate | date | 13 | ||||
orders | orderid | serial | 10 | √ | nextval('orders_orderid_seq'::regclass) | ||
orders | tax | numeric | 12,2 | ||||
orders | totalamount | numeric | 12,2 | ||||
products | actor | varchar | 50 | ||||
products | category | int4 | 10 | ||||
products | common_prod_id | int4 | 10 | ||||
products | price | numeric | 12,2 | ||||
products | prod_id | serial | 10 | √ | nextval('products_prod_id_seq'::regclass) | ||
products | special | int2 | 5 | √ | null | ||
products | title | varchar | 50 | ||||
reorder | date_expected | date | 13 | √ | null | ||
reorder | date_low | date | 13 | ||||
reorder | date_reordered | date | 13 | √ | null | ||
reorder | prod_id | int4 | 10 | ||||
reorder | quan_low | int4 | 10 | ||||
reorder | quan_reordered | int4 | 10 | √ | null |