sakila - 2024-01-16 10:14:11
Tables (16)
actor
- actor_id — SMALLINT — Primary key — NOT NULL
- first_name — VARCHAR(45) — NOT NULL
- last_name — VARCHAR(45) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
address
- address_id — SMALLINT — Primary key — NOT NULL
- address — VARCHAR(50) — NOT NULL
- address2 — VARCHAR(50)
- district — VARCHAR(20) — NOT NULL
- city_id — SMALLINT — NOT NULL
- postal_code — VARCHAR(10)
- phone — VARCHAR(20) — NOT NULL
- /*!50705 — location — NOT NULL
- */ — last_update — NOT NULL
- /*!50705 — SPATIAL
- */ — CONSTRAINT
category
- category_id — TINYINT — Primary key — NOT NULL
- name — VARCHAR(25) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
city
- city_id — SMALLINT — Primary key — NOT NULL
- city — VARCHAR(50) — NOT NULL
- country_id — SMALLINT — Foreign key — NOT NULL
- last_update — TIMESTAMP — NOT NULL
country
- country_id — SMALLINT — Primary key — NOT NULL
- country — VARCHAR(50) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
customer
- customer_id — SMALLINT — Primary key — NOT NULL
- store_id — TINYINT — Foreign key — NOT NULL
- first_name — VARCHAR(45) — NOT NULL
- last_name — VARCHAR(45) — NOT NULL
- email — VARCHAR(50)
- address_id — SMALLINT — Foreign key — NOT NULL
- active — BOOLEAN — NOT NULL
- create_date — DATETIME — NOT NULL
- last_update — TIMESTAMP
film
- film_id — SMALLINT — Primary key — NOT NULL
- title — VARCHAR(128) — NOT NULL
- description — TEXT
- release_year — YEAR
- language_id — TINYINT — Foreign key — NOT NULL
- original_language_id — TINYINT — Foreign key
- 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 — SMALLINT — Foreign key — NOT NULL
- film_id — SMALLINT — Foreign key — NOT NULL
- last_update — TIMESTAMP — NOT NULL
film_category
- film_id — SMALLINT — Foreign key — NOT NULL
- category_id — TINYINT — Foreign key — NOT NULL
- last_update — TIMESTAMP — NOT NULL
film_text
- film_id — SMALLINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- FULLTEXT — KEY
inventory
- inventory_id — MEDIUMINT — Primary key — NOT NULL
- film_id — SMALLINT — Foreign key — NOT NULL
- store_id — TINYINT — Foreign key — NOT NULL
- last_update — TIMESTAMP — NOT NULL
language
- language_id — TINYINT — Primary key — NOT NULL
- name — CHAR(20) — NOT NULL
- last_update — TIMESTAMP — NOT NULL
payment
- payment_id — SMALLINT — Primary key — NOT NULL
- customer_id — SMALLINT — Foreign key — NOT NULL
- staff_id — TINYINT — Foreign key — NOT NULL
- rental_id — INT — Foreign key
- 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 — MEDIUMINT — Foreign key — NOT NULL
- customer_id — SMALLINT — Foreign key — NOT NULL
- return_date — DATETIME
- staff_id — TINYINT — Foreign key — NOT NULL
- last_update — TIMESTAMP — NOT NULL
staff
- staff_id — TINYINT — Primary key — NOT NULL
- first_name — VARCHAR(45) — NOT NULL
- last_name — VARCHAR(45) — NOT NULL
- address_id — SMALLINT — Foreign key — NOT NULL
- picture — BLOB
- email — VARCHAR(50)
- store_id — TINYINT — Foreign key — NOT NULL
- active — BOOLEAN — NOT NULL
- username — VARCHAR(16) — NOT NULL
- password — VARCHAR(40)
- last_update — TIMESTAMP — NOT NULL
store
- store_id — TINYINT — Primary key — NOT NULL
- manager_staff_id — TINYINT — Foreign key — NOT NULL
- address_id — SMALLINT — Foreign key — NOT NULL
- last_update — TIMESTAMP — NOT NULL