movie

Tables (5)

Actor (Untitled2)

  • actor_id (Key) — Primary key — NOT NULL
  • actor_name (Field)
  • pay (Field2)

Casting (Untitled)

  • movie_id (Key) — Primary key — NOT NULL
  • actor_id (Key3) — Foreign key → Actor.actor_id — NOT NULL
  • movie_id (Key2) — Long — Foreign key → Movie.movie_id — NOT NULL
  • director_id (Key22) — Long — Foreign key → Movie.director_id — NOT NULL
  • actor_role (Field2)

Copy Of Casting (CopyOfUntitled)

  • Key3 — Primary key — NOT NULL
  • movie_id (Key) — Primary key — NOT NULL
  • actor_id (Key2) — Primary key — NOT NULL
  • actor_role (Field2)

Director (감독)

  • director_id (Key) — Long — Primary key — NOT NULL
  • director_name (Field)

Movie (영화)

  • movie_id (Key) — Long — Primary key — NOT NULL
  • director_id (Key2) — Long — Foreign key → Director.director_id — NOT NULL
  • title (Field)
  • genre (Field2)