db_project

Tables (5)

director (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

genre (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

movie (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • engName (Field2)
  • year (Field3)
  • nation (Field4)
  • company (Field5)

movie_director (Untitled4)

  • movie_id (Key) — Foreign key → movie.id — NOT NULL
  • director_id (Key2) — Foreign key → director.id — NOT NULL

movie_genre (Untitled5)

  • movie_id (Key) — Foreign key → movie.id — NOT NULL
  • genre_id (Key2) — Foreign key → genre.id — NOT NULL