Query
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'))
)