58 lines
1.7 KiB
SQL
58 lines
1.7 KiB
SQL
CREATE TABLE "evidmon_criteria" (
|
|
"version" bigint PRIMARY KEY NOT NULL,
|
|
"label" text NOT NULL,
|
|
"config" text NOT NULL,
|
|
"note" text,
|
|
"strategy_id" text,
|
|
"active" bigint NOT NULL,
|
|
"created_at" bigint NOT NULL,
|
|
"activated_at" bigint
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE "evidmon_findings" (
|
|
"id" text PRIMARY KEY NOT NULL,
|
|
"day" text NOT NULL,
|
|
"title" text NOT NULL,
|
|
"summary" text NOT NULL,
|
|
"highlights" text,
|
|
"findings" text,
|
|
"metrics_snapshot" text,
|
|
"deltas" text,
|
|
"author" text NOT NULL,
|
|
"created_at" bigint NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE "evidmon_metrics_daily" (
|
|
"day" text PRIMARY KEY NOT NULL,
|
|
"generated_at" bigint NOT NULL,
|
|
"metrics" text NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE "evidmon_strategies" (
|
|
"id" text PRIMARY KEY NOT NULL,
|
|
"finding_id" text,
|
|
"day" text NOT NULL,
|
|
"code" text NOT NULL,
|
|
"title" text NOT NULL,
|
|
"rationale" text NOT NULL,
|
|
"knob" text NOT NULL,
|
|
"metric_key" text NOT NULL,
|
|
"baseline_value" double precision,
|
|
"target_value" double precision,
|
|
"payload" text,
|
|
"replay" text,
|
|
"status" text NOT NULL,
|
|
"decided_by" text,
|
|
"decided_at" bigint,
|
|
"decision_note" text,
|
|
"effective_at" bigint,
|
|
"before_value" double precision,
|
|
"after_value" double precision,
|
|
"created_at" bigint NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
-- NOTE: drizzle-kit also wanted to drop/recreate tasks_meegoId_unique purely to
|
|
-- rename it to snake_case. That is pre-existing drift between the hand-maintained
|
|
-- schema and the live DB, unrelated to this change, and churning a unique
|
|
-- constraint on the busiest table is not worth it — removed by hand.
|
|
ALTER TABLE "evidence_capture_events" ADD COLUMN "criteria_version" bigint; |