BEGIN 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;