umc_mission
Tables (6)
done_mission (CopyOfUntitled3)
- 식별자 (done_mission_id) — bigint — Primary key — NOT NULL
- (mission_id2) — bigint — Foreign key → mission.식별자 — NOT NULL
- (member_id) — bigint — Foreign key → mission.member_id — NOT NULL
- (region_id) — bigint — Foreign key → mission.region_id — NOT NULL
- restaurant — varchar(45)
- remain date (d_day) — bigint
- status — varchar(10)
- created_at — datetime
- updated_at — datetime
- verication_code — varchar(15)
like_food (Untitled2)
- 식별자 (like_food_id) — bigint — Primary key — NOT NULL
- 식별자 (member_id) — bigint — Foreign key → member.식별자 — NOT NULL
- 음식 이름 (food) — varchar(45)
- created_at — datetime
- updated_at — datetime
member (Untitled)
- 식별자 (member_id) — bigint — Primary key — NOT NULL
- 이름 (name) — varchar(20)
- 성별 (gender) — varchar(10)
- 생년월일 (birth_date) — date
- 주소 (address) — varchar(45)
- created_at — datetime
- updated_at — datetime
- 위치정보 제공 동의 (location_consent) — boolean
- 마케팅 수신 동의 (marketing_consent) — boolean
- oauth_provider — varchar(10)
mission (Untitled3)
- 식별자 (mission_id) — bigint — Primary key — NOT NULL
- (member_id) — bigint — Foreign key → member.식별자 — NOT NULL
- (region_id) — bigint — Foreign key → region.식별자 — NOT NULL
- restaurant — varchar(45)
- remain date (d_day) — bigint
- status — varchar(10)
- created_at — datetime
- updated_at — datetime
- verication_code — varchar(15)
region (Untitled5)
- 식별자 (region_id) — bigint — Primary key — NOT NULL
- region_name — varchar(20)
region_mission (Untitled4)
- 식별자 (region_mission_id) — bigint — Primary key — NOT NULL
- (done_mission_id) — bigint — Foreign key → done_mission.식별자 — NOT NULL
- (mission_id2) — bigint — Foreign key → done_mission.mission_id2 — NOT NULL
- (member_id) — bigint — Foreign key → done_mission.member_id — NOT NULL
- (region_id) — bigint — Foreign key → region.식별자 — NOT NULL
- 지역 이름 (region_name) — varchar(45)
- created_at — datetime
- updated_at — datetime