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