Zanit

Tables (4)

Bar (바)

  • BarUID (바고유번호) — Primary key — NOT NULL
  • Bar_name (바이름) — String
  • Bar_location (바위치) — String
  • Bar_mood (바분위기) — String
  • Bar_phone (바 번호) — String
  • UID (회원고유번호) — Foreign key → User.UID — NOT NULL

Cocktail (칵테일)

  • Cocktail (칵테일고유번호) — Primary key — NOT NULL
  • BarUID (바고유번호) — Foreign key → Bar.BarUID — NOT NULL
  • Cocktail_name (칵테일이름) — String
  • Cocktail_detail (칵테일설명) — String
  • Cocktail_price (칵테일가격) — num
  • reco_user (추천사용자유형)

Coupon (쿠폰)

  • CouponUID (쿠폰구분고유번호) — String — Primary key — NOT NULL
  • UID (회원고유번호) — Foreign key → User.UID — NOT NULL
  • Coupon_name (쿠폰이름) — String
  • exp_date (유효기간)
  • use (사용여부) — boolean
  • Cocktail (사용된 칵테일) — Foreign key → Cocktail.Cocktail — NOT NULL
  • BarUID (사용된 바) — Foreign key → Cocktail.BarUID — NOT NULL

User (유저)

  • UID (회원고유번호) — Primary key — NOT NULL
  • name (이름) — String
  • phone (번호) — String
  • password (비밀번호)
  • marketing (마케팅동의여부) — boolean
  • subcribe (구독여부) — boolean
  • gender (성별) — boolean
  • role (유저,바주인 여부) — short