조별**

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)