75 lines
2.3 KiB
PL/PgSQL
75 lines
2.3 KiB
PL/PgSQL
BEGIN;
|
|
|
|
SET ROLE self_role;
|
|
|
|
CREATE TABLE IF NOT EXISTS self.learning_signals (
|
|
signal_id TEXT PRIMARY KEY,
|
|
principal_id TEXT NOT NULL,
|
|
kind TEXT NOT NULL,
|
|
task_pattern TEXT NOT NULL,
|
|
scope_key TEXT NOT NULL,
|
|
subject_ref JSONB NOT NULL,
|
|
evidence_refs JSONB NOT NULL,
|
|
expected_outcome TEXT NOT NULL DEFAULT '',
|
|
actual_outcome TEXT NOT NULL DEFAULT '',
|
|
dependency_refs JSONB NOT NULL DEFAULT '[]'::jsonb,
|
|
environment_version TEXT NOT NULL DEFAULT '',
|
|
observed_at_unix_millis BIGINT NOT NULL,
|
|
severity INTEGER NOT NULL DEFAULT 0,
|
|
user_impact INTEGER NOT NULL DEFAULT 0,
|
|
correction_count INTEGER NOT NULL DEFAULT 0,
|
|
decision_regret TEXT NOT NULL DEFAULT ''
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS self.weakness_patterns (
|
|
assessment_id TEXT PRIMARY KEY,
|
|
principal_id TEXT NOT NULL,
|
|
revision BIGINT NOT NULL CHECK (revision > 0),
|
|
pattern_key TEXT NOT NULL,
|
|
task_pattern TEXT NOT NULL,
|
|
scope_key TEXT NOT NULL,
|
|
environment_version TEXT NOT NULL DEFAULT '',
|
|
dependency_refs JSONB NOT NULL DEFAULT '[]'::jsonb,
|
|
failure_mode TEXT NOT NULL,
|
|
detection_evidence_refs JSONB NOT NULL,
|
|
frequency INTEGER NOT NULL,
|
|
last_observed_at_unix_millis BIGINT NOT NULL,
|
|
severity INTEGER NOT NULL,
|
|
affected_component TEXT NOT NULL,
|
|
affected_strategy TEXT NOT NULL DEFAULT '',
|
|
confidence_millis BIGINT NOT NULL,
|
|
epistemic_status TEXT NOT NULL,
|
|
state TEXT NOT NULL,
|
|
recorded_at_unix_millis BIGINT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS self.improvement_candidates (
|
|
candidate_id TEXT PRIMARY KEY,
|
|
principal_id TEXT NOT NULL,
|
|
need_ref JSONB NOT NULL,
|
|
hypothesis TEXT NOT NULL,
|
|
expected_effect TEXT NOT NULL,
|
|
evaluation_plan TEXT NOT NULL,
|
|
must_not_worsen JSONB NOT NULL,
|
|
rollback_plan TEXT NOT NULL,
|
|
resource_cost TEXT NOT NULL,
|
|
creator TEXT NOT NULL,
|
|
independent_evaluator TEXT NOT NULL,
|
|
state TEXT NOT NULL,
|
|
evidence_refs JSONB NOT NULL,
|
|
created_at_unix_millis BIGINT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS self.personal_benchmark_cases (
|
|
case_id TEXT PRIMARY KEY,
|
|
principal_id TEXT NOT NULL,
|
|
task_class TEXT NOT NULL,
|
|
evidence_refs JSONB NOT NULL,
|
|
recorded_at_unix_millis BIGINT NOT NULL
|
|
);
|
|
|
|
GRANT SELECT, INSERT, UPDATE ON self.learning_signals, self.weakness_patterns, self.improvement_candidates, self.personal_benchmark_cases TO self_role;
|
|
|
|
RESET ROLE;
|
|
COMMIT;
|