SQL

CREATE TABLE meetings  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  meeting_start TEXT NOT NULL,
  meeting_end TEXT,
  meeting_app TEXT NOT NULL,
  title TEXT,
  attendees TEXT,
  detection_source TEXT NOT NULL DEFAULT 'app',
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
  note TEXT
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
meeting_start TEXT read-only
meeting_end TEXT ✓ read-only
meeting_app TEXT read-only
title TEXT ✓ read-only
attendees TEXT ✓ read-only
detection_source TEXT read-only
created_at TEXT read-only
note TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_meetings_end meeting_end SQL 
CREATE INDEX idx_meetings_end
ON meetings(meeting_end)
read-only
idx_meetings_start meeting_start SQL 
CREATE INDEX idx_meetings_start
ON meetings(meeting_start)
read-only