DB과제
테이블 (6)
CATEGORIES
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
LIKES
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USERS.id — NOT NULL
- review_id — BIGINT — 외래 키 → REVIEWS.id — NOT NULL
- created_at — TIMESTAMP
MOVIES
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- poster_url — VARCHAR(1000)
- description — TEXT
- created_at — TIMESTAMP
MOVIE_CATEGORY
- movie_id — BIGINT — 외래 키 → MOVIES.id — NOT NULL
- category_id — BIGINT — 외래 키 → CATEGORIES.id — NOT NULL
REVIEWS
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USERS.id — NOT NULL
- movie_id — BIGINT — 외래 키 → MOVIES.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
USERS
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP