sakila
Tables (16)
actor
- actor_id — INT — Primary key — NOT NULL
- first_name — VARCHAR(45) — NOT NULL
- last_name — VARCHAR(45) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
address
- address_id — INT — Primary key — NOT NULL
- address — VARCHAR(50) — NOT NULL
- address2 — VARCHAR(50)
- district — VARCHAR(20) — NOT NULL
- city_id — INT — Foreign key → city.city_id — NOT NULL
- postal_code — VARCHAR(10)
- phone — VARCHAR(20) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
category
- category_id — INT — Primary key — NOT NULL
- name — VARCHAR(25) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
city
- city_id — INT — Primary key — NOT NULL
- city — VARCHAR(50) — NOT NULL
- country_id — INT — Foreign key → country.country_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
country
- country_id — INT — Primary key — NOT NULL
- country — VARCHAR(50) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
customer
- customer_id — INT — Primary key — NOT NULL
- store_id — INT — Foreign key → store.store_id — NOT NULL
- first_name — VARCHAR(45) — NOT NULL
- last_name — VARCHAR(45) — NOT NULL
- email — VARCHAR(50)
- address_id — INT — Foreign key → address.address_id — NOT NULL
- active — BOOLEAN — NOT NULL
- create_date — DATETIME — NOT NULL
- last_update — TIMESTAMP
film
- film_id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- release_year — YEAR
- language_id — INT — Foreign key → language.language_id — NOT NULL
- original_language_id — INT — Foreign key → language.language_id
- rental_duration — TINYINT — NOT NULL
- rental_rate — DECIMAL(4,2) — NOT NULL
- length — SMALLINT
- replacement_cost — DECIMAL(5,2) — NOT NULL
- rating — ENUM('G','PG','PG-13','R','NC-17')
- special_features — SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')
- last_update — TIMESTAMP — NOT NULL
film_actor
- actor_id — INT — Foreign key → actor.actor_id — NOT NULL
- film_id — INT — Foreign key → film.film_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
film_category
- film_id — INT — Foreign key → film.film_id — NOT NULL
- category_id — INT — Foreign key → category.category_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
film_text
- film_id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- FULLTEXT — KEY
inventory
- inventory_id — INT — Primary key — NOT NULL
- film_id — INT — Foreign key → film.film_id — NOT NULL
- store_id — INT — Foreign key → store.store_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
language
- language_id — INT — Primary key — NOT NULL
- name — CHAR(20) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
payment
- payment_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → customer.customer_id — NOT NULL
- staff_id — INT — Foreign key → staff.staff_id — NOT NULL
- rental_id — INT — Foreign key → rental.rental_id
- amount — DECIMAL(5,2) — NOT NULL
- payment_date — DATETIME — NOT NULL
- last_update — TIMESTAMP
rental
- rental_id — INT — Primary key — NOT NULL
- rental_date — DATETIME — NOT NULL
- inventory_id — INT — Foreign key → inventory.inventory_id — NOT NULL
- customer_id — INT — Foreign key → customer.customer_id — NOT NULL
- return_date — DATETIME
- staff_id — INT — Foreign key → staff.staff_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
staff
- staff_id — INT — Primary key — NOT NULL
- first_name — VARCHAR(45) — NOT NULL
- last_name — VARCHAR(45) — NOT NULL
- address_id — INT — Foreign key → address.address_id — NOT NULL
- picture — MEDIUMBLOB
- email — VARCHAR(50)
- store_id — INT — Foreign key → store.store_id — NOT NULL
- active — BOOLEAN — NOT NULL
- username — VARCHAR(16) — NOT NULL
- password — VARCHAR(40)
- last_update — TIMESTAMP — NOT NULL
store
- store_id — INT — Primary key — NOT NULL
- manager_staff_id — INT — Foreign key → staff.staff_id — NOT NULL
- address_id — INT — Foreign key → address.address_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL