Query

avatarai.db — BetRecommendationLogs

SQL

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'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT ✓ Rename | Drop
OwnerId TEXT ✓ Rename | Drop
ClientId TEXT Rename | Drop
ConversationId TEXT Rename | Drop
MatchId TEXT Rename | Drop
League TEXT Rename | Drop
HomeTeam TEXT Rename | Drop
AwayTeam TEXT Rename | Drop
Kickoff TEXT Rename | Drop
Market TEXT Rename | Drop
Pick TEXT Rename | Drop
Player TEXT ✓ Rename | Drop
Odds TEXT ✓ Rename | Drop
ProbabilityEstimate TEXT Rename | Drop
Confidence TEXT Rename | Drop
Reasoning TEXT Rename | Drop
Result TEXT Rename | Drop
ClosingOdds TEXT ✓ Rename | Drop
Clv TEXT ✓ Rename | Drop
RecommendedAt TEXT Rename | Drop
SettledAt TEXT ✓ Rename | Drop
ActualSot INTEGER ✓ Rename | Drop
AvgSot TEXT Rename | Drop
ImpliedValue TEXT ✓ Rename | Drop
PlayerId INTEGER ✓ Rename | Drop
RiskFactor TEXT ✓ Rename | Drop
SampleSize INTEGER Rename | Drop
Side TEXT ✓ Rename | Drop
Edge TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_BetRecommendationLogs_Kickoff Kickoff SQL 
CREATE INDEX "IX_BetRecommendationLogs_Kickoff"
ON "BetRecommendationLogs" ("Kickoff")
Drop
IX_BetRecommendationLogs_Result Result SQL 
CREATE INDEX "IX_BetRecommendationLogs_Result"
ON "BetRecommendationLogs" ("Result")
Drop
sqlite_autoindex_BetRecommendationLogs_1 Id ✓ SQL
-- no sql found --
 Drop