영화추천
테이블 (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