payment_p2007_06

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
payment_id serial 10 √ nextval('payment_payment_id_seq'::regclass)
payment.payment_id Implied ConstraintR
customer_id int2 5 null
customer.customer_id payment_p2007_06_customer_id_fkeyR
staff_id int2 5 null
staff.staff_id payment_p2007_06_staff_id_fkeyR
rental_id int4 10 null
rental.rental_id payment_p2007_06_rental_id_fkeyR
amount numeric 5,2 null
payment_date timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
idx_fk_payment_p2007_06_customer_id Performance Asc customer_id
idx_fk_payment_p2007_06_staff_id Performance Asc staff_id

Check Constraints

Constraint Name Constraint
payment_p2007_06_payment_date_check (((payment_date >= '2007-06-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-07-01 00:00:00'::timestamp without time zone)))

Relationships

Close relationships within degrees of separation