umc11

Tables (7)

FOOD_CATEGORY (Untitled2)

  • category_id (Key) — Primary key — NOT NULL
  • name (Field)

MISSION (Untitled4)

  • mission_id (Key) — Primary key — NOT NULL
  • description (Field3)
  • limit_date (Field4)
  • reward_point (Field5)
  • store_id (Key2) — Foreign key → STORE.store_id — NOT NULL

REVIEW (Untitled7)

  • review_id (Key) — Primary key — NOT NULL
  • Field

STORE (Untitled6)

  • store_id (Key) — Primary key — NOT NULL
  • name (Field)
  • category (Field2)
  • rating (Field3)

USER (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • name (Field2)
  • gender (Field3)
  • birth_date (Field4)
  • address (Field5)
  • detail)_address (Field)

USER_MISSION (Untitled5)

  • user_mission_id (Key) — Primary key — NOT NULL
  • status (Field)
  • started_at (Field2)
  • completed_at (Field3)
  • mission_id (Key2) — Foreign key → MISSION.mission_id — NOT NULL
  • user_id (Key3) — Foreign key → USER.user_id — NOT NULL

USER_PREFERENCE (Untitled3)

  • category_id (Key) — Foreign key → FOOD_CATEGORY.category_id — NOT NULL
  • user_id (Key2) — Foreign key → USER.user_id — NOT NULL