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)