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