aitalk_erd

Tables (3)

care_center (Untitled3)

  • center_id (Key) — unsigned int — Primary key — NOT NULL
  • center_name (Field) — varchar(20)
  • center_number (Field2) — varchar(20)
  • center_latitude (Field3) — float
  • center_longtitude (Field4) — float

care_children (Untitled2)

  • child_id (Key) — unsigned int — Primary key — NOT NULL
  • therapist_id (Key2) — unsigned int — Foreign key → speech_therapist.therapist_id — NOT NULL
  • center_id (Key3) — unsigned int — Foreign key → care_center.center_id — NOT NULL
  • child_name (Field) — varchar(10)
  • protector_number (Field2) — varchar(20)

speech_therapist (Untitled)

  • therapist_id (Key) — varchar(20) — Primary key — NOT NULL
  • id (Field) — varchar(20)
  • password (Field2) — varchar(20)
  • email (Field3) — varchar(20)
  • user_name (Field4) — varchar(20)
  • phone_number (Field5) — varchar(20)