Table dellstore2.public.customers Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
customerid serial 10  √  nextval('customers_customerid_seq'::regclass)
cust_hist.customerid fk_cust_hist_customerid C
orders.customerid fk_customerid N
firstname varchar 50
lastname varchar 50
address1 varchar 50
address2 varchar 50  √  null
city varchar 50
state varchar 50  √  null
zip int4 10  √  null
country varchar 50
region int2 5
email varchar 50  √  null
phone varchar 50  √  null
creditcardtype int4 10
creditcard varchar 50
creditcardexpiration varchar 50
username varchar 50
password varchar 50
age int2 5  √  null
income int4 10  √  null
gender varchar 1  √  null

Table contained 20,000 rows at Tue May 24 11:41 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
customerid Primary key Asc customers_pkey
username Must be unique Asc ix_cust_username

Close relationships  within of separation: