sample2

Tables (23)

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

actor_info

  • actor_id — SMALLINT — NOT NULL
  • first_name — VARCHAR(1) — NOT NULL
  • last_name — VARCHAR(1) — NOT NULL
  • film_info — TEXT

address

  • address_id — smallint — Primary key — NOT NULL
  • address — varchar(50) — NOT NULL
  • address2 — varchar(50)
  • district — varchar(20) — NOT NULL
  • city_id — smallint — Foreign key → city.city_id — NOT NULL
  • postal_code — varchar(10)
  • phone — varchar(20) — NOT NULL — 코멘트
  • location — geometry — NOT NULL
  • last_update — timestamp — NOT NULL
  • SPATIAL — KEY
  • Field
  • Field2

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 — tinyint(1) — NOT NULL
  • create_date — datetime — NOT NULL
  • last_update — timestamp

customer_list

  • ID — SMALLINT — NOT NULL
  • name — VARCHAR(1)
  • address — VARCHAR(1) — NOT NULL
  • zip — code`
  • phone — VARCHAR(1) — NOT NULL
  • city — VARCHAR(1) — NOT NULL
  • country — VARCHAR(1) — NOT NULL
  • notes — VARCHAR(1) — NOT NULL
  • SID — TINYINT — NOT NULL

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

  • category_id — tinyint — Foreign key → category.category_id — NOT NULL
  • film_id — smallint — Foreign key → film.film_id — NOT NULL
  • last_update — timestamp — NOT NULL

film_list

  • FID — SMALLINT — NOT NULL
  • title — VARCHAR(1) — NOT NULL
  • description — TEXT
  • category — VARCHAR(1)
  • price — DECIMAL(4,2) — NOT NULL
  • length — SMALLINT
  • rating — ENUM('G','PG','PG-13','R','NC-17')
  • actors — TEXT

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

nicer_but_slower_film_list

  • FID — SMALLINT — NOT NULL
  • title — VARCHAR(1) — NOT NULL
  • description — TEXT
  • category — VARCHAR(1)
  • price — DECIMAL(4,2) — NOT NULL
  • length — SMALLINT
  • rating — ENUM('G','PG','PG-13','R','NC-17')
  • actors — TEXT

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

sales_by_film_category

  • category — VARCHAR(1) — NOT NULL
  • total_sales — DECIMAL(27,2)

sales_by_store

  • store — VARCHAR(1)
  • manager — VARCHAR(1)
  • total_sales — DECIMAL(27,2)

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 — tinyint(1) — NOT NULL
  • username — varchar(16) — NOT NULL
  • password — varchar(40)
  • last_update — timestamp — NOT NULL

staff_list

  • ID — TINYINT — NOT NULL
  • name — VARCHAR(1)
  • address — VARCHAR(1) — NOT NULL
  • zip — code`
  • phone — VARCHAR(1) — NOT NULL
  • city — VARCHAR(1) — NOT NULL
  • country — VARCHAR(1) — NOT NULL
  • SID — TINYINT — 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