umc_mission

Tables (6)

alarm (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • status (on/off) — boolean
  • title (Field) — varchar(50)
  • content (Field2) — text
  • created_at (Field3) — date
  • updated_at (Field4)
  • dtype (Field6)
  • is_confirmed (Field5)
  • id (Key2) — bigint — Foreign key → user.id — NOT NULL

member_mission (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • Field
  • created_date (Field2)
  • updated_date (Field3)
  • status (Field4)
  • mission_id (Key3) — bigint — Foreign key → mission.id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL

mission (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • created_date (Field2) — datetime
  • updated_date (Field3) — datetime
  • price (Field) — int
  • point (Field4) — int
  • store_id (Key2) — bigint — Foreign key → store.id — NOT NULL

review (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • score (Field) — float
  • content (Field2) — text
  • photo (Field3) — image
  • id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • id (Key3) — bigint — Foreign key → store.id — NOT NULL

store (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • price (Field2) — int
  • certi_num (Field3) — int
  • latitude (Field4) — int
  • longitude (Field5) — int

user (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL
  • gender (Field2) — enum
  • birthdat (Field3) — date
  • food (Field4) — varchar(50)
  • address (Field9) — varchar(60)
  • created_date (Field5) — datetime(6)
  • updated_date (Field6) — datetime(6)
  • status (Field7) — varchar(15)
  • inactive_date (Field8) — datetime
  • total_point (Field10) — bigint
  • phone_num (Field11)