umc-IA
Tables (5)
mission (Untitled4)
- id (Field) — int — Primary key — NOT NULL
- user_id (Field2) — int — Foreign key → store.id — NOT NULL
- store_id (Field6) — int — Foreign key → user.id — NOT NULL
- due_date (Field3) — date — NOT NULL
- get_point (Field4) — int — NOT NULL
- over_cost (Field5) — int
- done (Field7) — bool — NOT NULL
- auth_num (Field8) — int — NOT NULL
review (Untitled5)
- id (Field) — int — Primary key — NOT NULL
- user_id (Field6) — int — Foreign key → user.id — NOT NULL
- store_id (Field3) — int — Foreign key → store.id — NOT NULL
- rate (Field2) — int — NOT NULL
- text (Field4) — text
- pic_link (Field5) — char
- boss_reply (Field7) — text
store (Untitled2)
- id (Field) — int — Primary key — NOT NULL
- category_id (Field6) — int — Foreign key → store_category.id — NOT NULL
- name (Field2) — char(20) — NOT NULL
store_category (Untitled3)
- id (Field) — int — Primary key — NOT NULL
- name (Field2) — char(20) — NOT NULL
user (Untitled)
- id (Field6) — int — Primary key — NOT NULL
- name (Field) — char(5) — NOT NULL
- gender (Field2) — char(2) — NOT NULL
- birth (Field3) — date — NOT NULL
- address (Field4) — char(30) — NOT NULL
- prefer_food (Field5) — char(10)
- social_login (Field7) — char(10)
- point (Field8) — int — NOT NULL
- phone_num (Field9) — char(15)
- email (Field10) — char(30)