sakila
Tables (14)
actor
- actor_id — SMALLINT — Primary key — NOT NULL
- first_name — VARCHAR — NOT NULL
- last_name — VARCHAR — NOT NULL
- last_update — TIMESTAMP — NOT NULL
address
- address_id — SMALLINT — Primary key — NOT NULL
- city_id — SMALLINT — Foreign key → city.city_id — NOT NULL
- country_id — SMALLINT — Foreign key → city.country_id — NOT NULL
- address — VARCHAR
- address2 — VARCHAR
- district — VARCHAR
- postal_code — VARCHAR
- phone — VARCHAR — NOT NULL
- last_update — TIMESTAMP — NOT NULL
category
- category_id — TINYINT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- last_update — TIMESTAMP — NOT NULL
city
- city_id — SMALLINT — Primary key — NOT NULL
- country_id — SMALLINT — Foreign key → country.country_id — NOT NULL
- 도시이름 (city) — VARCHAR — NOT NULL
- last_update — TIMESTAMP — NOT NULL
country
- country_id — SMALLINT — Primary key — NOT NULL
- country — VARCHAR — NOT NULL
- last_update — TIMESTAMP — NOT NULL
customer
- customer_id — SMALLINT — Primary key — NOT NULL
- address_id — SMALLINT — Foreign key → address.address_id — NOT NULL
- first_name — VARCHAR — NOT NULL
- last_name — VARCHAR — NOT NULL
- email — VARCHAR
- active — TINYINT — NOT NULL
- create_date — DATETIME — NOT NULL
- last_update — TIMEStAMP — NOT NULL
film
- film_id — SMALLINT — Primary key — NOT NULL
- title — VARCHAR — NOT NULL
- description — TEXT
- release_year — YEAR
- language_id — TINYINT — NOT NULL
- original_language_id — TINYINT
- rental_duration — TINYINT — NOT NULL
- rental_rate — TINYINT — NOT NULL
- length — SMALLINT
- replacement_cost — DECIMAL — NOT NULL
- rating — ENUM
- special_features — SET
- last_update — TIMESTAMP — NOT NULL
film_actor
- actor_id (actor_id2) — SMALLINT — Foreign key → actor.actor_id — NOT NULL
- film_id — SMALLINT — Foreign key → film.film_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
film_category
- film_id — SMALLINT — Foreign key → film.film_id — NOT NULL
- category_id — TINYINT — Foreign key → category.category_id — NOT NULL
- last_update — TIMESTAMP — NOT NULL
film_text
- film_id — SMALLINT — Foreign key → film.film_id — NOT NULL
- title — VARCHAR — NOT NULL
- description — TEXT
inventory
- inventory_id — MEDIUMINT — Primary key — NOT NULL
- film_id — SMALLINT — Foreign key → film.film_id — NOT NULL
- last_update — SMALLINT — NOT NULL
language
- language_id — TINYINT — Primary key — NOT NULL
- name — CHAR — NOT NULL
- last_update — TIMESTAMP — NOT NULL
payment
- payment_id — SMALLINT — Primary key — NOT NULL
- amount — DECIMAL — NOT NULL
- payment_date — DATETIME — NOT NULL
- last_update — TIMESTAMP — NOT NULL
rental
- rental_id — INT — Primary key — NOT NULL
- rental_date — DATETIME — NOT NULL
- Field