Table postgres.public.payment_p2007_02 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
payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment.payment_id Implied Constraint R
customer_id int2 5
customer.customer_id payment_p2007_02_customer_id_fkey R
staff_id int2 5
staff.staff_id payment_p2007_02_staff_id_fkey R
rental_id int4 10
rental.rental_id payment_p2007_02_rental_id_fkey R
amount numeric 5,2
payment_date timestamp 29,6

Table contained 2,312 rows at Mon Feb 20 18:07 CET 2023

Indexes:
Column(s) Type Sort Constraint Name
customer_id Performance Asc idx_fk_payment_p2007_02_customer_id
staff_id Performance Asc idx_fk_payment_p2007_02_staff_id

Close relationships  within of separation: