UMC2
Tables (14)
Alert
- alertId — int — Primary key — NOT NULL
- alert — varchar
User
- user_id — int — Primary key — NOT NULL
- name — varchar — NOT NULL
- sex — Enum — NOT NULL
- birthDate — varchar(8) — NOT NULL
- adress — varchar — NOT NULL — 지역구
- detail_address — varchar
- phone — varchar
- point — int
- email — varchar
- status — Boolean
- vaidDate — Date
User_alert
- user_id — int — Foreign key → User.user_id — NOT NULL
- alertId — int — Foreign key → Alert.alertId — NOT NULL
- alert — Date
- watched — Boolean
User_preferencefood
- user_food_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
- Field — VARCHAR(255)
- food_id — int — Foreign key → cusine.food_id — NOT NULL
User_promise
- promiseId — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
- agree — Boolean
- promiseId (promiseId3) — int — Foreign key → promise.promiseId — NOT NULL
cusine
- food_id — int — Primary key — NOT NULL
- cusine — Enum — 양식 중식 한식
location
- localId — int — Primary key — NOT NULL
- Local — varchar — 구
mission
- mission_id — int — Primary key — NOT NULL
- vaildDate — Date
- givePoint — int(10)
- pay — int(10)
- restourantId — int — Foreign key → restourant.restourantId — NOT NULL
promise
- promiseId — int — Primary key — NOT NULL
- promise — varchar
restourant
- restourantId — int — Primary key — NOT NULL
- restourantname — varchar
- restourantAdress — varchar
- localId — int — NOT NULL
- localId (localId2) — int — Foreign key → location.localId — NOT NULL
restourant_cusine
- restourant_cusine_id — int — Primary key — NOT NULL
- restourantId — int — Foreign key → restourant.restourantId — NOT NULL
- food_id — int — Foreign key → cusine.food_id — NOT NULL
review
- reviewId — int — Primary key — NOT NULL
- context — varchar
- created_at — timestamp
- star — float
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL
- restourantId (restourantId2) — int — Foreign key → restourant.restourantId — NOT NULL
review_comment
- responseId — int — Primary key — NOT NULL
- context — varchar
- reviewId (reviewId2) — int — Foreign key → review.reviewId — NOT NULL
user_mission
- mission_id — int — Foreign key → mission.mission_id — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
- isSucess — Boolean
- sucessDate — varchar(8)