Files
archie/internal/platform/pg/migrations/00020_judgement_classes.sql

37 lines
1.4 KiB
SQL

-- +goose Up
-- An action class is what earned autonomy belongs to: one connector's action on
-- one kind of target in one environment. A class is made the first time an
-- action of it is judged, at the level its kind of action starts at, and its
-- decisions stay in judgement.decisions under the same four names. A target
-- that moves environment is a different class, which starts as any new one.
CREATE TABLE judgement.classes (
id uuid PRIMARY KEY,
org_id text NOT NULL,
connector text NOT NULL,
action text NOT NULL,
target_kind text NOT NULL,
environment text NOT NULL,
read_only boolean NOT NULL,
level text NOT NULL CHECK (level IN ('act_quietly', 'act_and_tell', 'propose_and_wait', 'escalate', 'never')),
created_at timestamptz NOT NULL DEFAULT now(),
reset_at timestamptz,
UNIQUE (org_id, connector, action, target_kind, environment)
);
-- A reset returns a class to its default and keeps what led there.
CREATE TABLE judgement.class_resets (
id uuid PRIMARY KEY,
org_id text NOT NULL,
class_id uuid NOT NULL REFERENCES judgement.classes (id),
from_level text NOT NULL,
to_level text NOT NULL,
by text NOT NULL,
at timestamptz NOT NULL DEFAULT now()
);
CREATE INDEX class_resets_by_class ON judgement.class_resets (class_id, at);
-- +goose Down
DROP TABLE judgement.class_resets;
DROP TABLE judgement.classes;