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