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)