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