SQL

CREATE TABLE video_chunks (
  id INT,
  file_path TEXT,
  device_name TEXT,
  sync_id TEXT,
  machine_id TEXT,
  synced_at NUM,
  fps REAL,
  cloud_blob_id TEXT
)

Columns

Column Data type Allow null Primary key Actions
id INT ✓ read-only
file_path TEXT ✓ read-only
device_name TEXT ✓ read-only
sync_id TEXT ✓ read-only
machine_id TEXT ✓ read-only
synced_at NUM ✓ read-only
fps REAL ✓ read-only
cloud_blob_id TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_video_chunks_device device_name SQL 
CREATE INDEX idx_video_chunks_device
ON video_chunks(device_name)
read-only