무비

테이블 (3)

actors (Untitled2)

  • actor_id (PRIMARY KEY) — INT(10) — 기본 키 — NOT NULL
  • movie_id (Key) — INT(10) — 외래 키 → movie.movie_id — NOT NULL
  • actor_name (Field) — VARCHAR(255)

directors

  • director_id (PRIMARY KEY) — INT(10) — 기본 키 — NOT NULL
  • movie_id (Key) — INT(10) — 외래 키 → movie.movie_id — NOT NULL
  • director_name (Field) — VARCHAR(255)

movie (Untitled)

  • movie_id (Key) — INT(10) — 기본 키 — NOT NULL
  • movie_title (Field) — VARCHAR(255)
  • director (Field2) — VARCHAR(255)
  • genre (Field3) — VARCHAR(255)
  • runtime (Field4) — INT(10)
  • release_date (Field5) — DATE
  • actors (Field6) — VARCHAR(255)
  • director_past_works (Field7) — VARCHAR(255)