CREATE TABLE "BetRecommendationLogs" (
"Id" TEXT NOT NULL CONSTRAINT "PK_BetRecommendationLogs" PRIMARY KEY,
"AvatarId" TEXT NULL,
"OwnerId" TEXT NULL,
"ClientId" TEXT NOT NULL,
"ConversationId" TEXT NOT NULL,
"MatchId" TEXT NOT NULL,
"League" TEXT NOT NULL,
"HomeTeam" TEXT NOT NULL,
"AwayTeam" TEXT NOT NULL,
"Kickoff" TEXT NOT NULL,
"Market" TEXT NOT NULL,
"Pick" TEXT NOT NULL,
"Player" TEXT NULL,
"Odds" TEXT NULL,
"ProbabilityEstimate" TEXT NOT NULL,
"Confidence" TEXT NOT NULL,
"Reasoning" TEXT NOT NULL,
"Result" TEXT NOT NULL,
"ClosingOdds" TEXT NULL,
"Clv" TEXT NULL,
"RecommendedAt" TEXT NOT NULL,
"SettledAt" TEXT NULL,
"ActualSot" INTEGER NULL,
"AvgSot" TEXT NOT NULL DEFAULT '0.0',
"ImpliedValue" TEXT NULL,
"PlayerId" INTEGER NULL,
"RiskFactor" TEXT NULL,
"SampleSize" INTEGER NOT NULL DEFAULT 0,
"Side" TEXT NULL,
"Edge" TEXT NOT NULL DEFAULT '0.0'
)