Der Video

customer
customer_id SMALLINT(5) store_id TINYINT(3) first_name VARCHAR(45) last_name VARCHAR(45) email VARCHAR(50) address_id SMALLINT(5) active TINYINT(1) create_date DATETIME last_updateTIMESTAMP Indexes Triggers

address
address_id SMALLINT(5) address VARCHAR(50) address2 VARCHAR(50) district VARCHAR(20) city_id SMALLINT(5) postal_code VARCHAR(10) phone VARCHAR(20) last_update TIMESTAMPIndexes

city
city_id SMALLINT(5) city VARCHAR(50) country_id SMALLINT(5) last_update TIMESTAMP Indexes

country
country_id SMALLINT(5) country VARCHAR(50) last_update TIMESTAMP Indexesfilm_text rental
rental_id INT(11) rental_date DATETIME inventory_id MEDIUMINT(8) customer_id SMALLINT(5) film_id SMALLINT(6) title VARCHAR(255) description TEXT Indexes

staff
staff_id TINYINT(3)first_name VARCHAR(45) last_name VARCHAR(45) address_id SMALLINT(5) picture BLOB email VARCHAR(50) store_id TINYINT(3) active TINYINT(1) username VARCHAR(16) password VARCHAR(40) last_update TIMESTAMPreturn_date DATETIME staff_id TINYINT(3) last_update TIMESTAMP Indexes Triggers

nicer_but_slower_film_list staff_list

actor_info

inventory
inventory_id MEDIUMINT(8) film_id SMALLINT(5)store_id TINYINT(3) last_update TIMESTAMP Indexes

sales_by_store

film_list sales_by_film_category customer_list category
category_id TINYINT(3) name VARCHAR(25) last_update TIMESTAMP Indexespayment
payment_id SMALLINT(5) customer_id SMALLINT(5) staff_id TINYINT(3) rental_id INT(11) amount DECIMAL(5,2) payment_date DATETIME last_update TIMESTAMP Indexes Triggers

Indexes

film_categoryfilm_id SMALLINT(5) category_id TINYINT(3) last_update TIMESTAMP Indexes

store
store_id TINYINT(3) manager_staff_id TINYINT(3) address_id SMALLINT(5) last_update TIMESTAMP Indexes

film
film_idSMALLINT(5) title VARCHAR(255) description TEXT release_year YEAR language_id TINYINT(3) original_language_id TINYINT(3) rental_duration TINYINT(3) rental_rate DECIMAL(4,2) length SMALLINT(5)...