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