movie-pjt
Tables (11)
Actor
- actor_id — INT
- name — VARCHAR(255) — NOT NULL
Actors
- actor_id — INTEGER
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
Admins
- admin_id — INT
- user_id — INT
Comment_Likes
- user_id — INTEGER — Foreign key — NOT NULL
- comment_id — INTEGER — Foreign key — NOT NULL
- created_at — TIMESTAMP
Comments
- comment_id — INT
- user_id — INT
- movie_id — INT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Follows
- following_user_id — INT
- followed_user_id — INT
- created_at — TIMESTAMP
Likes
- like_id — INT
- user_id — INT
- movie_id — INT
- comment_id — INT
- created_at — TIMESTAMP
Movie_Actors
- movie_id — INTEGER — Foreign key — NOT NULL
- actor_id — INTEGER — Foreign key → Actors.actor_id — NOT NULL
- created_at — TIMESTAMP
Movies
- movie_id — INT
- title — VARCHAR(255) — NOT NULL
- overview — TEXT
- release_date — DATE
- poster_path — VARCHAR(255)
- like_count — INT
- rating — FLOAT
- created_at — TIMESTAMP
- actor_id — INT
User_Movie_Likes
- user_id — INTEGER — Foreign key — NOT NULL
- movie_id — INTEGER — Foreign key — NOT NULL
- created_at — TIMESTAMP
Users
- user_id — INT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- is_active — BOOLEAN
- created_at — TIMESTAMP