Wine
Tables (8)
Like_user (Untitled7)
- Key (id) — INT — Primary key — NOT NULL
- 유저id (userid) — INT
- 좋아요누른id (liked_user_id) — INT
Like_wine (Untitled6)
- Key (id) — INT — Primary key — NOT NULL
- 유저id (user_id) — INT
- 와인id (wine_id) — INT
- Field
Review (Untitled4)
- 유저id (user_id) — INT — Primary key — NOT NULL
- 리뷰id (review_id) — INT — Primary key — NOT NULL
- 와인id (wineid) — INT
- 사진 (photo) — BLOB
- 내용 (content) — VARCHAR(300)
Review_rate (Untitled5)
- Key (id) — INT — Primary key — NOT NULL
- 유저id (user_id) — INT
- 리뷰id (review_id) — INT
- 외관 (look)
- 향 (smell)
- 맛 (taste)
- 느낌 (feel)
- 평점 (overall) — FLOAT
User (Untitled)
- 회원번호 (userid) — INT — Primary key — NOT NULL
- 회원이름 (username) — VARCHAR
- 이메일 (email) — VARCHAR
- 비밀번호 (password) — VARCHAR
- 유저타입 (usertype) — BOOLEAN
Wine_information (Untitled2)
- 와인id (wineid) — INT — Primary key — NOT NULL
- 와인명 (winename) — VARCHAR
Winery (Untitled3)
- 양조장id (wineryid) — INT — Primary key — NOT NULL
- 양조장이름 (wineryname) — VARCHAR