BabeCare
Tables (3)
Emotion_TB (Untitled3)
- idx (Key) — auto_increment — Primary key — NOT NULL
- doll_code — integer(6) — Foreign key → Users_TB.doll_code — NOT NULL
- emotion_anger (Field) — number
- emotion_fear (Field2) — number
- emotion_disgust (Field3) — number
- emotion_happiness (Field4) — number
- emotion_neutral (Field5) — number
- emotion_sadness (Field6) — number
- emotion_surprise (Field7) — number
- create_at (Field8) — number
Users_TB (Untitled)
- doll_code — integer(6) — Primary key — NOT NULL
- parent_name — varchar(20)
- parent_phone (phonenumber) — integer(11)
- child_name — varchar(20)
Words_TB (Untitled2)
- idx (index) — auto_increment — Primary key — NOT NULL
- doll_code — integer(6) — Foreign key → Users_TB.doll_code — NOT NULL
- word — varchar(10)
- emotion_anger (anger) — number
- emotion_fear (fear) — number
- emotion_disgust (disgust) — number
- emotion_happiness (happiness) — number
- emotion_neutral (neutral) — number
- emotion_sadness (sadness) — number
- emotion_surprise (surprise) — number
- created_at (inserted time) — datetime