연습4

테이블 (7)

actor (Untitled4)

  • actCODE (Key) — 기본 키 — NOT NULL
  • name (Field2)
  • biography (Field)

director (Untitled5)

  • dirCODE (Key) — 기본 키 — NOT NULL
  • name (Field2)
  • biography (Field)

dvd (Untitled2)

  • dvdCODE (Key) — 기본 키 — NOT NULL
  • purchaseDate (Field)
  • number of rental (Field2)
  • movieID (Key2) — 외래 키 → movie.movieID — NOT NULL

enroll (Untitled7)

  • movieID (Key2) — 외래 키 → movie.movieID — NOT NULL
  • dirCODE (Key) — 외래 키 → director.dirCODE — NOT NULL
  • actCODE (Key3) — 외래 키 → actor.actCODE — NOT NULL

member (Untitled)

  • memberID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • phone (Field3)

movie (Untitled3)

  • movieID (Key) — 기본 키 — NOT NULL
  • title (Field)
  • year (Field2)

rental service (Untitled6)

  • memberID (Key) — 외래 키 → member.memberID — NOT NULL
  • dvdCODE (Key2) — 외래 키 → dvd.dvdCODE — NOT NULL
  • date (Field)
  • time (Field2)