SchemaSpy - Table sakila.rental

Generated by
SchemaSpy

Legend:

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

√

payment.rental_id

fk_payment_rental N

rental_date

datetime

inventory_id

mediumint unsigned

inventory.inventory_id

fk_rental_inventory R

customer_id

smallint unsigned

customer.customer_id

fk_rental_customer R

return_date

datetime

√

null

staff_id

tinyint unsigned

staff.staff_id

fk_rental_staff R

last_update

timestamp

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