exercise 4 모범

테이블 (9)

CLIENT

  • clientId — int(100) — 기본 키 — NOT NULL
  • name — char(30)
  • phone — int(11)
  • email — char(30)
  • address (Field) — char(30)

DVDITEM (DVD)

  • itemId (dvdID) — int(100) — 기본 키 — NOT NULL
  • buyingdate — date
  • price — int(10)
  • statuslevel (statusLevel) — char(1)
  • movieId (movieId2) — int(10) — 외래 키 → MOVIE.movieId — NOT NULL

GENRE (Untitled3)

  • genreID (genreId) — int(5) — 기본 키 — NOT NULL
  • name — char(30)
  • description — LONGTEXT

MOVIE

  • movieId — int(10) — 기본 키 — NOT NULL
  • title — char(30)
  • pubYear — int(4)
  • pubMonth — int(2)
  • description — LONGTEXT
  • award — LONGTEXT

MOVIE_GENRE

  • movieId — int(10) — 외래 키 → MOVIE.movieId — NOT NULL
  • genreID (genreId) — int(5) — 외래 키 → GENRE.genreID — NOT NULL

PERSON

  • personId — 기본 키 — NOT NULL
  • fname
  • minit
  • lname
  • description
  • award

RENT

  • rentID (Key) — int(100) — 기본 키 — NOT NULL
  • rentDate (Field) — date
  • returnDate (Field2) — date
  • itemId (Field3) — int(100)
  • clientId (Field4) — int(100)
  • itemId (dvdID) — int(100) — 외래 키 → DVDITEM.itemId — NOT NULL
  • clientId — int(100) — 외래 키 → CLIENT.clientId — NOT NULL

ROLE

  • roleId — 기본 키 — NOT NULL
  • roletitle
  • description

Untitled (CASTING)

  • Key (roleId) — 외래 키 → ROLE.roleId — NOT NULL
  • movieId (Key) — int(10) — 외래 키 → MOVIE.movieId — NOT NULL
  • Key (personId) — 외래 키 → PERSON.personId — NOT NULL
  • Field (description) — text