speech recognition

Tables (5)

Comment

  • comment_id — INT — Primary key
  • comment_text — TEXT
  • solve_problem — Boolean
  • sentence_id — INT — Foreign key → Sentences.sentence_id

Presentations

  • Presentation_id — INT — Primary key — NOT NULL
  • file_path — TEXT
  • id — INT — Foreign key → Users.id

Question

  • question_id — INT — Primary key
  • comment_text — TEXT
  • Presentation_id — INT — Foreign key → Presentations.Presentation_id — NOT NULL

Sentences

  • sentence_id — INT — Primary key
  • time — TIMESTAMP
  • text — TEXT
  • speed — FLOAT
  • voice_size — FLOAT
  • Field — FLOAT
  • sentenceCorrection — TEXT
  • Presentation_id — INT — Foreign key → Presentations.Presentation_id — NOT NULL

Users

  • id — INT — Primary key
  • name — VARCHAR(100)
  • birth_date — DATE
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • provider — VARCHAR(50)