데이터베이스론 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