AI STT

Tables (4)

ai2_contents_info

  • file — varchar(45) — Primary key — NOT NULL
  • series_num — int — Foreign key → ai2_lecture_info.series_num
  • idx — int — NOT NULL
  • field — text
  • series_title — text
  • advantage — text
  • content_title — text
  • resolution — text
  • level — text
  • target — text
  • main_story — text
  • keyword_topic — text
  • keyword_subject — text
  • time — text
  • day_start — int
  • teacher — text
  • teacher_info — text
  • sample — text
  • youtube — text

ai2_contents_segment

  • idx — int — Primary key — NOT NULL
  • file — varchar(45) — Foreign key → ai2_contents_info.file — NOT NULL
  • no_segment — int
  • transcript — varchar(300)
  • segment_start — float
  • segment_length — float
  • total_length — float
  • bayes_risk — float

ai2_contents_words

  • idx — int — Primary key — NOT NULL
  • file — varchar(45)
  • no_segment — int — Foreign key → ai2_contents_segment.idx
  • word — varchar(100)
  • word_start — float
  • word_length — float
  • confidence — float

ai2_lecture_info

  • series_num — int — Primary key — NOT NULL
  • field — text
  • series_title — text
  • time — double
  • day — int
  • teacher — text
  • teacher_info — text
  • file_name — text
  • amount — int