무비 커뮤니티

테이블 (8)

Article (Untitled4)

  • id — int — 기본 키 — NOT NULL
  • user — foreignKey — 외래 키 → user.id — NOT NULL
  • movie — foreignKey — 외래 키 → Movie.id — NOT NULL
  • title — text
  • content — text
  • created_at — date
  • updated_at — date

Comment (Untitled5)

  • id — int — 기본 키 — NOT NULL
  • user — foreignKey — 외래 키 → user.id — NOT NULL
  • article — foreignKey — 외래 키 → Article.id — NOT NULL
  • content — text
  • created_at — date
  • updated_at — date

Genre (Untitled7)

  • id — int — 기본 키 — NOT NULL
  • name — str

Iwantthis (Untitled8)

  • id — int — 기본 키 — NOT NULL
  • user — ForeignKey — 외래 키 → user.id — NOT NULL
  • comment — text

Movie (Untitled2)

  • id — int — 기본 키 — NOT NULL
  • genre — manyTomany — 외래 키 → Genre.id — NOT NULL
  • title — text
  • poster (poster_url) — url
  • director — text
  • actor — text
  • rate — float
  • genres — array
  • pub_date — int
  • movie_id — int
  • created_at — date

Review (Untitled3)

  • id — int — 기본 키 — NOT NULL
  • movie — foreignKey — 외래 키 → Movie.id — NOT NULL
  • user — foreignKey — 외래 키 → user.id — NOT NULL
  • content — text
  • created_at — date
  • updated_at — date
  • rate — int

like (Untitled6)

  • like_user — manyTomanny — 외래 키 → user.id — NOT NULL
  • like_article — manyTomany — 외래 키 → Article.id — NOT NULL

user (Untitled)

  • id — int — 기본 키 — NOT NULL
  • username — text
  • followers — manyTomany — 외래 키 → user.id — NOT NULL
  • nickname — text
  • itro — text
  • photo — img
  • img_thumbnail — img