Table postgres.public.customer 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
customer_id serial 10  √  nextval('customer_customer_id_seq'::regclass)
payment.customer_id payment_customer_id_fkey R
payment_p2007_01.customer_id payment_p2007_01_customer_id_fkey R
payment_p2007_02.customer_id payment_p2007_02_customer_id_fkey R
payment_p2007_03.customer_id payment_p2007_03_customer_id_fkey R
payment_p2007_04.customer_id payment_p2007_04_customer_id_fkey R
payment_p2007_05.customer_id payment_p2007_05_customer_id_fkey R
payment_p2007_06.customer_id payment_p2007_06_customer_id_fkey R
rental.customer_id rental_customer_id_fkey R
store_id int2 5
store.store_id customer_store_id_fkey R
first_name varchar 45
last_name varchar 45
email varchar 50  √  null
address_id int2 5
address.address_id customer_address_id_fkey R
activebool bool 1 true
create_date date 13 ('now'::text)::date
last_update timestamp 29,6  √  now()
active int4 10  √  null

Table contained 599 rows at Mon Feb 20 18:07 CET 2023

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

Close relationships  within of separation: