protected override void OnModelCreating(ModelBuilder modelBuilder)
{
foreach (var relationship in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()))
{
relationship.DeleteBehavior = DeleteBehavior.Restrict;
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<LpaUser>(e =>
{
e.Key(p => p.Id);
e.Property(p => p.Id).UseSqlServerSequenceHiLo("LpaUserSeq", "dbo");
e.Property(p => p.Username).MaxLength(120).Required();
e.Property(p => p.Password).MaxLength(150).Required();
e.Property(p => p.PasswordSalt).MaxLength(100).Required();
e.Property(p => p.Created).Required().ValueGeneratedNever().HasSqlServerDefaultValueSql("sysdatetime()");
e.Collection(p => p.Claims).InverseReference(p => p.User);
e.ToSqlServerTable("Users");
});
modelBuilder.Entity<LpaUserClaim>(e =>
{
e.Key(p=>new { p.UserId, p.ClaimId }).SqlServerClustered();
e.Reference(p => p.Claim).InverseCollection(p => p.Users).Required();
e.Reference(p => p.User).InverseCollection(p => p.Claims).Required();
e.ToSqlServerTable("UserClaims");
});
modelBuilder.Entity<LpaClaim>(e =>
{
e.Key(p => p.Id).SqlServerClustered();
e.Property(p => p.Name).MaxLength(125).Required();
e.Property(p => p.Value).MaxLength(150).Required();
e.Collection(p => p.Users).InverseReference(p => p.Claim);
e.ToSqlServerTable("Claims");
});
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.0-rtm-21431");
modelBuilder.Entity("Sannel.House.Thermostat.Base.Models.Device", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<DateTime>("DateCreated");
b.Property<DateTime>("DateModified");
b.Property<string>("Description");
b.Property<int>("DisplayOrder");
b.Property<bool>("IsReadOnly");
b.Property<string>("Name");
b.HasKey("Id");
b.ToTable("Devices");
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.UseSqlServerIdentityColumns();
modelBuilder.Entity<ExamInstance>(
e =>
{
e.Property(p => p.Id).HasColumnName("ExamInstanceId");
}
);
modelBuilder.Entity<ExamInstanceQuestion>(
e =>
{
e.Property(p => p.Id).HasColumnName("ExamInstanceQuestionId");
}
);
modelBuilder.Entity<Question>(
e =>
{
e.Property(p => p.Id).HasColumnName("QuestionId");
}
);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<KettleChips>()
.Property(e => e.BestBuyDate)
.StoreGeneratedPattern(StoreGeneratedPattern.Identity)
.DefaultValue(new DateTime(2035, 9, 25));
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.0-rc2-20901")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("ToDo.Core.Models.ToDoItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("CreatedBy")
.IsRequired();
b.Property<DateTime>("CreatedDate");
b.Property<string>("Description")
.IsRequired();
b.Property<bool>("IsComplete");
b.Property<string>("Title")
.HasAnnotation("MaxLength", 25);
b.Property<string>("UpdatedBy");
b.Property<DateTime>("UpdatedDate");
b.HasKey("Id");
b.ToTable("ToDoItems");
});
}
public override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity<CustomerOrderHistory>().HasKey(coh => coh.ProductName);
modelBuilder.Entity<MostExpensiveProduct>().HasKey(mep => mep.TenMostExpensiveProducts);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.0-rtm-21431")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("BPE.Players.Player", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<DateTime>("CreationTime");
b.Property<string>("FirstName");
b.Property<DateTime?>("LastModificationTime");
b.Property<string>("LastName");
b.Property<int>("LoginCount");
b.HasKey("Id");
b.ToTable("Players");
});
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "7.0.0-rc1-16348")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Truewheelers.Models.Bicycles", b =>
{
b.Property<int>("ID")
.ValueGeneratedOnAdd();
b.Property<string>("Brand");
b.Property<string>("Colour");
b.Property<string>("Model");
b.Property<double>("Price");
b.Property<int>("Size");
b.HasKey("ID");
});
modelBuilder.Entity("Truewheelers.Models.ShoppingCart", b =>
{
b.Property<int>("ID")
.ValueGeneratedOnAdd();
b.Property<int>("itemID");
b.HasKey("ID");
});
}
public void RegisterModels(ModelBuilder modelbuilder)
{
modelbuilder.Entity<Dictionary>(etb =>
{
etb.HasKey(e => e.Id);
etb.Property(e => e.Id).UseSqlServerIdentityColumn();
etb.ForSqlServerToTable("Dictionaries");
}
);
modelbuilder.Entity<Culture>(etb =>
{
etb.HasKey(e => e.Id);
etb.Property(e => e.Id).UseSqlServerIdentityColumn();
etb.ForSqlServerToTable("Cultures");
}
);
modelbuilder.Entity<Localization>(etb =>
{
etb.HasKey(e => e.Id);
etb.Property(e => e.Id).UseSqlServerIdentityColumn();
etb.ForSqlServerToTable("Localizations");
}
);
}
public override void BuildModel(ModelBuilder builder)
{
builder
.Annotation("ProductVersion", "7.0.0-beta6-13815");
builder.Entity("EF7ProjectLemon.Auth", b =>
{
b.Property<int>("AuthId")
.ValueGeneratedOnAdd();
b.Property<string>("Login");
b.Key("AuthId");
});
builder.Entity("EF7ProjectLemon.Person", b =>
{
b.Property<int>("PersonId")
.ValueGeneratedOnAdd();
b.Property<string>("Name");
b.Key("PersonId");
});
}
public void NotMappedAttribute_ignores_entityTypes_with_conventional_builder()
{
var modelBuilder = new ModelBuilder(new CoreConventionSetBuilder().CreateConventionSet());
modelBuilder.Entity<B>();
Assert.Equal(1, modelBuilder.Model.EntityTypes.Count);
}
protected Model CreateModel()
{
var modelBuilder = new ModelBuilder(new ConventionSet());
modelBuilder.Entity<MappingQueryTestBase.MappedCustomer>(e =>
{
e.Key(c => c.CustomerID);
e.Property(c => c.CompanyName2).Metadata.Relational().Column = "Broken";
e.Metadata.Relational().Table = "Broken";
if (!string.IsNullOrEmpty(DatabaseSchema))
{
e.Metadata.Relational().Schema = "wrong";
}
});
modelBuilder.Entity<MappingQueryTestBase.MappedEmployee>(e =>
{
e.Key(em => em.EmployeeID);
e.Property(em => em.City2).Metadata.Relational().Column = "City";
e.Metadata.Relational().Table = "Employees";
e.Metadata.Relational().Schema = DatabaseSchema;
});
modelBuilder.Entity<MappingQueryTestBase.MappedOrder>(e =>
{
e.Key(o => o.OrderID);
e.Property(em => em.ShipVia2).Metadata.Relational().Column = "ShipVia";
e.Metadata.Relational().Table = "Orders";
e.Metadata.Relational().Schema = DatabaseSchema;
});
OnModelCreating(modelBuilder);
return modelBuilder.Model;
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
//Ignores
modelBuilder.Ignore<DataPoint>();
modelBuilder.Ignore<MarketsAndNews>();
modelBuilder.Ignore<MarketQuotes>();
modelBuilder.Ignore<OperationStatus>();
modelBuilder.Ignore<TickerQuote>();
modelBuilder.Ignore<Security>();
// Map these class names to the table names in the DB for Table Per Type (TPT)
// Currently not supported in EF7
//modelBuilder.Entity<Security>().ToTable("Security");
//modelBuilder.Entity<Stock>().ToTable("Stock");
//modelBuilder.Entity<MutualFund>().ToTable("MutualFund");
//Create one to many relationship between Customer/BrokerageAccounts
//modelBuilder.Entity<Customer>()
// .Collection(c => c.BrokerageAccounts)
// .InverseReference(ba => ba.Customer)
// .ForeignKey(ba => ba.CustomerId);
//modelBuilder.Entity<BrokerageAccount>()
// .Collection(ba => ba.Positions)
// .InverseReference(p => p.BrokerageAccount)
// .ForeignKey(p => p.BrokerageAccountId);
}
public override void BuildModel(ModelBuilder builder)
{
builder
.Annotation("ProductVersion", "7.0.0-beta6-13815");
builder.Entity("OoadProjekatBaza.RestoranBaza.Models.Restoran", b =>
{
b.Property<int>("RestoranId")
.ValueGeneratedOnAdd();
b.Property<float>("GeoDuzina");
b.Property<float>("GeoSirina");
b.Property<string>("Naziv");
b.Property<string>("Opis");
b.Property<float>("Rating");
b.Property<byte[]>("Slika")
.Annotation("Relational:ColumnType", "image");
b.Property<string>("Telefon");
b.Property<string>("fourSqaureId");
b.Key("RestoranId");
});
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "7.0.0-rc1-16348")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("ASP.NET_Core_SPAs.Models.Contact", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("EmailAddress")
.HasAnnotation("MaxLength", 200);
b.Property<string>("Name")
.IsRequired()
.HasAnnotation("MaxLength", 200);
b.Property<string>("PhoneNumber");
b.Property<string>("UserId");
b.HasKey("Id");
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
// Make Blog.Url required
modelBuilder.Entity<Blog>()
.Property(b => b.Url)
.IsRequired();
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
_logger.LogInformation("[{0}]: Mapping Records to DB Context", GetType().Name);
var sw = Stopwatch.StartNew();
var entityMethod = modelBuilder.GetType().GetRuntimeMethod("Entity", new Type[0]);
foreach (var assembly in _assemblyProvider.CandidateAssemblies.Distinct()) {
// Keep persistent attribute, but also introduce a convention like ContentPart
var entityTypes = assembly
.ExportedTypes
.Where(t =>
typeof(StorageDocument).IsAssignableFrom(t) &&
!t.GetTypeInfo().IsAbstract &&
!t.GetTypeInfo().IsInterface);
foreach (var type in entityTypes) {
_logger.LogDebug("Mapping record {0}", type.FullName);
entityMethod.MakeGenericMethod(type)
.Invoke(modelBuilder, new object[0]);
}
}
sw.Stop();
_logger.LogInformation("[{0}]: Records Mapped in {1}ms", GetType().Name, sw.ElapsedMilliseconds);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.1.0-rtm-22752")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Domain.Bag", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("Description");
b.Property<string>("Factory");
b.Property<string>("ImageLink");
b.Property<string>("Name");
b.Property<string>("Owner");
b.Property<int>("Price");
b.Property<DateTime?>("TimeBought");
b.Property<DateTime>("TimeCreation");
b.HasKey("Id");
b.ToTable("Bags");
});
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.1")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("hwnn.Models.Contact", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("FirstName");
b.Property<string>("LastName");
b.HasKey("Id");
b.ToTable("Contacts");
});
modelBuilder.Entity("hwnn.Models.Customer", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("CustomerName");
b.HasKey("Id");
b.ToTable("Customers");
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<AspNetUserLogins>()
.HasKey(k => new { k.LoginProvider, k.ProviderKey, k.UserId });
modelBuilder.Entity<AspNetUserRoles>()
.HasKey(k => new { k.UserId, k.RoleId });
modelBuilder.Entity<AspNetUserRoles>()
.HasOne(ur => ur.User)
.WithMany(u => u.AspNetUserRoles)
.HasForeignKey(ur => ur.UserId);
modelBuilder.Entity<AspNetUserRoles>()
.HasOne(ur => ur.Role)
.WithMany(r => r.AspNetUserRoles)
.HasForeignKey(ur => ur.RoleId);
modelBuilder.Entity<C__MigrationHistory>().HasKey(k => k.MigrationId);
/* modelBuilder.Entity<AspNetUsers>()
.HasMany(e => e.AspNetUserClaims)
.WithRequired(e => e.AspNetUsers)
.HasForeignKey(e => e.UserId);
modelBuilder.Entity<AspNetUsers>()
.HasMany(e => e.AspNetUserLogins)
.WithRequired(e => e.AspNetUsers)
.HasForeignKey(e => e.UserId);*/
base.OnModelCreating(modelBuilder);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.0-rc2-20901")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Haufwerk.Models.Issue", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("AdditionalInfo");
b.Property<DateTime>("CreationDateTime");
b.Property<bool>("Ignore");
b.Property<string>("Message");
b.Property<Guid?>("ParentId");
b.Property<string>("Source");
b.Property<string>("StackTrace");
b.Property<string>("User");
b.HasKey("Id");
b.ToTable("Issues");
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder) {
modelBuilder.Entity<Category>(entity => {
entity.HasIndex(e => e.CategoryName).HasName("CategoryName");
entity.Property(e => e.Description).HasColumnType("ntext");
entity.Property(e => e.Picture).HasColumnType("image");
});
modelBuilder.Entity<Order_Details>(entity => {
entity.HasKey(e => new { e.OrderID, e.ProductID });
entity.Property(e => e.Discount).HasDefaultValueSql("0");
entity.Property(e => e.Quantity).HasDefaultValueSql("1");
entity.Property(e => e.UnitPrice).HasDefaultValueSql("0");
});
modelBuilder.Entity<Order>(entity => {
entity.Property(e => e.Freight).HasDefaultValueSql("0");
});
modelBuilder.Entity<Product>(entity => {
entity.Property(e => e.Discontinued).HasDefaultValueSql("0");
entity.Property(e => e.ReorderLevel).HasDefaultValueSql("0");
entity.Property(e => e.UnitPrice).HasDefaultValueSql("0");
entity.Property(e => e.UnitsInStock).HasDefaultValueSql("0");
entity.Property(e => e.UnitsOnOrder).HasDefaultValueSql("0");
});
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.0-rtm-21431")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("WebApi_Identity_Provider_DotNet.Models.Credential", b =>
{
b.Property<string>("UserId")
.HasAnnotation("MaxLength", 256);
b.Property<string>("PublicKeyHash");
b.Property<string>("ActiveChallenge");
b.Property<string>("DeviceName")
.IsRequired();
b.Property<string>("PublicKey")
.IsRequired();
b.HasKey("UserId", "PublicKeyHash");
b.ToTable("Credentials");
});
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "7.0.0-beta8-15964")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Dorothy.Models.Guest", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<int>("AdultCount");
b.Property<int>("ChildCount");
b.Property<string>("Group");
b.Property<bool>("HasEmail");
b.Property<bool>("HasInvitation");
b.Property<bool>("IsOptional");
b.Property<string>("Names");
b.Property<string>("Notes");
b.HasKey("Id");
});
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
modelBuilder
.Annotation("ProductVersion", "7.0.0-beta8-15964")
.Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("PhoneSpotter.Models.PhoneSpotting", b =>
{
b.Property<int>("PhoneSpottingId")
.ValueGeneratedOnAdd();
b.Property<double>("Latitude");
b.Property<double>("Longitude");
b.Property<string>("Notes");
b.Property<string>("PhoneManufacturer");
b.Property<string>("PhoneModel");
b.Property<DateTime>("SpotTime");
b.HasKey("PhoneSpottingId");
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Parent>()
.HasMany(b => b.Children)
.WithOne(b => b.MyParent)
.HasForeignKey(b => b.ParentId);
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.0-rc2-20901");
modelBuilder.Entity("LinkThere.Models.Link", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<int>("ClickCount")
.IsConcurrencyToken();
b.Property<string>("Key")
.IsRequired();
b.Property<string>("LinkUrl")
.IsRequired();
b.HasKey("Id");
b.HasIndex("Key")
.IsUnique();
b.ToTable("Links");
});
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
modelBuilder
.HasAnnotation("ProductVersion", "1.0.1");
modelBuilder.Entity("cloudscribe.Core.IdentityServer.EFCore.Entities.PersistedGrant", b =>
{
b.Property<string>("Key");
b.Property<string>("Type");
b.Property<string>("ClientId")
.IsRequired()
.HasAnnotation("MaxLength", 200);
b.Property<DateTime>("CreationTime");
b.Property<string>("Data")
.IsRequired();
b.Property<DateTime>("Expiration");
b.Property<string>("SiteId")
.IsRequired()
.HasAnnotation("MaxLength", 36);
b.Property<string>("SubjectId");
b.HasKey("Key", "Type");
b.HasIndex("SiteId");
b.ToTable("csids_PersistedGrants");
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<User>().ToTable("Users");
modelBuilder.Entity<User>().HasKey(c => c.UserId);
modelBuilder.Entity<User>().Property(c => c.UserId).HasColumnName("Id");
modelBuilder.Entity<User>().Property(x=> x.Identifier).HasColumnName("Login");
modelBuilder.Entity<User>().Property(x=> x.Name).HasColumnName("Name");
modelBuilder.Entity<User>().Property(x=> x.Email).HasColumnName("Email");
modelBuilder.Entity<User>().Property(x=> x.IsSurveyor).HasColumnName("isSurveyor");
modelBuilder.Entity<User>().Property(x=> x.Password).HasColumnName("Password");
modelBuilder.Entity<User>().Property(x=> x.Status).HasColumnName("Status");
// mappings for orgs...
modelBuilder.Entity<Organization>().ToTable("Organizations");
modelBuilder.Entity<Organization>().HasKey(x => x.OrganizationId);
modelBuilder.Entity<Organization>().Property(x => x.OrganizationId).HasColumnName("ID");
modelBuilder.Entity<Organization>().Property(x => x.Identifier).HasColumnName("Identifier");
modelBuilder.Entity<Organization>().Property(x => x.Name).HasColumnName("Name");
modelBuilder.Entity<Organization>().Property(x => x.Email).HasColumnName("Email");
modelBuilder.Entity<Organization>().Property(x => x.BillingEmail).HasColumnName("BillingEmail");
modelBuilder.Entity<Organization>().Property(x => x.CreatedAt).HasColumnName("FirstAdded");
modelBuilder.Entity<Organization>().Property(x => x.Type).HasColumnName("Type");
modelBuilder.Entity<Organization>().Ignore(x => x.Status);//.HasColumnName("Status");
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.1.14-servicing-32113")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Blog.Models.Category", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Name");
b.HasKey("Id");
b.ToTable("Categories");
});
modelBuilder.Entity("Blog.Models.Post", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Body");
b.Property<int>("CategoryId");
b.Property<DateTime>("Created");
b.Property<string>("Description");
b.Property<string>("Image");
b.Property<string>("Tags");
b.Property<string>("Title");
b.HasKey("Id");
b.HasIndex("CategoryId");
b.ToTable("Posts");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property<string>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property<string>("Name")
.HasMaxLength(256);
b.Property<string>("NormalizedName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ClaimType");
b.Property<string>("ClaimValue");
b.Property<string>("RoleId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUser", b =>
{
b.Property<string>("Id")
.ValueGeneratedOnAdd();
b.Property<int>("AccessFailedCount");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property<string>("Email")
.HasMaxLength(256);
b.Property<bool>("EmailConfirmed");
b.Property<bool>("LockoutEnabled");
b.Property<DateTimeOffset?>("LockoutEnd");
b.Property<string>("NormalizedEmail")
.HasMaxLength(256);
b.Property<string>("NormalizedUserName")
.HasMaxLength(256);
b.Property<string>("PasswordHash");
b.Property<string>("PhoneNumber");
b.Property<bool>("PhoneNumberConfirmed");
b.Property<string>("SecurityStamp");
b.Property<bool>("TwoFactorEnabled");
b.Property<string>("UserName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ClaimType");
b.Property<string>("ClaimValue");
b.Property<string>("UserId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property<string>("LoginProvider");
b.Property<string>("ProviderKey");
b.Property<string>("ProviderDisplayName");
b.Property<string>("UserId")
.IsRequired();
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property<string>("UserId");
b.Property<string>("RoleId");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property<string>("UserId");
b.Property<string>("LoginProvider");
b.Property<string>("Name");
b.Property<string>("Value");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("Blog.Models.Post", b =>
{
b.HasOne("Blog.Models.Category", "Category")
.WithMany("Posts")
.HasForeignKey("CategoryId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void OnModelCreating(ModelBuilder builder)
{ base.OnModelCreating(builder);
}
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);
builder.Entity<Organization>(org => { org.ToTable("Organizations"); org.HasKey(x => x.Id); org.HasMany<Profile>().WithOne().HasForeignKey(x => x.OrgId).IsRequired(false); });
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.0.1-rtm-125")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("stockportfolio.Models.Stock", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("Currency");
b.Property<string>("Name");
b.Property<int>("StockExchangeID");
b.Property<string>("Symbol");
b.HasKey("Id");
b.HasIndex("StockExchangeID");
b.ToTable("Stock");
});
modelBuilder.Entity("stockportfolio.Models.StockExchange", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("Name");
b.Property<string>("Symbol");
b.HasKey("Id");
b.ToTable("StockExchange");
});
modelBuilder.Entity("stockportfolio.Models.User", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("Email")
.IsRequired();
b.Property<string>("FirstName")
.IsRequired();
b.Property<string>("LastName")
.IsRequired();
b.HasKey("Id");
b.ToTable("User");
});
modelBuilder.Entity("stockportfolio.Models.UserStock", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd();
b.Property<int>("Amount");
b.Property<DateTime>("PurchaseDate");
b.Property<double>("PurchasePrice");
b.Property<int>("StockId");
b.Property<int>("UserId");
b.HasKey("Id");
b.HasIndex("StockId");
b.HasIndex("UserId");
b.ToTable("UserStock");
});
modelBuilder.Entity("stockportfolio.Models.Stock", b =>
{
b.HasOne("stockportfolio.Models.StockExchange", "StockExchange")
.WithMany("Stocks")
.HasForeignKey("StockExchangeID")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("stockportfolio.Models.UserStock", b =>
{
b.HasOne("stockportfolio.Models.Stock", "Stock")
.WithMany()
.HasForeignKey("StockId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("stockportfolio.Models.User", "User")
.WithMany("UserStocks")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "5.0.1");
modelBuilder.Entity("Domain.Activity", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property<string>("Category")
.HasColumnType("TEXT");
b.Property<string>("City")
.HasColumnType("TEXT");
b.Property<DateTime>("Date")
.HasColumnType("TEXT");
b.Property<string>("Description")
.HasColumnType("TEXT");
b.Property<bool>("IsCancelled")
.HasColumnType("INTEGER");
b.Property<string>("Title")
.HasColumnType("TEXT");
b.Property<string>("Venue")
.HasColumnType("TEXT");
b.HasKey("Id");
b.ToTable("Activities");
});
modelBuilder.Entity("Domain.ActivityAttendee", b =>
{
b.Property<string>("AppUserId")
.HasColumnType("TEXT");
b.Property<Guid>("ActivityId")
.HasColumnType("TEXT");
b.Property<bool>("IsHost")
.HasColumnType("INTEGER");
b.HasKey("AppUserId", "ActivityId");
b.HasIndex("ActivityId");
b.ToTable("ActivityAttendees");
});
modelBuilder.Entity("Domain.AppUser", b =>
{
b.Property<string>("Id")
.HasColumnType("TEXT");
b.Property<int>("AccessFailedCount")
.HasColumnType("INTEGER");
b.Property<string>("Bio")
.HasColumnType("TEXT");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("TEXT");
b.Property<string>("DisplayName")
.HasColumnType("TEXT");
b.Property<string>("Email")
.HasMaxLength(256)
.HasColumnType("TEXT");
b.Property<bool>("EmailConfirmed")
.HasColumnType("INTEGER");
b.Property<bool>("LockoutEnabled")
.HasColumnType("INTEGER");
b.Property<DateTimeOffset?>("LockoutEnd")
.HasColumnType("TEXT");
b.Property<string>("NormalizedEmail")
.HasMaxLength(256)
.HasColumnType("TEXT");
b.Property<string>("NormalizedUserName")
.HasMaxLength(256)
.HasColumnType("TEXT");
b.Property<string>("PasswordHash")
.HasColumnType("TEXT");
b.Property<string>("PhoneNumber")
.HasColumnType("TEXT");
b.Property<bool>("PhoneNumberConfirmed")
.HasColumnType("INTEGER");
b.Property<string>("SecurityStamp")
.HasColumnType("TEXT");
b.Property<bool>("TwoFactorEnabled")
.HasColumnType("INTEGER");
b.Property<string>("UserName")
.HasMaxLength(256)
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasDatabaseName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasDatabaseName("UserNameIndex");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("Domain.Comment", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("INTEGER");
b.Property<Guid?>("ActivityId")
.HasColumnType("TEXT");
b.Property<string>("AuthorId")
.HasColumnType("TEXT");
b.Property<string>("Body")
.HasColumnType("TEXT");
b.Property<DateTime>("CreatedAt")
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("ActivityId");
b.HasIndex("AuthorId");
b.ToTable("Comments");
});
modelBuilder.Entity("Domain.Photo", b =>
{
b.Property<string>("Id")
.HasColumnType("TEXT");
b.Property<string>("AppUserId")
.HasColumnType("TEXT");
b.Property<bool>("IsMain")
.HasColumnType("INTEGER");
b.Property<string>("Url")
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("AppUserId");
b.ToTable("Photos");
});
modelBuilder.Entity("Domain.UserFollowing", b =>
{
b.Property<string>("ObserverId")
.HasColumnType("TEXT");
b.Property<string>("TargetId")
.HasColumnType("TEXT");
b.HasKey("ObserverId", "TargetId");
b.HasIndex("TargetId");
b.ToTable("UserFollowings");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property<string>("Id")
.HasColumnType("TEXT");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("TEXT");
b.Property<string>("Name")
.HasMaxLength(256)
.HasColumnType("TEXT");
b.Property<string>("NormalizedName")
.HasMaxLength(256)
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasDatabaseName("RoleNameIndex");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("INTEGER");
b.Property<string>("ClaimType")
.HasColumnType("TEXT");
b.Property<string>("ClaimValue")
.HasColumnType("TEXT");
b.Property<string>("RoleId")
.IsRequired()
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("INTEGER");
b.Property<string>("ClaimType")
.HasColumnType("TEXT");
b.Property<string>("ClaimValue")
.HasColumnType("TEXT");
b.Property<string>("UserId")
.IsRequired()
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property<string>("LoginProvider")
.HasColumnType("TEXT");
b.Property<string>("ProviderKey")
.HasColumnType("TEXT");
b.Property<string>("ProviderDisplayName")
.HasColumnType("TEXT");
b.Property<string>("UserId")
.IsRequired()
.HasColumnType("TEXT");
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property<string>("UserId")
.HasColumnType("TEXT");
b.Property<string>("RoleId")
.HasColumnType("TEXT");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property<string>("UserId")
.HasColumnType("TEXT");
b.Property<string>("LoginProvider")
.HasColumnType("TEXT");
b.Property<string>("Name")
.HasColumnType("TEXT");
b.Property<string>("Value")
.HasColumnType("TEXT");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("Domain.ActivityAttendee", b =>
{
b.HasOne("Domain.Activity", "Activity")
.WithMany("Attendees")
.HasForeignKey("ActivityId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Domain.AppUser", "AppUser")
.WithMany("Activities")
.HasForeignKey("AppUserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Activity");
b.Navigation("AppUser");
});
modelBuilder.Entity("Domain.Comment", b =>
{
b.HasOne("Domain.Activity", "Activity")
.WithMany("Comments")
.HasForeignKey("ActivityId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("Domain.AppUser", "Author")
.WithMany()
.HasForeignKey("AuthorId");
b.Navigation("Activity");
b.Navigation("Author");
});
modelBuilder.Entity("Domain.Photo", b =>
{
b.HasOne("Domain.AppUser", null)
.WithMany("Photos")
.HasForeignKey("AppUserId");
});
modelBuilder.Entity("Domain.UserFollowing", b =>
{
b.HasOne("Domain.AppUser", "Observer")
.WithMany("Followings")
.HasForeignKey("ObserverId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Domain.AppUser", "Target")
.WithMany("Followers")
.HasForeignKey("TargetId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Observer");
b.Navigation("Target");
});
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("Domain.AppUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("Domain.AppUser", 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("Domain.AppUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("Domain.AppUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Domain.Activity", b =>
{
b.Navigation("Attendees");
b.Navigation("Comments");
});
modelBuilder.Entity("Domain.AppUser", b =>
{
b.Navigation("Activities");
b.Navigation("Followers");
b.Navigation("Followings");
b.Navigation("Photos");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn)
.HasAnnotation("ProductVersion", "3.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 63);
modelBuilder.Entity("TITS_API.Models.Models.Ingredient", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("integer")
.HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn);
b.Property<string>("EnglishName")
.HasColumnType("text");
b.Property<string>("MolecularFormula")
.HasColumnType("text");
b.Property<string>("PolishName")
.HasColumnType("text");
b.Property<int?>("PubChemID")
.HasColumnType("integer");
b.Property<string>("PubChemUrl")
.HasColumnType("text");
b.Property<string>("ToxicityGrade")
.HasColumnType("text");
b.Property<string>("WikiUrl")
.HasColumnType("text");
b.HasKey("Id");
b.ToTable("Ingredients");
});
modelBuilder.Entity("TITS_API.Models.Models.Product", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("integer")
.HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn);
b.Property<string>("BrandName")
.HasColumnType("text");
b.Property<string>("BrandOwner")
.HasColumnType("text");
b.Property<string>("CountryOfOrigin")
.HasColumnType("text");
b.Property<string>("Description")
.HasColumnType("text");
b.Property<string>("Gtin")
.HasColumnType("text");
b.Property<string>("ItemName")
.HasColumnType("text");
b.Property<string>("ManufacturerName")
.HasColumnType("text");
b.Property<string>("Picture")
.HasColumnType("text");
b.Property<string>("Url")
.HasColumnType("text");
b.HasKey("Id");
b.ToTable("Products");
});
modelBuilder.Entity("TITS_API.Models.Models.ProductComposition", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("integer")
.HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn);
b.Property<int>("IngredientId")
.HasColumnType("integer");
b.Property<int>("ProductId")
.HasColumnType("integer");
b.HasKey("Id");
b.HasIndex("IngredientId");
b.HasIndex("ProductId");
b.ToTable("ProductCompositions");
});
modelBuilder.Entity("TITS_API.Models.Models.ProductComposition", b =>
{
b.HasOne("TITS_API.Models.Models.Ingredient", "Ingredient")
.WithMany()
.HasForeignKey("IngredientId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("TITS_API.Models.Models.Product", "Product")
.WithMany()
.HasForeignKey("ProductId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
#pragma warning restore 612, 618
}
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Anuncio>(entity =>
{
entity.ToTable("anuncio");
entity.Property(e => e.Anuncioid)
.HasColumnName("anuncioid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Mensaje)
.IsRequired()
.HasColumnName("mensaje")
.HasColumnType("character varying");
entity.Property(e => e.Tecnicoid).HasColumnName("tecnicoid");
entity.Property(e => e.Titulo)
.IsRequired()
.HasColumnName("titulo")
.HasColumnType("character varying");
entity.HasOne(d => d.Tecnico)
.WithMany(p => p.Anuncio)
.HasForeignKey(d => d.Tecnicoid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_tecnicoid");
});
modelBuilder.Entity<Banca>(entity =>
{
entity.ToTable("banca");
entity.Property(e => e.Bancaid)
.HasColumnName("bancaid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Banco)
.IsRequired()
.HasColumnName("banco")
.HasColumnType("character varying");
entity.Property(e => e.Cuenta)
.IsRequired()
.HasColumnName("cuenta")
.HasColumnType("character varying");
});
modelBuilder.Entity<Categoria>(entity =>
{
entity.ToTable("categoria");
entity.Property(e => e.Categoriaid)
.HasColumnName("categoriaid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Nombre)
.IsRequired()
.HasColumnName("nombre")
.HasColumnType("character varying");
});
modelBuilder.Entity<Cliente>(entity =>
{
entity.ToTable("cliente");
entity.Property(e => e.Clienteid)
.HasColumnName("clienteid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Bancaid).HasColumnName("bancaid");
entity.Property(e => e.Correo)
.IsRequired()
.HasColumnName("correo")
.HasColumnType("character varying");
entity.Property(e => e.Direccion)
.IsRequired()
.HasColumnName("direccion")
.HasColumnType("character varying");
entity.Property(e => e.Nombre)
.IsRequired()
.HasColumnName("nombre")
.HasColumnType("character varying");
entity.Property(e => e.Telefono)
.IsRequired()
.HasColumnName("telefono")
.HasColumnType("character varying");
entity.Property(e => e.Usuarioid).HasColumnName("usuarioid");
entity.HasOne(d => d.Banca)
.WithMany(p => p.Cliente)
.HasForeignKey(d => d.Bancaid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_bancaid");
entity.HasOne(d => d.Usuario)
.WithMany(p => p.Cliente)
.HasForeignKey(d => d.Usuarioid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_usuarioid");
});
modelBuilder.Entity<Contrato>(entity =>
{
entity.ToTable("contrato");
entity.Property(e => e.Contratoid)
.HasColumnName("contratoid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Descripcion)
.IsRequired()
.HasColumnName("descripcion")
.HasColumnType("character varying");
entity.Property(e => e.Tecnicoid).HasColumnName("tecnicoid");
entity.HasOne(d => d.Tecnico)
.WithMany(p => p.Contrato)
.HasForeignKey(d => d.Tecnicoid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_tecnicoid");
});
modelBuilder.Entity<Cotizacion>(entity =>
{
entity.ToTable("cotizacion");
entity.Property(e => e.Cotizacionid)
.HasColumnName("cotizacionid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Clienteid).HasColumnName("clienteid");
entity.Property(e => e.Descripcion)
.IsRequired()
.HasColumnName("descripcion")
.HasColumnType("character varying");
entity.HasOne(d => d.Cliente)
.WithMany(p => p.Cotizacion)
.HasForeignKey(d => d.Clienteid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_clienteid");
});
modelBuilder.Entity<Evaluacion>(entity =>
{
entity.ToTable("evaluacion");
entity.Property(e => e.Evaluacionid)
.HasColumnName("evaluacionid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Categoriaid).HasColumnName("categoriaid");
entity.Property(e => e.Clienteid).HasColumnName("clienteid");
entity.Property(e => e.Comentario)
.IsRequired()
.HasColumnName("comentario")
.HasColumnType("character varying");
entity.Property(e => e.Puntuacion).HasColumnName("puntuacion");
entity.Property(e => e.Tecnicoid).HasColumnName("tecnicoid");
entity.HasOne(d => d.Categoria)
.WithMany(p => p.Evaluacion)
.HasForeignKey(d => d.Categoriaid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_categoriaid");
entity.HasOne(d => d.Cliente)
.WithMany(p => p.Evaluacion)
.HasForeignKey(d => d.Clienteid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_clienteid");
entity.HasOne(d => d.Tecnico)
.WithMany(p => p.Evaluacion)
.HasForeignKey(d => d.Tecnicoid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_tecnicoid");
});
modelBuilder.Entity<Historialtecnico>(entity =>
{
entity.ToTable("historialtecnico");
entity.Property(e => e.Historialtecnicoid)
.HasColumnName("historialtecnicoid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Servicioid).HasColumnName("servicioid");
entity.Property(e => e.Tecnicoid).HasColumnName("tecnicoid");
entity.HasOne(d => d.Servicio)
.WithMany(p => p.Historialtecnico)
.HasForeignKey(d => d.Servicioid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_servicioid");
entity.HasOne(d => d.Tecnico)
.WithMany(p => p.Historialtecnico)
.HasForeignKey(d => d.Tecnicoid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_tecnicoid");
});
modelBuilder.Entity<Pago>(entity =>
{
entity.ToTable("pago");
entity.Property(e => e.Pagoid)
.HasColumnName("pagoid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Cleinteid).HasColumnName("cleinteid");
entity.Property(e => e.Fechadeexpiracion)
.IsRequired()
.HasColumnName("fechadeexpiracion")
.HasColumnType("character varying");
entity.Property(e => e.Monto).HasColumnName("monto");
entity.Property(e => e.Servicioid).HasColumnName("servicioid");
entity.Property(e => e.Tarjeta)
.IsRequired()
.HasColumnName("tarjeta")
.HasColumnType("character varying");
entity.Property(e => e.Tarjetahabiente)
.IsRequired()
.HasColumnName("tarjetahabiente")
.HasColumnType("character varying");
entity.Property(e => e.Tecnicoid).HasColumnName("tecnicoid");
entity.HasOne(d => d.Cleinte)
.WithMany(p => p.Pago)
.HasForeignKey(d => d.Cleinteid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_clienteid");
entity.HasOne(d => d.Servicio)
.WithMany(p => p.Pago)
.HasForeignKey(d => d.Servicioid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_servicioid");
entity.HasOne(d => d.Tecnico)
.WithMany(p => p.Pago)
.HasForeignKey(d => d.Tecnicoid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_tecnicoid");
});
modelBuilder.Entity<Servicio>(entity =>
{
entity.ToTable("servicio");
entity.Property(e => e.Servicioid)
.HasColumnName("servicioid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Categoriaid).HasColumnName("categoriaid");
entity.Property(e => e.Nombre)
.IsRequired()
.HasColumnName("nombre")
.HasColumnType("character varying");
});
modelBuilder.Entity<Tecnico>(entity =>
{
entity.ToTable("tecnico");
entity.Property(e => e.Tecnicoid)
.HasColumnName("tecnicoid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Bancaid).HasColumnName("bancaid");
entity.Property(e => e.Direccion)
.IsRequired()
.HasColumnName("direccion")
.HasColumnType("character varying");
entity.Property(e => e.Nombre)
.IsRequired()
.HasColumnName("nombre")
.HasColumnType("character varying");
entity.Property(e => e.Servicioid).HasColumnName("servicioid");
entity.Property(e => e.Telefono)
.IsRequired()
.HasColumnName("telefono")
.HasColumnType("character varying");
entity.Property(e => e.Usuarioid).HasColumnName("usuarioid");
entity.HasOne(d => d.Banca)
.WithMany(p => p.Tecnico)
.HasForeignKey(d => d.Bancaid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_bancaid");
entity.HasOne(d => d.Servicio)
.WithMany(p => p.Tecnico)
.HasForeignKey(d => d.Servicioid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_servicioid");
entity.HasOne(d => d.Usuario)
.WithMany(p => p.Tecnico)
.HasForeignKey(d => d.Usuarioid)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_usuarioid");
});
modelBuilder.Entity<Usuario>(entity =>
{
entity.ToTable("usuario");
entity.Property(e => e.Usuarioid)
.HasColumnName("usuarioid")
.UseIdentityAlwaysColumn();
entity.Property(e => e.Clave)
.IsRequired()
.HasColumnName("clave")
.HasColumnType("character varying");
entity.Property(e => e.Correo)
.IsRequired()
.HasColumnName("correo")
.HasColumnType("character varying");
entity.Property(e => e.Cuenta).HasColumnName("cuenta");
entity.Property(e => e.Nombre)
.IsRequired()
.HasColumnName("nombre")
.HasColumnType("character varying");
entity.Property(e => e.Tipo).HasColumnName("tipo");
});
OnModelCreatingPartial(modelBuilder);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "3.1.8")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
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")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
b.Property <string>("NormalizedName")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
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");
});
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")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
b.Property <bool>("EmailConfirmed")
.HasColumnType("bit");
b.Property <bool>("LockoutEnabled")
.HasColumnType("bit");
b.Property <DateTimeOffset?>("LockoutEnd")
.HasColumnType("datetimeoffset");
b.Property <string>("NormalizedEmail")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
b.Property <string>("NormalizedUserName")
.HasColumnType("nvarchar(256)")
.HasMaxLength(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")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
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");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property <string>("LoginProvider")
.HasColumnType("nvarchar(128)")
.HasMaxLength(128);
b.Property <string>("ProviderKey")
.HasColumnType("nvarchar(128)")
.HasMaxLength(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");
});
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");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property <string>("UserId")
.HasColumnType("nvarchar(450)");
b.Property <string>("LoginProvider")
.HasColumnType("nvarchar(128)")
.HasMaxLength(128);
b.Property <string>("Name")
.HasColumnType("nvarchar(128)")
.HasMaxLength(128);
b.Property <string>("Value")
.HasColumnType("nvarchar(max)");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("PathChatApp.Models.Message", b =>
{
b.Property <Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property <DateTime>("CreatedTime")
.HasColumnType("datetime2");
b.Property <string>("MessageText")
.HasColumnType("nvarchar(max)");
b.Property <Guid?>("RoomId")
.HasColumnType("uniqueidentifier");
b.Property <string>("SenderName")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("RoomId");
b.ToTable("Messages");
});
modelBuilder.Entity("PathChatApp.Models.Room", b =>
{
b.Property <Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property <string>("RoomName")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Rooms");
});
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("PathChatApp.Models.Message", b =>
{
b.HasOne("PathChatApp.Models.Room", null)
.WithMany("Messages")
.HasForeignKey("RoomId");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.4-servicing-10062")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
modelBuilder.Entity("ApplicationCore.Entities.BasketAggregate.Basket", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("BuyerId");
b.Property <DateTime?>("CreatedDate");
b.Property <DateTime?>("UpdatedDate");
b.HasKey("Id");
b.ToTable("Basket");
});
modelBuilder.Entity("ApplicationCore.Entities.BasketAggregate.BasketItem", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <int>("BasketId");
b.Property <int?>("CatalogAttribute1");
b.Property <int?>("CatalogAttribute2");
b.Property <int?>("CatalogAttribute3");
b.Property <int>("CatalogItemId");
b.Property <DateTime?>("CreatedDate");
b.Property <string>("CustomizeName")
.HasMaxLength(100);
b.Property <int>("Quantity");
b.Property <decimal>("UnitPrice")
.HasColumnType("decimal(18,2)");
b.Property <DateTime?>("UpdatedDate");
b.HasKey("Id");
b.HasIndex("BasketId");
b.ToTable("BasketItem");
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogAttribute", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <int>("CatalogItemId");
b.Property <string>("Name");
b.Property <int>("Stock");
b.Property <int>("Type");
b.HasKey("Id");
b.HasIndex("CatalogItemId");
b.ToTable("CatalogAttribute");
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogCategory", b =>
{
b.Property <int>("CatalogItemId");
b.Property <int>("CategoryId");
b.HasKey("CatalogItemId", "CategoryId");
b.HasIndex("CategoryId");
b.ToTable("CatalogCategory");
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogItem", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <int>("CatalogTypeId");
b.Property <bool>("IsFeatured");
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(100);
b.Property <string>("PictureUri");
b.Property <decimal?>("Price")
.HasColumnType("decimal(18,2)");
b.Property <bool>("ShowOnShop");
b.Property <string>("Sku")
.HasMaxLength(255);
b.Property <int>("Stock");
b.HasKey("Id");
b.HasIndex("CatalogTypeId");
b.ToTable("Catalog");
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogType", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Code")
.IsRequired()
.HasMaxLength(25);
b.Property <decimal>("Price")
.HasColumnType("decimal(18,2)");
b.HasKey("Id");
b.HasIndex("Code")
.IsUnique();
b.ToTable("CatalogType");
});
modelBuilder.Entity("ApplicationCore.Entities.Category", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(100);
b.Property <int>("Order")
.ValueGeneratedOnAdd()
.HasDefaultValue(1);
b.Property <int?>("ParentId");
b.HasKey("Id");
b.HasIndex("Name")
.IsUnique();
b.HasIndex("ParentId");
b.ToTable("Category");
});
modelBuilder.Entity("ApplicationCore.Entities.Country", b =>
{
b.Property <int>("Id");
b.Property <string>("Code")
.IsRequired()
.HasMaxLength(10);
b.Property <string>("Name")
.IsRequired()
.HasMaxLength(100);
b.HasKey("Id");
b.ToTable("Country");
});
modelBuilder.Entity("ApplicationCore.Entities.InvoiceConfig", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <DateTime?>("LastRunDate");
b.Property <decimal>("MaxValue");
b.Property <int>("NrInvoices");
b.Property <int>("Week");
b.Property <int>("WeekState");
b.HasKey("Id");
b.ToTable("InvoiceConfig");
});
modelBuilder.Entity("ApplicationCore.Entities.OrderAggregate.Order", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("BuyerId");
b.Property <string>("CustomerEmail");
b.Property <DateTimeOffset>("OrderDate");
b.Property <int>("OrderState")
.ValueGeneratedOnAdd()
.HasDefaultValue(0);
b.Property <long?>("SalesInvoiceId");
b.Property <string>("SalesInvoiceNumber")
.HasMaxLength(255);
b.Property <int?>("TaxNumber");
b.HasKey("Id");
b.ToTable("Orders");
});
modelBuilder.Entity("ApplicationCore.Entities.OrderAggregate.OrderItem", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("CustomizeName");
b.Property <int?>("OrderId");
b.Property <decimal>("UnitPrice")
.HasColumnType("decimal(18,2)");
b.Property <int>("Units");
b.HasKey("Id");
b.HasIndex("OrderId");
b.ToTable("OrderItems");
});
modelBuilder.Entity("ApplicationCore.Entities.BasketAggregate.BasketItem", b =>
{
b.HasOne("ApplicationCore.Entities.BasketAggregate.Basket", "Basket")
.WithMany("Items")
.HasForeignKey("BasketId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogAttribute", b =>
{
b.HasOne("ApplicationCore.Entities.CatalogItem", "CatalogItem")
.WithMany("CatalogAttributes")
.HasForeignKey("CatalogItemId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogCategory", b =>
{
b.HasOne("ApplicationCore.Entities.CatalogItem", "CatalogItem")
.WithMany("CatalogCategories")
.HasForeignKey("CatalogItemId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("ApplicationCore.Entities.Category", "Category")
.WithMany("CatalogCategories")
.HasForeignKey("CategoryId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ApplicationCore.Entities.CatalogItem", b =>
{
b.HasOne("ApplicationCore.Entities.CatalogType", "CatalogType")
.WithMany("CatalogItems")
.HasForeignKey("CatalogTypeId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ApplicationCore.Entities.Category", b =>
{
b.HasOne("ApplicationCore.Entities.Category", "Parent")
.WithMany()
.HasForeignKey("ParentId");
});
modelBuilder.Entity("ApplicationCore.Entities.OrderAggregate.Order", b =>
{
b.OwnsOne("ApplicationCore.Entities.OrderAggregate.Address", "BillingToAddress", b1 =>
{
b1.Property <int>("OrderId");
b1.Property <string>("City");
b1.Property <string>("Country");
b1.Property <string>("Name");
b1.Property <string>("PostalCode");
b1.Property <string>("Street");
b1.HasKey("OrderId");
b1.ToTable("Orders");
b1.HasOne("ApplicationCore.Entities.OrderAggregate.Order")
.WithOne("BillingToAddress")
.HasForeignKey("ApplicationCore.Entities.OrderAggregate.Address", "OrderId")
.OnDelete(DeleteBehavior.Cascade);
});
});
modelBuilder.Entity("ApplicationCore.Entities.OrderAggregate.OrderItem", b =>
{
b.HasOne("ApplicationCore.Entities.OrderAggregate.Order")
.WithMany("OrderItems")
.HasForeignKey("OrderId");
b.OwnsOne("ApplicationCore.Entities.OrderAggregate.CatalogItemOrdered", "ItemOrdered", b1 =>
{
b1.Property <int>("OrderItemId");
b1.Property <int>("CatalogItemId");
b1.Property <string>("PictureUri");
b1.Property <string>("ProductName");
b1.HasKey("OrderItemId");
b1.ToTable("OrderItems");
b1.HasOne("ApplicationCore.Entities.OrderAggregate.OrderItem")
.WithOne("ItemOrdered")
.HasForeignKey("ApplicationCore.Entities.OrderAggregate.CatalogItemOrdered", "OrderItemId")
.OnDelete(DeleteBehavior.Cascade);
});
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.4-servicing-10062")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
modelBuilder.Entity("WeddingPlanner.Models.Attendee", b =>
{
b.Property<int>("AttendeeId")
.ValueGeneratedOnAdd();
b.Property<int>("UserId");
b.Property<int>("WeddingId");
b.HasKey("AttendeeId");
b.HasIndex("UserId");
b.HasIndex("WeddingId");
b.ToTable("Attendees");
});
modelBuilder.Entity("WeddingPlanner.Models.User", b =>
{
b.Property<int>("UserId")
.ValueGeneratedOnAdd();
b.Property<DateTime>("CreatedAt");
b.Property<string>("Email")
.IsRequired();
b.Property<string>("FirstName")
.IsRequired();
b.Property<string>("LastName")
.IsRequired();
b.Property<string>("Password")
.IsRequired();
b.Property<DateTime>("UpdatedAt");
b.HasKey("UserId");
b.ToTable("Users");
});
modelBuilder.Entity("WeddingPlanner.Models.Wedding", b =>
{
b.Property<int>("WeddingId")
.ValueGeneratedOnAdd();
b.Property<string>("Address")
.IsRequired();
b.Property<DateTime>("CreatedAt");
b.Property<DateTime>("Date");
b.Property<DateTime>("UpdatedAt");
b.Property<int>("UserId");
b.Property<string>("WedderOne")
.IsRequired();
b.Property<string>("WedderTwo")
.IsRequired();
b.HasKey("WeddingId");
b.HasIndex("UserId");
b.ToTable("Weddings");
});
modelBuilder.Entity("WeddingPlanner.Models.Attendee", b =>
{
b.HasOne("WeddingPlanner.Models.User", "User")
.WithMany("Attending")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("WeddingPlanner.Models.Wedding", "Wedding")
.WithMany("Atendees")
.HasForeignKey("WeddingId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("WeddingPlanner.Models.Wedding", b =>
{
b.HasOne("WeddingPlanner.Models.User")
.WithMany("CreatedWeddings")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:MaxIdentifierLength", 64)
.HasAnnotation("ProductVersion", "5.0.3");
modelBuilder.Entity("JustWorkForGodsSake.Models.User", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <string>("FirstName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("HomeTown")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("LastName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <int>("UserGroupId")
.HasColumnType("int");
b.HasKey("Id");
b.ToTable("Users");
b.HasData(
new
{
Id = 1,
FirstName = "Jack",
HomeTown = "Varna",
LastName = "Smith",
UserGroupId = 1
},
new
{
Id = 2,
FirstName = "Simo",
HomeTown = "Sofia",
LastName = "Petrov",
UserGroupId = 1
});
});
modelBuilder.Entity("JustWorkForGodsSake.Models.UserGroup", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <int>("Memebers")
.HasColumnType("int");
b.Property <string>("Name")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.ToTable("UserGroups");
b.HasData(
new
{
Id = 1,
Memebers = 226,
Name = "SoftServe"
},
new
{
Id = 2,
Memebers = 150,
Name = "IKEA"
});
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:MaxIdentifierLength", 64)
.HasAnnotation("ProductVersion", "5.0.2");
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property<string>("Id")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("Name")
.HasMaxLength(256)
.HasColumnType("varchar(256) CHARACTER SET utf8mb4");
b.Property<string>("NormalizedName")
.HasMaxLength(256)
.HasColumnType("varchar(256) CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasDatabaseName("RoleNameIndex");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property<string>("ClaimType")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("ClaimValue")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("RoleId")
.IsRequired()
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUser", b =>
{
b.Property<string>("Id")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.Property<int>("AccessFailedCount")
.HasColumnType("int");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("Email")
.HasMaxLength(256)
.HasColumnType("varchar(256) CHARACTER SET utf8mb4");
b.Property<bool>("EmailConfirmed")
.HasColumnType("tinyint(1)");
b.Property<bool>("LockoutEnabled")
.HasColumnType("tinyint(1)");
b.Property<DateTimeOffset?>("LockoutEnd")
.HasColumnType("datetime(6)");
b.Property<string>("NormalizedEmail")
.HasMaxLength(256)
.HasColumnType("varchar(256) CHARACTER SET utf8mb4");
b.Property<string>("NormalizedUserName")
.HasMaxLength(256)
.HasColumnType("varchar(256) CHARACTER SET utf8mb4");
b.Property<string>("PasswordHash")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("PhoneNumber")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<bool>("PhoneNumberConfirmed")
.HasColumnType("tinyint(1)");
b.Property<string>("SecurityStamp")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<bool>("TwoFactorEnabled")
.HasColumnType("tinyint(1)");
b.Property<string>("UserName")
.HasMaxLength(256)
.HasColumnType("varchar(256) CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasDatabaseName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasDatabaseName("UserNameIndex");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property<string>("ClaimType")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("ClaimValue")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("UserId")
.IsRequired()
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property<string>("LoginProvider")
.HasMaxLength(128)
.HasColumnType("varchar(128) CHARACTER SET utf8mb4");
b.Property<string>("ProviderKey")
.HasMaxLength(128)
.HasColumnType("varchar(128) CHARACTER SET utf8mb4");
b.Property<string>("ProviderDisplayName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property<string>("UserId")
.IsRequired()
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property<string>("UserId")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.Property<string>("RoleId")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property<string>("UserId")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.Property<string>("LoginProvider")
.HasMaxLength(128)
.HasColumnType("varchar(128) CHARACTER SET utf8mb4");
b.Property<string>("Name")
.HasMaxLength(128)
.HasColumnType("varchar(128) CHARACTER SET utf8mb4");
b.Property<string>("Value")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
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();
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.1.14-servicing-32113")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("MyVet.Web.Data.Entities.Agenda", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("Date");
b.Property<bool>("IsAvailable");
b.Property<int?>("OwnerId");
b.Property<int?>("PetId");
b.Property<string>("Remarks");
b.HasKey("Id");
b.HasIndex("OwnerId");
b.HasIndex("PetId");
b.ToTable("Agendas");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.History", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("Date");
b.Property<string>("Description")
.IsRequired()
.HasMaxLength(100);
b.Property<int?>("PetId");
b.Property<string>("Remarks");
b.Property<int?>("serviceTypeId");
b.HasKey("Id");
b.HasIndex("PetId");
b.HasIndex("serviceTypeId");
b.ToTable("Histories");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.Owner", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Address")
.HasMaxLength(100);
b.Property<string>("CellPhone")
.IsRequired()
.HasMaxLength(20);
b.Property<string>("Document")
.IsRequired()
.HasMaxLength(30);
b.Property<string>("FirstName")
.IsRequired()
.HasMaxLength(50);
b.Property<string>("FixedPhone")
.HasMaxLength(20);
b.Property<string>("LastName")
.IsRequired()
.HasMaxLength(50);
b.HasKey("Id");
b.ToTable("Owners");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.Pet", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("Born");
b.Property<string>("ImageUrl");
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(50);
b.Property<int?>("OwnerId");
b.Property<string>("Race")
.HasMaxLength(50);
b.Property<string>("Remarks");
b.Property<int?>("petTypeId");
b.HasKey("Id");
b.HasIndex("OwnerId");
b.HasIndex("petTypeId");
b.ToTable("Pets");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.PetType", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(50);
b.HasKey("Id");
b.ToTable("petTypes");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.ServiceType", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(50);
b.HasKey("Id");
b.ToTable("serviceTypes");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.Agenda", b =>
{
b.HasOne("MyVet.Web.Data.Entities.Owner", "Owner")
.WithMany("Agendas")
.HasForeignKey("OwnerId");
b.HasOne("MyVet.Web.Data.Entities.Pet", "Pet")
.WithMany("Agendas")
.HasForeignKey("PetId");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.History", b =>
{
b.HasOne("MyVet.Web.Data.Entities.Pet", "Pet")
.WithMany("Histories")
.HasForeignKey("PetId");
b.HasOne("MyVet.Web.Data.Entities.ServiceType", "serviceType")
.WithMany("Histories")
.HasForeignKey("serviceTypeId");
});
modelBuilder.Entity("MyVet.Web.Data.Entities.Pet", b =>
{
b.HasOne("MyVet.Web.Data.Entities.Owner", "Owner")
.WithMany("Pets")
.HasForeignKey("OwnerId");
b.HasOne("MyVet.Web.Data.Entities.PetType", "petType")
.WithMany("Pets")
.HasForeignKey("petTypeId");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.0-rtm-35687")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("SudokuApp.Data.Entity.Grid", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property <Guid?>("CreatedBy");
b.Property <DateTime>("CreatedDate");
b.Property <Guid?>("DeletedBy");
b.Property <DateTime?>("DeletedDate");
b.Property <string>("FilledBoardData");
b.Property <string>("FullBoardData")
.IsRequired();
b.Property <bool>("IsActive");
b.Property <Guid?>("ModifiedBy");
b.Property <DateTime?>("ModifiedDate");
b.Property <int>("UserId");
b.Property <byte[]>("Version")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate();
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("Grid");
});
modelBuilder.Entity("SudokuApp.Data.Entity.User", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property <Guid?>("CreatedBy");
b.Property <DateTime>("CreatedDate");
b.Property <Guid?>("DeletedBy");
b.Property <DateTime?>("DeletedDate");
b.Property <Guid?>("ModifiedBy");
b.Property <DateTime?>("ModifiedDate");
b.Property <string>("UserName")
.IsRequired();
b.Property <byte[]>("Version")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate();
b.HasKey("Id");
b.HasIndex("UserName")
.IsUnique();
b.ToTable("User");
});
modelBuilder.Entity("SudokuApp.Data.Entity.Grid", b =>
{
b.HasOne("SudokuApp.Data.Entity.User", "User")
.WithMany("Grids")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "3.1.5")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("StockManagement.Data.Models.ProductModel", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <string>("ProductCode")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.HasKey("Id");
b.HasIndex("ProductCode");
b.ToTable("Product");
});
modelBuilder.Entity("StockManagement.Data.Models.StockActionModel", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property <string>("CorrelationId")
.IsRequired()
.HasColumnType("nvarchar(450)");
b.Property <int>("Count")
.HasColumnType("int");
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <long>("ProductId")
.HasColumnType("bigint");
b.Property <int>("StockActionType")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("ProductId");
b.HasIndex("CorrelationId", "StockActionType")
.IsUnique();
b.ToTable("StockAction");
});
modelBuilder.Entity("StockManagement.Data.Models.StockModel", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property <int>("AvailableStock")
.HasColumnType("int");
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <long>("ProductId")
.HasColumnType("bigint");
b.Property <string>("ProductCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property <long>("StockActionId")
.HasColumnType("bigint");
b.Property <DateTime>("UpdatedOn")
.HasColumnType("datetime2");
b.HasKey("Id");
b.HasIndex("ProductId")
.IsUnique();
b.ToTable("Stock");
});
modelBuilder.Entity("StockManagement.Data.Models.StockSnapshotModel", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property <int>("AvailableStock")
.HasColumnType("int");
b.Property <DateTime>("CreatedOn")
.HasColumnType("datetime2");
b.Property <long>("ProductId")
.HasColumnType("bigint");
b.Property <long>("StockActionId")
.HasColumnType("bigint");
b.Property <DateTime>("UpdatedOn")
.HasColumnType("datetime2");
b.HasKey("Id");
b.HasIndex("ProductId");
b.ToTable("StockSnapshot");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.1.4-rtm-31024")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property<string>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property<string>("Name")
.HasMaxLength(256);
b.Property<string>("NormalizedName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ClaimType");
b.Property<string>("ClaimValue");
b.Property<string>("RoleId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUser", b =>
{
b.Property<string>("Id")
.ValueGeneratedOnAdd();
b.Property<int>("AccessFailedCount");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property<string>("Discriminator")
.IsRequired();
b.Property<string>("Email")
.HasMaxLength(256);
b.Property<bool>("EmailConfirmed");
b.Property<bool>("LockoutEnabled");
b.Property<DateTimeOffset?>("LockoutEnd");
b.Property<string>("NormalizedEmail")
.HasMaxLength(256);
b.Property<string>("NormalizedUserName")
.HasMaxLength(256);
b.Property<string>("PasswordHash");
b.Property<string>("PhoneNumber");
b.Property<bool>("PhoneNumberConfirmed");
b.Property<string>("SecurityStamp");
b.Property<bool>("TwoFactorEnabled");
b.Property<string>("UserName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers");
b.HasDiscriminator<string>("Discriminator").HasValue("IdentityUser");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ClaimType");
b.Property<string>("ClaimValue");
b.Property<string>("UserId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property<string>("LoginProvider");
b.Property<string>("ProviderKey");
b.Property<string>("ProviderDisplayName");
b.Property<string>("UserId")
.IsRequired();
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property<string>("UserId");
b.Property<string>("RoleId");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property<string>("UserId");
b.Property<string>("LoginProvider");
b.Property<string>("Name");
b.Property<string>("Value");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("Smart_Binance.Models.API", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Guid");
b.Property<string>("Key");
b.Property<string>("Secret");
b.HasKey("Id");
b.ToTable("APIs");
});
modelBuilder.Entity("Smart_Binance.Models.Customer", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("APIId");
b.Property<string>("Name");
b.Property<int?>("PhoneNumber");
b.Property<string>("UserId");
b.HasKey("Id");
b.HasIndex("APIId");
b.HasIndex("UserId");
b.ToTable("Customers");
});
modelBuilder.Entity("Smart_Binance.Models.Trade", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<decimal>("Amount")
.HasColumnType("decimal(28, 18)");
b.Property<int>("AmountDecimal");
b.Property<int>("BasePriceDecimal");
b.Property<decimal>("BuyPrice")
.HasColumnType("decimal(28, 18)");
b.Property<int>("CustomerId");
b.Property<string>("DisplayType");
b.Property<bool>("IsTrailing");
b.Property<bool>("LimitPending");
b.Property<string>("Market");
b.Property<long>("OrderId");
b.Property<int>("PriceDecimal");
b.Property<DateTime>("StartTime");
b.Property<bool>("Status");
b.Property<decimal>("StopLossPrice")
.HasColumnType("decimal(28, 18)");
b.Property<bool>("Success");
b.Property<decimal>("TakeProfitPrice")
.HasColumnType("decimal(28, 18)");
b.Property<string>("Type");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.ToTable("Trades");
});
modelBuilder.Entity("Smart_Binance.Models.TradeResult", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("EndTime");
b.Property<decimal>("PercentDiff")
.HasColumnType("decimal(10, 10)");
b.Property<long>("SellOrderId");
b.Property<decimal>("SellPrice")
.HasColumnType("decimal(10, 10)");
b.Property<bool>("Success");
b.Property<int>("TradeId");
b.HasKey("Id");
b.HasIndex("TradeId");
b.ToTable("TradeResults");
});
modelBuilder.Entity("Smart_Binance.Models.ApplicationUser", b =>
{
b.HasBaseType("Microsoft.AspNetCore.Identity.IdentityUser");
b.ToTable("ApplicationUser");
b.HasDiscriminator().HasValue("ApplicationUser");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Smart_Binance.Models.Customer", b =>
{
b.HasOne("Smart_Binance.Models.API", "API")
.WithMany()
.HasForeignKey("APIId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("Smart_Binance.Models.ApplicationUser", "ApplicationUser")
.WithMany()
.HasForeignKey("UserId");
});
modelBuilder.Entity("Smart_Binance.Models.Trade", b =>
{
b.HasOne("Smart_Binance.Models.Customer", "Customer")
.WithMany()
.HasForeignKey("CustomerId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Smart_Binance.Models.TradeResult", b =>
{
b.HasOne("Smart_Binance.Models.Trade", "Trade")
.WithMany()
.HasForeignKey("TradeId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.2-servicing-10034")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiResource", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("Created");
b.Property<string>("Description")
.HasMaxLength(1000);
b.Property<string>("DisplayName")
.HasMaxLength(200);
b.Property<bool>("Enabled");
b.Property<DateTime?>("LastAccessed");
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(200);
b.Property<bool>("NonEditable");
b.Property<DateTime?>("Updated");
b.HasKey("Id");
b.HasIndex("Name")
.IsUnique();
b.ToTable("ApiResources");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiResourceClaim", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ApiResourceId");
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(200);
b.HasKey("Id");
b.HasIndex("ApiResourceId");
b.ToTable("ApiClaims");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiResourceProperty", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ApiResourceId");
b.Property<string>("Key")
.IsRequired()
.HasMaxLength(250);
b.Property<string>("Value")
.IsRequired()
.HasMaxLength(2000);
b.HasKey("Id");
b.HasIndex("ApiResourceId");
b.ToTable("ApiProperties");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiScope", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ApiResourceId");
b.Property<string>("Description")
.HasMaxLength(1000);
b.Property<string>("DisplayName")
.HasMaxLength(200);
b.Property<bool>("Emphasize");
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(200);
b.Property<bool>("Required");
b.Property<bool>("ShowInDiscoveryDocument");
b.HasKey("Id");
b.HasIndex("ApiResourceId");
b.HasIndex("Name")
.IsUnique();
b.ToTable("ApiScopes");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiScopeClaim", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ApiScopeId");
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(200);
b.HasKey("Id");
b.HasIndex("ApiScopeId");
b.ToTable("ApiScopeClaims");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiSecret", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ApiResourceId");
b.Property<DateTime>("Created");
b.Property<string>("Description")
.HasMaxLength(1000);
b.Property<DateTime?>("Expiration");
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(250);
b.Property<string>("Value")
.IsRequired()
.HasMaxLength(4000);
b.HasKey("Id");
b.HasIndex("ApiResourceId");
b.ToTable("ApiSecrets");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.Client", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("AbsoluteRefreshTokenLifetime");
b.Property<int>("AccessTokenLifetime");
b.Property<int>("AccessTokenType");
b.Property<bool>("AllowAccessTokensViaBrowser");
b.Property<bool>("AllowOfflineAccess");
b.Property<bool>("AllowPlainTextPkce");
b.Property<bool>("AllowRememberConsent");
b.Property<bool>("AlwaysIncludeUserClaimsInIdToken");
b.Property<bool>("AlwaysSendClientClaims");
b.Property<int>("AuthorizationCodeLifetime");
b.Property<bool>("BackChannelLogoutSessionRequired");
b.Property<string>("BackChannelLogoutUri")
.HasMaxLength(2000);
b.Property<string>("ClientClaimsPrefix")
.HasMaxLength(200);
b.Property<string>("ClientId")
.IsRequired()
.HasMaxLength(200);
b.Property<string>("ClientName")
.HasMaxLength(200);
b.Property<string>("ClientUri")
.HasMaxLength(2000);
b.Property<int?>("ConsentLifetime");
b.Property<DateTime>("Created");
b.Property<string>("Description")
.HasMaxLength(1000);
b.Property<int>("DeviceCodeLifetime");
b.Property<bool>("EnableLocalLogin");
b.Property<bool>("Enabled");
b.Property<bool>("FrontChannelLogoutSessionRequired");
b.Property<string>("FrontChannelLogoutUri")
.HasMaxLength(2000);
b.Property<int>("IdentityTokenLifetime");
b.Property<bool>("IncludeJwtId");
b.Property<DateTime?>("LastAccessed");
b.Property<string>("LogoUri")
.HasMaxLength(2000);
b.Property<bool>("NonEditable");
b.Property<string>("PairWiseSubjectSalt")
.HasMaxLength(200);
b.Property<string>("ProtocolType")
.IsRequired()
.HasMaxLength(200);
b.Property<int>("RefreshTokenExpiration");
b.Property<int>("RefreshTokenUsage");
b.Property<bool>("RequireClientSecret");
b.Property<bool>("RequireConsent");
b.Property<bool>("RequirePkce");
b.Property<int>("SlidingRefreshTokenLifetime");
b.Property<bool>("UpdateAccessTokenClaimsOnRefresh");
b.Property<DateTime?>("Updated");
b.Property<string>("UserCodeType")
.HasMaxLength(100);
b.Property<int?>("UserSsoLifetime");
b.HasKey("Id");
b.HasIndex("ClientId")
.IsUnique();
b.ToTable("Clients");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientClaim", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(250);
b.Property<string>("Value")
.IsRequired()
.HasMaxLength(250);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientClaims");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientCorsOrigin", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("Origin")
.IsRequired()
.HasMaxLength(150);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientCorsOrigins");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientGrantType", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("GrantType")
.IsRequired()
.HasMaxLength(250);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientGrantTypes");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientIdPRestriction", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("Provider")
.IsRequired()
.HasMaxLength(200);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientIdPRestrictions");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientPostLogoutRedirectUri", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("PostLogoutRedirectUri")
.IsRequired()
.HasMaxLength(2000);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientPostLogoutRedirectUris");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientProperty", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("Key")
.IsRequired()
.HasMaxLength(250);
b.Property<string>("Value")
.IsRequired()
.HasMaxLength(2000);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientProperties");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientRedirectUri", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("RedirectUri")
.IsRequired()
.HasMaxLength(2000);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientRedirectUris");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientScope", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<string>("Scope")
.IsRequired()
.HasMaxLength(200);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientScopes");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientSecret", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ClientId");
b.Property<DateTime>("Created");
b.Property<string>("Description")
.HasMaxLength(2000);
b.Property<DateTime?>("Expiration");
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(250);
b.Property<string>("Value")
.IsRequired()
.HasMaxLength(4000);
b.HasKey("Id");
b.HasIndex("ClientId");
b.ToTable("ClientSecrets");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.DeviceFlowCodes", b =>
{
b.Property<string>("UserCode")
.ValueGeneratedOnAdd()
.HasMaxLength(200);
b.Property<string>("ClientId")
.IsRequired()
.HasMaxLength(200);
b.Property<DateTime>("CreationTime");
b.Property<string>("Data")
.IsRequired()
.HasMaxLength(50000);
b.Property<string>("DeviceCode")
.IsRequired()
.HasMaxLength(200);
b.Property<DateTime?>("Expiration")
.IsRequired();
b.Property<string>("SubjectId")
.HasMaxLength(200);
b.HasKey("UserCode");
b.HasIndex("DeviceCode")
.IsUnique();
b.ToTable("DeviceCodes");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.IdentityClaim", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("IdentityResourceId");
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(200);
b.HasKey("Id");
b.HasIndex("IdentityResourceId");
b.ToTable("IdentityClaims");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.IdentityResource", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("Created");
b.Property<string>("Description")
.HasMaxLength(1000);
b.Property<string>("DisplayName")
.HasMaxLength(200);
b.Property<bool>("Emphasize");
b.Property<bool>("Enabled");
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(200);
b.Property<bool>("NonEditable");
b.Property<bool>("Required");
b.Property<bool>("ShowInDiscoveryDocument");
b.Property<DateTime?>("Updated");
b.HasKey("Id");
b.HasIndex("Name")
.IsUnique();
b.ToTable("IdentityResources");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.IdentityResourceProperty", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("IdentityResourceId");
b.Property<string>("Key")
.IsRequired()
.HasMaxLength(250);
b.Property<string>("Value")
.IsRequired()
.HasMaxLength(2000);
b.HasKey("Id");
b.HasIndex("IdentityResourceId");
b.ToTable("IdentityProperties");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.PersistedGrant", b =>
{
b.Property<string>("Key")
.HasMaxLength(200);
b.Property<string>("ClientId")
.IsRequired()
.HasMaxLength(200);
b.Property<DateTime>("CreationTime");
b.Property<string>("Data")
.IsRequired()
.HasMaxLength(50000);
b.Property<DateTime?>("Expiration");
b.Property<string>("SubjectId")
.HasMaxLength(200);
b.Property<string>("Type")
.IsRequired()
.HasMaxLength(50);
b.HasKey("Key");
b.HasIndex("SubjectId", "ClientId", "Type");
b.ToTable("PersistedGrants");
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiResourceClaim", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.ApiResource", "ApiResource")
.WithMany("UserClaims")
.HasForeignKey("ApiResourceId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiResourceProperty", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.ApiResource", "ApiResource")
.WithMany("Properties")
.HasForeignKey("ApiResourceId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiScope", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.ApiResource", "ApiResource")
.WithMany("Scopes")
.HasForeignKey("ApiResourceId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiScopeClaim", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.ApiScope", "ApiScope")
.WithMany("UserClaims")
.HasForeignKey("ApiScopeId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ApiSecret", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.ApiResource", "ApiResource")
.WithMany("Secrets")
.HasForeignKey("ApiResourceId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientClaim", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("Claims")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientCorsOrigin", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("AllowedCorsOrigins")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientGrantType", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("AllowedGrantTypes")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientIdPRestriction", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("IdentityProviderRestrictions")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientPostLogoutRedirectUri", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("PostLogoutRedirectUris")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientProperty", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("Properties")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientRedirectUri", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("RedirectUris")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientScope", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("AllowedScopes")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.ClientSecret", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.Client", "Client")
.WithMany("ClientSecrets")
.HasForeignKey("ClientId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.IdentityClaim", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.IdentityResource", "IdentityResource")
.WithMany("UserClaims")
.HasForeignKey("IdentityResourceId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("IdentityServer4.EntityFramework.Entities.IdentityResourceProperty", b =>
{
b.HasOne("IdentityServer4.EntityFramework.Entities.IdentityResource", "IdentityResource")
.WithMany("Properties")
.HasForeignKey("IdentityResourceId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.6-servicing-10079");
modelBuilder.Entity("DatingApp.API.Models.Photo", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <DateTime>("DateAdded");
b.Property <string>("Description");
b.Property <bool>("IsMain");
b.Property <string>("PublicId");
b.Property <string>("Url");
b.Property <int>("UserId");
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("Photos");
});
modelBuilder.Entity("DatingApp.API.Models.User", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("City");
b.Property <string>("Country");
b.Property <DateTime>("Created");
b.Property <DateTime>("DateOfBirth");
b.Property <string>("Gender");
b.Property <string>("Interests");
b.Property <string>("Introduction");
b.Property <string>("KnownAs");
b.Property <DateTime>("LastActive");
b.Property <string>("LookingFor");
b.Property <byte[]>("PasswordHash");
b.Property <byte[]>("PasswordSalt");
b.Property <string>("Username");
b.HasKey("Id");
b.ToTable("Users");
});
modelBuilder.Entity("DatingApp.API.Models.Value", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Name");
b.HasKey("Id");
b.ToTable("Values");
});
modelBuilder.Entity("DatingApp.API.Models.Photo", b =>
{
b.HasOne("DatingApp.API.Models.User", "User")
.WithMany("Photos")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.0.3-rtm-10026")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("ISCS.Data.Entities.Area", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Coords");
b.Property <string>("Name");
b.HasKey("Id");
b.ToTable("Areas");
});
modelBuilder.Entity("ISCS.Data.Entities.AreaWork", b =>
{
b.Property <long>("WorkId");
b.Property <long>("AreaId");
b.HasKey("WorkId", "AreaId");
b.HasIndex("AreaId");
b.ToTable("AreaWorks");
});
modelBuilder.Entity("ISCS.Data.Entities.Equipment", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd();
b.Property <long>("AreaId");
b.Property <string>("Description");
b.Property <string>("Name");
b.HasKey("Id");
b.HasIndex("AreaId");
b.ToTable("Equipments");
});
modelBuilder.Entity("ISCS.Data.Entities.EquipmentOperation", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd();
b.Property <long>("EquipmentId");
b.Property <long>("OperationId");
b.HasKey("Id");
b.HasIndex("EquipmentId");
b.HasIndex("OperationId");
b.ToTable("EquipmentOperations");
});
modelBuilder.Entity("ISCS.Data.Entities.Operation", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Description");
b.Property <string>("Name");
b.HasKey("Id");
b.ToTable("Operations");
});
modelBuilder.Entity("ISCS.Data.Entities.TechCard", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Comment");
b.Property <DateTime>("CreationDate")
.ValueGeneratedOnAdd()
.HasDefaultValue(new DateTime(2018, 5, 15, 0, 0, 0, 0, DateTimeKind.Local));
b.Property <string>("Description");
b.Property <bool>("IsActual")
.ValueGeneratedOnAdd()
.HasDefaultValue(true);
b.Property <int>("PeopleNumber");
b.Property <int>("TechCardState")
.ValueGeneratedOnAdd()
.HasDefaultValue(0);
b.Property <long>("WorkId");
b.HasKey("Id");
b.HasIndex("WorkId");
b.ToTable("TechCards");
});
modelBuilder.Entity("ISCS.Data.Entities.TechCardEquipment", b =>
{
b.Property <long>("EquipmentId");
b.Property <long>("TechCardId");
b.HasKey("EquipmentId", "TechCardId");
b.HasIndex("TechCardId");
b.ToTable("TechCardEquipments");
});
modelBuilder.Entity("ISCS.Data.Entities.TechCardOperation", b =>
{
b.Property <long>("TechCardId");
b.Property <long>("EquipmentOperationId");
b.Property <long>("OrderId");
b.HasKey("TechCardId", "EquipmentOperationId");
b.HasIndex("EquipmentOperationId");
b.ToTable("TechCardOperations");
});
modelBuilder.Entity("ISCS.Data.Entities.Work", b =>
{
b.Property <long>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("Description");
b.Property <string>("Name");
b.HasKey("Id");
b.ToTable("Works");
});
modelBuilder.Entity("ISCS.Models.ApplicationUser", b =>
{
b.Property <string>("Id")
.ValueGeneratedOnAdd();
b.Property <int>("AccessFailedCount");
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property <string>("Email")
.HasMaxLength(256);
b.Property <bool>("EmailConfirmed");
b.Property <bool>("LockoutEnabled");
b.Property <DateTimeOffset?>("LockoutEnd");
b.Property <string>("NormalizedEmail")
.HasMaxLength(256);
b.Property <string>("NormalizedUserName")
.HasMaxLength(256);
b.Property <string>("PasswordHash");
b.Property <string>("PhoneNumber");
b.Property <bool>("PhoneNumberConfirmed");
b.Property <string>("SecurityStamp");
b.Property <bool>("TwoFactorEnabled");
b.Property <string>("UserName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property <string>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property <string>("Name")
.HasMaxLength(256);
b.Property <string>("NormalizedName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("ClaimType");
b.Property <string>("ClaimValue");
b.Property <string>("RoleId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property <int>("Id")
.ValueGeneratedOnAdd();
b.Property <string>("ClaimType");
b.Property <string>("ClaimValue");
b.Property <string>("UserId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property <string>("LoginProvider");
b.Property <string>("ProviderKey");
b.Property <string>("ProviderDisplayName");
b.Property <string>("UserId")
.IsRequired();
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property <string>("UserId");
b.Property <string>("RoleId");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property <string>("UserId");
b.Property <string>("LoginProvider");
b.Property <string>("Name");
b.Property <string>("Value");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("ISCS.Data.Entities.AreaWork", b =>
{
b.HasOne("ISCS.Data.Entities.Area", "Area")
.WithMany("AreaWorks")
.HasForeignKey("AreaId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("ISCS.Data.Entities.Work", "Work")
.WithMany("AreaWorks")
.HasForeignKey("WorkId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ISCS.Data.Entities.Equipment", b =>
{
b.HasOne("ISCS.Data.Entities.Area", "Area")
.WithMany("Equipments")
.HasForeignKey("AreaId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ISCS.Data.Entities.EquipmentOperation", b =>
{
b.HasOne("ISCS.Data.Entities.Equipment", "Equipment")
.WithMany("EquipmentOperations")
.HasForeignKey("EquipmentId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("ISCS.Data.Entities.Operation", "Operation")
.WithMany("EquipmentOperations")
.HasForeignKey("OperationId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ISCS.Data.Entities.TechCard", b =>
{
b.HasOne("ISCS.Data.Entities.Work", "Work")
.WithMany("TechCards")
.HasForeignKey("WorkId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ISCS.Data.Entities.TechCardEquipment", b =>
{
b.HasOne("ISCS.Data.Entities.Equipment", "Equipment")
.WithMany("TechCardEquipments")
.HasForeignKey("EquipmentId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("ISCS.Data.Entities.TechCard", "TechCard")
.WithMany("TechCardEquipments")
.HasForeignKey("TechCardId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("ISCS.Data.Entities.TechCardOperation", b =>
{
b.HasOne("ISCS.Data.Entities.EquipmentOperation", "EquipmentOperation")
.WithMany()
.HasForeignKey("EquipmentOperationId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("ISCS.Data.Entities.TechCard", "TechCard")
.WithMany("TechCardOperations")
.HasForeignKey("TechCardId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("ISCS.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("ISCS.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("ISCS.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("ISCS.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.4-servicing-10062")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("BachelorProject.Models.AdditionalGame", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ApplicationUserId");
b.Property<int?>("BarmaidId");
b.Property<int>("BranchOffice");
b.Property<int>("Count");
b.Property<DateTime>("Date");
b.Property<int>("GameTypeId");
b.Property<int?>("InstructorId");
b.HasKey("Id");
b.HasIndex("ApplicationUserId");
b.HasIndex("BarmaidId");
b.HasIndex("GameTypeId");
b.HasIndex("InstructorId");
b.ToTable("AdditionalGames");
});
modelBuilder.Entity("BachelorProject.Models.ApplicationUser", b =>
{
b.Property<string>("Id")
.ValueGeneratedOnAdd();
b.Property<int>("AccessFailedCount");
b.Property<int?>("BranchOffice");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property<string>("Email")
.HasMaxLength(256);
b.Property<bool>("EmailConfirmed");
b.Property<bool>("LockoutEnabled");
b.Property<DateTimeOffset?>("LockoutEnd");
b.Property<string>("NormalizedEmail")
.HasMaxLength(256);
b.Property<string>("NormalizedUserName")
.HasMaxLength(256);
b.Property<string>("PasswordHash");
b.Property<string>("PhoneNumber");
b.Property<bool>("PhoneNumberConfirmed");
b.Property<string>("SecurityStamp");
b.Property<bool>("TwoFactorEnabled");
b.Property<string>("UserName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasName("UserNameIndex")
.HasFilter("[NormalizedUserName] IS NOT NULL");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("BachelorProject.Models.Employee", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Email")
.IsRequired();
b.Property<bool>("IsValid");
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(50);
b.Property<int>("Role");
b.HasKey("Id");
b.ToTable("Employees");
});
modelBuilder.Entity("BachelorProject.Models.GameType", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("BarmaidCommision");
b.Property<int>("InstruktorCommision");
b.Property<bool>("IsValid");
b.Property<string>("Name")
.IsRequired()
.HasMaxLength(50);
b.Property<int>("Price");
b.Property<int>("SoloCommision");
b.HasKey("Id");
b.ToTable("GameTypes");
});
modelBuilder.Entity("BachelorProject.Models.Voucher", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ApplicationUserId");
b.Property<string>("Code");
b.Property<DateTime>("CreationDate");
b.Property<string>("Description")
.IsRequired()
.HasMaxLength(250);
b.Property<bool>("IsValid");
b.Property<string>("Title")
.IsRequired()
.HasMaxLength(50);
b.Property<DateTime>("ValidFrom");
b.Property<DateTime>("ValidUntil");
b.Property<int>("Value");
b.HasKey("Id");
b.HasIndex("ApplicationUserId");
b.ToTable("Vouchers");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property<string>("Id")
.ValueGeneratedOnAdd();
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property<string>("Name")
.HasMaxLength(256);
b.Property<string>("NormalizedName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasName("RoleNameIndex")
.HasFilter("[NormalizedName] IS NOT NULL");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ClaimType");
b.Property<string>("ClaimValue");
b.Property<string>("RoleId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ClaimType");
b.Property<string>("ClaimValue");
b.Property<string>("UserId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.Property<string>("LoginProvider");
b.Property<string>("ProviderKey");
b.Property<string>("ProviderDisplayName");
b.Property<string>("UserId")
.IsRequired();
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.Property<string>("UserId");
b.Property<string>("RoleId");
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.Property<string>("UserId");
b.Property<string>("LoginProvider");
b.Property<string>("Name");
b.Property<string>("Value");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("BachelorProject.Models.AdditionalGame", b =>
{
b.HasOne("BachelorProject.Models.ApplicationUser", "ApplicationUser")
.WithMany()
.HasForeignKey("ApplicationUserId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("BachelorProject.Models.Employee", "Barmaid")
.WithMany("BarmaidAdditionalGames")
.HasForeignKey("BarmaidId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("BachelorProject.Models.GameType", "GameType")
.WithMany("AdditionalGames")
.HasForeignKey("GameTypeId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("BachelorProject.Models.Employee", "Instructor")
.WithMany("InstuctorAdditionalGames")
.HasForeignKey("InstructorId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("BachelorProject.Models.Voucher", b =>
{
b.HasOne("BachelorProject.Models.ApplicationUser", "ApplicationUser")
.WithMany()
.HasForeignKey("ApplicationUserId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
{
b.HasOne("BachelorProject.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
{
b.HasOne("BachelorProject.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("BachelorProject.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
{
b.HasOne("BachelorProject.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Restrict);
});
#pragma warning restore 612, 618
}
public override void ApplyConfiguration(ModelBuilder modelBuilder)
{
base.ApplyConfiguration(modelBuilder);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasAnnotation("ProductVersion", "2.2.4-servicing-10062");
modelBuilder.Entity<Locations>(entity =>
{
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.City)
.IsRequired()
.HasColumnName("city")
.HasMaxLength(50);
entity.Property(e => e.Country)
.IsRequired()
.HasColumnName("country")
.HasMaxLength(50);
entity.Property(e => e.Image)
.HasColumnName("image")
.HasMaxLength(50);
entity.Property(e => e.Latitude).HasColumnName("latitude");
entity.Property(e => e.Longitude).HasColumnName("longitude");
entity.Property(e => e.Tripadvisor)
.HasColumnName("tripadvisor")
.HasMaxLength(50);
});
modelBuilder.Entity<Users>(entity =>
{
entity.HasKey(e => e.Userid)
.HasName("PK_Users_1");
entity.Property(e => e.Userid).HasColumnName("userid");
entity.Property(e => e.Firstname)
.IsRequired()
.HasColumnName("firstname")
.HasMaxLength(50);
entity.Property(e => e.Joindate)
.HasColumnName("joindate")
.HasColumnType("datetime");
entity.Property(e => e.Lastname)
.IsRequired()
.HasColumnName("lastname")
.HasMaxLength(50);
entity.Property(e => e.Password)
.IsRequired()
.HasColumnName("password")
.HasMaxLength(50);
entity.Property(e => e.Username)
.IsRequired()
.HasColumnName("username")
.HasMaxLength(50);
});
modelBuilder.Entity<Vacation>(entity =>
{
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.Isactive).HasColumnName("isactive");
entity.Property(e => e.Location)
.IsRequired()
.HasColumnName("location")
.HasMaxLength(50);
entity.Property(e => e.Startdate)
.HasColumnName("startdate")
.HasColumnType("date");
entity.Property(e => e.User)
.IsRequired()
.HasColumnName("user")
.HasMaxLength(50);
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity <Equipo>().ToTable("Equipo");
modelBuilder.Entity <Jugador>().ToTable("Jugador");
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "3.1.1")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("IRunes.Models.Album", b =>
{
b.Property<string>("Id")
.HasColumnType("nvarchar(450)");
b.Property<string>("Cover")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("nvarchar(20)")
.HasMaxLength(20);
b.Property<decimal>("Price")
.HasColumnType("decimal(18,2)");
b.HasKey("Id");
b.ToTable("Albums");
});
modelBuilder.Entity("IRunes.Models.Track", b =>
{
b.Property<string>("Id")
.HasColumnType("nvarchar(450)");
b.Property<string>("AlbumId")
.HasColumnType("nvarchar(450)");
b.Property<string>("Link")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("nvarchar(20)")
.HasMaxLength(20);
b.Property<decimal>("Price")
.HasColumnType("decimal(18,2)");
b.HasKey("Id");
b.HasIndex("AlbumId");
b.ToTable("Tracks");
});
modelBuilder.Entity("IRunes.Models.User", b =>
{
b.Property<string>("Id")
.HasColumnType("nvarchar(450)");
b.Property<string>("Email")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<string>("Password")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<int>("Role")
.HasColumnType("int");
b.Property<string>("Username")
.IsRequired()
.HasColumnType("nvarchar(20)")
.HasMaxLength(20);
b.HasKey("Id");
b.ToTable("Users");
});
modelBuilder.Entity("IRunes.Models.Track", b =>
{
b.HasOne("IRunes.Models.Album", "Album")
.WithMany("Tracks")
.HasForeignKey("AlbumId");
});
#pragma warning restore 612, 618
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Address>(entity =>
{
entity.HasKey(e => e.AddressId);
entity.Property(e => e.AddressId).HasColumnName("AddressID");
entity.Property(e => e.AddressText)
.IsRequired()
.HasMaxLength(100)
.IsUnicode(false);
entity.Property(e => e.TownId).HasColumnName("TownID");
entity.HasOne(d => d.Town)
.WithMany(p => p.Addresses)
.HasForeignKey(d => d.TownId)
.HasConstraintName("FK_Addresses_Towns");
});
modelBuilder.Entity<Department>(entity =>
{
entity.HasKey(e => e.DepartmentId);
entity.Property(e => e.DepartmentId).HasColumnName("DepartmentID");
entity.Property(e => e.ManagerId).HasColumnName("ManagerID");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.HasOne(d => d.Manager)
.WithMany(p => p.Departments)
.HasForeignKey(d => d.ManagerId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_Departments_Employees");
});
modelBuilder.Entity<Employee>(entity =>
{
entity.HasKey(e => e.EmployeeId);
entity.Property(e => e.EmployeeId).HasColumnName("EmployeeID");
entity.Property(e => e.AddressId).HasColumnName("AddressID");
entity.Property(e => e.DepartmentId).HasColumnName("DepartmentID");
entity.Property(e => e.FirstName)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.HireDate).HasColumnType("smalldatetime");
entity.Property(e => e.JobTitle)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.LastName)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.ManagerId).HasColumnName("ManagerID");
entity.Property(e => e.MiddleName)
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.Salary).HasColumnType("decimal(15, 4)");
entity.HasOne(d => d.Address)
.WithMany(p => p.Employees)
.HasForeignKey(d => d.AddressId)
.HasConstraintName("FK_Employees_Addresses");
entity.HasOne(d => d.Department)
.WithMany(p => p.Employees)
.HasForeignKey(d => d.DepartmentId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_Employees_Departments");
entity.HasOne(d => d.Manager)
.WithMany(p => p.InverseManager)
.HasForeignKey(d => d.ManagerId)
.HasConstraintName("FK_Employees_Employees");
});
modelBuilder.Entity<EmployeeProject>(entity =>
{
entity.HasKey(e => new { e.EmployeeId, e.ProjectId });
entity.Property(e => e.EmployeeId).HasColumnName("EmployeeID");
entity.Property(e => e.ProjectId).HasColumnName("ProjectID");
entity.HasOne(d => d.Employee)
.WithMany(p => p.EmployeesProjects)
.HasForeignKey(d => d.EmployeeId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_EmployeesProjects_Employees");
entity.HasOne(d => d.Project)
.WithMany(p => p.EmployeesProjects)
.HasForeignKey(d => d.ProjectId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_EmployeesProjects_Projects");
});
modelBuilder.Entity<Project>(entity =>
{
entity.HasKey(e => e.ProjectId);
entity.Property(e => e.ProjectId).HasColumnName("ProjectID");
entity.Property(e => e.Description).HasColumnType("ntext");
entity.Property(e => e.EndDate).HasColumnType("smalldatetime");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.StartDate).HasColumnType("smalldatetime");
});
modelBuilder.Entity<Town>(entity =>
{
entity.HasKey(e => e.TownId);
entity.Property(e => e.TownId).HasColumnName("TownID");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
});
OnModelCreatingPartial(modelBuilder);
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.UseIdentityColumns()
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("ProductVersion", "5.0.1");
modelBuilder.Entity("PizzaWorld.Domain.Abstracts.APizzaModel", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <long?>("CrustEntityId")
.HasColumnType("bigint");
b.Property <long?>("OrderEntityId")
.HasColumnType("bigint");
b.Property <long?>("SizeEntityId")
.HasColumnType("bigint");
b.HasKey("EntityId");
b.HasIndex("CrustEntityId");
b.HasIndex("OrderEntityId");
b.HasIndex("SizeEntityId");
b.ToTable("APizzaModel");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Crust", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.HasKey("EntityId");
b.ToTable("Crusts");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Order", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <long?>("StoreEntityId")
.HasColumnType("bigint");
b.Property <long?>("UserEntityId")
.HasColumnType("bigint");
b.HasKey("EntityId");
b.HasIndex("StoreEntityId");
b.HasIndex("UserEntityId");
b.ToTable("Order");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Size", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <int>("Inches")
.HasColumnType("int");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.HasKey("EntityId");
b.ToTable("Sizes");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Store", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.HasKey("EntityId");
b.ToTable("Stores");
b.HasData(
new
{
EntityId = 1L,
Name = "First Store"
},
new
{
EntityId = 2L,
Name = "Second Store"
});
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Topping", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <long?>("APizzaModelEntityId")
.HasColumnType("bigint");
b.Property <string>("Name")
.HasColumnType("nvarchar(max)");
b.HasKey("EntityId");
b.HasIndex("APizzaModelEntityId");
b.ToTable("Toppings");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.User", b =>
{
b.Property <long>("EntityId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.UseIdentityColumn();
b.Property <long?>("SelectedStoreEntityId")
.HasColumnType("bigint");
b.HasKey("EntityId");
b.HasIndex("SelectedStoreEntityId");
b.ToTable("Users");
});
modelBuilder.Entity("PizzaWorld.Domain.Abstracts.APizzaModel", b =>
{
b.HasOne("PizzaWorld.Domain.Models.Crust", "Crust")
.WithMany()
.HasForeignKey("CrustEntityId");
b.HasOne("PizzaWorld.Domain.Models.Order", null)
.WithMany("Pizzas")
.HasForeignKey("OrderEntityId");
b.HasOne("PizzaWorld.Domain.Models.Size", "Size")
.WithMany()
.HasForeignKey("SizeEntityId");
b.Navigation("Crust");
b.Navigation("Size");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Order", b =>
{
b.HasOne("PizzaWorld.Domain.Models.Store", null)
.WithMany("Orders")
.HasForeignKey("StoreEntityId");
b.HasOne("PizzaWorld.Domain.Models.User", null)
.WithMany("Orders")
.HasForeignKey("UserEntityId");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Topping", b =>
{
b.HasOne("PizzaWorld.Domain.Abstracts.APizzaModel", null)
.WithMany("Toppings")
.HasForeignKey("APizzaModelEntityId");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.User", b =>
{
b.HasOne("PizzaWorld.Domain.Models.Store", "SelectedStore")
.WithMany()
.HasForeignKey("SelectedStoreEntityId");
b.Navigation("SelectedStore");
});
modelBuilder.Entity("PizzaWorld.Domain.Abstracts.APizzaModel", b =>
{
b.Navigation("Toppings");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Order", b =>
{
b.Navigation("Pizzas");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.Store", b =>
{
b.Navigation("Orders");
});
modelBuilder.Entity("PizzaWorld.Domain.Models.User", b =>
{
b.Navigation("Orders");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:MaxIdentifierLength", 64)
.HasAnnotation("ProductVersion", "5.0.4");
modelBuilder.Entity("PragyoSala.Services.Models.Category", b =>
{
b.Property <int>("CategoryId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("DeletedAt")
.HasColumnType("datetime(6)");
b.Property <bool>("DisplayHome")
.HasColumnType("tinyint(1)");
b.Property <string>("Link")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("Name")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.HasKey("CategoryId");
b.ToTable("categories");
});
modelBuilder.Entity("PragyoSala.Services.Models.Chapter", b =>
{
b.Property <int>("ChapterId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <string>("ChapterName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <int>("CourseId")
.HasColumnType("int");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("DeletedAt")
.HasColumnType("datetime(6)");
b.Property <int>("Order")
.HasColumnType("int");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.HasKey("ChapterId");
b.HasIndex("CourseId");
b.ToTable("chapters");
});
modelBuilder.Entity("PragyoSala.Services.Models.Comment", b =>
{
b.Property <int>("CommentId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <int>("ChapterId")
.HasColumnType("int");
b.Property <int>("CourseId")
.HasColumnType("int");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("DeletedAt")
.HasColumnType("datetime(6)");
b.Property <string>("Text")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <int>("TopicId")
.HasColumnType("int");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property <int>("UserId")
.HasColumnType("int");
b.HasKey("CommentId");
b.HasIndex("ChapterId");
b.HasIndex("CourseId");
b.HasIndex("TopicId");
b.HasIndex("UserId");
b.ToTable("comments");
});
modelBuilder.Entity("PragyoSala.Services.Models.Course", b =>
{
b.Property <int>("CourseId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <int?>("CategoryId")
.HasColumnType("int");
b.Property <string>("CourseTitle")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <string>("Image")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property <int>("UserId")
.HasColumnType("int");
b.HasKey("CourseId");
b.HasIndex("CategoryId");
b.HasIndex("UserId");
b.ToTable("courses");
});
modelBuilder.Entity("PragyoSala.Services.Models.CourseRate", b =>
{
b.Property <int>("CourseRateId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <int>("CourseId")
.HasColumnType("int");
b.Property <DateTime>("CratedAt")
.HasColumnType("datetime(6)");
b.Property <double>("Rate")
.HasColumnType("double");
b.Property <bool>("Status")
.HasColumnType("tinyint(1)");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.HasKey("CourseRateId");
b.HasIndex("CourseId");
b.ToTable("course_rate");
});
modelBuilder.Entity("PragyoSala.Services.Models.CourseStudent", b =>
{
b.Property <int>("CourseStudentId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <int>("CourseId")
.HasColumnType("int");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("DeletedAt")
.HasColumnType("datetime(6)");
b.Property <string>("Status")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property <int>("UserId")
.HasColumnType("int");
b.HasKey("CourseStudentId");
b.HasIndex("CourseId");
b.HasIndex("UserId");
b.ToTable("course_students");
});
modelBuilder.Entity("PragyoSala.Services.Models.Topic", b =>
{
b.Property <int>("TopicId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <int>("ChapterId")
.HasColumnType("int");
b.Property <int>("CourseId")
.HasColumnType("int");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("DeletedAt")
.HasColumnType("datetime(6)");
b.Property <bool>("IsWatched")
.HasColumnType("tinyint(1)");
b.Property <double>("Length")
.HasColumnType("double");
b.Property <int>("Order")
.HasColumnType("int");
b.Property <string>("TopicName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property <int?>("VideoId")
.HasColumnType("int");
b.HasKey("TopicId");
b.HasIndex("ChapterId");
b.HasIndex("CourseId");
b.HasIndex("VideoId");
b.ToTable("topics");
});
modelBuilder.Entity("PragyoSala.Services.Models.User", b =>
{
b.Property <int>("UserId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <string>("Address")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("Email")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("FirstName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("LastName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("Password")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("PhoneNo")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property <string>("Role")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("UserId");
b.ToTable("Users");
});
modelBuilder.Entity("PragyoSala.Services.Models.Video", b =>
{
b.Property <int>("VideoId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property <DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("DeletedAt")
.HasColumnType("datetime(6)");
b.Property <DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property <string>("VideoName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("VideoId");
b.ToTable("videos");
});
modelBuilder.Entity("PragyoSala.Services.Models.Chapter", b =>
{
b.HasOne("PragyoSala.Services.Models.Course", "Course")
.WithMany("Chapters")
.HasForeignKey("CourseId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Course");
});
modelBuilder.Entity("PragyoSala.Services.Models.Comment", b =>
{
b.HasOne("PragyoSala.Services.Models.Chapter", "Chapter")
.WithMany()
.HasForeignKey("ChapterId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("PragyoSala.Services.Models.Course", "Course")
.WithMany()
.HasForeignKey("CourseId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("PragyoSala.Services.Models.Topic", "Topic")
.WithMany()
.HasForeignKey("TopicId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("PragyoSala.Services.Models.User", "User")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Chapter");
b.Navigation("Course");
b.Navigation("Topic");
b.Navigation("User");
});
modelBuilder.Entity("PragyoSala.Services.Models.Course", b =>
{
b.HasOne("PragyoSala.Services.Models.Category", "Category")
.WithMany("Courses")
.HasForeignKey("CategoryId");
b.HasOne("PragyoSala.Services.Models.User", "User")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Category");
b.Navigation("User");
});
modelBuilder.Entity("PragyoSala.Services.Models.CourseRate", b =>
{
b.HasOne("PragyoSala.Services.Models.Course", "Course")
.WithMany("Rates")
.HasForeignKey("CourseId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Course");
});
modelBuilder.Entity("PragyoSala.Services.Models.CourseStudent", b =>
{
b.HasOne("PragyoSala.Services.Models.Course", "Course")
.WithMany("CourseStudents")
.HasForeignKey("CourseId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("PragyoSala.Services.Models.User", "User")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Course");
b.Navigation("User");
});
modelBuilder.Entity("PragyoSala.Services.Models.Topic", b =>
{
b.HasOne("PragyoSala.Services.Models.Chapter", "Chapter")
.WithMany("Topics")
.HasForeignKey("ChapterId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("PragyoSala.Services.Models.Course", "Course")
.WithMany()
.HasForeignKey("CourseId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("PragyoSala.Services.Models.Video", "Video")
.WithMany()
.HasForeignKey("VideoId");
b.Navigation("Chapter");
b.Navigation("Course");
b.Navigation("Video");
});
modelBuilder.Entity("PragyoSala.Services.Models.Category", b =>
{
b.Navigation("Courses");
});
modelBuilder.Entity("PragyoSala.Services.Models.Chapter", b =>
{
b.Navigation("Topics");
});
modelBuilder.Entity("PragyoSala.Services.Models.Course", b =>
{
b.Navigation("Chapters");
b.Navigation("CourseStudents");
b.Navigation("Rates");
});
#pragma warning restore 612, 618
}
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.4-servicing-10062")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("CrowDo.LinkingTable", b =>
{
b.Property<int>("UserId");
b.Property<int>("RewardPackageId");
b.Property<int>("ProjectId");
b.HasKey("UserId", "RewardPackageId", "ProjectId");
b.HasIndex("ProjectId");
b.HasIndex("RewardPackageId");
b.ToTable("LinkingTable");
});
modelBuilder.Entity("CrowDo.Project", b =>
{
b.Property<int>("ProjectId")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("CreationDate");
b.Property<string>("Description");
b.Property<DateTime>("EstimatedDurationInMonths");
b.Property<DateTime>("ExpirationDate");
b.Property<decimal>("Funds");
b.Property<bool>("IsAvailable");
b.Property<bool>("IsSuccessful");
b.Property<string>("ProjectCategory");
b.Property<decimal>("ProjectGoal");
b.Property<string>("ProjectName");
b.Property<string>("StatusUpdate");
b.Property<int?>("UserId");
b.Property<int>("Visits");
b.HasKey("ProjectId");
b.HasIndex("UserId");
b.ToTable("Project");
});
modelBuilder.Entity("CrowDo.ProjectMedia", b =>
{
b.Property<int>("ProjectMediaId")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("FileName");
b.Property<int>("ProjectId");
b.HasKey("ProjectMediaId");
b.HasIndex("ProjectId");
b.ToTable("ProjectMedia");
});
modelBuilder.Entity("CrowDo.RewardPackage", b =>
{
b.Property<int>("RewardPackageId")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("PackageName");
b.Property<decimal>("Price");
b.Property<int?>("ProjectId");
b.Property<string>("RewardName");
b.HasKey("RewardPackageId");
b.HasIndex("ProjectId");
b.ToTable("RewardPackage");
});
modelBuilder.Entity("CrowDo.User", b =>
{
b.Property<int>("UserId")
.ValueGeneratedOnAdd()
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Address");
b.Property<DateTime>("BirthDate");
b.Property<int>("CreatedProjectsCount");
b.Property<string>("Email");
b.Property<string>("Name");
b.Property<DateTime>("RegistrationDate");
b.HasKey("UserId");
b.ToTable("User");
});
modelBuilder.Entity("CrowDo.LinkingTable", b =>
{
b.HasOne("CrowDo.Project", "Project")
.WithMany("LinkingTables")
.HasForeignKey("ProjectId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("CrowDo.RewardPackage", "RewardPackage")
.WithMany()
.HasForeignKey("RewardPackageId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("CrowDo.User", "User")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("CrowDo.Project", b =>
{
b.HasOne("CrowDo.User")
.WithMany("CreatedProjects")
.HasForeignKey("UserId");
});
modelBuilder.Entity("CrowDo.ProjectMedia", b =>
{
b.HasOne("CrowDo.Project")
.WithMany("MultimediaFiles")
.HasForeignKey("ProjectId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("CrowDo.RewardPackage", b =>
{
b.HasOne("CrowDo.Project")
.WithMany("RewardPackages")
.HasForeignKey("ProjectId");
});
#pragma warning restore 612, 618
}
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.UseIdentityColumns()
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("ProductVersion", "5.0.0");
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Bill", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property<DateTime>("CreationTime")
.HasColumnType("datetime2");
b.Property<Guid>("GroupContextId")
.HasColumnType("uniqueidentifier");
b.Property<Guid>("LoanerId")
.HasColumnType("uniqueidentifier");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<decimal>("Total")
.HasColumnType("decimal(18,2)");
b.HasKey("Id");
b.HasIndex("GroupContextId");
b.HasIndex("LoanerId");
b.ToTable("Bills");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Group", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Groups");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Loan", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property<decimal>("Amount")
.HasColumnType("decimal(18,2)");
b.Property<Guid>("BillId")
.HasColumnType("uniqueidentifier");
b.Property<Guid>("LoaneeId")
.HasColumnType("uniqueidentifier");
b.HasKey("Id");
b.HasIndex("BillId");
b.HasIndex("LoaneeId");
b.ToTable("Loans");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Payment", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property<decimal>("Amount")
.HasColumnType("decimal(18,2)");
b.Property<DateTime>("CreationTime")
.HasColumnType("datetime2");
b.Property<Guid>("GroupContextId")
.HasColumnType("uniqueidentifier");
b.Property<Guid>("PayerId")
.HasColumnType("uniqueidentifier");
b.Property<Guid>("ReceiverId")
.HasColumnType("uniqueidentifier");
b.HasKey("Id");
b.HasIndex("GroupContextId");
b.HasIndex("PayerId");
b.HasIndex("ReceiverId");
b.ToTable("Payments");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.User", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property<string>("Email")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property<string>("Password")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("Users");
});
modelBuilder.Entity("GroupUser", b =>
{
b.Property<Guid>("GroupsId")
.HasColumnType("uniqueidentifier");
b.Property<Guid>("UsersId")
.HasColumnType("uniqueidentifier");
b.HasKey("GroupsId", "UsersId");
b.HasIndex("UsersId");
b.ToTable("GroupUser");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Bill", b =>
{
b.HasOne("BillChopBE.DataAccessLayer.Models.Group", "GroupContext")
.WithMany("Bills")
.HasForeignKey("GroupContextId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("BillChopBE.DataAccessLayer.Models.User", "Loaner")
.WithMany("Bills")
.HasForeignKey("LoanerId")
.OnDelete(DeleteBehavior.NoAction)
.IsRequired();
b.Navigation("GroupContext");
b.Navigation("Loaner");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Loan", b =>
{
b.HasOne("BillChopBE.DataAccessLayer.Models.Bill", "Bill")
.WithMany("Loans")
.HasForeignKey("BillId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("BillChopBE.DataAccessLayer.Models.User", "Loanee")
.WithMany("Loans")
.HasForeignKey("LoaneeId")
.OnDelete(DeleteBehavior.NoAction)
.IsRequired();
b.Navigation("Bill");
b.Navigation("Loanee");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Payment", b =>
{
b.HasOne("BillChopBE.DataAccessLayer.Models.Group", "GroupContext")
.WithMany()
.HasForeignKey("GroupContextId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("BillChopBE.DataAccessLayer.Models.User", "Payer")
.WithMany("PaymentsMade")
.HasForeignKey("PayerId")
.OnDelete(DeleteBehavior.NoAction)
.IsRequired();
b.HasOne("BillChopBE.DataAccessLayer.Models.User", "Receiver")
.WithMany("PaymentsReceived")
.HasForeignKey("ReceiverId")
.OnDelete(DeleteBehavior.NoAction)
.IsRequired();
b.Navigation("GroupContext");
b.Navigation("Payer");
b.Navigation("Receiver");
});
modelBuilder.Entity("GroupUser", b =>
{
b.HasOne("BillChopBE.DataAccessLayer.Models.Group", null)
.WithMany()
.HasForeignKey("GroupsId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("BillChopBE.DataAccessLayer.Models.User", null)
.WithMany()
.HasForeignKey("UsersId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Bill", b =>
{
b.Navigation("Loans");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.Group", b =>
{
b.Navigation("Bills");
});
modelBuilder.Entity("BillChopBE.DataAccessLayer.Models.User", b =>
{
b.Navigation("Bills");
b.Navigation("Loans");
b.Navigation("PaymentsMade");
b.Navigation("PaymentsReceived");
});
#pragma warning restore 612, 618
}
