DB

Tables (9)

Film Participants (participantid)

  • name (Key) — Primary key — NOT NULL
  • movieid (Key2) — Foreign key → Movie Participants.movieid — NOT NULL
  • name (Key22) — Foreign key → Movie Participants.name — NOT NULL
  • movieid (Key222) — Foreign key → Movie Participants.movieid — NOT NULL
  • occupation (Field)
  • representative (Field2)
  • title_in_film (Field3)
  • role_in_film (Field4)

Genre (Untitled4)

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

Movie (movie_id)

  • movie_id (Field1) — SERIAL PRIMARY KEY — Primary key — NOT NULL
  • name (Field6) — VARCHAR(255) UNIQUE
  • type (Field9) — VARCHAR(50) UNIQUE
  • running_time (Field10) — INTEGER
  • is_adult (Field) — BOOLEAN
  • launch_year (Field2) — INTEGER UNIQUE
  • end_year (Field3) — INTEGER
  • rating (Field4) — NUMERIC(3,1)
  • votes (Field5) — INTEGER

Movie Genre (Untitled5)

  • movieid (Key) — Primary key — NOT NULL
  • genreid (Field)

Movie Participants (Untitled7)

  • movieid (Key) — Primary key — NOT NULL
  • name (Key2) — Foreign key → Film Participants.name — NOT NULL
  • movieid (Key22) — Foreign key → Film Participants.movieid — NOT NULL
  • participantid (Field)

User (Untitled)

  • email (Key) — Primary key — NOT NULL
  • password (Field)
  • contact_number (Field2)
  • gender (Field3)

User Comments (userid)

  • movieid (Key) — Primary key — NOT NULL
  • rating (Field)
  • comment (Field2)
  • date_left (Field3)

User Genre (Untitled3)

  • userid (Key) — Primary key — NOT NULL
  • genreid (Field)

Viewing History (Untitled2)

  • viewinghistoryid (Key) — Primary key — NOT NULL
  • userid (Field)
  • movieid (Field2)
  • viewing_date (Field3)
  • viewing_time (Field4)
  • playing_time (Field5)