584 lines
20 KiB
C#
584 lines
20 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using AutoBet.Db;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Metadata;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
|
|
namespace AutoBet.Db.Migrations
|
|
{
|
|
[DbContext(typeof(HorseRacingDataContext))]
|
|
[Migration("20200413114806_JockeyIdCanBeNull")]
|
|
partial class JockeyIdCanBeNull
|
|
{
|
|
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.HasAnnotation("ProductVersion", "3.1.2")
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 128)
|
|
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
|
|
|
|
modelBuilder.Entity("AutoBet.Db.BetOdds", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
|
|
|
|
b.Property<decimal>("Available")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<decimal>("Odds")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<int?>("OddsSnapshotId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("OddsType")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("OddsSnapshotId");
|
|
|
|
b.ToTable("BetOdds");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.Fixture", b =>
|
|
{
|
|
b.Property<string>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<int>("AbandonedReasonCode")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("BcsEvent")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("BlackTypeRaces")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("CourseId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("CourseName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Distance")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<bool>("EntriesAvailable")
|
|
.HasColumnType("bit");
|
|
|
|
b.Property<DateTime?>("FirstRace")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<DateTime>("FixtureDate")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<int>("FixtureId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("FixtureName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("FixtureSession")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("FixtureType")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("FixtureYear")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Going")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("GoingUpdatedDate")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("GoingUpdatedTime")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("MajorEvent")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("MeetingId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("NumberOfRaces")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Other")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("RacePlanningCode")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<bool>("RacecardAvailable")
|
|
.HasColumnType("bit");
|
|
|
|
b.Property<int>("RacingTrackType")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Rail")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<bool>("ResultsAvailable")
|
|
.HasColumnType("bit");
|
|
|
|
b.Property<string>("Stalls")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("TicketsLink")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Weather")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("Fixtures");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.LastRun", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
|
|
|
|
b.Property<int>("Days")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RaceType")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("RunnerId")
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("RunnerId");
|
|
|
|
b.ToTable("LastRuns");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.OddsSnapshot", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
|
|
|
|
b.Property<string>("EventName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("HorseName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("JockeyName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<DateTime>("SnapshotDate")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("OddsSnapshots");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.Race", b =>
|
|
{
|
|
b.Property<string>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<int>("AbandonedReasonCode")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("AgeLimit")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("BlackTypeRace")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("DistanceChange")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("DistanceChangeText")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("DistanceText")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("DistanceUnits")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("DistanceValue")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("DivisionSequence")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("FixtureId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<bool>("Plus10")
|
|
.HasColumnType("bit");
|
|
|
|
b.Property<int>("PrizeAmount")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("PrizeCurrency")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("RaceClass")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RaceCriteriaRaceType")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<DateTime>("RaceDate")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<int>("RaceId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RaceName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<TimeSpan>("RaceTime")
|
|
.HasColumnType("time");
|
|
|
|
b.Property<string>("RatingBand")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("RawDistanceText")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("YearOfRace")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("Races");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.Runner", b =>
|
|
{
|
|
b.Property<string>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<int>("AgeYears")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("AnimalId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("BhaRating")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Bred")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("ClothNumber")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("CourseWinner")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<decimal?>("DecimalOdds")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<string>("DistanceWinner")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("DivisionSequence")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int?>("DrawnStall")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("ForecastPriceDenominator")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ForecastPriceNumerator")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("FormFigures")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("HeadGearAbbreviation")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("HeadGearDescription")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("HeadGearWearingCode")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("HeadGearWearingSheepSkin")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int?>("JockeyId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("JockeyName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("JockeyProfile")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("NonRunnerDeclaredDate")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("NonRunnerDeclaredReason")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("NonRunnerDeclaredTime")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Odds")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("OwnerId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("OwnerName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("PenaltyValue")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("Plus10")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<float>("Prediction")
|
|
.HasColumnType("real");
|
|
|
|
b.Property<string>("RaceHorseNameWithoutCountry")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("RaceId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RacehorseName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ReserveNumber")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("RunnerNumber")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("SexType")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("SilkImage")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("Status")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("TrainerId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("TrainerName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("WbSilkCode")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("WbSilkDescription")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<decimal?>("WeightInGrams")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<string>("WeightText")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("WeightValue")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("WeightsJockeyClaiming")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("WindSurgeryFirstRun")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("YearOfRace")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("Runners");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.RunnerResult", b =>
|
|
{
|
|
b.Property<string>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<int>("AgeYear")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("AnimalId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("BettingRatio")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Bred")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("ClothNumber")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("DivisionSequence")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int?>("DrawnStall")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("FinishTime")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("FinishTimeInMilliseconds")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("HorseId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("Hro")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int?>("JockeyId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("JockeyName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("JockeyProfile")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int?>("LossMilliseconds")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime?>("NonRunnerDeclaredDate")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<string>("NonRunnerDeclaredReason")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<TimeSpan?>("NonRunnerDeclaredTime")
|
|
.HasColumnType("time");
|
|
|
|
b.Property<int?>("OwnerId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("OwnerName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("PerformanceFigure")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("Plus10")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("PositionFinishTime")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("RaceCriteriaRaceType")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("RaceId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RacehorseName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("RacehorseNameWithoutConuntry")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("Ran")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RatingAwt")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("RatingChase")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("RatingFlat")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("RatingHurdle")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ResultBtnDistance")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ResultFinishDNF")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("ResultFinishPos")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("SexType")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("SilkImage")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Status")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("TrainerId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("TrainerName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("WbSilkCode")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("WbSilkDescription")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int?>("WeightValue")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("YearOfRace")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("RunnerResults");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.BetOdds", b =>
|
|
{
|
|
b.HasOne("AutoBet.Db.OddsSnapshot", "OddsSnapshot")
|
|
.WithMany("Odds")
|
|
.HasForeignKey("OddsSnapshotId");
|
|
});
|
|
|
|
modelBuilder.Entity("AutoBet.Db.LastRun", b =>
|
|
{
|
|
b.HasOne("AutoBet.Db.Runner", null)
|
|
.WithMany("LastRuns")
|
|
.HasForeignKey("RunnerId");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|