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)