UMC 10th 1weak
Tables (5)
Untitled (User)
- Key (user_id) — INT — Primary key — NOT NULL
- Field (email) — VARCHAR(100)
- Field2 (password) — VARCHAR(100)
- Field3 (nickname) — VARCHAR(50)
- Field4 (point) — INT
- Field5 (created_at) — INT
Untitled (Region)
- Key (region_id) — INT — Primary key — NOT NULL
- Field (region_name) — VARCHAR(50)
Untitled2 (Store)
- Key (store_id) — INT — Primary key — NOT NULL
- Field (region_id) — INT
- Field2 (store_name) — VARCHAR(100)
- Field3 (address) — VARCHAR(200)
- Key (region_id2) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled3 (Mission)
- Key (mission_id) — INT — Primary key — NOT NULL
- Field2 (mission_name) — VARCHAR(100)
- Field3 (point) — INT
- Key (store_id) — INT — Foreign key → Untitled2.Key — NOT NULL
Untitled4 (User_Mission)
- Key (user_mission_id) — INT — Primary key — NOT NULL
- Field (user_id) — INT
- Field2 (mission_id) — INT
- Field3 (status) — VARCHAR(20)
- Field4 (completed_at) — DATETIME
- Key (mission_id2) — INT — Foreign key → Untitled3.Key — NOT NULL
- Key (user_id2) — INT — Foreign key → Untitled.Key — NOT NULL