ㅇㅇ - 2026-03-20 04:57:25
Tables (7)
area
- id — INT
- address — VARCHAR(50) — NOT NULL
food_category
- id — INT
- name — VARCHAR(50) — NOT NULL
mission
- id — INT
- store_id — INT — Foreign key
- reward — INT
- description — TEXT
preference
- id — INT
- user_id — INT — Foreign key
- category_id — INT — Foreign key
store
- id — INT
- name — VARCHAR(50)
- category_id — INT — Foreign key
- description — TEXT
- addr — INT — Foreign key
user
- id — INT
- email — VARCHAR(100)
- nickname — VARCHAR(50)
- phone_num — VARCHAR(20)
- gender — ENUM('MALE', 'FEMALE', 'NONE')
- birth_date — DATE
- address — VARCHAR(100)
- point — INT
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
user_mission
- id — INT
- store_id — INT — Foreign key
- user_id — INT — Foreign key
- status — ENUM('ONGOING', 'COMPLETE')