Blame · Line-by-line history

`0110_flywheel_telemetry.sql`

Each line is annotated with the commit that last touched it. Click any SHA to jump to that commit and see the surrounding change.

0110_flywheel_telemetry.sqlBlame17 lines · 1 contributor

6682dbeClaude	1	CREATE TABLE IF NOT EXISTS "flywheel_telemetry" (
	2	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	3	"gate_run_id" uuid REFERENCES "gate_runs"("id") ON DELETE SET NULL,
	4	"repository_id" uuid REFERENCES "repositories"("id") ON DELETE CASCADE,
	5	"error_signature_hash" text NOT NULL,
	6	"error_raw_text" text,
	7	"model_route" text NOT NULL,
	8	"attempts_count" integer NOT NULL DEFAULT 1,
	9	"token_cost_cents" integer NOT NULL DEFAULT 0,
	10	"execution_time_ms" integer NOT NULL DEFAULT 0,
	11	"outcome" text NOT NULL,
	12	"rework_rate_status" text NOT NULL DEFAULT 'untouched',
	13	"created_at" timestamp DEFAULT now()
	14	);
	15	CREATE INDEX IF NOT EXISTS "idx_flywheel_telemetry_repo" ON "flywheel_telemetry" ("repository_id");
	16	CREATE INDEX IF NOT EXISTS "idx_flywheel_telemetry_gate_run" ON "flywheel_telemetry" ("gate_run_id");
	17	CREATE INDEX IF NOT EXISTS "idx_flywheel_telemetry_hash" ON "flywheel_telemetry" ("error_signature_hash");