영화추천

테이블 (7)

Article (Untitled3)

  • articleid (pk) — int — 기본 키 — NOT NULL
  • username (Field4) — string — 외래 키 → User.username
  • movieid (id) — int — 외래 키 → Movie.movieid — NOT NULL
  • title (Field2) — string
  • content (Field) — string
  • createdat (Field3) — date
  • updatedat (Field5) — date
  • rating (Field6)

Comment (Untitled4)

  • username (Field3) — string — 외래 키 → User.username
  • articleid (pk) — int — 외래 키 → Article.articleid — NOT NULL
  • username (Field4) — string — 외래 키 → Article.username
  • content (Field) — string
  • createdat (Field2) — date
  • updatedat (Field5) — date
  • Field6

Movie (Untitled5)

  • movieid (id) — int — 기본 키 — NOT NULL
  • movietitle (Field) — string
  • overview (Field2) — string
  • genre (Field3) — string
  • actors (Field4) — string
  • poster (Field5) — string
  • 평점 (Field6) — int
  • Field7

User (Untitled)

  • username (Field) — string — 기본 키
  • password (Field2) — string
  • 성별 (Field3) — boolean
  • Field4

like (Untitled2)

  • username (Field2) — string — 외래 키 → User.username
  • articleid (pk) — int — 외래 키 → Article.articleid — NOT NULL
  • Field

예고 comment (Untitled7)

  • username (Field) — string — 외래 키 → User.username
  • movieid (id) — int — 외래 키 → Movie.movieid — NOT NULL

장바구니 (Untitled6)

  • username (Field) — string — 외래 키 → User.username
  • movieid (id) — int — 외래 키 → Movie.movieid — NOT NULL
  • createdat (Field1) — date
  • updatedat (Field2) — date
  • Field3