umc
Tables (8)
food (Untitled6)
- id (Key) — Primary key — NOT NULL
- name (Field)
mission (Untitled5)
- id (Key) — Primary key — NOT NULL
- store_id (Field)
- reward (Field2)
- deadline (Field3)
- created_at (Field4)
- updated_at (Field5)
region (Untitled4)
- id (Key) — Primary key — NOT NULL
- name (Field)
review (Untitled2)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- store_id (Key3) — Primary key — NOT NULL
- score (Field)
- content (Field2)
- wrtingDate (Field3)
- created_at (Field4)
- updated_at (Field5)
store (Untitled)
- id (Key) — Primary key — NOT NULL
- region_id (Key2) — Primary key — NOT NULL
- name (Field3)
- score (Field5)
- address (Field4)
- created_at (Field)
- updated_at (Field2)
user (Untitled3)
- id (Key) — Primary key — NOT NULL
- name (Field)
- age (Field5)
- gender (Field2)
- birthDate (Field3)
- address (Field4)
- email (Field6)
- point (Field7)
- state (Field8)
- inactive_date (Field11)
- created_at (Field9)
- updated_at (Field10)
userFood (Untitled8)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- food_id (Key3) — Primary key — NOT NULL
userMission (Untitled7)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- mission_id (Key3) — Primary key — NOT NULL
- status (Field)