맛집
테이블 (11)
Food (음식)
- food_id (PK) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(100)
Member (유저)
- member_id (PK) — bigint — 기본 키 — NOT NULL
- name (Field1) — varchar(50)
- gender (Field2) — varchar(10)
- birthday (Field3) — datatime
- social_provider (Field4) — varchar(10)
- created_at (Field5) — datatime(6)
- update_at (Field6) — datetime(6)
- status (Field7) — varchar(10)
- inactive_date (Field8) — datetime
- like_food (Field9) — varchar(20)
- address (Field10) — varchar(50)
Member_Mission (유저 미션)
- user_mission_id (Key) — 기본 키 — NOT NULL
- status (Field4) — int
- member_id (PK) — bigint — 외래 키 → Member.member_id — NOT NULL
- mission_id (PK2) — bigint — 외래 키 → Mission.mission_id — NOT NULL
Mission (미션)
- mission_id (PK) — bigint — 기본 키 — NOT NULL
- reward_point (Field) — bigint
- minimum_price (Field2) — bigint
- region (Field7) — varchar(50)
- is_active (Field3) — int
- restaurant_id (PK2) — bigint — 외래 키 → Restaurant.restaurant_id — NOT NULL
Restaurant (식당)
- restaurant_id (PK) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(50)
- food_category (Field3) — varchar(20)
- region_id (PK2) — bigint — 외래 키 → region.region_id — NOT NULL
Review (리뷰)
- review_id (PK) — bigint — 기본 키 — NOT NULL
- star_rate (Field) — float
- description (Field2) — string
- created_at (Field3) — datatime(6)
- updated_at (Field4) — datatime(6)
- restaurant_id (PK3) — bigint — 외래 키 → Restaurant.restaurant_id — NOT NULL
- member_id (PK2) — bigint — 외래 키 → Member.member_id — NOT NULL
Review_reply (리뷰 답글)
- reply_id (Key) — bigint — 기본 키 — NOT NULL
- content (Field) — text
- review_id (PK) — bigint — 외래 키 → Review.review_id — NOT NULL
User_Food (유저선호음식)
- member_food_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (PK2) — bigint — 외래 키 → Member.member_id — NOT NULL
- food_id (PK3) — bigint — 외래 키 → Food.food_id — NOT NULL
User_region_progress (지역별 미션 현황)
- clear_mission_count (Field2) — int
- region_id (PK) — bigint — 외래 키 → region.region_id — NOT NULL
- member_id (PK2) — bigint — 외래 키 → Member.member_id — NOT NULL
region (지역)
- region_id (PK) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(50)
review_photo (리뷰 사진)
- photo_id (Key) — bigint — 기본 키 — NOT NULL
- photo_url (Field) — varchar(100)
- review_id (PK) — bigint — 외래 키 → Review.review_id — NOT NULL