데이터베이스론 10.16
테이블 (5)
casting (Untitled3)
- movield (Key) — int(10) — 외래 키 → movie.movield — NOT NULL
dvditem (Untitled4)
- itemid (Key) — int(100) — 기본 키 — NOT NULL
- butingdate (Field) — date
- price (Field2) — int(10)
- statuslevel (Field3) — char(1)
- movield (Key2) — int(10) — 외래 키 → movie.movield — NOT NULL
movie (Untitled)
- movield (Key) — int(10) — 기본 키 — NOT NULL
- title (Field) — char(30)
- pub year (Field2) — int(4)
- pubMonth (Field3) — inr(2)
- description (Field4) — longtext
- award (Field5) — longtext
movie genre (Untitled2)
- movield (Key) — int(10) — 외래 키 → movie.movield — NOT NULL
rent (Untitled5)
- rentid (Key) — int(1000) — 기본 키 — NOT NULL
- rentdate (Field) — date
- itemid (Key2) — int(100) — 외래 키 → dvditem.itemid — NOT NULL