hackaton

Tables (5)

JWT (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • refresh (Field2)
  • access (Field3)

drug bol (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → sym.id — NOT NULL
  • id (Key22) — Foreign key → sym.id — NOT NULL
  • id (Key222) — Foreign key → sym.id — NOT NULL
  • drug_if (Field) — boolean
  • user_id (Field2)
  • drug_name (Field3)
  • time (Field4) — datetime
  • image (Field5)
  • id (Key3) — Foreign key → sym.id — NOT NULL
  • id (Key23) — Foreign key → sym.id — NOT NULL
  • id (Key223) — Foreign key → sym.id — NOT NULL

report (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • time (Field) — datetime
  • Field2
  • id (Key2) — Foreign key → user.id — NOT NULL
  • id (Key22) — Foreign key → user.id — NOT NULL

sym (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → user.id — NOT NULL
  • id (Key22) — Foreign key → user.id — NOT NULL
  • symptom (Field)
  • when (Field2) — datetime
  • memo (Field3) — text
  • user_id (Field4)

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → JWT.id — NOT NULL
  • name (Field)
  • gender (Field2)
  • birth (Field3)
  • user_id (Field4)
  • pw (Field5)