영화

테이블 (7)

Untitled (Movie)

  • Key (movie id) — 기본 키 — NOT NULL
  • Field (title)
  • Field2 (release date)
  • Field3 (popularity)
  • Field4 (vote count)
  • Field5 (overview)
  • Field (poster path)
  • Field2 (upcoming)

Untitled (Movie-Genres)

  • Key (movie id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (genres id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Genres)

  • Key (genres id) — 기본 키 — NOT NULL
  • Field (genre)

Untitled (Movie Comment)

  • Key (movie comment id) — 기본 키 — NOT NULL
  • Key (movie id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (content)
  • Field2 (rank)
  • Field3 (created_at)
  • Field4 (updated_at)

Untitled (User)

  • Key (user id) — 기본 키 — NOT NULL
  • Field (user name)
  • Field2 (email)
  • Field3 (password)

Untitled (Like(Comment-User))

  • Key (user id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (movie comment id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (movie id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user id2) — 외래 키 → Untitled.Key — NOT NULL

Untitled (User-genre movies)

  • Key (user id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (movie id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (genres id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (genre_id)