Create
Query
homilies.db
—
homilies
homilies
sqlite_sequence
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 127 in homilies
id
Primary key.
INTEGER
title
VARCHAR(200) NOT NULL
preacher
VARCHAR(120)
recorded_at
DATE
audio_url
VARCHAR(512) NOT NULL
duration_s
INTEGER
transcript_text
NULL
TEXT
transcript_vtt
NULL
TEXT
transcription_status
VARCHAR(20) (default 'pending'
analysis
NULL
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
Update
Cancel