맛집

테이블 (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