Query

event_store.db — events_archive

SQL

CREATE TABLE events_archive  (
  id TEXT PRIMARY KEY,
  seq INTEGER,
  kind TEXT NOT NULL,
  ts TEXT NOT NULL,
  actor TEXT,
  subject_entity_ids TEXT,
  payload TEXT NOT NULL,
  source_ref TEXT,
  confidence REAL DEFAULT 0.0,
  dedupe_key TEXT,
  episode_id TEXT,
  created_at TEXT NOT NULL,
  archived_at TEXT NOT NULL,
  archive_reason TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
seq INTEGER ✓ Rename | Drop
kind TEXT Rename | Drop
ts TEXT Rename | Drop
actor TEXT ✓ Rename | Drop
subject_entity_ids TEXT ✓ Rename | Drop
payload TEXT Rename | Drop
source_ref TEXT ✓ Rename | Drop
confidence REAL ✓ Rename | Drop
dedupe_key TEXT ✓ Rename | Drop
episode_id TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
archived_at TEXT Rename | Drop
archive_reason TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_events_archive_archived_at archived_at SQL 
CREATE INDEX idx_events_archive_archived_at
ON events_archive(archived_at)
Drop
idx_events_archive_kind_ts
  • kind
  • ts
 SQL 
CREATE INDEX idx_events_archive_kind_ts
ON events_archive(kind, ts)
Drop
sqlite_autoindex_events_archive_1 id ✓ SQL
-- no sql found --
 Drop