m

Tables (3)

distributor

  • distributor_id — INT
  • d_name — VARCHAR(100)

movie_distributor

  • movie_id — INT — Primary key — NOT NULL
  • distributor_id — INT — Primary key — NOT NULL

movies

  • movie_id — INT
  • title — VARCHAR(30) — NOT NULL
  • director — VARCHAR(30) — NOT NULL
  • release_date — DATETIME
  • movie_type — VARCHAR(30)
  • country — VARCHAR(30)
  • screens — INT
  • revenue — BIGINT
  • audience — INT
  • genre — VARCHAR(30)
  • rating — VARCHAR(30)