peachmentor

Tables (8)

analysis (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • analysisText (Field) — String
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL

answer (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • evaluation (Field4) — Long
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • question_id (Key3) — Long — Foreign key → question.id — NOT NULL

feedback (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • beforeAudioLink (Field) — String
  • beforeScript (Field2) — Text
  • afterAudioLink (Field3) — String
  • afterScript (Field4) — Text
  • feedbackText (Field5) — Text
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • answer_id (Key3) — Long — Foreign key → answer.id — NOT NULL

insight (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • insight (Field) — String
  • answer_id (Key2) — Long — Foreign key → answer.id — NOT NULL

question (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • description (Field) — String
  • questionIndex (Field2) — Long
  • level (Field3) — Long

selfFeedback (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • feedback (Field) — Text
  • answer_id (Key2) — Long — Foreign key → answer.id — NOT NULL

statistics (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • gantourCount (Field) — Long
  • slientTime (Field2) — Double
  • answer_id (Key2) — Long — Foreign key → answer.id — NOT NULL

user (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • name (Field2) — String
  • oauthId (Field3) — Long
  • voiceUrl (Field4) — String
  • level1QuestionNumber (Field5) — Long
  • level2QuestionNumber (Field6) — Long
  • level3QuestionNumber (Field7) — Long
  • analyzeCompleteAnswerIndex (Field8) — Long