MoodFlix
Tables (18)
Cast
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
- character — TEXT — NOT NULL
- person_id — INTEGER — NOT NULL
Comment
- id — SERIAL
- community_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
Community
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- movie_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
Crew
- id — SERIAL
- department — VARCHAR(100) — NOT NULL
- person_id — INTEGER — NOT NULL
CustomUser
- id — SERIAL
- username — VARCHAR(150) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- email — VARCHAR(254)
- nickname — VARCHAR(100)
- user_profile — VARCHAR(200)
- user_intro — VARCHAR(100)
Emotion
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
Emotion_Genre
- emotion_id — INTEGER — Primary key — NOT NULL
- genre_id — INTEGER — Primary key — NOT NULL
Genre
- id — INTEGER
- name — VARCHAR(100) — NOT NULL
Movie
- id — INTEGER
- title — VARCHAR(100) — NOT NULL
- belong_to_collection — VARCHAR(100)
- original_title — VARCHAR(100)
- release_date — DATE
- overview — TEXT
- runtime — INTEGER
- popularity — FLOAT
- vote_average — FLOAT
- vote_count — INTEGER
- poster_path — VARCHAR(200)
- backdrop_path — VARCHAR(200)
- budget — BIGINT
- revenue — BIGINT
- adult — BOOLEAN
- status — VARCHAR(50)
- homepage — VARCHAR(200)
- imdb_id — VARCHAR(15)
- tagline — VARCHAR(255)
- origin_country — VARCHAR(100)
- spoken_languages — VARCHAR(100)
- user_rating — FLOAT
- trailer — VARCHAR(100)
Movie_Cast
- movie_id — INTEGER — Primary key — NOT NULL
- cast_id — INTEGER — Primary key — NOT NULL
Movie_Crew
- movie_id — INTEGER — Primary key — NOT NULL
- crew_id — INTEGER — Primary key — NOT NULL
Movie_Genre
- movie_id — INTEGER — Primary key — NOT NULL
- genre_id — INTEGER — Primary key — NOT NULL
Person
- id — INTEGER
- name — TEXT — NOT NULL
- profile_path — TEXT
Review
- id — SERIAL
- content — TEXT — NOT NULL
- rating — FLOAT
- create_review — TIMESTAMP
- user_id — INTEGER — NOT NULL
- movie_id — INTEGER — NOT NULL
- emotion_id — INTEGER — NOT NULL
- likes_count — INTEGER
ReviewComment
- id — SERIAL
- review_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Review_Likes
- review_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Primary key — NOT NULL
User_Followings
- user_id — INTEGER — Primary key — NOT NULL
- following_id — INTEGER — Primary key — NOT NULL
User_KeptMovies
- user_id — INTEGER — Primary key — NOT NULL
- movie_id — INTEGER — Primary key — NOT NULL