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)