SchemaSpy Analysis of dellstore2.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 24 11:41 EDT 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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)
customers customerid serial 10  √  nextval('customers_customerid_seq'::regclass)
orders orderid serial 10  √  nextval('orders_orderid_seq'::regclass)
products prod_id serial 10  √  nextval('products_prod_id_seq'::regclass)
products actor varchar 50
customers address1 varchar 50
customers address2 varchar 50  √  null
customers age int2 5  √  null
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
orders customerid int4 10  √  null
reorder date_expected date 13  √  null
reorder date_low date 13
reorder date_reordered date 13  √  null
customers email 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
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
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