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

Untitled8

    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