sakila

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 → country.country_id — 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 → store.store_id — NOT NULL
  • first_name — VARCHAR(45) — NOT NULL
  • last_name — VARCHAR(45) — NOT NULL
  • email — VARCHAR(50)
  • address_id — SMALLINT — Foreign key → address.address_id — 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 → language.language_id — NOT NULL
  • original_language_id — TINYINT — 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 — 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 — 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 → film.film_id — NOT NULL
  • store_id — TINYINT — Foreign key → store.store_id — 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 → customer.customer_id — NOT NULL
  • staff_id — TINYINT — 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 — MEDIUMINT — Foreign key → inventory.inventory_id — NOT NULL
  • customer_id — SMALLINT — Foreign key → customer.customer_id — NOT NULL
  • return_date — DATETIME
  • staff_id — TINYINT — Foreign key → staff.staff_id — 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 → address.address_id — NOT NULL
  • picture — BLOB
  • email — VARCHAR(50)
  • store_id — TINYINT — 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 — TINYINT — Primary key — NOT NULL
  • manager_staff_id — TINYINT — Foreign key → staff.staff_id — NOT NULL
  • address_id — SMALLINT — Foreign key → address.address_id — NOT NULL
  • last_update — TIMESTAMP — NOT NULL