protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Sample.Web.Models.Entities.AnetUser", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <long>("Id"), 1L, 1);
b.Property <string>("UserName")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("AnetUser");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("ChangeReturnRazorPages.Models.Product", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <decimal>("Price")
.HasColumnType("decimal(18,2)");
b.HasKey("Id");
b.ToTable("Products");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("RazorPagesContacts.Models.Customer", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.HasKey("Id");
b.ToTable("Customer");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0-rc.2.21480.5")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("WebMvcEF.Models.Movie", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Genre")
.HasColumnType("nvarchar(max)");
b.Property <decimal>("Price")
.HasColumnType("decimal(18,2)");
b.Property <DateTime>("ReleaseDate")
.HasColumnType("datetime2");
b.Property <string>("Title")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Movie");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("NetCore6TestApplication.Data.SecondDataModel", b =>
{
b.Property <int>("SecondDataModelID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("SecondDataModelID"), 1L, 1);
b.Property <string>("CompanyName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("SecondDataModelID");
b.ToTable("SecondDataModels");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasDefaultSchema("ProjectsDatabaseContext")
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Projects.Models.Project", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ExternalId")
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserExternalId")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Projects", "ProjectsDatabaseContext");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Domain.Entities.TodoItem", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <bool>("IsDone")
.HasColumnType("bit");
b.Property <int>("OwnerId")
.HasColumnType("int");
b.Property <string>("Title")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.HasKey("Id");
b.ToTable("TodoItems");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("API.Entities.AppUser", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <byte[]>("PasswordHash")
.HasColumnType("varbinary(max)");
b.Property <byte[]>("PasswordSalt")
.HasColumnType("varbinary(max)");
b.Property <string>("Username")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Users");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("PizzaPlace.Shared.Pizza", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(80)
.HasColumnType("nvarchar(80)");
b.Property <decimal>("Price")
.HasColumnType("money");
b.Property <string>("Spiciness")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Pizzas");
});
#pragma warning restore 612, 618
}
/// <summary>
/// Build model for mapping entity type do database table.
/// </summary>
/// <param name="builder">Entity type builder.</param>
/// <returns>Model for mapping entity type do database table.</returns>
protected virtual EntityTypeTableModel BuildEntityModel(EntityTypeBuilder <TEntity> builder)
{
var model = new EntityTypeTableModel(this.TableName);
builder.ToTable(this.TableName);
builder.Ignore(t => ((IPersistentObject)t).IsTransient);
builder.Ignore(t => ((IPersistentObject)t).IsDeleted);
builder.Ignore(t => t.DisplayValue);
builder.HasKey(t => t.Id);
var Id = builder.Property(t => t.Id).IsRequired();
var idSequenceName = this.namingConvention.ApplyToSequenceName($"{this.TableName}_Id");
switch (this.connectionSettings.ServerType)
{
case DatabaseServerType.MSSQLServer:
SqlServerPropertyBuilderExtensions.UseHiLo(Id, idSequenceName);
break;
case DatabaseServerType.PostgreSQL:
NpgsqlPropertyBuilderExtensions.UseHiLo(Id, idSequenceName);
break;
}
var TypeGuid = builder.Property(t => t.TypeGuid).IsRequired();
model.Properties.Add(Id);
model.Properties.Add(TypeGuid);
return(model);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.3")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("TodoApi.Models.TodoItem", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <long>("Id"), 1L, 1);
b.Property <bool>("IsComplete")
.HasColumnType("bit");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.Property <string>("Secret")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("TodoItems");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasDefaultSchema("FilesDatabaseContext")
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Files.Models.File", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Extension")
.HasColumnType("nvarchar(max)");
b.Property <string>("ExternalId")
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.Property <string>("Path")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserExternalId")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Files", "FilesDatabaseContext");
b.HasData(
new
{
Id = 1,
Extension = ".mp4",
ExternalId = "724df22d-0e4e-4fd1-9e0e-e2cc5cfd8b8d",
Name = "Default mp4",
Path = "/default.mp4",
UserExternalId = "f07af1d1-7b23-445a-ae46-a418799ef6ba"
},
new
{
Id = 2,
Extension = ".png",
ExternalId = "df10063b-7486-4fd1-8ded-acf96cd2dd1f",
Name = "Default png",
Path = "/default.png",
UserExternalId = "f07af1d1-7b23-445a-ae46-a418799ef6ba"
});
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.4")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("WPF_EF_Core.Country", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Country");
});
modelBuilder.Entity("WPF_EF_Core.UserData", b =>
{
b.Property <int?>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int?>("Id"), 1L, 1);
b.Property <bool?>("BoolValue")
.HasColumnType("bit");
b.Property <DateTime?>("DateValue")
.HasColumnType("datetime2");
b.Property <double?>("DoubleValue")
.HasColumnType("float");
b.Property <int?>("IntValue")
.HasColumnType("int");
b.Property <byte[]>("RowVersion")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property <string>("TextValue")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("UsersData");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasDefaultSchema("bank")
.HasAnnotation("ProductVersion", "6.0.3")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Payment", b =>
{
b.Property <int>("PaymentId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("PaymentId"), 1L, 1);
b.Property <decimal>("Amount")
.HasColumnType("Money");
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property <string>("Type")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("PaymentId");
b.ToTable("Payments", "bank");
b.HasDiscriminator <string>("Type").HasValue("Payment");
});
modelBuilder.Entity("CashPayment", b =>
{
b.HasBaseType("Payment");
b.HasDiscriminator().HasValue("cash");
});
modelBuilder.Entity("CreditcardPayment", b =>
{
b.HasBaseType("Payment");
b.Property <string>("CreditcardNumber")
.HasColumnType("nvarchar(max)");
b.HasDiscriminator().HasValue("creditcard");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.5")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Address", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("City")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("FirstName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("LastName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("MiddleName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("State")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Street")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Zipcode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Address");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("CSMA_API.Domain.Appointment", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("ClientId")
.HasColumnType("int");
b.Property <DateTime>("Date")
.HasColumnType("datetime2");
b.Property <string>("Details")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <int>("EmployeeId")
.HasColumnType("int");
b.Property <int>("LocationId")
.HasColumnType("int");
b.Property <bool>("NoShow")
.HasColumnType("bit");
b.Property <int>("ServiceId")
.HasColumnType("int");
b.HasKey("Id");
b.ToTable("Appointments");
});
#pragma warning restore 612, 618
}
public override void Map(EntityTypeBuilder <Customer> builder)
{
builder.ToTable(nameof(Customer), CRMConstant.Schema);
builder.HasKey(args => args.CustomerID);
var propertyBuilder = builder.Property(args => args.CustomerID);
NpgsqlPropertyBuilderExtensions.UseHiLo(propertyBuilder, CRMConstant.Hilo, CRMConstant.Schema);
SqlServerPropertyBuilderExtensions.UseHiLo(propertyBuilder, CRMConstant.Hilo, CRMConstant.Schema);
builder.Property(args => args.Name).HasMaxLength(CRMConstant.NameLength).IsRequired();
builder.HasIndex(args => args.Name).IsUnique();
builder.Property(args => args.Company).HasMaxLength(CRMConstant.NameLength).IsRequired();
builder.HasMany(args => args.Contacts).WithOne(args => args.Customer).HasForeignKey(args => args.CustomerID).IsRequired();
builder.HasMany(args => args.Licenses).WithOne(args => args.Customer).HasForeignKey(args => args.CustomerID).IsRequired();
base.Map(builder);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasDefaultSchema("UsersDBContext")
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Users.Models.User", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ExternalId")
.HasColumnType("nvarchar(max)");
b.Property <string>("Login")
.HasColumnType("nvarchar(max)");
b.Property <string>("Password")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Users", "UsersDBContext");
b.HasData(
new
{
Id = 1,
ExternalId = "f07af1d1-7b23-445a-ae46-a418799ef6ba",
Login = "******",
Password = "******"
});
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("ThisisPaymentAPI.Model.PaymentDetail", b =>
{
b.Property <int>("PaymentDetailId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("PaymentDetailId"), 1L, 1);
b.Property <string>("CardNumber")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("ExpirationDate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("PaymentDetailName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("SecurityCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("PaymentDetailId");
b.ToTable("PaymentDetail");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.4")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("PracticeNotice.Models.Notice", b =>
{
b.Property <int>("Idx")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Idx"), 1L, 1);
b.Property <string>("Content")
.HasColumnType("nvarchar(max)");
b.Property <string>("FileName")
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.Property <DateTime>("RegDate")
.HasColumnType("datetime2");
b.Property <string>("Subject")
.HasColumnType("nvarchar(max)");
b.HasKey("Idx");
b.ToTable("Notice");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Hardwares.Domain.Hardware", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <decimal>("Cost")
.HasColumnType("decimal(18,2)");
b.Property <string>("Description")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <DateTime>("InstallationDate")
.HasColumnType("datetime2");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Hardwares");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.2")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("NormalizedName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasDatabaseName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ClaimType")
.HasColumnType("nvarchar(max)");
b.Property <string>("ClaimValue")
.HasColumnType("nvarchar(max)");
b.Property <string>("RoleId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUser", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <int>("AccessFailedCount")
.HasColumnType("int");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("nvarchar(max)");
b.Property <string>("Email")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <bool>("EmailConfirmed")
.HasColumnType("bit");
b.Property <bool>("LockoutEnabled")
.HasColumnType("bit");
b.Property <DateTimeOffset?>("LockoutEnd")
.HasColumnType("datetimeoffset");
b.Property <string>("NormalizedEmail")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("NormalizedUserName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("PasswordHash")
.HasColumnType("nvarchar(max)");
b.Property <string>("PhoneNumber")
.HasColumnType("nvarchar(max)");
b.Property <bool>("PhoneNumberConfirmed")
.HasColumnType("bit");
b.Property <string>("SecurityStamp")
.HasColumnType("nvarchar(max)");
b.Property <bool>("TwoFactorEnabled")
.HasColumnType("bit");
b.Property <string>("UserName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasDatabaseName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasDatabaseName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ClaimType")
.HasColumnType("nvarchar(max)");
b.Property <string>("ClaimValue")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property <string>("LoginProvider")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("ProviderKey")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("ProviderDisplayName")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("RoleId")
.HasColumnType("nvarchar(450)");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("LoginProvider")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("Name")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("Value")
.HasColumnType("nvarchar(max)");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens", (string)null);
});
modelBuilder.Entity("MusicSpot.Data.Models.Album", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("ArtistId")
.HasColumnType("int");
b.Property <string>("Format")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("ImageUrl")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("MediaCondition")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(160)
.HasColumnType("nvarchar(160)");
b.Property <string>("Notes")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("SleeveCondition")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <int>("Year")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("ArtistId");
b.ToTable("Albums");
});
modelBuilder.Entity("MusicSpot.Data.Models.Artist", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Genre")
.IsRequired()
.HasMaxLength(40)
.HasColumnType("nvarchar(40)");
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(60)
.HasColumnType("nvarchar(60)");
b.HasKey("Id");
b.ToTable("Artists");
});
modelBuilder.Entity("MusicSpot.Data.Models.Track", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("AlbumId")
.HasColumnType("int");
b.Property <string>("Duration")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.HasKey("Id");
b.HasIndex("AlbumId");
b.ToTable("Tracks");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("MusicSpot.Data.Models.Album", b =>
{
b.HasOne("MusicSpot.Data.Models.Artist", "Artist")
.WithMany("Albums")
.HasForeignKey("ArtistId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Artist");
});
modelBuilder.Entity("MusicSpot.Data.Models.Track", b =>
{
b.HasOne("MusicSpot.Data.Models.Album", "Album")
.WithMany("Tracks")
.HasForeignKey("AlbumId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Album");
});
modelBuilder.Entity("MusicSpot.Data.Models.Album", b =>
{
b.Navigation("Tracks");
});
modelBuilder.Entity("MusicSpot.Data.Models.Artist", b =>
{
b.Navigation("Albums");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasDefaultSchema("AdsDBContext")
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Ads.Models.Ad", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ExternalId")
.HasColumnType("nvarchar(max)");
b.Property <string>("FileExternalId")
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.Property <string>("ProjectExternalId")
.HasColumnType("nvarchar(max)");
b.Property <string>("Url")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Ads", "AdsDBContext");
});
modelBuilder.Entity("Ads.Models.AdClicksStats", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("AdId")
.HasColumnType("int");
b.Property <DateTime>("Date")
.HasColumnType("datetime2");
b.Property <int>("Number")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("AdId");
b.ToTable("AdClicksStats", "AdsDBContext");
});
modelBuilder.Entity("Ads.Models.AdShowStats", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("AdId")
.HasColumnType("int");
b.Property <DateTime>("Date")
.HasColumnType("datetime2");
b.Property <int>("Number")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("AdId");
b.ToTable("AdShowStats", "AdsDBContext");
});
modelBuilder.Entity("Ads.Models.AdClicksStats", b =>
{
b.HasOne("Ads.Models.Ad", "Ad")
.WithMany()
.HasForeignKey("AdId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Ad");
});
modelBuilder.Entity("Ads.Models.AdShowStats", b =>
{
b.HasOne("Ads.Models.Ad", "Ad")
.WithMany()
.HasForeignKey("AdId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Ad");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.DeviceFlowCodes", b =>
{
b.Property <string>("UserCode")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("ClientId")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime>("CreationTime")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasMaxLength(50000)
.HasColumnType("nvarchar(max)");
b.Property <string>("Description")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("DeviceCode")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime?>("Expiration")
.IsRequired()
.HasColumnType("datetime2");
b.Property <string>("SessionId")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("SubjectId")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.HasKey("UserCode");
b.HasIndex("DeviceCode")
.IsUnique();
b.HasIndex("Expiration");
b.ToTable("DeviceCodes", (string)null);
});
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.Key", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <string>("Algorithm")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <DateTime>("Created")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <bool>("DataProtected")
.HasColumnType("bit");
b.Property <bool>("IsX509Certificate")
.HasColumnType("bit");
b.Property <string>("Use")
.HasColumnType("nvarchar(450)");
b.Property <int>("Version")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("Use");
b.ToTable("Keys", (string)null);
});
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.PersistedGrant", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <long>("Id"), 1L, 1);
b.Property <string>("ClientId")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime?>("ConsumedTime")
.HasColumnType("datetime2");
b.Property <DateTime>("CreationTime")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasMaxLength(50000)
.HasColumnType("nvarchar(max)");
b.Property <string>("Description")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime?>("Expiration")
.HasColumnType("datetime2");
b.Property <string>("Key")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("SessionId")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("SubjectId")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("Type")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.HasKey("Id");
b.HasIndex("ConsumedTime");
b.HasIndex("Expiration");
b.HasIndex("Key")
.IsUnique()
.HasFilter("[Key] IS NOT NULL");
b.HasIndex("SubjectId", "ClientId", "Type");
b.HasIndex("SubjectId", "SessionId", "Type");
b.ToTable("PersistedGrants", (string)null);
});
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.ServerSideSession", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <DateTime>("Created")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("DisplayName")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <DateTime?>("Expires")
.HasColumnType("datetime2");
b.Property <string>("Key")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <DateTime>("Renewed")
.HasColumnType("datetime2");
b.Property <string>("Scheme")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("SessionId")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("SubjectId")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.HasKey("Id");
b.HasIndex("DisplayName");
b.HasIndex("Expires");
b.HasIndex("Key")
.IsUnique();
b.HasIndex("SessionId");
b.HasIndex("SubjectId");
b.ToTable("ServerSideSessions", (string)null);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("ChristmasCalendar.Domain.Answer", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Country")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <bool>("CountryIsCorrect")
.HasColumnType("bit");
b.Property <int>("DoorId")
.HasColumnType("int");
b.Property <string>("Location")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <bool>("LocationIsCorrect")
.HasColumnType("bit");
b.Property <string>("UserId")
.IsRequired()
.HasMaxLength(450)
.HasColumnType("nvarchar(450)");
b.Property <DateTime>("When")
.HasColumnType("datetime2");
b.HasKey("Id");
b.ToTable("Answer", (string)null);
});
modelBuilder.Entity("ChristmasCalendar.Domain.ApplicationUser", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <int>("AccessFailedCount")
.HasColumnType("int");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("nvarchar(max)");
b.Property <string>("DateOfBirth")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("Email")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("EmailAddressFromAuthProvider")
.HasMaxLength(300)
.HasColumnType("nvarchar(300)");
b.Property <bool>("EmailConfirmed")
.HasColumnType("bit");
b.Property <string>("FirstName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("LastName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <bool>("LockoutEnabled")
.HasColumnType("bit");
b.Property <DateTimeOffset?>("LockoutEnd")
.HasColumnType("datetimeoffset");
b.Property <string>("Name")
.HasMaxLength(512)
.HasColumnType("nvarchar(512)");
b.Property <string>("NormalizedEmail")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("NormalizedUserName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("PasswordHash")
.HasColumnType("nvarchar(max)");
b.Property <string>("PhoneNumber")
.HasColumnType("nvarchar(max)");
b.Property <bool>("PhoneNumberConfirmed")
.HasColumnType("bit");
b.Property <string>("SecurityStamp")
.HasColumnType("nvarchar(max)");
b.Property <bool>("TwoFactorEnabled")
.HasColumnType("bit");
b.Property <string>("UserName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <bool>("WantsDailyNotification")
.HasColumnType("bit");
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasDatabaseName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasDatabaseName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers", (string)null);
});
modelBuilder.Entity("ChristmasCalendar.Domain.DailyScore", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("Bonus")
.HasColumnType("int");
b.Property <int>("DoorId")
.HasColumnType("int");
b.Property <int?>("DoorNumber")
.HasColumnType("int");
b.Property <string>("NameOfUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <int>("Points")
.HasColumnType("int");
b.Property <int>("Rank")
.HasColumnType("int");
b.Property <int>("RankMovement")
.HasColumnType("int");
b.Property <int>("TimeToAnswer")
.HasColumnType("int");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.Property <int>("Year")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("DoorId", "UserId")
.IsUnique();
b.ToTable("DailyScore", (string)null);
});
modelBuilder.Entity("ChristmasCalendar.Domain.DailyScoreLastUpdated", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <DateTime>("LastUpdated")
.HasColumnType("datetime2");
b.HasKey("Id");
b.ToTable("DailyScoreLastUpdated", (string)null);
});
modelBuilder.Entity("ChristmasCalendar.Domain.Door", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Country")
.IsRequired()
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("Description")
.HasMaxLength(512)
.HasColumnType("nvarchar(512)");
b.Property <DateTime>("ForDate")
.HasColumnType("datetime2");
b.Property <string>("ImagePath")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Location")
.IsRequired()
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <int>("Number")
.HasColumnType("int");
b.Property <int?>("PointsForCountry")
.HasColumnType("int");
b.Property <int?>("PointsForLocation")
.HasColumnType("int");
b.HasKey("Id");
b.ToTable("Door", (string)null);
});
modelBuilder.Entity("ChristmasCalendar.Domain.FirstTimeOpeningDoor", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("DoorId")
.HasColumnType("int");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <DateTime>("When")
.HasColumnType("datetime2");
b.HasKey("Id");
b.ToTable("FirstTimeOpeningDoor", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("NormalizedName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasDatabaseName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ClaimType")
.HasColumnType("nvarchar(max)");
b.Property <string>("ClaimValue")
.HasColumnType("nvarchar(max)");
b.Property <string>("RoleId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ClaimType")
.HasColumnType("nvarchar(max)");
b.Property <string>("ClaimValue")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property <string>("LoginProvider")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("ProviderKey")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("ProviderDisplayName")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("RoleId")
.HasColumnType("nvarchar(450)");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("LoginProvider")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("Name")
.HasMaxLength(128)
.HasColumnType("nvarchar(128)");
b.Property <string>("Value")
.HasColumnType("nvarchar(max)");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("ChristmasCalendar.Domain.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("ChristmasCalendar.Domain.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("ChristmasCalendar.Domain.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("ChristmasCalendar.Domain.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.HasSequence <int>("PollId")
.StartsAt(10000000L);
modelBuilder.Entity("RaidBattlesBot.Model.Friendship", b =>
{
b.Property <long>("Id")
.HasColumnType("bigint");
b.Property <long>("FriendId")
.HasColumnType("bigint");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <int?>("PollId")
.HasColumnType("int");
b.Property <int>("Type")
.HasColumnType("int");
b.HasKey("Id", "FriendId");
b.HasIndex("PollId");
b.ToTable("Friendship", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Notification", b =>
{
b.Property <int>("PollId")
.HasColumnType("int");
b.Property <long>("ChatId")
.HasColumnType("bigint");
b.Property <byte>("Type")
.HasColumnType("tinyint");
b.Property <long?>("BotId")
.HasColumnType("bigint");
b.Property <DateTimeOffset?>("DateTime")
.HasColumnType("datetimeoffset");
b.Property <long?>("MessageId")
.HasColumnType("bigint");
b.HasKey("PollId", "ChatId", "Type");
b.ToTable("Notifications", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Player", b =>
{
b.Property <long>("UserId")
.HasColumnType("bigint");
b.Property <bool?>("AutoApproveFriendship")
.HasColumnType("bit");
b.Property <long?>("FriendCode")
.HasColumnType("bigint");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <string>("Nickname")
.HasColumnType("nvarchar(max)");
b.HasKey("UserId");
b.ToTable("Players", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Poll", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasDefaultValueSql("NEXT VALUE FOR PollId");
b.Property <int?>("AllowedVotes")
.HasColumnType("int");
b.Property <bool>("Cancelled")
.HasColumnType("bit");
b.Property <bool>("ExRaidGym")
.HasColumnType("bit");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <long?>("Owner")
.HasColumnType("bigint");
b.Property <string>("PortalId")
.HasColumnType("nvarchar(450)");
b.Property <int?>("RaidId")
.HasColumnType("int");
b.Property <DateTimeOffset?>("Time")
.HasColumnType("datetimeoffset");
b.Property <string>("TimeZoneId")
.HasColumnType("nvarchar(max)");
b.Property <string>("Title")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("Id")
.IsUnique();
b.HasIndex("PortalId");
b.HasIndex("RaidId");
b.HasIndex("Time");
b.ToTable("Polls", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.PollMessage", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <long?>("BotId")
.HasColumnType("bigint");
b.Property <long?>("ChatId")
.HasColumnType("bigint");
b.Property <int?>("ChatType")
.HasColumnType("int");
b.Property <string>("InlineMessageId")
.HasColumnType("nvarchar(max)");
b.Property <int?>("MessageId")
.HasColumnType("int");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <int>("PollId")
.HasColumnType("int");
b.Property <byte?>("PollMode")
.HasColumnType("tinyint");
b.Property <long?>("UserId")
.HasColumnType("bigint");
b.HasKey("Id");
b.HasIndex("PollId");
b.HasIndex("ChatId", "MessageId");
b.ToTable("Messages", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Portal", b =>
{
b.Property <string>("Guid")
.HasColumnType("nvarchar(450)");
b.Property <string>("Address")
.HasColumnType("nvarchar(max)");
b.Property <string>("Image")
.HasColumnType("nvarchar(max)");
b.Property <decimal>("Latitude")
.HasColumnType("decimal(18,15)");
b.Property <decimal>("Longitude")
.HasColumnType("decimal(18,15)");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.HasKey("Guid");
b.ToTable("Portals", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Raid", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Description")
.HasColumnType("nvarchar(max)");
b.Property <int?>("EggRaidId")
.HasColumnType("int");
b.Property <DateTimeOffset?>("EndTime")
.HasColumnType("datetimeoffset");
b.Property <string>("Gym")
.HasColumnType("nvarchar(max)");
b.Property <decimal?>("Lat")
.HasColumnType("decimal(18,15)");
b.Property <decimal?>("Lon")
.HasColumnType("decimal(18,15)");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <string>("Move1")
.HasColumnType("nvarchar(max)");
b.Property <string>("Move2")
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.Property <string>("NearByAddress")
.HasColumnType("nvarchar(max)");
b.Property <string>("NearByPlaceId")
.HasColumnType("nvarchar(max)");
b.Property <int?>("Pokemon")
.HasColumnType("int");
b.Property <string>("PossibleGym")
.HasColumnType("nvarchar(max)");
b.Property <int?>("RaidBossLevel")
.HasColumnType("int");
b.Property <DateTimeOffset?>("StartTime")
.HasColumnType("datetimeoffset");
b.Property <string>("Title")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("EggRaidId")
.IsUnique()
.HasFilter("[EggRaidId] IS NOT NULL");
b.ToTable("Raids", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.ReplyNotification", b =>
{
b.Property <long>("ChatId")
.HasColumnType("bigint");
b.Property <long>("FromChatId")
.HasColumnType("bigint");
b.Property <int>("FromMessageId")
.HasColumnType("int");
b.Property <long?>("BotId")
.HasColumnType("bigint");
b.Property <long?>("FromUserId")
.HasColumnType("bigint");
b.Property <int?>("MessageId")
.HasColumnType("int");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <int?>("PollId")
.HasColumnType("int");
b.HasKey("ChatId", "FromChatId", "FromMessageId");
b.HasIndex("MessageId");
b.HasIndex("PollId");
b.ToTable("ReplyNotifications", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Settings", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <long>("Chat")
.HasColumnType("bigint");
b.Property <int>("Format")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasDefaultValue(71108369);
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <int>("Order")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("Chat");
SqlServerIndexBuilderExtensions.IncludeProperties(b.HasIndex("Chat"), new[] { "Format" });
b.ToTable("Settings", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.TimeZoneSettings", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <long>("ChatId")
.HasColumnType("bigint");
b.Property <string>("TimeZone")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("ChatId");
b.ToTable("TimeZoneSettings", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.UserSettings", b =>
{
b.Property <long>("UserId")
.HasColumnType("bigint");
b.Property <decimal?>("Lat")
.HasColumnType("decimal(18,15)");
b.Property <decimal?>("Lon")
.HasColumnType("decimal(18,15)");
b.Property <string>("TimeZoneId")
.HasMaxLength(32)
.HasColumnType("nvarchar(32)");
b.HasKey("UserId");
b.ToTable("UserSettings", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Vote", b =>
{
b.Property <int>("PollId")
.HasColumnType("int");
b.Property <long>("UserId")
.HasColumnType("bigint");
b.Property <long?>("BotId")
.HasColumnType("bigint");
b.Property <string>("FirstName")
.HasColumnType("nvarchar(max)");
b.Property <string>("LastName")
.HasColumnType("nvarchar(max)");
b.Property <DateTimeOffset?>("Modified")
.HasColumnType("datetimeoffset");
b.Property <int?>("Team")
.HasColumnType("int");
b.Property <string>("Username")
.HasColumnType("nvarchar(max)");
b.HasKey("PollId", "UserId");
b.HasIndex("PollId");
b.HasIndex("UserId");
b.ToTable("Votes", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.VoteLimit", b =>
{
b.Property <int>("PollId")
.HasColumnType("int");
b.Property <int>("Vote")
.HasColumnType("int");
b.Property <int>("Limit")
.HasColumnType("int");
b.HasKey("PollId", "Vote");
b.ToTable("VoteLimits", (string)null);
});
modelBuilder.Entity("RaidBattlesBot.Model.Notification", b =>
{
b.HasOne("RaidBattlesBot.Model.Poll", "Poll")
.WithMany("Notifications")
.HasForeignKey("PollId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Poll");
});
modelBuilder.Entity("RaidBattlesBot.Model.Poll", b =>
{
b.HasOne("RaidBattlesBot.Model.Portal", "Portal")
.WithMany()
.HasForeignKey("PortalId");
b.HasOne("RaidBattlesBot.Model.Raid", "Raid")
.WithMany("Polls")
.HasForeignKey("RaidId");
b.Navigation("Portal");
b.Navigation("Raid");
});
modelBuilder.Entity("RaidBattlesBot.Model.PollMessage", b =>
{
b.HasOne("RaidBattlesBot.Model.Poll", "Poll")
.WithMany("Messages")
.HasForeignKey("PollId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Poll");
});
modelBuilder.Entity("RaidBattlesBot.Model.Raid", b =>
{
b.HasOne("RaidBattlesBot.Model.Raid", "EggRaid")
.WithOne("PostEggRaid")
.HasForeignKey("RaidBattlesBot.Model.Raid", "EggRaidId");
b.Navigation("EggRaid");
});
modelBuilder.Entity("RaidBattlesBot.Model.ReplyNotification", b =>
{
b.HasOne("RaidBattlesBot.Model.Poll", "Poll")
.WithMany()
.HasForeignKey("PollId");
b.Navigation("Poll");
});
modelBuilder.Entity("RaidBattlesBot.Model.Vote", b =>
{
b.HasOne("RaidBattlesBot.Model.Poll", null)
.WithMany("Votes")
.HasForeignKey("PollId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("RaidBattlesBot.Model.VoteLimit", b =>
{
b.HasOne("RaidBattlesBot.Model.Poll", null)
.WithMany("Limits")
.HasForeignKey("PollId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("RaidBattlesBot.Model.Poll", b =>
{
b.Navigation("Limits");
b.Navigation("Messages");
b.Navigation("Notifications");
b.Navigation("Votes");
});
modelBuilder.Entity("RaidBattlesBot.Model.Raid", b =>
{
b.Navigation("Polls");
b.Navigation("PostEggRaid");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.DeviceFlowCodes", b =>
{
b.Property <string>("UserCode")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("ClientId")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime>("CreationTime")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasMaxLength(50000)
.HasColumnType("nvarchar(max)");
b.Property <string>("Description")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("DeviceCode")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime?>("Expiration")
.IsRequired()
.HasColumnType("datetime2");
b.Property <string>("SessionId")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("SubjectId")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.HasKey("UserCode");
b.HasIndex("DeviceCode")
.IsUnique();
b.HasIndex("Expiration");
b.ToTable("DeviceCodes", (string)null);
});
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.Key", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <string>("Algorithm")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <DateTime>("Created")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <bool>("DataProtected")
.HasColumnType("bit");
b.Property <bool>("IsX509Certificate")
.HasColumnType("bit");
b.Property <string>("Use")
.HasColumnType("nvarchar(450)");
b.Property <int>("Version")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("Use");
b.ToTable("Keys");
});
modelBuilder.Entity("Duende.IdentityServer.EntityFramework.Entities.PersistedGrant", b =>
{
b.Property <string>("Key")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("ClientId")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime?>("ConsumedTime")
.HasColumnType("datetime2");
b.Property <DateTime>("CreationTime")
.HasColumnType("datetime2");
b.Property <string>("Data")
.IsRequired()
.HasMaxLength(50000)
.HasColumnType("nvarchar(max)");
b.Property <string>("Description")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <DateTime?>("Expiration")
.HasColumnType("datetime2");
b.Property <string>("SessionId")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property <string>("SubjectId")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <string>("Type")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.HasKey("Key");
b.HasIndex("ConsumedTime");
b.HasIndex("Expiration");
b.HasIndex("SubjectId", "ClientId", "Type");
b.HasIndex("SubjectId", "SessionId", "Type");
b.ToTable("PersistedGrants", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("NormalizedName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasDatabaseName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ClaimType")
.HasColumnType("nvarchar(max)");
b.Property <string>("ClaimValue")
.HasColumnType("nvarchar(max)");
b.Property <string>("RoleId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("ClaimType")
.HasColumnType("nvarchar(max)");
b.Property <string>("ClaimValue")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property <string>("LoginProvider")
.HasColumnType("nvarchar(450)");
b.Property <string>("ProviderKey")
.HasColumnType("nvarchar(450)");
b.Property <string>("ProviderDisplayName")
.HasColumnType("nvarchar(max)");
b.Property <string>("UserId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("RoleId")
.HasColumnType("nvarchar(450)");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("LoginProvider")
.HasColumnType("nvarchar(450)");
b.Property <string>("Name")
.HasColumnType("nvarchar(450)");
b.Property <string>("Value")
.HasColumnType("nvarchar(max)");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens", (string)null);
});
modelBuilder.Entity("Northwind.Infrastructure.ApplicationUser", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <int>("AccessFailedCount")
.HasColumnType("int");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("nvarchar(max)");
b.Property <string>("Email")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <bool>("EmailConfirmed")
.HasColumnType("bit");
b.Property <bool>("LockoutEnabled")
.HasColumnType("bit");
b.Property <DateTimeOffset?>("LockoutEnd")
.HasColumnType("datetimeoffset");
b.Property <string>("NormalizedEmail")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("NormalizedUserName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property <string>("PasswordHash")
.HasColumnType("nvarchar(max)");
b.Property <string>("PhoneNumber")
.HasColumnType("nvarchar(max)");
b.Property <bool>("PhoneNumberConfirmed")
.HasColumnType("bit");
b.Property <string>("SecurityStamp")
.HasColumnType("nvarchar(max)");
b.Property <bool>("TwoFactorEnabled")
.HasColumnType("bit");
b.Property <string>("UserName")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasDatabaseName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasDatabaseName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers", (string)null);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("Northwind.Infrastructure.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("Northwind.Infrastructure.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Northwind.Infrastructure.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("Northwind.Infrastructure.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.2")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("FootballManager.Data.Models.Player", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("Description")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property <byte>("Endurance")
.HasColumnType("tinyint");
b.Property <string>("FullName")
.IsRequired()
.HasMaxLength(80)
.HasColumnType("nvarchar(80)");
b.Property <string>("ImageUrl")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Position")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property <byte>("Speed")
.HasColumnType("tinyint");
b.HasKey("Id");
b.ToTable("Players");
});
modelBuilder.Entity("FootballManager.Data.Models.User", b =>
{
b.Property <string>("Id")
.HasColumnType("nvarchar(450)");
b.Property <string>("Email")
.IsRequired()
.HasMaxLength(60)
.HasColumnType("nvarchar(60)");
b.Property <string>("Password")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("Username")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.HasKey("Id");
b.ToTable("Users");
});
modelBuilder.Entity("FootballManager.Data.Models.UserPlayer", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <int>("PlayerId")
.HasColumnType("int");
b.HasKey("UserId", "PlayerId");
b.HasIndex("PlayerId");
b.ToTable("UserPlayers");
});
modelBuilder.Entity("FootballManager.Data.Models.UserPlayer", b =>
{
b.HasOne("FootballManager.Data.Models.Player", "Player")
.WithMany("UserPlayers")
.HasForeignKey("PlayerId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("FootballManager.Data.Models.User", "User")
.WithMany("UserPlayers")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Player");
b.Navigation("User");
});
modelBuilder.Entity("FootballManager.Data.Models.Player", b =>
{
b.Navigation("UserPlayers");
});
modelBuilder.Entity("FootballManager.Data.Models.User", b =>
{
b.Navigation("UserPlayers");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("ESTeSoccerMVC.Models.League", b =>
{
b.Property <int>("LeagueId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("LeagueId"), 1L, 1);
b.Property <string>("Country")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.HasKey("LeagueId");
b.ToTable("League");
b.HasData(
new
{
LeagueId = 1,
Country = "Portugal",
Name = "Liga Bwin"
},
new
{
LeagueId = 2,
Country = "Inglaterra",
Name = "Premier League"
});
});
modelBuilder.Entity("ESTeSoccerMVC.Models.Player", b =>
{
b.Property <int>("PlayerId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("PlayerId"), 1L, 1);
b.Property <DateTime>("DateOfBirth")
.HasColumnType("datetime2");
b.Property <decimal?>("MarketValue")
.HasColumnType("decimal(18,2)");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <int?>("TeamId")
.HasColumnType("int");
b.HasKey("PlayerId");
b.HasIndex("TeamId");
b.ToTable("Player");
b.HasData(
new
{
PlayerId = 1,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 25000000m,
Name = "Pote",
TeamId = 1
},
new
{
PlayerId = 2,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 15000000m,
Name = "Paulinho",
TeamId = 1
},
new
{
PlayerId = 3,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 10000000m,
Name = "Francisco Conceição",
TeamId = 2
},
new
{
PlayerId = 4,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 25000000m,
Name = "Luis Diaz",
TeamId = 2
},
new
{
PlayerId = 5,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 25000000m,
Name = "Rafa",
TeamId = 3
},
new
{
PlayerId = 6,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 20000000m,
Name = "Grimaldo",
TeamId = 3
},
new
{
PlayerId = 7,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 45000000m,
Name = "Lukaku",
TeamId = 4
},
new
{
PlayerId = 8,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 25000000m,
Name = "Harvertz",
TeamId = 4
},
new
{
PlayerId = 9,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 100000000m,
Name = "De Bruyne",
TeamId = 5
},
new
{
PlayerId = 10,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 45000000m,
Name = "Bernardo Silva",
TeamId = 5
},
new
{
PlayerId = 11,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 75000000m,
Name = "Ronaldo",
TeamId = 6
},
new
{
PlayerId = 12,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 80000000m,
Name = "Bruno Fernandes",
TeamId = 6
},
new
{
PlayerId = 13,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 200000000m,
Name = "Salah",
TeamId = 7
},
new
{
PlayerId = 14,
DateOfBirth = new DateTime(1990, 3, 22, 0, 0, 0, 0, DateTimeKind.Unspecified),
MarketValue = 50000000m,
Name = "Diogo Jota",
TeamId = 7
});
});
modelBuilder.Entity("ESTeSoccerMVC.Models.Team", b =>
{
b.Property <int>("TeamId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("TeamId"), 1L, 1);
b.Property <DateTime?>("FoundingDate")
.HasColumnType("datetime2");
b.Property <string>("Initials")
.IsRequired()
.HasMaxLength(3)
.HasColumnType("nvarchar(3)");
b.Property <int>("LeagueId")
.HasColumnType("int");
b.Property <string>("MainColor")
.HasColumnType("nvarchar(max)");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <int>("NumberOfTitles")
.HasColumnType("int");
b.HasKey("TeamId");
b.HasIndex("LeagueId");
b.ToTable("Team");
b.HasData(
new
{
TeamId = 1,
Initials = "SCP",
LeagueId = 1,
MainColor = "Verde",
Name = "Sporting",
NumberOfTitles = 19
},
new
{
TeamId = 2,
Initials = "FCP",
LeagueId = 1,
MainColor = "Azul",
Name = "Porto",
NumberOfTitles = 29
},
new
{
TeamId = 3,
Initials = "SLB",
LeagueId = 1,
MainColor = "Vermelho",
Name = "Benfica",
NumberOfTitles = 35
},
new
{
TeamId = 4,
Initials = "CHE",
LeagueId = 2,
MainColor = "Azul",
Name = "Chelsea",
NumberOfTitles = 3
},
new
{
TeamId = 5,
Initials = "MCI",
LeagueId = 2,
MainColor = "Azul",
Name = "Manchester City",
NumberOfTitles = 6
},
new
{
TeamId = 6,
Initials = "MUN",
LeagueId = 2,
MainColor = "Vermelho",
Name = "Manchester United",
NumberOfTitles = 35
},
new
{
TeamId = 7,
Initials = "LIV",
LeagueId = 2,
MainColor = "Vermelho",
Name = "Liverpool",
NumberOfTitles = 35
});
});
modelBuilder.Entity("ESTeSoccerMVC.Models.Player", b =>
{
b.HasOne("ESTeSoccerMVC.Models.Team", "Team")
.WithMany("Players")
.HasForeignKey("TeamId");
b.Navigation("Team");
});
modelBuilder.Entity("ESTeSoccerMVC.Models.Team", b =>
{
b.HasOne("ESTeSoccerMVC.Models.League", "League")
.WithMany("Teams")
.HasForeignKey("LeagueId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("League");
});
modelBuilder.Entity("ESTeSoccerMVC.Models.League", b =>
{
b.Navigation("Teams");
});
modelBuilder.Entity("ESTeSoccerMVC.Models.Team", b =>
{
b.Navigation("Players");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("GameUser", b =>
{
b.Property <int>("GamesId")
.HasColumnType("int");
b.Property <int>("PlayersId")
.HasColumnType("int");
b.HasKey("GamesId", "PlayersId");
b.HasIndex("PlayersId");
b.ToTable("GameUser");
});
modelBuilder.Entity("InstaSport.Data.Models.City", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <DateTime?>("DeletedOn")
.HasColumnType("datetime2");
b.Property <bool>("IsDeleted")
.HasColumnType("bit");
b.Property <DateTime?>("ModifiedOn")
.HasColumnType("datetime2");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Cities");
b.HasData(
new
{
Id = 1,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Name = "Sofia"
},
new
{
Id = 2,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Name = "Plovdiv"
},
new
{
Id = 3,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Name = "Varna"
});
});
modelBuilder.Entity("InstaSport.Data.Models.Game", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <DateTime?>("DeletedOn")
.HasColumnType("datetime2");
b.Property <bool>("IsDeleted")
.HasColumnType("bit");
b.Property <int>("LocationId")
.HasColumnType("int");
b.Property <int?>("MaxPlayers")
.HasColumnType("int");
b.Property <int?>("MinPlayers")
.HasColumnType("int");
b.Property <DateTime?>("ModifiedOn")
.HasColumnType("datetime2");
b.Property <int>("SportId")
.HasColumnType("int");
b.Property <DateTime>("StartingDateTime")
.HasColumnType("datetime2");
b.Property <int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("LocationId");
b.HasIndex("SportId");
b.ToTable("Games");
b.HasData(
new
{
Id = 1,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
LocationId = 1,
MaxPlayers = 12,
MinPlayers = 6,
SportId = 1,
StartingDateTime = new DateTime(2022, 1, 3, 13, 4, 40, 450, DateTimeKind.Local).AddTicks(4837),
Status = 0
},
new
{
Id = 2,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
LocationId = 2,
MaxPlayers = 12,
MinPlayers = 6,
SportId = 2,
StartingDateTime = new DateTime(2022, 1, 2, 17, 4, 40, 450, DateTimeKind.Local).AddTicks(4915),
Status = 1
},
new
{
Id = 3,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
LocationId = 3,
MaxPlayers = 2,
MinPlayers = 2,
SportId = 3,
StartingDateTime = new DateTime(2022, 1, 2, 16, 4, 40, 450, DateTimeKind.Local).AddTicks(4922),
Status = 2
});
});
modelBuilder.Entity("InstaSport.Data.Models.Location", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("CityId")
.HasColumnType("int");
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <DateTime?>("DeletedOn")
.HasColumnType("datetime2");
b.Property <bool>("IsDeleted")
.HasColumnType("bit");
b.Property <decimal>("Latitude")
.HasColumnType("decimal(18,6)");
b.Property <decimal>("Longitude")
.HasColumnType("decimal(18,6)");
b.Property <DateTime?>("ModifiedOn")
.HasColumnType("datetime2");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("CityId");
b.ToTable("Locations");
b.HasData(
new
{
Id = 1,
CityId = 1,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Latitude = 42.6373743m,
Longitude = 23.315249m,
Name = "Tsarsko Selo"
},
new
{
Id = 2,
CityId = 2,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Latitude = 42.6846187m,
Longitude = 23.3356765m,
Name = "Sportna Sofia"
},
new
{
Id = 3,
CityId = 3,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Latitude = 42.6589267m,
Longitude = 23.3634143m,
Name = "Musagenitsa Sport"
});
});
modelBuilder.Entity("InstaSport.Data.Models.Rating", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <int>("AuthorId")
.HasColumnType("int");
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <DateTime?>("DeletedOn")
.HasColumnType("datetime2");
b.Property <bool>("IsDeleted")
.HasColumnType("bit");
b.Property <int?>("LocationId")
.HasColumnType("int");
b.Property <DateTime?>("ModifiedOn")
.HasColumnType("datetime2");
b.Property <int>("Value")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("AuthorId");
b.HasIndex("LocationId");
b.ToTable("Rating");
});
modelBuilder.Entity("InstaSport.Data.Models.Sport", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <DateTime?>("DeletedOn")
.HasColumnType("datetime2");
b.Property <bool>("IsDeleted")
.HasColumnType("bit");
b.Property <DateTime?>("ModifiedOn")
.HasColumnType("datetime2");
b.Property <string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Sports");
b.HasData(
new
{
Id = 1,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Name = "Football"
},
new
{
Id = 2,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Name = "Basketball"
},
new
{
Id = 3,
CreatedOn = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsDeleted = false,
Name = "Tennis"
});
});
modelBuilder.Entity("InstaSport.Data.Models.User", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property <int>("Id"), 1L, 1);
b.Property <string>("AvatarUrl")
.HasColumnType("nvarchar(max)");
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <DateTime>("DateJoined")
.HasColumnType("datetime2");
b.Property <DateTime?>("DeletedOn")
.HasColumnType("datetime2");
b.Property <string>("Email")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("FacebookUrl")
.HasColumnType("nvarchar(max)");
b.Property <string>("FirstName")
.HasColumnType("nvarchar(max)");
b.Property <bool>("IsDeleted")
.HasColumnType("bit");
b.Property <string>("LastName")
.HasColumnType("nvarchar(max)");
b.Property <DateTime?>("ModifiedOn")
.HasColumnType("datetime2");
b.Property <string>("PasswordHash")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <string>("UserName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Users");
});
modelBuilder.Entity("LocationSport", b =>
{
b.Property <int>("AvailableSportsId")
.HasColumnType("int");
b.Property <int>("LocationsId")
.HasColumnType("int");
b.HasKey("AvailableSportsId", "LocationsId");
b.HasIndex("LocationsId");
b.ToTable("LocationSport");
});
modelBuilder.Entity("SportUser", b =>
{
b.Property <int>("FavouriteSportsId")
.HasColumnType("int");
b.Property <int>("PlayersId")
.HasColumnType("int");
b.HasKey("FavouriteSportsId", "PlayersId");
b.HasIndex("PlayersId");
b.ToTable("SportUser");
});
modelBuilder.Entity("GameUser", b =>
{
b.HasOne("InstaSport.Data.Models.Game", null)
.WithMany()
.HasForeignKey("GamesId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("InstaSport.Data.Models.User", null)
.WithMany()
.HasForeignKey("PlayersId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("InstaSport.Data.Models.Game", b =>
{
b.HasOne("InstaSport.Data.Models.Location", "Location")
.WithMany()
.HasForeignKey("LocationId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("InstaSport.Data.Models.Sport", "Sport")
.WithMany()
.HasForeignKey("SportId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Location");
b.Navigation("Sport");
});
modelBuilder.Entity("InstaSport.Data.Models.Location", b =>
{
b.HasOne("InstaSport.Data.Models.City", "City")
.WithMany()
.HasForeignKey("CityId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("City");
});
modelBuilder.Entity("InstaSport.Data.Models.Rating", b =>
{
b.HasOne("InstaSport.Data.Models.User", "Author")
.WithMany("Ratings")
.HasForeignKey("AuthorId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("InstaSport.Data.Models.Location", null)
.WithMany("Ratings")
.HasForeignKey("LocationId");
b.Navigation("Author");
});
modelBuilder.Entity("LocationSport", b =>
{
b.HasOne("InstaSport.Data.Models.Sport", null)
.WithMany()
.HasForeignKey("AvailableSportsId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("InstaSport.Data.Models.Location", null)
.WithMany()
.HasForeignKey("LocationsId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("SportUser", b =>
{
b.HasOne("InstaSport.Data.Models.Sport", null)
.WithMany()
.HasForeignKey("FavouriteSportsId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("InstaSport.Data.Models.User", null)
.WithMany()
.HasForeignKey("PlayersId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("InstaSport.Data.Models.Location", b =>
{
b.Navigation("Ratings");
});
modelBuilder.Entity("InstaSport.Data.Models.User", b =>
{
b.Navigation("Ratings");
});
#pragma warning restore 612, 618
}
