20 lines
663 B
SQL
20 lines
663 B
SQL
CREATE TABLE "prediction_runs" (
|
|
"id" BIGSERIAL NOT NULL,
|
|
"match_id" TEXT NOT NULL,
|
|
"engine_version" TEXT NOT NULL,
|
|
"decision_trace_id" TEXT,
|
|
"generated_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"odds_snapshot" JSONB,
|
|
"payload_summary" JSONB NOT NULL,
|
|
"eventual_outcome" TEXT,
|
|
"unit_profit" DOUBLE PRECISION,
|
|
|
|
CONSTRAINT "prediction_runs_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
CREATE INDEX "prediction_runs_match_id_generated_at_idx"
|
|
ON "prediction_runs"("match_id", "generated_at" DESC);
|
|
|
|
CREATE INDEX "prediction_runs_engine_version_generated_at_idx"
|
|
ON "prediction_runs"("engine_version", "generated_at" DESC);
|