customer

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id serial 10 √ nextval('customer_customer_id_seq'::regclass)
payment.customer_id payment_customer_id_fkeyR
payment_p2007_01.customer_id payment_p2007_01_customer_id_fkeyR
payment_p2007_02.customer_id payment_p2007_02_customer_id_fkeyR
payment_p2007_03.customer_id payment_p2007_03_customer_id_fkeyR
payment_p2007_04.customer_id payment_p2007_04_customer_id_fkeyR
payment_p2007_05.customer_id payment_p2007_05_customer_id_fkeyR
payment_p2007_06.customer_id payment_p2007_06_customer_id_fkeyR
rental.customer_id rental_customer_id_fkeyR
store_id int2 5 null
store.store_id customer_store_id_fkeyR
first_name varchar 45 null
last_name varchar 45 null
email varchar 50 √ null
address_id int2 5 null
address.address_id customer_address_id_fkeyR
activebool bool 1 true
create_date date 13 ('now'::text)::date
last_update timestamp 29,6 √ now()
active int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
customer_pkey Primary key Asc customer_id
idx_fk_address_id Performance Asc address_id
idx_fk_store_id Performance Asc store_id
idx_last_name Performance Asc last_name

Relationships

Close relationships within degrees of separation