umc0주차
테이블 (7)
Member
- member_id — INT — 기본 키
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100)
- phone_number — VARCHAR(20)
- total_points — INT
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
- point_history_id — INT — 외래 키 → Point_History.point_history_id
- notification_id — INT — 외래 키 → Notification.notification_id
Member_Mission
- member_mission_id — INT — 기본 키
- member_id — INT
- mission_id — INT
- status — VARCHAR(20)
- assigned_at — DATETIME
- completed_at — DATETIME
- mission_id (mission_id2) — INT — 외래 키 → Mission.mission_id
- review_id — INT — 외래 키 → Review.review_id
- member_id (member_id2) — INT — 외래 키 → Member.member_id
Mission
- mission_id — INT — 기본 키
- store_id — INT
- title — VARCHAR(255)
- description — TEXT
- reward_points — INT
- start_date — DATE
- end_date — DATE
- status — VARCHAR(20)
- created_at — DATETIME
- store_id (store_id2) — INT — 외래 키 → Store.store_id
Notification
- notification_id — INT — 기본 키
- member_id — INT
- type — VARCHAR(50)
- content — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
Point_History
- point_history_id — INT — 기본 키
- member_id — INT
- amount — INT
- reason — VARCHAR(255)
- related_id — INT
- created_at — DATETIME
Review
- review_id — INT — 기본 키
- member_mission_id — INT
- rating — INT
- content — TEXT
- image_url — VARCHAR(255)
- created_at — DATETIME
Store
- store_id — INT — 기본 키
- store_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- description — TEXT
- phone_number — VARCHAR(20)
- category — VARCHAR(50)