1
Tables (3)
member
- user_id — BIGINT — Primary key
- nickname — VARCHAR(255)
- profile_image_url — VARCHAR(255)
- email — VARCHAR(255)
- role — VARCHAR(50)
- status — VARCHAR(50)
movie
- movie_id — BIGINT — Primary key
- title — VARCHAR(255)
- poster_image_url — VARCHAR(255)
- director_name — TEXT
- casts_list — TEXT
- nation — VARCHAR(100)
- plot — VARCHAR(5000)
- genre_list — TEXT
- release_date — VARCHAR(50)
- status — VARCHAR(50)
- created_dt — DATETIME
- updated_dt — DATETIME
movie_preference
- movie_preference_id — BIGINT — Primary key
- movie_id — BIGINT
- member_id — BIGINT
- liked — VARCHAR(50)
- created_dt — DATETIME
- updated_dt — DATETIME