MovieLog-Week1
Tables (8)
food_category (음식 카테고리)
- category_id (Key) — Primary key — NOT NULL
- category_name (Field)
- created_at (Field2)
member (회원)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- nickname (Field2)
- email (Field3)
- gender (Field4)
- birth (Field5)
- address (Field6)
- status (Field7)
- created_at (Field8)
- updated_at (Field9)
member_mission (회원 미션)
- membermission_id (Key) — Primary key — NOT NULL
- completed_at (Field)
- created_at (Field2)
- member_id (Key4) — Foreign key → member.member_id — NOT NULL
- mission_id (Key2) — Foreign key → mission.mission_id — NOT NULL
member_point (회원별 포인트)
- point_id (Key) — Primary key — NOT NULL
- total_points (Field)
- mission_count (Field2)
- updated_at (Field3)
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- region_id (Key3) — Foreign key → region.region_id — NOT NULL
mission (미션)
- mission_id (Key) — Primary key — NOT NULL
- mission_title (Field)
- mission_discription (Field2)
- difficulty (Field3)
- created_at (Field4)
- region_id (Key2) — Foreign key → region.region_id — NOT NULL
region (지역)
- region_id (Key) — Primary key — NOT NULL
- region_name (Field)
- description (Field2)
- created_at (Field3)
social_login (소셜로그인)
- social_login_id (Key) — Primary key — NOT NULL
- created_at (Field2)
- provider_id (Field)
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
store (가게)
- store_id (Key) — Primary key — NOT NULL
- store_name (Field)
- address (Field2)
- description (Field3)
- created_at (Field4)
- region_id (Key2) — Foreign key → region.region_id — NOT NULL
- category_id (Key3) — Foreign key → food_category.category_id — NOT NULL