week1-mission
Tables (11)
food_categories
- food_category_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — STRING — NOT NULL
member_mission
- member_mission_id (Key) — BIGINT — Primary key — NOT NULL
- mission_id (Key2) — BIGINT — Foreign key → missions.mission_id — NOT NULL
- member_id (Key3) — BIGINT — Foreign key → members.member_id — NOT NULL
- status (Field) — ENUM('COMPLETED' | 'IN PROGRESS') — NOT NULL — 수행 완료 여부
- completed_at (Field2) — DATETIME — 수행 완료 시점
member_preferences
- member_preference_id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → members.member_id — NOT NULL
- preference_id (Key3) — BIGINT — Foreign key → preferences.preference_id — NOT NULL
members
- member_id (Key) — BIGINT — Primary key — NOT NULL
- nickname (Field) — STRING — NOT NULL
- created_at (Field2) — DATETIME — NOT NULL
- password (Field3) — STRING
- provider (Field4) — STRING
- social_id (Field5) — STRING
- is_widthdrawn (Field6) — BOOLEAN — NOT NULL — 탈퇴 여부
- store_id (Key2) — BIGINT — Foreign key → stores.store_id — NOT NULL
missions
- mission_id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — STRING — NOT NULL — 미션 제목
- description (Field2) — STRING — NOT NULL — 미션 설명
- store_id (Key2) — BIGINT — Foreign key → stores.store_id — NOT NULL
notificatons
- notificaton_id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → members.member_id — NOT NULL
- content (Field2) — STRING — NOT NULL
- is_read (Field) — BOOLEAN — NOT NULL — 읽었는지 여부
- crerated_at (Field3) — DATETIME — NOT NULL
points
- points (Key) — BIGINT — Primary key — NOT NULL
- amount (Field) — INT — NOT NULL — 받은 포인트의 양
- reason (Field2) — STRING — NOT NULL — 왜 받았는지
- created_at (Field3) — DATETIME — NOT NULL — 언제 받았는지
- region_id (Key2) — BIGINT — Foreign key → regions.region_id — NOT NULL
preferences
- preference_id (Key) — BIGINT — Primary key — NOT NULL
- content (Field) — STRING — NOT NULL — 선호도 내용
regions
- region_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — STRING — NOT NULL — 지역 이름
reviews
- review_id (Key) — BIGINT — Primary key — NOT NULL
- content (Field) — STRING — NOT NULL — 리뷰 내용
- created_at (Field2) — DATETIME — NOT NULL
- member_mission_id (Key2) — BIGINT — Foreign key → member_mission.member_mission_id — NOT NULL
stores
- store_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — STRING — NOT NULL
- description (Field3) — STRING
- region_id (Key2) — BIGINT — Foreign key → regions.region_id — NOT NULL
- food_category_id (Key3) — BIGINT — Foreign key → food_categories.food_category_id — NOT NULL
- latitude (Field2) — DECIMAL — 위도
- longitude (Field4) — DECIMAL — 경도