// using System; using BusinessERP.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace BusinessERP.Migrations { [DbContext(typeof(ApplicationDbContext))] [Migration("20221101191211_InitialCreate")] partial class InitialCreate { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "6.0.8") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1); modelBuilder.Entity("BusinessERP.Models.ApplicationUser", b => { b.Property("Id") .HasColumnType("nvarchar(450)"); b.Property("AccessFailedCount") .HasColumnType("int"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasColumnType("nvarchar(max)"); b.Property("Email") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("EmailConfirmed") .HasColumnType("bit"); b.Property("LockoutEnabled") .HasColumnType("bit"); b.Property("LockoutEnd") .HasColumnType("datetimeoffset"); b.Property("NormalizedEmail") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("NormalizedUserName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("PasswordHash") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumber") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumberConfirmed") .HasColumnType("bit"); b.Property("SecurityStamp") .HasColumnType("nvarchar(max)"); b.Property("TwoFactorEnabled") .HasColumnType("bit"); b.Property("UserName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.HasKey("Id"); b.HasIndex("NormalizedEmail") .HasDatabaseName("EmailIndex"); b.HasIndex("NormalizedUserName") .IsUnique() .HasDatabaseName("UserNameIndex") .HasFilter("[NormalizedUserName] IS NOT NULL"); b.ToTable("AspNetUsers", (string)null); }); modelBuilder.Entity("BusinessERP.Models.Attendance", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CheckIn") .HasColumnType("datetime2"); b.Property("CheckOut") .HasColumnType("datetime2"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("EmployeeId") .HasColumnType("bigint"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("StayTime") .HasColumnType("time"); b.HasKey("Id"); b.ToTable("Attendance"); }); modelBuilder.Entity("BusinessERP.Models.AuditLogs", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("AffectedColumns") .HasColumnType("nvarchar(max)"); b.Property("DateTime") .HasColumnType("datetime2"); b.Property("NewValues") .HasColumnType("nvarchar(max)"); b.Property("OldValues") .HasColumnType("nvarchar(max)"); b.Property("PrimaryKey") .HasColumnType("nvarchar(max)"); b.Property("TableName") .HasColumnType("nvarchar(max)"); b.Property("Type") .HasColumnType("nvarchar(max)"); b.Property("UserId") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("AuditLogs"); }); modelBuilder.Entity("BusinessERP.Models.Branch", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Address") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("ContactPerson") .HasColumnType("nvarchar(max)"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumber") .HasColumnType("nvarchar(max)"); b.Property("ShortDescription") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Branch"); }); modelBuilder.Entity("BusinessERP.Models.Categories", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Categories"); }); modelBuilder.Entity("BusinessERP.Models.CommonViewModel.ItemDropdownListViewModel", b => { b.Property("Id") .HasColumnType("bigint"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.ToTable("ItemDropdownListViewModel"); }); modelBuilder.Entity("BusinessERP.Models.CompanyInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Address") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CardPercentage") .HasColumnType("nvarchar(max)"); b.Property("City") .HasColumnType("nvarchar(max)"); b.Property("CompanyNumber") .HasColumnType("nvarchar(max)"); b.Property("Country") .HasColumnType("nvarchar(max)"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Email") .HasColumnType("nvarchar(max)"); b.Property("Fax") .HasColumnType("nvarchar(max)"); b.Property("HostName") .HasColumnType("nvarchar(max)"); b.Property("InvoiceNoPrefix") .HasColumnType("nvarchar(max)"); b.Property("IsVat") .HasColumnType("bit"); b.Property("Logo") .HasColumnType("nvarchar(max)"); b.Property("Mobile") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("Office") .HasColumnType("nvarchar(max)"); b.Property("Password") .HasColumnType("nvarchar(max)"); b.Property("Phone") .HasColumnType("nvarchar(max)"); b.Property("PostCode") .HasColumnType("nvarchar(max)"); b.Property("QuoteNoPrefix") .HasColumnType("nvarchar(max)"); b.Property("ShopNo") .HasColumnType("nvarchar(max)"); b.Property("StreetName") .HasColumnType("nvarchar(max)"); b.Property("TermsAndCondition") .HasColumnType("nvarchar(max)"); b.Property("TermsAndConditionItemSale") .HasColumnType("nvarchar(max)"); b.Property("VatNumber") .HasColumnType("nvarchar(max)"); b.Property("Website") .HasColumnType("nvarchar(max)"); b.Property("WhitelistIP") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("CompanyInfo"); }); modelBuilder.Entity("BusinessERP.Models.Currency", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("Code") .HasColumnType("nvarchar(max)"); b.Property("Country") .HasColumnType("nvarchar(max)"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("IsDefault") .HasColumnType("bit"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("Symbol") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Currency"); }); modelBuilder.Entity("BusinessERP.Models.CustomerInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("AccountNo") .HasColumnType("nvarchar(max)"); b.Property("Address") .HasColumnType("nvarchar(max)"); b.Property("AddressPostcode") .HasColumnType("nvarchar(max)"); b.Property("BillingAddress") .HasColumnType("nvarchar(max)"); b.Property("BillingAddressPostcode") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CompanyName") .HasColumnType("nvarchar(max)"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Email") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("Notes") .HasColumnType("nvarchar(max)"); b.Property("Phone") .HasColumnType("nvarchar(max)"); b.Property("Type") .HasColumnType("bigint"); b.HasKey("Id"); b.ToTable("CustomerInfo"); }); modelBuilder.Entity("BusinessERP.Models.CustomerType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("CustomerType"); }); modelBuilder.Entity("BusinessERP.Models.DamageItemDeatils", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ItemId") .HasColumnType("bigint"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("ReasonOfDamage") .HasColumnType("nvarchar(max)"); b.Property("TotalDamageItem") .HasColumnType("int"); b.HasKey("Id"); b.ToTable("DamageItemDeatils"); }); modelBuilder.Entity("BusinessERP.Models.DefaultIdentityOptions", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("AccessDeniedPath") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CookieExpiration") .HasColumnType("float"); b.Property("CookieExpireTimeSpan") .HasColumnType("float"); b.Property("CookieHttpOnly") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("LockoutAllowedForNewUsers") .HasColumnType("bit"); b.Property("LockoutDefaultLockoutTimeSpanInMinutes") .HasColumnType("float"); b.Property("LockoutMaxFailedAccessAttempts") .HasColumnType("int"); b.Property("LoginPath") .HasColumnType("nvarchar(max)"); b.Property("LogoutPath") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PasswordRequireDigit") .HasColumnType("bit"); b.Property("PasswordRequireLowercase") .HasColumnType("bit"); b.Property("PasswordRequireNonAlphanumeric") .HasColumnType("bit"); b.Property("PasswordRequireUppercase") .HasColumnType("bit"); b.Property("PasswordRequiredLength") .HasColumnType("int"); b.Property("PasswordRequiredUniqueChars") .HasColumnType("int"); b.Property("SignInRequireConfirmedEmail") .HasColumnType("bit"); b.Property("SlidingExpiration") .HasColumnType("bit"); b.Property("UserRequireUniqueEmail") .HasColumnType("bit"); b.HasKey("Id"); b.ToTable("DefaultIdentityOptions"); }); modelBuilder.Entity("BusinessERP.Models.Department", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Department"); }); modelBuilder.Entity("BusinessERP.Models.Designation", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Designation"); }); modelBuilder.Entity("BusinessERP.Models.EmailConfig", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Email") .HasColumnType("nvarchar(max)"); b.Property("Hostname") .HasColumnType("nvarchar(max)"); b.Property("IsDefault") .HasColumnType("bit"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Password") .HasColumnType("nvarchar(max)"); b.Property("Port") .HasColumnType("int"); b.Property("SSLEnabled") .HasColumnType("bit"); b.Property("SenderFullName") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("EmailConfig"); }); modelBuilder.Entity("BusinessERP.Models.Employee", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Address") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("DateOfBirth") .HasColumnType("datetime2"); b.Property("Department") .HasColumnType("int"); b.Property("Designation") .HasColumnType("int"); b.Property("Email") .HasColumnType("nvarchar(max)"); b.Property("EmployeeId") .HasColumnType("nvarchar(max)"); b.Property("FirstName") .HasColumnType("nvarchar(max)"); b.Property("JoiningDate") .HasColumnType("datetime2"); b.Property("LastName") .HasColumnType("nvarchar(max)"); b.Property("LeavingDate") .HasColumnType("datetime2"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Phone") .HasColumnType("nvarchar(max)"); b.Property("SubDepartment") .HasColumnType("int"); b.HasKey("Id"); b.ToTable("Employee"); }); modelBuilder.Entity("BusinessERP.Models.ExpenseDetails", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ExpenseSummaryId") .HasColumnType("bigint"); b.Property("ExpenseType") .HasColumnType("nvarchar(max)"); b.Property("ExpenseTypeId") .HasColumnType("bigint"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Quantity") .HasColumnType("int"); b.Property("TotalPrice") .HasColumnType("float"); b.Property("UnitPrice") .HasColumnType("float"); b.HasKey("Id"); b.ToTable("ExpenseDetails"); }); modelBuilder.Entity("BusinessERP.Models.ExpenseSummary", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Action") .HasColumnType("int"); b.Property("BranchId") .HasColumnType("bigint"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("ChangeAmount") .HasColumnType("float"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("CurrencyCode") .HasColumnType("bigint"); b.Property("DueAmount") .HasColumnType("float"); b.Property("GrandTotal") .HasColumnType("float"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PaidAmount") .HasColumnType("float"); b.Property("Title") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("ExpenseSummary"); }); modelBuilder.Entity("BusinessERP.Models.ExpenseType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("ExpenseType"); }); modelBuilder.Entity("BusinessERP.Models.Items", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Barcode") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CategoriesId") .HasColumnType("bigint"); b.Property("Code") .HasColumnType("nvarchar(max)"); b.Property("CostPrice") .HasColumnType("float"); b.Property("CostVAT") .HasColumnType("float"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ExpirationDate") .HasColumnType("datetime2"); b.Property("ImageURL") .HasColumnType("nvarchar(max)"); b.Property("ManufactureDate") .HasColumnType("datetime2"); b.Property("MeasureId") .HasColumnType("bigint"); b.Property("MeasureValue") .HasColumnType("float"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("NormalPrice") .HasColumnType("float"); b.Property("NormalVAT") .HasColumnType("float"); b.Property("Note") .HasColumnType("nvarchar(max)"); b.Property("OldSellPrice") .HasColumnType("float"); b.Property("OldUnitPrice") .HasColumnType("float"); b.Property("OtherPrice") .HasColumnType("float"); b.Property("OtherVAT") .HasColumnType("float"); b.Property("PremiumPrice") .HasColumnType("float"); b.Property("PremiumVAT") .HasColumnType("float"); b.Property("ProductLevel") .HasColumnType("nvarchar(max)"); b.Property("Quantity") .HasColumnType("int"); b.Property("StockKeepingUnit") .HasColumnType("nvarchar(max)"); b.Property("SupplierId") .HasColumnType("bigint"); b.Property("TradePrice") .HasColumnType("float"); b.Property("TradeVAT") .HasColumnType("float"); b.Property("UpdateQntNote") .HasColumnType("nvarchar(max)"); b.Property("UpdateQntType") .HasColumnType("nvarchar(max)"); b.Property("VatPercentage") .HasColumnType("float"); b.Property("WarehouseId") .HasColumnType("bigint"); b.HasKey("Id"); b.ToTable("Items"); }); modelBuilder.Entity("BusinessERP.Models.ItemSerialNumber", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Note") .HasColumnType("nvarchar(max)"); b.Property("PaymentDetailId") .HasColumnType("bigint"); b.Property("SerialNumber") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("ItemSerialNumber"); }); modelBuilder.Entity("BusinessERP.Models.ItemsHistory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Action") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CostPrice") .HasColumnType("float"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ItemId") .HasColumnType("bigint"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("NewQuantity") .HasColumnType("int"); b.Property("NormalPrice") .HasColumnType("float"); b.Property("OldQuantity") .HasColumnType("int"); b.Property("OldSellPrice") .HasColumnType("float"); b.Property("OldUnitPrice") .HasColumnType("float"); b.Property("TranQuantity") .HasColumnType("int"); b.HasKey("Id"); b.ToTable("ItemsHistory"); }); modelBuilder.Entity("BusinessERP.Models.ItemsViewModel.ItemGridViewModel", b => { b.Property("Code") .HasColumnType("nvarchar(max)"); b.Property("CostPrice") .HasColumnType("float"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Id") .HasColumnType("bigint"); b.Property("ImageURL") .HasColumnType("nvarchar(max)"); b.Property("MeasureName") .HasColumnType("nvarchar(max)"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("NormalPrice") .HasColumnType("float"); b.Property("Quantity") .HasColumnType("int"); b.Property("StockKeepingUnit") .HasColumnType("nvarchar(max)"); b.Property("SupplierName") .HasColumnType("nvarchar(max)"); b.Property("TotalEarned") .HasColumnType("float"); b.Property("TotalSold") .HasColumnType("int"); b.ToTable("ItemGridViewModel"); }); modelBuilder.Entity("BusinessERP.Models.LoginHistory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Action") .HasColumnType("nvarchar(max)"); b.Property("ActionStatus") .HasColumnType("nvarchar(max)"); b.Property("Browser") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Device") .HasColumnType("nvarchar(max)"); b.Property("Duration") .HasColumnType("float"); b.Property("Latitude") .HasColumnType("nvarchar(max)"); b.Property("LoginTime") .HasColumnType("datetime2"); b.Property("LogoutTime") .HasColumnType("datetime2"); b.Property("Longitude") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("OperatingSystem") .HasColumnType("nvarchar(max)"); b.Property("PublicIP") .HasColumnType("nvarchar(max)"); b.Property("UserName") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("LoginHistory"); }); modelBuilder.Entity("BusinessERP.Models.Payment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("BranchId") .HasColumnType("bigint"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("Category") .HasColumnType("int"); b.Property("ChangedAmount") .HasColumnType("float"); b.Property("CommonCharge") .HasColumnType("float"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("CurrencyId") .HasColumnType("bigint"); b.Property("CustomerId") .HasColumnType("bigint"); b.Property("CustomerNote") .HasColumnType("nvarchar(max)"); b.Property("Discount") .HasColumnType("float"); b.Property("DiscountAmount") .HasColumnType("float"); b.Property("DueAmount") .HasColumnType("float"); b.Property("GrandTotal") .HasColumnType("float"); b.Property("InvoiceNo") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PaidAmount") .HasColumnType("float"); b.Property("PaymentStatus") .HasColumnType("bigint"); b.Property("PrivateNote") .HasColumnType("nvarchar(max)"); b.Property("PurchaseOrderNumber") .HasColumnType("nvarchar(max)"); b.Property("QuoteNo") .HasColumnType("nvarchar(max)"); b.Property("ReturnType") .HasColumnType("int"); b.Property("SubTotal") .HasColumnType("float"); b.Property("VAT") .HasColumnType("float"); b.Property("VATAmount") .HasColumnType("float"); b.HasKey("Id"); b.ToTable("Payment"); }); modelBuilder.Entity("BusinessERP.Models.PaymentDetail", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("IsReturn") .HasColumnType("bit"); b.Property("ItemDiscount") .HasColumnType("float"); b.Property("ItemDiscountAmount") .HasColumnType("float"); b.Property("ItemId") .HasColumnType("bigint"); b.Property("ItemName") .HasColumnType("nvarchar(max)"); b.Property("ItemVAT") .HasColumnType("float"); b.Property("ItemVATAmount") .HasColumnType("float"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PaymentId") .HasColumnType("bigint"); b.Property("Quantity") .HasColumnType("int"); b.Property("TotalAmount") .HasColumnType("float"); b.Property("UnitPrice") .HasColumnType("float"); b.HasKey("Id"); b.ToTable("PaymentDetail"); }); modelBuilder.Entity("BusinessERP.Models.PaymentModeHistory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Amount") .HasColumnType("float"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ModeOfPayment") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PaymentId") .HasColumnType("bigint"); b.Property("PaymentType") .HasColumnType("int"); b.Property("ReferenceNo") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("PaymentModeHistory"); }); modelBuilder.Entity("BusinessERP.Models.PaymentStatus", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("PaymentStatus"); }); modelBuilder.Entity("BusinessERP.Models.PaymentType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("PaymentType"); }); modelBuilder.Entity("BusinessERP.Models.PurchasesPayment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("BranchId") .HasColumnType("bigint"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("Category") .HasColumnType("int"); b.Property("ChangedAmount") .HasColumnType("float"); b.Property("CommonCharge") .HasColumnType("float"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("CurrencyId") .HasColumnType("bigint"); b.Property("CustomerNote") .HasColumnType("nvarchar(max)"); b.Property("Discount") .HasColumnType("float"); b.Property("DiscountAmount") .HasColumnType("float"); b.Property("DueAmount") .HasColumnType("float"); b.Property("GrandTotal") .HasColumnType("float"); b.Property("InvoiceNo") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PaidAmount") .HasColumnType("float"); b.Property("PaymentStatus") .HasColumnType("bigint"); b.Property("PrivateNote") .HasColumnType("nvarchar(max)"); b.Property("PurchaseOrderNumber") .HasColumnType("nvarchar(max)"); b.Property("QuoteNo") .HasColumnType("nvarchar(max)"); b.Property("ReturnType") .HasColumnType("int"); b.Property("SubTotal") .HasColumnType("float"); b.Property("SupplierId") .HasColumnType("bigint"); b.Property("VAT") .HasColumnType("float"); b.Property("VATAmount") .HasColumnType("float"); b.HasKey("Id"); b.ToTable("PurchasesPayment"); }); modelBuilder.Entity("BusinessERP.Models.PurchasesPaymentDetail", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("IsReturn") .HasColumnType("bit"); b.Property("ItemDiscount") .HasColumnType("float"); b.Property("ItemDiscountAmount") .HasColumnType("float"); b.Property("ItemId") .HasColumnType("bigint"); b.Property("ItemName") .HasColumnType("nvarchar(max)"); b.Property("ItemVAT") .HasColumnType("float"); b.Property("ItemVATAmount") .HasColumnType("float"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("PaymentId") .HasColumnType("bigint"); b.Property("Quantity") .HasColumnType("int"); b.Property("TotalAmount") .HasColumnType("float"); b.Property("UnitPrice") .HasColumnType("float"); b.HasKey("Id"); b.ToTable("PurchasesPaymentDetail"); }); modelBuilder.Entity("BusinessERP.Models.RefreshToken", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("AddedDate") .HasColumnType("datetime2"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("ExpiryDate") .HasColumnType("datetime2"); b.Property("IsRevorked") .HasColumnType("bit"); b.Property("IsUsed") .HasColumnType("bit"); b.Property("JwtId") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Token") .HasColumnType("nvarchar(max)"); b.Property("UserId") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("RefreshToken"); }); modelBuilder.Entity("BusinessERP.Models.ReturnLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("CustomerId") .HasColumnType("bigint"); b.Property("InvoiceNo") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Note") .HasColumnType("nvarchar(max)"); b.Property("RefId") .HasColumnType("bigint"); b.Property("TranType") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("ReturnLog"); }); modelBuilder.Entity("BusinessERP.Models.SendEmailHistory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("InvoiceId") .HasColumnType("bigint"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("ReceiverEmail") .HasColumnType("nvarchar(max)"); b.Property("Result") .HasColumnType("nvarchar(max)"); b.Property("SenderEmail") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SendEmailHistory"); }); modelBuilder.Entity("BusinessERP.Models.SendGridSetting", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("FromEmail") .HasColumnType("nvarchar(max)"); b.Property("FromFullName") .HasColumnType("nvarchar(max)"); b.Property("IsDefault") .HasColumnType("bit"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("SendGridKey") .HasColumnType("nvarchar(max)"); b.Property("SendGridUser") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SendGridSetting"); }); modelBuilder.Entity("BusinessERP.Models.SMTPEmailSetting", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("FromEmail") .HasColumnType("nvarchar(max)"); b.Property("FromFullName") .HasColumnType("nvarchar(max)"); b.Property("Host") .HasColumnType("nvarchar(max)"); b.Property("IsDefault") .HasColumnType("bit"); b.Property("IsSSL") .HasColumnType("bit"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Password") .HasColumnType("nvarchar(max)"); b.Property("Port") .HasColumnType("int"); b.Property("UserName") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SMTPEmailSetting"); }); modelBuilder.Entity("BusinessERP.Models.SubDepartment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("DepartmentId") .HasColumnType("bigint"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SubDepartment"); }); modelBuilder.Entity("BusinessERP.Models.Supplier", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Address") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("ContactPerson") .HasColumnType("nvarchar(max)"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Email") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("Phone") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Supplier"); }); modelBuilder.Entity("BusinessERP.Models.UnitsofMeasure", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UnitsofMeasure"); }); modelBuilder.Entity("BusinessERP.Models.UserInfoFromBrowser", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("BrowserMajor") .HasColumnType("nvarchar(max)"); b.Property("BrowserName") .HasColumnType("nvarchar(max)"); b.Property("BrowserUniqueID") .HasColumnType("nvarchar(max)"); b.Property("BrowserVersion") .HasColumnType("nvarchar(max)"); b.Property("CPUArchitecture") .HasColumnType("nvarchar(max)"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("DeviceModel") .HasColumnType("nvarchar(max)"); b.Property("DeviceType") .HasColumnType("nvarchar(max)"); b.Property("DeviceVendor") .HasColumnType("nvarchar(max)"); b.Property("EngineName") .HasColumnType("nvarchar(max)"); b.Property("EngineVersion") .HasColumnType("nvarchar(max)"); b.Property("Lat") .HasColumnType("nvarchar(max)"); b.Property("Long") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("OSName") .HasColumnType("nvarchar(max)"); b.Property("OSVersion") .HasColumnType("nvarchar(max)"); b.Property("TimeZone") .HasColumnType("nvarchar(max)"); b.Property("UA") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UserInfoFromBrowser"); }); modelBuilder.Entity("BusinessERP.Models.UserProfile", b => { b.Property("UserProfileId") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UserProfileId"), 1L, 1); b.Property("Address") .HasColumnType("nvarchar(max)"); b.Property("ApplicationUserId") .HasColumnType("nvarchar(max)"); b.Property("BranchId") .HasColumnType("bigint"); b.Property("Cancelled") .HasColumnType("bit"); b.Property("ConfirmPassword") .HasColumnType("nvarchar(max)"); b.Property("Country") .HasColumnType("nvarchar(max)"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Email") .HasColumnType("nvarchar(max)"); b.Property("FirstName") .HasColumnType("nvarchar(max)"); b.Property("LastName") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("OldPassword") .HasColumnType("nvarchar(max)"); b.Property("PasswordHash") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumber") .HasColumnType("nvarchar(max)"); b.Property("ProfilePicture") .HasColumnType("nvarchar(max)"); b.HasKey("UserProfileId"); b.ToTable("UserProfile"); }); modelBuilder.Entity("BusinessERP.Models.VatPercentage", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("IsDefault") .HasColumnType("bit"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("Percentage") .HasColumnType("float"); b.HasKey("Id"); b.ToTable("VatPercentage"); }); modelBuilder.Entity("BusinessERP.Models.Warehouse", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Cancelled") .HasColumnType("bit"); b.Property("CreatedBy") .HasColumnType("nvarchar(max)"); b.Property("CreatedDate") .HasColumnType("datetime2"); b.Property("Description") .HasColumnType("nvarchar(max)"); b.Property("ModifiedBy") .HasColumnType("nvarchar(max)"); b.Property("ModifiedDate") .HasColumnType("datetime2"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Warehouse"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b => { b.Property("Id") .HasColumnType("nvarchar(450)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasColumnType("nvarchar(max)"); b.Property("Name") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("NormalizedName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.HasKey("Id"); b.HasIndex("NormalizedName") .IsUnique() .HasDatabaseName("RoleNameIndex") .HasFilter("[NormalizedName] IS NOT NULL"); b.ToTable("AspNetRoles", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("ClaimType") .HasColumnType("nvarchar(max)"); b.Property("ClaimValue") .HasColumnType("nvarchar(max)"); b.Property("RoleId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("RoleId"); b.ToTable("AspNetRoleClaims", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("ClaimType") .HasColumnType("nvarchar(max)"); b.Property("ClaimValue") .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("UserId"); b.ToTable("AspNetUserClaims", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.Property("LoginProvider") .HasColumnType("nvarchar(450)"); b.Property("ProviderKey") .HasColumnType("nvarchar(450)"); b.Property("ProviderDisplayName") .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("LoginProvider", "ProviderKey"); b.HasIndex("UserId"); b.ToTable("AspNetUserLogins", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.Property("UserId") .HasColumnType("nvarchar(450)"); b.Property("RoleId") .HasColumnType("nvarchar(450)"); b.HasKey("UserId", "RoleId"); b.HasIndex("RoleId"); b.ToTable("AspNetUserRoles", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b => { b.Property("UserId") .HasColumnType("nvarchar(450)"); b.Property("LoginProvider") .HasColumnType("nvarchar(450)"); b.Property("Name") .HasColumnType("nvarchar(450)"); b.Property("Value") .HasColumnType("nvarchar(max)"); b.HasKey("UserId", "LoginProvider", "Name"); b.ToTable("AspNetUserTokens", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null) .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.HasOne("BusinessERP.Models.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.HasOne("BusinessERP.Models.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null) .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("BusinessERP.Models.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b => { b.HasOne("BusinessERP.Models.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); #pragma warning restore 612, 618 } } }