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