Table sakila.payment 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 smallint unsigned 5  √ 
customer_id smallint unsigned 5
customer.customer_id fk_payment_customer R
staff_id tinyint unsigned 3
staff.staff_id fk_payment_staff R
rental_id int 10  √  null
rental.rental_id fk_payment_rental N
amount decimal 5,2
payment_date datetime 19
last_update timestamp 19 CURRENT_TIMESTAMP

Table contained 15,123 rows at Thu Aug 12 09:42 MDT 2010

Indexes:
Column(s) Type Sort Constraint Name
payment_id Primary key Asc PRIMARY
rental_id Performance Asc fk_payment_rental
customer_id Performance Asc idx_fk_customer_id
staff_id Performance Asc idx_fk_staff_id

Close relationships  within of separation: