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