MOVWA
Tables (10)
genres
- id — INTEGER
- name — VARCHAR(50) — NOT NULL
movie_genres
- id — BIGINT
- movie_id — UUID — NOT NULL
- genre_id — INTEGER — NOT NULL
movies
- id — UUID
- tmdb_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- original_title — VARCHAR(200)
- overview — TEXT
- release_date — DATE
- poster_path — VARCHAR(200)
- backdrop_path — VARCHAR(200)
- popularity — FLOAT
- vote_average — FLOAT
- vote_count — INTEGER
- adult — BOOLEAN
- runtime — INTEGER
- status — VARCHAR(50)
- created_at — TIMESTAMP
reviews
- id — BIGINT
- user_id — UUID — NOT NULL
- movie_id — UUID — NOT NULL
- content — TEXT — NOT NULL
- rating — FLOAT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_follows
- id — UUID — Primary key
- created_at — TIMESTAMP
- follower_id — UUID — Foreign key → users.id
- following_id — UUID — Foreign key → users.id
user_movie_logs
- id — BIGINT
- user_id — UUID — NOT NULL
- movie_id — UUID — NOT NULL
- is_liked — BOOLEAN
- is_saved — BOOLEAN
- rating — FLOAT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_movie_recommends
- id — BIGINT
- user_id — UUID — NOT NULL
- movie_id — UUID — NOT NULL
- score — FLOAT
- rank — INTEGER
- algo_type — VARCHAR(50)
- created_at — TIMESTAMP
user_profiles
- id — UUID — Primary key
- bio — VARCHAR(255)
- avatar_url — VARCHAR(2048)
- updated_at — TIMESTAMP
- user_id — UUID — Foreign key → users.id
user_review_likes
- id — BIGINT
- user_id — UUID — NOT NULL
- review_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
users
- id — UUID — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(128)
- username — VARCHAR(30) — NOT NULL
- nickname — VARCHAR(30)
- is_active — BOOLEAN
- date_joined — TIMESTAMP
- last_login — TIMESTAMP
- updated_at — TIMESTAMP