winery
Tables (6)
Untitled (wine)
- Key (wine_id) — int — Primary key — NOT NULL
- Field (wine_name) — string
- Field (type) — string
- Field (country) — string
- Field (winery) — string
- Field (variety) — string
- Field (sweet) — int
- Field (acidity) — int
- Field2 (body) — int
- Field (information) — string
- Field (wine_image_url) — string
- Field (create_date) — date
- Field (modify_date) — date
- Field (description) — string
Untitled (tag)
- Key (tag_id) — int — Primary key — NOT NULL
- Field (t ag_name) — string
- Field (create_date) — date
- Field (modify_date) — date
- Key (wine_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (review)
- Key (review_id) — int — Primary key — NOT NULL
- Field (contents) — string
- Field (create_date) — date
- Field (modify_date) — date
- Field (price) — int
- Field2 (location) — string
- Key (user_id) — string — Foreign key → user.Key — NOT NULL
- Key (wine_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (open) — boolean
Untitled (review_image)
- Key (review_image_id) — int — Primary key — NOT NULL
- Key (review_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — string
Untitled (evaluate)
- Key (evaluate_id) — int — Primary key — NOT NULL
- Key (user_id) — string — Foreign key → user.Key — NOT NULL
- Key (review_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (like) — int
user
- Key (user_id) — string — Primary key — NOT NULL
- Field (user_name) — string
- Field (email) — string
- Field (age) — int
- Field (gender) — string
- Field (user_image_url) — string
- Field (privilege) — string
- Field (create_date) — date
- Field (modify_date) — date