CREATE TABLE [dbo].[PredictionScanResults] (
    ScanId INT IDENTITY(1,1) PRIMARY KEY,
    SessionId UNIQUEIDENTIFIER NOT NULL,
    ScanDate DATETIME NOT NULL DEFAULT GETDATE(),
    Weight_HandicapRating DECIMAL(10,2) NOT NULL,
    Weight_CareerWins DECIMAL(10,2) NOT NULL,
    Weight_CareerStrikeRate DECIMAL(10,2) NOT NULL,
    Weight_JockeyLast100StrikeRate DECIMAL(10,2) NOT NULL,
    Weight_TrainerLast100StrikeRate DECIMAL(10,2) NOT NULL,
    Weight_BestFixedOdds DECIMAL(10,2) NOT NULL,
    Weight_Age DECIMAL(10,2) NOT NULL,
    Weight_CareerPlacings DECIMAL(10,2) NOT NULL,
    Weight_DryTrackStrikeRate DECIMAL(10,2) NOT NULL,
    Weight_ThisTrackStrikeRate DECIMAL(10,2) NOT NULL,
    Weight_LastStartFinishPosition DECIMAL(10,2) NOT NULL,
    Weight_WeightCarried DECIMAL(10,2) NOT NULL,
    TotalRaces INT NOT NULL,
    CorrectPredictions INT NOT NULL,
    WinPercentage DECIMAL(5,2) NOT NULL
)