lana
Tables (8)
Film_Participant
- participant_id — SERIAL
- name — VARCHAR(255) — NOT NULL
- occupation — VARCHAR(100)
- representative_work — VARCHAR(255)
- role_in_film — VARCHAR(100)
- title_in_film — VARCHAR(255)
Movie
- movie_id — SERIAL
- name — VARCHAR(255) — NOT NULL
- type — VARCHAR(50)
- runtime — INTEGER
- launch_year — INTEGER
- end_year — INTEGER
- is_adult — BOOLEAN
- ratings — DECIMAL(3, 2)
- voting — INTEGER
Movie_Film_Participant
- movie_id — INTEGER
- participant_id — INTEGER
User
- user_id — SERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- phone_no — VARCHAR(20)
User_Comment
- comment_id — SERIAL
- rating — DECIMAL(3, 2)
- comment — TEXT — EX
- review_date — DATE — NOT NULL
- user_id — INTEGER
- movie_id — INTEGER
User_Genre
- user_id — INTEGER
- genre_name — VARCHAR(100)
Viewing_History
- history_id — SERIAL
- viewing_date — DATE — NOT NULL
- viewing_time — TIME — NOT NULL
- playing_time — INTEGER
- user_id — INTEGER
- movie_id — INTEGER