inventory

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
inventory_id MEDIUMINT UNSIGNED 8 √ null
rental.inventory_id fk_rental_inventoryR
film_id SMALLINT UNSIGNED 5 null
film.film_id fk_inventory_filmR
store_id TINYINT UNSIGNED 3 null
store.store_id fk_inventory_storeR
last_update TIMESTAMP 26 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc inventory_id
idx_fk_film_id Performance Asc film_id
idx_store_id_film_id Performance Asc/Asc store_id + film_id

Relationships

Close relationships within degrees of separation