Query

event_store.db — entities

SQL

CREATE TABLE entities  (
  id TEXT PRIMARY KEY,
  type TEXT NOT NULL,
  title TEXT,
  status TEXT,
  data TEXT,
  -- JSON payload for typed metadata
  version INTEGER NOT NULL DEFAULT 0,
  -- NEW: optional OCC support
  tags TEXT,
  owners TEXT,
  source_refs TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
type TEXT Rename | Drop
title TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
data TEXT ✓ Rename | Drop
version INTEGER Rename | Drop
tags TEXT ✓ Rename | Drop
owners TEXT ✓ Rename | Drop
source_refs TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_entities_status status SQL 
CREATE INDEX idx_entities_status
ON entities (status)
Drop
idx_entities_type type SQL 
CREATE INDEX idx_entities_type
ON entities (type)
Drop
sqlite_autoindex_entities_1 id ✓ SQL
-- no sql found --
 Drop