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