capstone

Tables (6)

analysisResult (Untitled3)

  • id (Long) — Long — Primary key — NOT NULL
  • speech_id (Key2) — Long — Foreign key → speech.id — NOT NULL
  • pronunciation_score (float) — float
  • speed_score (Field) — float
  • silence_score (Field3) — float
  • stuttering_score (Field2) — float
  • confidence_score (Field4) — float
  • tone_pitch_score (Field5) — float
  • dialect_detected (.) — bool

baseEntity (Untitled4)

  • createdAt (Field) — LocalDAteTime
  • updatedAt (Field2) — LocalDateTime

skilltype (스킬)

  • 스킬id (id) — Primary key — NOT NULL
  • Field

speech (Untitled2)

  • id (Long) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • text (텍스트) — varchar(5000)
  • duration (Field2)
  • audiofileUrl (Field4)

user (Untitled)

  • id (.) — Long — Primary key — NOT NULL
  • Field7
  • name (이름) — varchar(3000)
  • oid (Field3)
  • provider (Field4)

userskill (Untitled5)

  • Key — Primary key — NOT NULL
  • skilltype (스킬타입(enum))
  • user_id (.) — Long — Foreign key → user.id — NOT NULL