노드 과제 피드백 적용
테이블 (10)
food_preference
- id — BIGINT
- food_name — VARCHAR(50) — NOT NULL
location_history
- id — BIGINT
- member_id — BIGINT — NOT NULL
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
member
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- social_type — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- gender — VARCHAR(10)
- birthdate — DATE
- address — VARCHAR(255)
- mission_completion_rate — INT
- status — VARCHAR(15) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
member_agreement
- id — BIGINT
- member_id — BIGINT — NOT NULL
- terms_id — BIGINT — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
member_mission
- id — BIGINT
- mission_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- completed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
member_preference
- id — BIGINT
- member_id — BIGINT — NOT NULL
- food_id — BIGINT — NOT NULL
mission
- id — BIGINT
- restaurant_id — BIGINT — NOT NULL
- point — INT — NOT NULL
- price_threshold — INT — NOT NULL
- auth_code — VARCHAR(10) — NOT NULL
- status — VARCHAR(15) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
notification
- id — BIGINT
- member_id — BIGINT — NOT NULL
- content — TEXT
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
point_history
- id — BIGINT
- member_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- reason — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
restaurant
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- type — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- status — VARCHAR(15) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL