UMC 0week
테이블 (9)
가게 (store)
- store_id (Key) — INT — 기본 키 — NOT NULL
- location_id (Key2) — INT — 외래 키 → 지역.location_id — NOT NULL
- name (Field) — VARCHAR(10)
- manager_number (Field2) — INT
- address (Field3) — VARCHAR(100)
- created_at (Field4) — Date
- updated_at (Field5) — Date
리뷰 (Review)
- review_id (Key2) — INT — 기본 키 — NOT NULL
- member_id (PK) — INT — 외래 키 → 유저.member_id — NOT NULL
- store_id (Key) — INT — 외래 키 → 가게.store_id — NOT NULL
- location_id (Key22) — INT — 외래 키 → 가게.location_id — NOT NULL
- star (Field) — FLOAT
- review_content (Field2) — VARCHAR(100)
- review_photo (Field5) — VARCHAR(100)
- created_at (Field3) — Date
- updated_at (Field4) — Date
리뷰 답글 (Review_reply)
- reply_id (Key) — INT — 기본 키 — NOT NULL
- review_id (Key2) — INT — 외래 키 → 리뷰.review_id — NOT NULL
- location_id (Key22) — INT — 외래 키 → 리뷰.location_id — NOT NULL
- reply_content (Field) — VARCHAR(100)
- created_at (Field2) — Date
- updated_at (Field3) — Date
미션 (Mission)
- mission_id (Key) — INT — 기본 키 — NOT NULL
- store_id (Key2) — INT — 외래 키 → 가게.store_id — NOT NULL
- deadline (Field) — Date
- title (Field2) — VARCHAR(10)
- reward_point (Field3) — INT
- reward_description (Field4) — VARCHAR(100)
- created_at (Field5) — Date
- updated_at (Field6) — Date
유저 (user)
- member_id (PK) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50)
- gender (Field2) — ENUM('M','F','N')
- birth_date (Field3) — Date
- address (Field4) — VARCHAR(100)
- email (Field5) — VARCHAR(100)
- point (Field6) — INT
- created_at (Field7) — Date
- updated_at (Field8) — Date
유저 미션 (user_mission)
- member_id (PK) — INT — 외래 키 → 유저.member_id — NOT NULL
- mission_id (Key) — INT — 외래 키 → 미션.mission_id — NOT NULL
- is_complete (Field) — bit
- created_at (Field3) — Date
- updated_at (Field4) — Date
유저 선호 음식 (user_food)
- user_food_id (Key) — INT — 기본 키 — NOT NULL
- member_id (FK1) — INT — 외래 키 → 유저.member_id — NOT NULL
- category_id (FK2) — INT — 외래 키 → 음식.category_id — NOT NULL
- created_at (Field) — Date
- updated_at (Field2) — Date
음식 (food)
- category_id (PK) — INT — 기본 키 — NOT NULL
- category_name (Field) — VARCHAR(50)
- created_at (Field2) — Date
- updated_at (Field3) — Date
지역 (location)
- location_id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(10)