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