SQL

CREATE TABLE audio_chunks  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  file_path TEXT NOT NULL,
  timestamp TIMESTAMP,
  sync_id TEXT,
  machine_id TEXT,
  synced_at DATETIME,
  evicted_at TIMESTAMP DEFAULT NULL
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
file_path TEXT read-only
timestamp TIMESTAMP ✓ read-only
sync_id TEXT ✓ read-only
machine_id TEXT ✓ read-only
synced_at DATETIME ✓ read-only
evicted_at TIMESTAMP ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_audio_chunks_timestamp timestamp SQL 
CREATE INDEX idx_audio_chunks_timestamp
ON audio_chunks(timestamp)
read-only