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