movie_rater
Tables (3)
movies
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(20)
- director — VARCHAR(20)
- release_global — DATE
- release_kr — DATE
- createdAt — DATETIME
- updatedAt — DATETIME
- poster — VARCHAR(100)
ratings
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- movie_id — INTEGER — Foreign key → movies.id — NOT NULL
- rating — INTEGER
- comment — MEDIUMTEXT
- createdAt — DATETIME
- updatedAt — DATETIME
users
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(20)
- email — VARCHAR(40)
- password — VARCHAR(100)
- salt — VARCHAR(100)
- createdAt — DATETIME
- updatedAt — DATETIME
- role — INTEGER