UMC_8th

Tables (10)

alarm

  • id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • is_confirmed — tinyint(1) — NOT NULL — 확인 유무
  • created_at — datetime(6)
  • updated_at — datetime(6)

food_like

  • id — bigint — NOT NULL
  • name — varchar(20) — NOT NULL
  • selected — int — NOT NULL — 체크 유무

member

  • id — bigint — NOT NULL
  • password — varchar(20) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • gender — varchar(20) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • status — varchar(15)
  • inactive_date — datetime
  • address — varchar(20) — NOT NULL — 주소
  • agreement — int — NOT NULL — 약관 동의 유무

member_food_like

  • id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • food_like_id — bigint — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_mission

  • id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • mission_id — bigint — NOT NULL
  • status — varchar(20) — NOT NULL — 진행 상황 확인 (완료 유무 등)
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

  • id — bigint — NOT NULL
  • deadline — varchar(20) — NOT NULL — 마감 기한
  • condition — varchar(20) — NOT NULL — 완료 조건
  • store_id — bigint — NOT NULL

mission_alarm

  • id — bigint — NOT NULL
  • alarm_id — bigint — NOT NULL
  • title — varchar(30)
  • body — text

review_alarm

  • id — bigint — NOT NULL
  • alarm_id — bigint — NOT NULL
  • title — varchar(30)
  • body — text

store

  • id — bigint — NOT NULL
  • name — varchar(20) — NOT NULL
  • category_id — bigint — NOT NULL

store_category

  • id — bigint — NOT NULL
  • name — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)