homilies.db — homilies

CREATE TABLE homilies  (
  id INTEGER PRIMARY KEY,
  title VARCHAR(200) NOT NULL,
  preacher VARCHAR(120),
  recorded_at DATE,
  audio_url VARCHAR(512) NOT NULL,
  duration_s INTEGER,
  transcript_text TEXT,
  transcript_vtt TEXT,
  transcription_status VARCHAR(20) DEFAULT 'pending',
  analysis TEXT,
  plays INTEGER DEFAULT 0,
  engage INTEGER DEFAULT 0,
  total_listening_time INTEGER DEFAULT 0,
  created_ts DATETIME DEFAULT CURRENT_TIMESTAMP,
  published INTEGER DEFAULT 1
)