Create
Query
homilies.db
—
homilies
homilies
sqlite_sequence
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into homilies
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)
Insert
Cancel