Table sakila.rental 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
rental_id int 10  √ 
payment.rental_id fk_payment_rental N
rental_date datetime 19
inventory_id mediumint unsigned 8
inventory.inventory_id fk_rental_inventory R
customer_id smallint unsigned 5
customer.customer_id fk_rental_customer R
return_date datetime 19  √  null
staff_id tinyint unsigned 3
staff.staff_id fk_rental_staff R
last_update timestamp 19 CURRENT_TIMESTAMP

Table contained 16,325 rows at Thu Aug 12 09:42 MDT 2010

Indexes:
Column(s) Type Sort Constraint Name
rental_id Primary key Asc PRIMARY
customer_id Performance Asc idx_fk_customer_id
inventory_id Performance Asc idx_fk_inventory_id
staff_id Performance Asc idx_fk_staff_id
rental_date + inventory_id + customer_id Must be unique Asc/Asc/Asc rental_date

Close relationships  within of separation: