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)