test
Tables (7)
Untitled (food_category)
- Key (id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(50)
Untitled (area)
- Key (id) — INT — Primary key — NOT NULL
- Field (address) — VARCHAR(50)
Untitled (store)
- Key — INT — Primary key — NOT NULL
- Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (addr) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(50)
- Field (description) — TEXT
Untitled (preference)
- Key (id) — INT — Primary key — NOT NULL
- Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — INT — Foreign key → user.Key — NOT NULL
Untitled (mission)
- Key (id) — INT — Primary key — NOT NULL
- Field (reward) — INT
- Field (description) — TEXT
user
- Key (id) — INT — Primary key — NOT NULL
- Field (nickname) — VARCHAR(50)
- Field (phone_num) — VARCHAR[30]
- Field (gender) — ENUM('M', 'F', 'NONE')
- Field (email) — VARCHAR(100)
- Field2 (birth_date) — DATE
- Field (address) — VARCHAR(100)
- Field (point) — INT
- Field (status) — ENUM('ACTIVE', 'INACTIVE')
- Field (created_at) — DATETIME(6)
- Field (updated_at) — DATETIME(6)
user_mission
- id — INT
- store_id — INT — Foreign key
- user_id — INT — Foreign key
- status — ENUM('ONGOING', 'COMPLETE')