조별**
db 테이블 구조
테이블 (16)
Country (table2)
- country_id (SMALLINT) — 기본 키 — NOT NULL
- country (VARCHAR(50))
- last_update (TIMESTAMP)
actor (table13)
- actor_id (SMALLINT) — 기본 키 — NOT NULL
- first_name (VARCHAR(45))
- last_name (VARCHAR(45))
- last_update (TIMESTAMP)
address (table3)
- address_id (SMALLINT) — 기본 키 — NOT NULL
- address (VARCHAR(50))
- address2 (VARCHAR(50))
- district (VARCHAR(20))
- city_id (SMALLINT)
- postal_code (VARCHAR(10))
- phone (VARCHAR(20))
- last_update (TIMESTAMP)
category (table12)
- category_id (TINYINT) — 기본 키 — NOT NULL
- name (VARCHAR(25))
- last_update (TIMESTAMP)
city (table1)
- city_id (SMALLINT) — 기본 키 — NOT NULL
- city (VARCHAR(50))
- country_id (SMALLINT)
- last_update (TIMESTAMP)
customer (table4)
- customer_id (SMALLINT) — 기본 키 — NOT NULL
- store_id (TINYINT)
- first_name (VARCHAR(45))
- last_name (VARCHAR(45))
- email (VARCHAR(50))
- address_id (SMALLINT)
- active (BOOLEAN)
- create_date (DATATIME)
- last_update (TIMESTAMP)
film (table9)
- film_id (SMALLINT) — 기본 키 — NOT NULL
- title (VARCHAR(255))
- description (TEXT)
- release_year (YEAR)
- language_id (TINYINT)
- original_language_id (TINYINT)
- rental_duration (TINYINT)
- rental_rate (DECIMAL)
- length (SMALLINT)
- replacement_cost (DECIMAL)
- rating (ENUM)
- special_features (SET)
- last_update (TIMESTAMP)
film_actor (table14)
- actor_id (SMALLINT) — 기본 키 — NOT NULL
- film_id (SMALLINT)
- last_update (TIMESTAMP)
film_category (table10)
- film_id (SMALLINT) — 기본 키 — NOT NULL
- category_id (TINYINT)
- last_update (TIMESTAMP)
film_text (table15)
- film_id (SMALLINT) — 기본 키 — NOT NULL
- title (VARCHAR(255))
- description (TEXT)
inventory (table16)
- inventory_id (MEDIUMINT) — 기본 키 — NOT NULL
- film_id (SMALLINT)
- store_id (TINYINT)
- last_update (TIMESTAMP)
language (table11)
- language_id (TINYINT) — 기본 키 — NOT NULL
- name (CHAR(20))
- last_update (TIMESTAMP)
paymnet (table7)
- payment_id (SMALLINT) — 기본 키 — NOT NULL
- customer_id (SMALLINT)
- staff_id (TINYINT)
- rental_id (INT)
- amount (DECIMAL)
- payment_date (DATETIME)
- last_update (TIMESTAMP)
rental (table8)
- rental_id (INT) — 기본 키 — NOT NULL
- rental_date (DATETIME)
- inventory_id (MEDIUMINT)
- customer_id (SMALLINT)
- return_date (DATETIME)
- staff_id (TINYINT)
- last_update (TIMESTAMP)
staff (table6)
- staff_id (TINYINT) — 기본 키 — NOT NULL
- first_name (VARCHAR(45))
- last_name (VARCHAR(45))
- address_id (SMALLINT)
- picture (BLOB)
- email (VARCHAR(50))
- store_id (TINYINT)
- active (BOOLEAN)
- username (VARCHAR(16))
- password (VARCHAR(40))
- last_update (TIMESTAMP)
store (table5)
- store_id (TINYINT) — 기본 키 — NOT NULL
- manager_staff_id (TINYINT)
- address_id (SMALLINT)
- last_update (TIMESTAMP)