관통

테이블 (6)

Articles (Untitled2)

  • Key (pk) — 기본 키 — NOT NULL
  • Char (title)
  • Text (content)
  • DateTime (created_at)
  • DateTime (updated_at)
  • Integer (user)
  • Integer (like_users)
  • Key (pk2) — 외래 키 → User.Key — NOT NULL

Comment (Untitled3)

  • Key (pk) — 기본 키 — NOT NULL
  • Integer (article)
  • Char (content)
  • DateTime (created_at)
  • DateTime (updated_at)
  • Integer (user)
  • Key (pk2) — 외래 키 → Articles.Key — NOT NULL
  • Key (pk3) — 외래 키 → User.Key — NOT NULL

Genre (Untitled6)

  • Key (pk) — 기본 키 — NOT NULL
  • Char (name)
  • Key (pk2) — 외래 키 → Movies.Key — NOT NULL

Movies (Untitled)

  • Key (pk) — 기본 키 — NOT NULL
  • Char (title)
  • Text (overview)
  • Date (release_date)
  • Text (poster_path)
  • Integer (genres)
  • Integer (vote_count)
  • Float (vote_average)
  • Integer (like_users)
  • Key (pk2) — 외래 키 → Genre.Key — NOT NULL
  • Key (pk3) — 외래 키 → User.Key — NOT NULL

Review (Untitled4)

  • Key (pk) — 기본 키 — NOT NULL
  • Integer (user)
  • Integer (movie)
  • Float (score)
  • DateTime (created_at)
  • DateTime (updated_at)
  • Key (pk2) — 외래 키 → Movies.Key — NOT NULL
  • Key (pk3) — 외래 키 → User.Key — NOT NULL

User (Untitled5)

  • Key (pk) — 기본 키 — NOT NULL
  • Char (username)
  • Char (password)
  • Key (pk2) — 외래 키 → Movies.Key — NOT NULL
  • Key (pk3) — 외래 키 → Articles.Key — NOT NULL