ㅅㅅ
Tables (6)
RestaurantInfo
- idxRestaurant — INT — Primary key — NOT NULL
- addrRestaurant — VARCHAR(45) — NOT NULL
- menuRestaurant — JSON
- reviewBoardRestaurant — JSON
- RestaurantInfocol — VARCHAR(45)
UserCoupon
- idxCoupon — INT — Primary key — NOT NULL
- codeCoupon — VARCHAR(45)
- nameCoupon — VARCHAR(45)
- minCostCoupon — VARCHAR(45)
- discountCoupon — INT
- expFromCoupon — DATETIME
- expToCoupon — DATETIME
- infoCoupon — VARCHAR(45)
- idxUser — INT — Foreign key → UserInfo.idxUser — NOT NULL
- INDEX — `fk_idxUser_idx`
UserDeliverAddress
- idxAddr — INT — Primary key — NOT NULL
- idxUser — INT — Foreign key → UserInfo.idxUser — NOT NULL
- infoAddr — VARCHAR(45) — NOT NULL
- INDEX — `fk_idxUser_deliver_idx`
UserDeliverInfo
- idxUser — INT — Foreign key → UserInfo.idxUser — NOT NULL
- needDisposable — TINYINT
- needKimchi — TINYINT
- requestToRes — VARCHAR(40) — NOT NULL
- requestToDeliver — VARCHAR(45) — NOT NULL
UserInfo
- idxUser — INT — Foreign key → UserInfo.idxUser — NOT NULL
- emailUser — VARCHAR(100) — NOT NULL
- passwdUser — VARCHAR(45) — NOT NULL
- userPhoneNumber — VARCHAR(45) — NOT NULL
- userNickname — VARCHAR(10) — NOT NULL
- userCreatedAt — DATETIME — NOT NULL
- userUpdatedAt — DATETIME — NOT NULL
- userAlarmMail — TINYINT
- userAlarmSNS — TINYINT
- idxRestaurant — INT
- idxUser — INT — NOT NULL
- contentReview — VARCHAR(45)
- starReview — INT
- INDEX — `fk_idxUser_review_idx`
UserOrder
- idxOrder — INT — Primary key — NOT NULL
- idxUser — INT — Foreign key → UserInfo.idxUser — NOT NULL
- idxRestaurant — INT
- menuOrder — VARCHAR(45)
- priceOrder — INT
- idxAddr — INT
- INDEX — `fk_idxUser_delivery_idx`