UMC 중앙 1주차

테이블 (7)

food_category (Untitled2)

  • id (Key) — Long — 기본 키 — NOT NULL
  • category_name (Field) — String — NOT NULL

mission (Untitled5)

  • id (Key2) — Long — 기본 키 — NOT NULL
  • store_id (Key) — Long — 외래 키 → store.id — NOT NULL
  • d_day (Field) — int — NOT NULL
  • title (Field2) — String — NOT NULL
  • content (Field3) — String — NOT NULL
  • reward_point (Field4) — int — NOT NULL

region (Untitled7)

  • id (Key) — Long — 기본 키 — NOT NULL
  • region_name (Field)

store (Untitled6)

  • id (Key) — Long — 기본 키 — NOT NULL
  • region_id (Key2) — Long — 외래 키 → region.id — NOT NULL
  • store_name (Field) — String — NOT NULL
  • store_address (Field2) — String — NOT NULL

user (Untitled)

  • id (Key) — Long — 기본 키 — NOT NULL
  • provider (Field6) — enum — NOT NULL — kakao, naver. apple. google
  • nickname (Field) — String — NOT NULL
  • gender (Field2) — enum — male, female, null
  • birth_date (Field3) — LocalDate — NOT NULL
  • point (Field9) — int — NOT NULL — 0~999,999
  • address (Field4) — String — NOT NULL
  • created_at (Field5) — LocalDateTime — NOT NULL
  • updated_at (Field8) — LocalDateTime — NOT NULL
  • deleted_at (Field7) — LocalDateTime — NOT NULL — Soft Delete 사용시

user_food_preference (Untitled3)

  • user_id (Key) — Long — 외래 키 → user.id — NOT NULL
  • food_category_id (Key2) — Long — 외래 키 → food_category.id — NOT NULL

user_mission (Untitled4)

  • id (Key3) — Long — 기본 키 — NOT NULL
  • user_id (Key) — Long — 외래 키 → user.id — NOT NULL
  • mission_id (Key2) — Long — 외래 키 → mission.id — NOT NULL
  • status (Field) — enum — NOT NULL — 성공, 실패, 시도중
  • completed_at (Field2) — LocalDateTime