MVP

Tables (7)

Map

  • map_id — Bigint — Primary key — NOT NULL
  • id (id2) — Bigint — Foreign key → User.id — NOT NULL
  • location — varchar(20)

Mission

  • mtssion_id — Bigint — Primary key — NOT NULL
  • title — varchar(20)
  • description — text

User

  • id — Bigint — Primary key — NOT NULL
  • name — varchar(20)
  • gender — enum
  • date — Bigint
  • address — text
  • created_at — datetime
  • updated_at — datetime
  • state — enum
  • outTime — datetime
  • point — Bigint
  • location — varchar(20)

alarm

  • alarm_id — Bigint — Primary key — NOT NULL
  • id (id2) — Bigint — Foreign key → User.id — NOT NULL
  • title — varchar(20)
  • description — text
  • Field

review

  • Key — Foreign key → store.store_id — NOT NULL
  • id — Bigint — Foreign key → User.id — NOT NULL
  • score — Bigint
  • description — text
  • created_at — datetime

store

  • store_id — Bigint — Primary key — NOT NULL
  • map_id — Bigint — Foreign key → Map.map_id — NOT NULL
  • id (id2) — Bigint — Foreign key → Map.id — NOT NULL
  • name — varchar(20)
  • description — text

user_mission

  • id — Bigint — Foreign key → User.id — NOT NULL
  • mtssion_id — Bigint — Foreign key → Mission.mtssion_id — NOT NULL
  • map_id — Bigint — Foreign key → Map.map_id — NOT NULL
  • id (id2) — Bigint — Foreign key → Map.id — NOT NULL
  • state — enum
  • updated_at — datetime