ㅇㅇ
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 → store.id
- reward — INT
- description — TEXT
preference
- id — INT
- user_id — INT — Foreign key → user.id
- category_id — INT — Foreign key → food_category.id
store
- id — INT
- name — VARCHAR(50)
- category_id — INT — Foreign key → food_category.id
- description — TEXT
- addr — INT — Foreign key → area.id
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 → store.id
- user_id — INT — Foreign key → user.id
- status — ENUM('ONGOING', 'COMPLETE')