1234567891011121314BEGIN IMMEDIATE;
CREATE TABLE observed_occurrences ( occurrence_id TEXT NOT NULL, case_id TEXT NOT NULL REFERENCES observer_cases(id), applied_ms INTEGER NOT NULL CHECK(applied_ms >= 0), PRIMARY KEY (occurrence_id, case_id)) STRICT;
CREATE INDEX idx_observed_occurrences_case ON observed_occurrences(case_id);
PRAGMA user_version = 4;COMMIT;