movie

Tables (5)

Movie

  • Key (movie_id) — Primary key — NOT NULL
  • Field (title)
  • Field (year)
  • Field2 (rating)
  • Field (gross)
  • Field2 (votes)
  • Field (language)

Untitled (Genres)

  • Key (Genres_id) — Primary key — NOT NULL
  • Field (Genre_name)

Untitled (Director)

  • Key (Director_id) — Primary key — NOT NULL
  • Field (Director_name)
  • Field2 (Director_nationality)

Untitled (Actor)

  • Key (Actor_1_id) — Primary key — NOT NULL
  • Key (Actor_2_id) — Primary key — NOT NULL
  • Key (Actor_3_id) — Primary key — NOT NULL
  • Field (Actor_1)
  • Field (Actor_2)
  • Field (Actor_3)
  • Field (Actor_1_nationality)
  • Field2 (Actor_2_nationality)
  • Field3 (Actor_3_nationality)

Untitled (Oscar)

  • Key (Oscar_id) — Primary key — NOT NULL
  • Field (year)
  • Key (best_flim) — NOT NULL
  • Field (best_actress)
  • Field (best_director)