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