1주차

테이블 (8)

food_category (Untitled2)

  • food_category_id (Key) — 기본 키 — NOT NULL
  • name (Field)

member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • member_name (Field)
  • member_gender (Field2)
  • member_age (Field3)
  • member_address (Field4)
  • inactive_date (Field5)

member_mission (Untitled7)

  • member_mission_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • mission_id (Key3) — 외래 키 → mission.mission_id — NOT NULL
  • status (Field)

mission (Untitled4)

  • mission_id (Key) — 기본 키 — NOT NULL
  • restaurant_id (Key2) — 외래 키 → restaurant.restaurant_id — NOT NULL

preference (Untitled3)

  • preference_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • food_category_id (Key3) — 외래 키 → food_category.food_category_id — NOT NULL

region (Untitled6)

  • region_id (Key) — 기본 키 — NOT NULL
  • region_name (Field)

restaurant (Untitled5)

  • restaurant_id (Key) — 기본 키 — NOT NULL
  • region_id (Key2) — 외래 키 → region.region_id — NOT NULL
  • name (Field)

review (Untitled8)

  • review_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • restaurant_id (Key3) — 외래 키 → restaurant.restaurant_id — NOT NULL
  • score (Field)
  • image (Field2)