UMC 2

Tables (10)

ALARM

  • Key (id) — bigint — Primary key — NOT NULL
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)
  • (alarm_contents) — varchar(100)
  • (alarm_list) — varchar(100)

CHALLENGE_MISSION

  • PK (id) — bigint — Foreign key → MY_Mission.PK — NOT NULL
  • (challenge_date) — timestamp
  • (mission_name) — varchar(100)
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL

COMPLETE_MISSION

  • PK (id) — bigint — Foreign key → MY_Mission.PK — NOT NULL
  • (challenge_date) — timestamp
  • (mission_name) — varchar(100)
  • (complete_date) — timestamp
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL

FOOD_PREFER

  • Key (id) — bigint — Primary key — NOT NULL
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL
  • Key (food_id) — bigint — Foreign key → Food.Key — NOT NULL

Food (FOOD)

  • Key (id) — bigint — Primary key
  • (food) — varchart(20)

MY_Mission

  • PK (id) — bigint — Primary key — NOT NULL
  • (mission_name_list) — varchar(100)
  • (complete_mission_count) — int
  • (challenge_mission_count) — int
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL

MY_PAGE (MYMENU)

  • Key (id) — bigint — Primary key — NOT NULL
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL
  • (my_point) — int
  • (info_change) — var
  • (login) — var
  • (logout) — var
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)

REVIEW

  • PK (id) — bigint — Primary key — NOT NULL
  • KEY (user_id) — bigint — Foreign key → USER.KEY — NOT NULL
  • (star_score) — int
  • (photo_review) — BLOP
  • (comment_review) — varchar(200)
  • (nick_name) — varchar(100)
  • (date) — timestamp
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)

USER

  • KEY (id) — bigint — Primary key — NOT NULL
  • (name) — varchar(20)
  • (Nickname) — varchar(20)
  • (gender) — varchar(10)
  • (birth) — datetime
  • (address) — varchar(100)
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)
  • KEY (phone_number) — int — NOT NULL

Untitled (RESTAURANT)

  • PK (id) — bigint — Foreign key → REVIEW.PK — NOT NULL
  • KEY (review_id) — bigint — Foreign key → REVIEW.KEY — NOT NULL
  • Field (name) — varchar(100)
  • Field2 (address) — varchar(200)
  • Field3 (category) — varchar(100)
  • Field (time) — time