umc_1

Tables (6)

missions

  • mission_id — BIGINT — Primary key — NOT NULL
  • store_id (store_id2) — BIGINT — Foreign key → stores.store_id — NOT NULL
  • region_id (region_id2) — BIGINT — Foreign key → stores.region_id — NOT NULL
  • store_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL

point_transactions

  • point_tx_id — BIGINT — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • region_id (region_id2) — BIGINT — Foreign key → regions.region_id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • region_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • milestone_n — INT — NOT NULL

regions

  • region_id — BIGINT — Primary key — NOT NULL
  • region_name — VARCHAR(100) — NOT NULL

stores

  • store_id — BIGINT — Primary key — NOT NULL
  • region_id (region_id2) — BIGINT — Foreign key → regions.region_id — NOT NULL
  • region_id — BIGINT — NOT NULL
  • store_name — VARCHAR(200) — NOT NULL

user_missions

  • user_mission_id — BIGINT — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • mission_id (mission_id2) — BIGINT — Foreign key → missions.mission_id — NOT NULL
  • store_id (store_id2) — BIGINT — Foreign key → missions.store_id — NOT NULL
  • region_id (region_id2) — BIGINT — Foreign key → missions.region_id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • mission_id — BIGINT — NOT NULL
  • status — ENUM('ASSIGNED','IN_PROGRESS','COMPLETED') — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL