UMC 미션

테이블 (7)

Member (Untitled)

  • id — bigint — 기본 키 — NOT NULL
  • email — varchar(50)
  • password — varchar(200)
  • name (real_name) — varchar(50) — NOT NULL
  • gender — int
  • age — int
  • point (Point) — int
  • updated_at — datetime(6)
  • created_at — datetime(6)
  • address (Field) — varchar(50)
  • birthday (Field2) — varchar(50)
  • status (Field3) — varchar(15)
  • inactive_date (Field4) — datetime
  • prefer_food (Field5) — varchar(10)

Mission (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(50)
  • description (Field2) — varchar(200)
  • created_at (Field3) — datetime(6)
  • upated_at (Field4) — datetime(6)

my_mission (Untitled2)

  • id — bigint — 기본 키 — NOT NULL
  • member_id (id2) — bigint — 외래 키 → Member.id — NOT NULL
  • mission_id (Key) — bigint — 외래 키 → Mission.id — NOT NULL
  • ongoing_mission (Field) — varchar(50)
  • completed_mission (Field2) — varchar(50)
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)

new_mission_alarm (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (id) — bigint — 외래 키 → Member.id — NOT NULL
  • name (Field) — varchar(50)
  • is_confirmed (Field2) — boolean
  • description (Field3) — varchar(200)
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)

review (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • store_id (Key2) — bigint — 외래 키 → store.id — NOT NULL
  • member_id (id) — bigint — 외래 키 → Member.id — NOT NULL
  • reward (Field) — int
  • updated_at (Field2) — datetime(6)
  • created_at (Field3) — datetime(6)

review_request_alarm (Untitled6)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • memever_id (id) — bigint — 외래 키 → Member.id — NOT NULL
  • name (Field) — varchar(50)
  • description (Field2) — varchar(200)
  • updated_at (Field3) — datetime(6)
  • created_at (Field4) — datetime(6)

store (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(50)
  • category (Field2) — varchar(10)
  • address (Field3) — varchar(100)
  • rating (Field4) — double(1)
  • reward (Field5) — int
  • updated_at (Field6) — datetime(6)
  • created_at (Field7) — datetime(6)
  • cost (Field8) — int