public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.WebSpecial> builder) { #region Generated Configure // table builder.ToTable("Web_Special", "dbo"); // key builder.HasKey(t => t.SpecialId); // properties builder.Property(t => t.SpecialId) .IsRequired() .HasColumnName("SpecialId") .HasColumnType("int") .ValueGeneratedOnAdd(); builder.Property(t => t.SiteId) .HasColumnName("SiteId") .HasColumnType("int"); builder.Property(t => t.SpecialCode) .HasColumnName("SpecialCode") .HasColumnType("varchar(10)") .HasMaxLength(10); builder.Property(t => t.Name) .HasColumnName("Name") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.DisplayType) .HasColumnName("DisplayType") .HasColumnType("int"); builder.Property(t => t.IsEnable) .HasColumnName("IsEnable") .HasColumnType("int"); builder.Property(t => t.RowVers) .IsRowVersion() .HasColumnName("RowVers") .HasColumnType("rowversion") .HasMaxLength(8) .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.Remarks) .HasColumnName("Remarks") .HasColumnType("nvarchar(255)") .HasMaxLength(255); builder.Property(t => t.CreateBy) .HasColumnName("CreateBy") .HasColumnType("int"); builder.Property(t => t.CreateTime) .HasColumnName("CreateTime") .HasColumnType("datetime"); // relationships #endregion }
/// <summary> /// Configures the entity of type <see cref="Tracker.Core.Data.Entities.Priority" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Tracker.Core.Data.Entities.Priority> builder) { #region Generated Configure // table builder.ToTable("Priority", "dbo"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())") ; builder.Property(t => t.Name) .IsRequired() .HasColumnName("Name") .HasColumnType("nvarchar(100)") .HasMaxLength(100) ; builder.Property(t => t.Description) .HasColumnName("Description") .HasColumnType("nvarchar(255)") .HasMaxLength(255) ; builder.Property(t => t.DisplayOrder) .IsRequired() .HasColumnName("DisplayOrder") .HasColumnType("int") ; builder.Property(t => t.IsActive) .IsRequired() .HasColumnName("IsActive") .HasColumnType("bit") .HasDefaultValueSql("((1))") ; builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())") ; builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100) ; builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())") ; builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100) ; builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .ValueGeneratedOnAddOrUpdate() ; // relationships #endregion // Generated Configure }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcCardArchive> builder) { #region Generated Configure // table builder.ToTable("cc_card_archive"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("id") .HasColumnType("bigint(20)"); builder.Property(t => t.Creationdate) .IsRequired() .HasColumnName("creationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(t => t.Firstusedate) .IsRequired() .HasColumnName("firstusedate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Expirationdate) .IsRequired() .HasColumnName("expirationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Enableexpire) .HasColumnName("enableexpire") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Expiredays) .HasColumnName("expiredays") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Username) .IsRequired() .HasColumnName("username") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Useralias) .IsRequired() .HasColumnName("useralias") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Uipass) .HasColumnName("uipass") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Credit) .IsRequired() .HasColumnName("credit") .HasColumnType("decimal(15,5)"); builder.Property(t => t.Tariff) .HasColumnName("tariff") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.IdDidgroup) .HasColumnName("id_didgroup") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Activated) .IsRequired() .HasColumnName("activated") .HasColumnType("char(1)") .HasMaxLength(1) .HasDefaultValueSql("'f'"); builder.Property(t => t.Status) .HasColumnName("status") .HasColumnType("int(11)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Lastname) .HasColumnName("lastname") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Firstname) .HasColumnName("firstname") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Address) .HasColumnName("address") .HasColumnType("char(100)") .HasMaxLength(100); builder.Property(t => t.City) .HasColumnName("city") .HasColumnType("char(40)") .HasMaxLength(40); builder.Property(t => t.State) .HasColumnName("state") .HasColumnType("char(40)") .HasMaxLength(40); builder.Property(t => t.Country) .HasColumnName("country") .HasColumnType("char(40)") .HasMaxLength(40); builder.Property(t => t.Zipcode) .HasColumnName("zipcode") .HasColumnType("char(20)") .HasMaxLength(20); builder.Property(t => t.Phone) .HasColumnName("phone") .HasColumnType("char(20)") .HasMaxLength(20); builder.Property(t => t.Email) .HasColumnName("email") .HasColumnType("char(70)") .HasMaxLength(70); builder.Property(t => t.Fax) .HasColumnName("fax") .HasColumnType("char(20)") .HasMaxLength(20); builder.Property(t => t.Inuse) .HasColumnName("inuse") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Simultaccess) .HasColumnName("simultaccess") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Currency) .HasColumnName("currency") .HasColumnType("char(3)") .HasMaxLength(3) .HasDefaultValueSql("'USD'"); builder.Property(t => t.Lastuse) .IsRequired() .HasColumnName("lastuse") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Nbused) .HasColumnName("nbused") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Typepaid) .HasColumnName("typepaid") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Creditlimit) .HasColumnName("creditlimit") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Voipcall) .HasColumnName("voipcall") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.SipBuddy) .HasColumnName("sip_buddy") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.IaxBuddy) .HasColumnName("iax_buddy") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Language) .HasColumnName("language") .HasColumnType("char(5)") .HasMaxLength(5) .HasDefaultValueSql("'en'"); builder.Property(t => t.Redial) .HasColumnName("redial") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Runservice) .HasColumnName("runservice") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Nbservice) .HasColumnName("nbservice") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.IdCampaign) .HasColumnName("id_campaign") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.NumTrialsDone) .HasColumnName("num_trials_done") .HasColumnType("bigint(20)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Vat) .IsRequired() .HasColumnName("vat") .HasColumnType("float"); builder.Property(t => t.Servicelastrun) .IsRequired() .HasColumnName("servicelastrun") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Initialbalance) .IsRequired() .HasColumnName("initialbalance") .HasColumnType("decimal(15,5)"); builder.Property(t => t.Invoiceday) .HasColumnName("invoiceday") .HasColumnType("int(11)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Autorefill) .HasColumnName("autorefill") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Loginkey) .HasColumnName("loginkey") .HasColumnType("char(40)") .HasMaxLength(40); builder.Property(t => t.Activatedbyuser) .IsRequired() .HasColumnName("activatedbyuser") .HasColumnType("char(1)") .HasMaxLength(1) .HasDefaultValueSql("'t'"); builder.Property(t => t.IdTimezone) .HasColumnName("id_timezone") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Tag) .HasColumnName("tag") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.VoicemailPermitted) .IsRequired() .HasColumnName("voicemail_permitted") .HasColumnType("int(11)"); builder.Property(t => t.VoicemailActivated) .IsRequired() .HasColumnName("voicemail_activated") .HasColumnType("smallint(6)"); builder.Property(t => t.LastNotification) .HasColumnName("last_notification") .HasColumnType("timestamp(6)"); builder.Property(t => t.EmailNotification) .HasColumnName("email_notification") .HasColumnType("char(70)") .HasMaxLength(70); builder.Property(t => t.NotifyEmail) .IsRequired() .HasColumnName("notify_email") .HasColumnType("smallint(6)"); builder.Property(t => t.CreditNotification) .IsRequired() .HasColumnName("credit_notification") .HasColumnType("int(11)") .HasDefaultValueSql("'-1'"); builder.Property(t => t.IdGroup) .IsRequired() .HasColumnName("id_group") .HasColumnType("int(11)") .HasDefaultValueSql("'1'"); builder.Property(t => t.CompanyName) .HasColumnName("company_name") .HasColumnType("varchar(50)") .HasMaxLength(50); builder.Property(t => t.CompanyWebsite) .HasColumnName("company_website") .HasColumnType("varchar(60)") .HasMaxLength(60); builder.Property(t => t.VatRn) .HasColumnName("VAT_RN") .HasColumnType("varchar(40)") .HasMaxLength(40); builder.Property(t => t.Traffic) .HasColumnName("traffic") .HasColumnType("bigint(20)"); builder.Property(t => t.TrafficTarget) .HasColumnName("traffic_target") .HasColumnType("mediumtext"); builder.Property(t => t.Discount) .IsRequired() .HasColumnName("discount") .HasColumnType("decimal(5,2)"); builder.Property(t => t.Restriction) .IsRequired() .HasColumnName("restriction") .HasColumnType("tinyint(4)"); builder.Property(t => t.MacAddr) .IsRequired() .HasColumnName("mac_addr") .HasColumnType("char(17)") .HasMaxLength(17) .HasDefaultValueSql("'00-00-00-00-00-00'"); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Tracker.Data.Entities.Task> builder) { #region Generated Configure // table builder.ToTable("Task", "dbo"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())"); builder.Property(t => t.StatusId) .IsRequired() .HasColumnName("StatusId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.PriorityId) .HasColumnName("PriorityId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.Title) .IsRequired() .HasColumnName("Title") .HasColumnType("nvarchar(255)") .HasMaxLength(255); builder.Property(t => t.Description) .HasColumnName("Description") .HasColumnType("nvarchar(max)"); builder.Property(t => t.StartDate) .HasColumnName("StartDate") .HasColumnType("datetimeoffset"); builder.Property(t => t.DueDate) .HasColumnName("DueDate") .HasColumnType("datetimeoffset"); builder.Property(t => t.CompleteDate) .HasColumnName("CompleteDate") .HasColumnType("datetimeoffset"); builder.Property(t => t.AssignedId) .HasColumnName("AssignedId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .ValueGeneratedOnAddOrUpdate(); // relationships builder.HasOne(t => t.Priority) .WithMany(t => t.Tasks) .HasForeignKey(d => d.PriorityId) .HasConstraintName("FK_Task_Priority_PriorityId"); builder.HasOne(t => t.Status) .WithMany(t => t.Tasks) .HasForeignKey(d => d.StatusId) .HasConstraintName("FK_Task_Status_StatusId"); builder.HasOne(t => t.AssignedUser) .WithMany(t => t.AssignedTasks) .HasForeignKey(d => d.AssignedId) .HasConstraintName("FK_Task_User_AssignedId"); #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.SalesOrderHeader> builder) { #region Generated Configure // table builder.ToTable("SalesOrderHeader", "Sales"); // key builder.HasKey(t => t.SalesOrderID); // properties builder.Property(t => t.SalesOrderID) .IsRequired() .HasColumnName("SalesOrderID") .HasColumnType("int") .ValueGeneratedOnAdd(); builder.Property(t => t.RevisionNumber) .IsRequired() .HasColumnName("RevisionNumber") .HasColumnType("tinyint"); builder.Property(t => t.OrderDate) .IsRequired() .HasColumnName("OrderDate") .HasColumnType("datetime") .HasDefaultValueSql("(getdate())"); builder.Property(t => t.DueDate) .IsRequired() .HasColumnName("DueDate") .HasColumnType("datetime"); builder.Property(t => t.ShipDate) .HasColumnName("ShipDate") .HasColumnType("datetime"); builder.Property(t => t.Status) .IsRequired() .HasColumnName("Status") .HasColumnType("tinyint") .HasDefaultValueSql("((1))"); builder.Property(t => t.OnlineOrderFlag) .IsRequired() .HasColumnName("OnlineOrderFlag") .HasColumnType("bit") .HasDefaultValueSql("((1))"); builder.Property(t => t.SalesOrderNumber) .IsRequired() .HasColumnName("SalesOrderNumber") .HasColumnType("nvarchar(25)") .HasMaxLength(25) .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.PurchaseOrderNumber) .HasColumnName("PurchaseOrderNumber") .HasColumnType("nvarchar(25)") .HasMaxLength(25); builder.Property(t => t.AccountNumber) .HasColumnName("AccountNumber") .HasColumnType("nvarchar(15)") .HasMaxLength(15); builder.Property(t => t.CustomerID) .IsRequired() .HasColumnName("CustomerID") .HasColumnType("int"); builder.Property(t => t.SalesPersonID) .HasColumnName("SalesPersonID") .HasColumnType("int"); builder.Property(t => t.TerritoryID) .HasColumnName("TerritoryID") .HasColumnType("int"); builder.Property(t => t.BillToAddressID) .IsRequired() .HasColumnName("BillToAddressID") .HasColumnType("int"); builder.Property(t => t.ShipToAddressID) .IsRequired() .HasColumnName("ShipToAddressID") .HasColumnType("int"); builder.Property(t => t.ShipMethodID) .IsRequired() .HasColumnName("ShipMethodID") .HasColumnType("int"); builder.Property(t => t.CreditCardID) .HasColumnName("CreditCardID") .HasColumnType("int"); builder.Property(t => t.CreditCardApprovalCode) .HasColumnName("CreditCardApprovalCode") .HasColumnType("varchar(15)") .HasMaxLength(15); builder.Property(t => t.CurrencyRateID) .HasColumnName("CurrencyRateID") .HasColumnType("int"); builder.Property(t => t.SubTotal) .IsRequired() .HasColumnName("SubTotal") .HasColumnType("money") .HasDefaultValueSql("((0.00))"); builder.Property(t => t.TaxAmt) .IsRequired() .HasColumnName("TaxAmt") .HasColumnType("money") .HasDefaultValueSql("((0.00))"); builder.Property(t => t.Freight) .IsRequired() .HasColumnName("Freight") .HasColumnType("money") .HasDefaultValueSql("((0.00))"); builder.Property(t => t.TotalDue) .IsRequired() .HasColumnName("TotalDue") .HasColumnType("money") .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.Comment) .HasColumnName("Comment") .HasColumnType("nvarchar(128)") .HasMaxLength(128); builder.Property(t => t.Rowguid) .IsRequired() .HasColumnName("rowguid") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newid())"); builder.Property(t => t.ModifiedDate) .IsRequired() .HasColumnName("ModifiedDate") .HasColumnType("datetime") .HasDefaultValueSql("(getdate())"); // relationships builder.HasOne(t => t.BillToAddress) .WithMany(t => t.BillToSalesOrderHeaders) .HasForeignKey(d => d.BillToAddressID) .HasConstraintName("FK_SalesOrderHeader_Address_BillToAddressID"); builder.HasOne(t => t.ShipToAddress) .WithMany(t => t.ShipToSalesOrderHeaders) .HasForeignKey(d => d.ShipToAddressID) .HasConstraintName("FK_SalesOrderHeader_Address_ShipToAddressID"); builder.HasOne(t => t.CreditCard) .WithMany(t => t.SalesOrderHeaders) .HasForeignKey(d => d.CreditCardID) .HasConstraintName("FK_SalesOrderHeader_CreditCard_CreditCardID"); builder.HasOne(t => t.CurrencyRate) .WithMany(t => t.SalesOrderHeaders) .HasForeignKey(d => d.CurrencyRateID) .HasConstraintName("FK_SalesOrderHeader_CurrencyRate_CurrencyRateID"); builder.HasOne(t => t.Customer) .WithMany(t => t.SalesOrderHeaders) .HasForeignKey(d => d.CustomerID) .HasConstraintName("FK_SalesOrderHeader_Customer_CustomerID"); builder.HasOne(t => t.SalesPerson) .WithMany(t => t.SalesOrderHeaders) .HasForeignKey(d => d.SalesPersonID) .HasConstraintName("FK_SalesOrderHeader_SalesPerson_SalesPersonID"); builder.HasOne(t => t.SalesTerritory) .WithMany(t => t.SalesOrderHeaders) .HasForeignKey(d => d.TerritoryID) .HasConstraintName("FK_SalesOrderHeader_SalesTerritory_TerritoryID"); builder.HasOne(t => t.ShipMethod) .WithMany(t => t.SalesOrderHeaders) .HasForeignKey(d => d.ShipMethodID) .HasConstraintName("FK_SalesOrderHeader_ShipMethod_ShipMethodID"); #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcDidDestination> builder) { #region Generated Configure // table builder.ToTable("cc_did_destination"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("id") .HasColumnType("bigint(20)") .ValueGeneratedOnAdd(); builder.Property(t => t.Destination) .HasColumnName("destination") .HasColumnType("varchar(100)") .HasMaxLength(100); builder.Property(t => t.Priority) .IsRequired() .HasColumnName("priority") .HasColumnType("int(11)"); builder.Property(t => t.IdCcCard) .IsRequired() .HasColumnName("id_cc_card") .HasColumnType("bigint(20)"); builder.Property(t => t.IdCcDid) .IsRequired() .HasColumnName("id_cc_did") .HasColumnType("bigint(20)"); builder.Property(t => t.Creationdate) .IsRequired() .HasColumnName("creationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(t => t.Activated) .IsRequired() .HasColumnName("activated") .HasColumnType("int(11)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Secondusedreal) .HasColumnName("secondusedreal") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.VoipCall) .HasColumnName("voip_call") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Validated) .HasColumnName("validated") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.TransactionHistoryArchive> builder) { #region Generated Configure // table builder.ToTable("TransactionHistoryArchive", "Production"); // key builder.HasKey(t => t.TransactionID); // properties builder.Property(t => t.TransactionID) .IsRequired() .HasColumnName("TransactionID") .HasColumnType("int"); builder.Property(t => t.ProductID) .IsRequired() .HasColumnName("ProductID") .HasColumnType("int"); builder.Property(t => t.ReferenceOrderID) .IsRequired() .HasColumnName("ReferenceOrderID") .HasColumnType("int"); builder.Property(t => t.ReferenceOrderLineID) .IsRequired() .HasColumnName("ReferenceOrderLineID") .HasColumnType("int"); builder.Property(t => t.TransactionDate) .IsRequired() .HasColumnName("TransactionDate") .HasColumnType("datetime") .HasDefaultValueSql("(getdate())"); builder.Property(t => t.TransactionType) .IsRequired() .HasColumnName("TransactionType") .HasColumnType("nchar(1)") .HasMaxLength(1); builder.Property(t => t.Quantity) .IsRequired() .HasColumnName("Quantity") .HasColumnType("int"); builder.Property(t => t.ActualCost) .IsRequired() .HasColumnName("ActualCost") .HasColumnType("money"); builder.Property(t => t.ModifiedDate) .IsRequired() .HasColumnName("ModifiedDate") .HasColumnType("datetime") .HasDefaultValueSql("(getdate())"); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.MemberWithdraw> builder) { #region Generated Configure // table builder.ToTable("Member_Withdraw", "dbo"); // key builder.HasKey(t => t.WithdrawId); // properties builder.Property(t => t.WithdrawId) .IsRequired() .HasColumnName("WithdrawId") .HasColumnType("bigint"); builder.Property(t => t.MemberId) .HasColumnName("MemberId") .HasColumnType("int"); builder.Property(t => t.Methods) .HasColumnName("Methods") .HasColumnType("int"); builder.Property(t => t.Title) .HasColumnName("Title") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.Beans) .HasColumnName("Beans") .HasColumnType("int"); builder.Property(t => t.Amount) .HasColumnName("Amount") .HasColumnType("decimal(18,2)"); builder.Property(t => t.Proportion) .HasColumnName("Proportion") .HasColumnType("varchar(20)") .HasMaxLength(20); builder.Property(t => t.CreateTime) .HasColumnName("CreateTime") .HasColumnType("datetime"); builder.Property(t => t.Status) .HasColumnName("Status") .HasColumnType("int"); builder.Property(t => t.Remarks) .HasColumnName("Remarks") .HasColumnType("nvarchar(255)") .HasMaxLength(255); builder.Property(t => t.AuditId) .HasColumnName("AuditId") .HasColumnType("int"); builder.Property(t => t.Audit) .HasColumnName("Audit") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.AuditTime) .HasColumnName("AuditTime") .HasColumnType("datetime"); // relationships builder.HasOne(t => t.MemberInfos) .WithMany(t => t.MemberWithdraws) .HasForeignKey(d => d.MemberId) .HasConstraintName("FK_MEMBER_W_REFERENCE_MEMBER_I"); #endregion }
/// <summary> /// Configures the entity of type <see cref="InstructorIQ.Core.Data.Entities.SessionReferenceNumber" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <InstructorIQ.Core.Data.Entities.SessionReferenceNumber> builder) { #region Generated Configure // table builder.ToTable("SessionReferenceNumber", "IQ"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())"); builder.Property(t => t.ReferenceNumber) .IsRequired() .HasColumnName("ReferenceNumber") .HasColumnType("nvarchar(255)") .HasMaxLength(255); builder.Property(t => t.ReferenceType) .IsRequired() .HasColumnName("ReferenceType") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.SessionId) .IsRequired() .HasColumnName("SessionId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .ValueGeneratedOnAddOrUpdate(); // relationships builder.HasOne(t => t.Session) .WithMany(t => t.SessionReferenceNumbers) .HasForeignKey(d => d.SessionId) .HasConstraintName("FK_SessionReferenceNumber_Session_[SessionId"); #endregion }
/// <summary> /// Configures the entity of type <see cref="Tracker.Core.Data.Entities.TaskExtended" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Tracker.Core.Data.Entities.TaskExtended> builder) { #region Generated Configure // table builder.ToTable("TaskExtended", "dbo"); // key builder.HasKey(t => t.TaskId); // properties builder.Property(t => t.TaskId) .IsRequired() .HasColumnName("TaskId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.UserAgent) .HasColumnName("UserAgent") .HasColumnType("nvarchar(max)"); builder.Property(t => t.Browser) .HasColumnName("Browser") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.OperatingSystem) .HasColumnName("OperatingSystem") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .HasMaxLength(8) .ValueGeneratedOnAddOrUpdate(); // relationships builder.HasOne(t => t.Task) .WithOne(t => t.TaskExtended) .HasForeignKey <Tracker.Core.Data.Entities.TaskExtended>(d => d.TaskId) .HasConstraintName("FK_TaskExtended_Task_TaskId"); #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <OrderItem> builder) { builder.OwnsOne(i => i.ItemOrdered, io => { io.WithOwner(); }); builder.Property(i => i.Price) .HasColumnType("decimal(18,2)"); }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.CurrencyRate> builder) { #region Generated Configure // table builder.ToTable("CurrencyRate", "Sales"); // key builder.HasKey(t => t.CurrencyRateID); // properties builder.Property(t => t.CurrencyRateID) .IsRequired() .HasColumnName("CurrencyRateID") .HasColumnType("int") .ValueGeneratedOnAdd(); builder.Property(t => t.CurrencyRateDate) .IsRequired() .HasColumnName("CurrencyRateDate") .HasColumnType("datetime"); builder.Property(t => t.FromCurrencyCode) .IsRequired() .HasColumnName("FromCurrencyCode") .HasColumnType("nchar(3)") .HasMaxLength(3); builder.Property(t => t.ToCurrencyCode) .IsRequired() .HasColumnName("ToCurrencyCode") .HasColumnType("nchar(3)") .HasMaxLength(3); builder.Property(t => t.AverageRate) .IsRequired() .HasColumnName("AverageRate") .HasColumnType("money"); builder.Property(t => t.EndOfDayRate) .IsRequired() .HasColumnName("EndOfDayRate") .HasColumnType("money"); builder.Property(t => t.ModifiedDate) .IsRequired() .HasColumnName("ModifiedDate") .HasColumnType("datetime") .HasDefaultValueSql("(getdate())"); // relationships builder.HasOne(t => t.FromCurrency) .WithMany(t => t.FromCurrencyRates) .HasForeignKey(d => d.FromCurrencyCode) .HasConstraintName("FK_CurrencyRate_Currency_FromCurrencyCode"); builder.HasOne(t => t.ToCurrency) .WithMany(t => t.ToCurrencyRates) .HasForeignKey(d => d.ToCurrencyCode) .HasConstraintName("FK_CurrencyRate_Currency_ToCurrencyCode"); #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.VVendorWithAddresses> builder) { #region Generated Configure // table builder.ToView("vVendorWithAddresses", "Purchasing"); // key builder.HasNoKey(); // properties builder.Property(t => t.BusinessEntityID) .IsRequired() .HasColumnName("BusinessEntityID") .HasColumnType("int"); builder.Property(t => t.Name) .IsRequired() .HasColumnName("Name") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.AddressType) .IsRequired() .HasColumnName("AddressType") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.AddressLine1) .IsRequired() .HasColumnName("AddressLine1") .HasColumnType("nvarchar(60)") .HasMaxLength(60); builder.Property(t => t.AddressLine2) .HasColumnName("AddressLine2") .HasColumnType("nvarchar(60)") .HasMaxLength(60); builder.Property(t => t.City) .IsRequired() .HasColumnName("City") .HasColumnType("nvarchar(30)") .HasMaxLength(30); builder.Property(t => t.StateProvinceName) .IsRequired() .HasColumnName("StateProvinceName") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.PostalCode) .IsRequired() .HasColumnName("PostalCode") .HasColumnType("nvarchar(15)") .HasMaxLength(15); builder.Property(t => t.CountryRegionName) .IsRequired() .HasColumnName("CountryRegionName") .HasColumnType("nvarchar(50)") .HasMaxLength(50); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcEpaymentLogAgent> builder) { #region Generated Configure // table builder.ToTable("cc_epayment_log_agent"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("id") .HasColumnType("bigint(20)") .ValueGeneratedOnAdd(); builder.Property(t => t.AgentId) .IsRequired() .HasColumnName("agent_id") .HasColumnType("bigint(20)"); builder.Property(t => t.Amount) .IsRequired() .HasColumnName("amount") .HasColumnType("varchar(50)") .HasMaxLength(50) .HasDefaultValueSql("'0'"); builder.Property(t => t.Vat) .IsRequired() .HasColumnName("vat") .HasColumnType("float"); builder.Property(t => t.Paymentmethod) .IsRequired() .HasColumnName("paymentmethod") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.CcOwner) .HasColumnName("cc_owner") .HasColumnType("varchar(64)") .HasMaxLength(64); builder.Property(t => t.CcNumber) .HasColumnName("cc_number") .HasColumnType("varchar(32)") .HasMaxLength(32); builder.Property(t => t.CcExpires) .HasColumnName("cc_expires") .HasColumnType("varchar(7)") .HasMaxLength(7); builder.Property(t => t.Creationdate) .IsRequired() .HasColumnName("creationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(t => t.Status) .IsRequired() .HasColumnName("status") .HasColumnType("int(11)"); builder.Property(t => t.Cvv) .HasColumnName("cvv") .HasColumnType("varchar(4)") .HasMaxLength(4); builder.Property(t => t.CreditCardType) .HasColumnName("credit_card_type") .HasColumnType("varchar(20)") .HasMaxLength(20); builder.Property(t => t.Currency) .HasColumnName("currency") .HasColumnType("varchar(4)") .HasMaxLength(4); builder.Property(t => t.TransactionDetail) .HasColumnName("transaction_detail") .HasColumnType("longtext"); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.MemberProblem> builder) { #region Generated Configure // table builder.ToTable("Member_Problem", "dbo"); // key builder.HasKey(t => t.ProblemId); // properties builder.Property(t => t.ProblemId) .IsRequired() .HasColumnName("ProblemId") .HasColumnType("int") .ValueGeneratedOnAdd(); builder.Property(t => t.Title) .HasColumnName("Title") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.Desc) .HasColumnName("Desc") .HasColumnType("nvarchar(500)") .HasMaxLength(500); builder.Property(t => t.Type) .HasColumnName("Type") .HasColumnType("int"); builder.Property(t => t.Urls) .HasColumnName("Urls") .HasColumnType("nvarchar(500)") .HasMaxLength(500); builder.Property(t => t.IsHot) .HasColumnName("IsHot") .HasColumnType("int"); builder.Property(t => t.Sequence) .HasColumnName("Sequence") .HasColumnType("int"); builder.Property(t => t.IsEnable) .HasColumnName("IsEnable") .HasColumnType("int"); builder.Property(t => t.Remarks) .HasColumnName("Remarks") .HasColumnType("nvarchar(255)") .HasMaxLength(255); builder.Property(t => t.CreateBy) .HasColumnName("CreateBy") .HasColumnType("int"); builder.Property(t => t.CreateTime) .HasColumnName("CreateTime") .HasColumnType("datetime"); // relationships #endregion }
/// <summary> /// Configures the entity of type <see cref="InstructorIQ.Core.Data.Entities.Location" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <InstructorIQ.Core.Data.Entities.Location> builder) { #region Generated Configure // table builder.ToTable("Location", "IQ"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())"); builder.Property(t => t.Name) .IsRequired() .HasColumnName("Name") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.Description) .HasColumnName("Description") .HasColumnType("nvarchar(max)"); builder.Property(t => t.AddressLine1) .HasColumnName("AddressLine1") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.AddressLine2) .HasColumnName("AddressLine2") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.AddressLine3) .HasColumnName("AddressLine3") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.City) .HasColumnName("City") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.StateProvince) .HasColumnName("StateProvince") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.PostalCode) .HasColumnName("PostalCode") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.ContactName) .HasColumnName("ContactName") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.ContactEmail) .HasColumnName("ContactEmail") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.ContactPhone) .HasColumnName("ContactPhone") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.Latitude) .HasColumnName("Latitude") .HasColumnType("decimal(20,10)"); builder.Property(t => t.Longitude) .HasColumnName("Longitude") .HasColumnType("decimal(20,10)"); builder.Property(t => t.TenantId) .IsRequired() .HasColumnName("TenantId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .HasMaxLength(8) .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.PeriodStart) .IsRequired() .HasColumnName("PeriodStart") .HasColumnType("datetime2") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.PeriodEnd) .IsRequired() .HasColumnName("PeriodEnd") .HasColumnType("datetime2") .HasDefaultValueSql("('9999-12-31 23:59:59.9999999')"); // relationships builder.HasOne(t => t.Tenant) .WithMany(t => t.Locations) .HasForeignKey(d => d.TenantId) .HasConstraintName("FK_Location_Tenant_TenantId"); #endregion builder.Property(t => t.PeriodStart) .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.PeriodEnd) .ValueGeneratedOnAddOrUpdate(); }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Tracker.Data.Entities.TaskExtended> builder) { #region Generated Configure // table builder.ToTable("TaskExtended", "public"); // key builder.HasKey(t => t.TaskId); // properties builder.Property(t => t.TaskId) .IsRequired() .HasColumnName("TaskId") .HasColumnType("uuid"); builder.Property(t => t.UserAgent) .HasColumnName("UserAgent") .HasColumnType("text"); builder.Property(t => t.Browser) .HasColumnName("Browser") .HasColumnType("character varying(256)") .HasMaxLength(256); builder.Property(t => t.OperatingSystem) .HasColumnName("OperatingSystem") .HasColumnType("character varying(256)") .HasMaxLength(256); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("timestamp with time zone") .HasDefaultValueSql("timezone('utc'::text, now())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("character varying(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("timestamp with time zone") .HasDefaultValueSql("timezone('utc'::text, now())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("character varying(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .HasColumnName("RowVersion") .HasColumnType("bytea"); // relationships builder.HasOne(t => t.Task) .WithOne(t => t.TaskExtended) .HasForeignKey <Tracker.Data.Entities.TaskExtended>(d => d.TaskId) .HasConstraintName("FK_TaskExtended_Task_TaskId"); #endregion }
public override void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ArticlePraise> builder) { builder.HasKey(x => x.KID); builder.Property(x => x.States).IsRequired().HasColumnType("tinyint(4)").HasDefaultValue(0); builder.Property(x => x.IsDeleted).IsRequired().HasColumnType("tinyint(4)").HasDefaultValue(0); builder.Property(x => x.CreateUserId).HasMaxLength(512).IsRequired().HasDefaultValue("1"); builder.Property(x => x.CreateUserName).HasMaxLength(512).IsRequired().HasDefaultValue("System"); builder.Property(x => x.UpdateTime).IsRequired().HasColumnType("timestamp").HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(x => x.CreateTime).IsRequired().HasDefaultValue("1970-01-01 08:00:00"); builder.Property(x => x.UpdateUserId).HasMaxLength(512).IsRequired().HasDefaultValue(""); builder.Property(x => x.UpdateUserName).HasMaxLength(512).IsRequired().HasDefaultValue(""); builder.Property(x => x.Extend1).IsRequired().HasDefaultValue(0); builder.Property(x => x.Extend2).IsRequired().HasDefaultValue(0); builder.Property(x => x.Extend3).IsRequired().HasDefaultValue(0); builder.Property(x => x.Extend4).HasMaxLength(128).IsRequired().HasDefaultValue(""); builder.Property(x => x.Extend5).HasMaxLength(128).IsRequired().HasDefaultValue(""); builder.Property(x => x.Extend6).HasMaxLength(128).IsRequired().HasDefaultValue(""); builder.Property(x => x.MemberId).IsRequired().HasMaxLength(20); builder.Property(x => x.IpAddress).IsRequired().HasMaxLength(50); //builder.HasKey(x => x.KID); //builder.HasOne<Bloginfo>(en => en.Bloginfo).WithMany(x => x.ArticlePraises).HasForeignKey(x => x.BlogNum);//只需在这边指定外键就行 }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.CcTicket> builder) { #region Generated Configure // table builder.ToTable("cc_ticket"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("id") .HasColumnType("bigint(10)") .ValueGeneratedOnAdd(); builder.Property(t => t.IdComponent) .IsRequired() .HasColumnName("id_component") .HasColumnType("smallint(5)"); builder.Property(t => t.Title) .IsRequired() .HasColumnName("title") .HasColumnType("varchar(100)") .HasMaxLength(100); builder.Property(t => t.Description) .HasColumnName("description") .HasColumnType("text"); builder.Property(t => t.Priority) .IsRequired() .HasColumnName("priority") .HasColumnType("smallint(6)"); builder.Property(t => t.Creationdate) .IsRequired() .HasColumnName("creationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(t => t.Creator) .IsRequired() .HasColumnName("creator") .HasColumnType("bigint(20)"); builder.Property(t => t.Status) .IsRequired() .HasColumnName("status") .HasColumnType("smallint(6)"); builder.Property(t => t.CreatorType) .IsRequired() .HasColumnName("creator_type") .HasColumnType("tinyint(4)"); builder.Property(t => t.ViewedCust) .IsRequired() .HasColumnName("viewed_cust") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.ViewedAgent) .IsRequired() .HasColumnName("viewed_agent") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.ViewedAdmin) .IsRequired() .HasColumnName("viewed_admin") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); // relationships #endregion }
/// <summary> /// Configures the entity of type <see cref="Tracker.Core.Data.Entities.UserLogin" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Tracker.Core.Data.Entities.UserLogin> builder) { #region Generated Configure // table builder.ToTable("UserLogin", "dbo"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())"); builder.Property(t => t.EmailAddress) .IsRequired() .HasColumnName("EmailAddress") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.UserId) .HasColumnName("UserId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.UserAgent) .HasColumnName("UserAgent") .HasColumnType("nvarchar(max)"); builder.Property(t => t.Browser) .HasColumnName("Browser") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.OperatingSystem) .HasColumnName("OperatingSystem") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.DeviceFamily) .HasColumnName("DeviceFamily") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.DeviceBrand) .HasColumnName("DeviceBrand") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.DeviceModel) .HasColumnName("DeviceModel") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.IpAddress) .HasColumnName("IpAddress") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.IsSuccessful) .IsRequired() .HasColumnName("IsSuccessful") .HasColumnType("bit"); builder.Property(t => t.FailureMessage) .HasColumnName("FailureMessage") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .HasMaxLength(8) .ValueGeneratedOnAddOrUpdate(); // relationships builder.HasOne(t => t.User) .WithMany(t => t.UserLogins) .HasForeignKey(d => d.UserId) .HasConstraintName("FK_UserLogin_User_UserId"); #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Error> builder) { builder.ToTable("Error"); builder.HasKey(x => x.Id); builder.Property(x => x.Id) .HasColumnName("Id") .IsRequired(); builder.Property(x => x.Title) .HasColumnName("Title") .HasMaxLength(60) .HasColumnType("varchar(60)") .IsRequired(); builder.Property(x => x.Details) .HasColumnName("Details") .HasMaxLength(1024) .HasColumnType("varchar(1024)") .IsRequired(); builder.Property(x => x.CreatedAt) .HasColumnName("CreatedAt") .IsRequired(); builder.Property(x => x.SourceId) .HasColumnName("SourceId") .IsRequired(); builder.Property(x => x.Level) .HasConversion(x => x.ToString(), x => Enum.Parse <Level>(x)) .HasColumnName("Level") .HasMaxLength(50) .HasColumnType("varchar(50)") .IsRequired(); builder.Property(x => x.Archived) .HasColumnName("Archived") .IsRequired(); builder.Property(x => x.Deleted) .HasColumnName("Deleted") .IsRequired(); builder.HasOne(x => x.Source) .WithMany(x => x.Errors) .HasForeignKey(x => x.SourceId); builder.Property(x => x.UserId) .HasColumnName("UserId") .HasMaxLength(450) .HasColumnType("varchar(450)") .IsRequired(); builder.HasOne(x => x.User) .WithMany(x => x.Errors) .HasForeignKey(x => x.UserId); //#region add data //var title = "Description Project File Suppression State Line"; //var detail = @"Error CS7036 There is no argument given that corresponds to the required formal parameter 'id' of 'Error.Error(int, string, string, string, DateTime, int, int, int, int)' EziLog.Infrastructure D:\source\repos\EziLog\src\EziLog.Infrastructure\Data\Maps\ErrorMap.cs Active 15"; //var token = "eyJhbGciOiJIUzUxMiIsInR5cCI6IkpXVCJ9.eyJuYW1laWQiOiI1YjlmYTNhYi0zMjBiLTRjNzUtOTMyMi0zOGYzM2FlM2VmZGMiLCJlbWFpbCI6InJtaWlrZS45MEBnbWFpbC5jb20iLCJ1bmlxdWVfbmFtZSI6IlJlbmF0byBBbHZlcyIsIm5iZiI6MTU5NTU0NjEzMCwiZXhwIjoxNTk1NjMyNTMwLCJpYXQiOjE1OTU1NDYxMzB9.K5RhT2V3OGpwD0Tif6L5gb6BwqwD__edIxHb6a1PqZgW8EK9fJlux621L0-bWdTxaJqI5yuJ92SS39hEK2Yt4w"; //var errorData = Error.Create(1, token, title, detail, Level.Debug, 1); //#endregion //builder.HasData(errorData); }
public override void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ArticlePraise> builder) { builder.HasKey(x => x.KID); builder.Property(x => x.States).IsRequired().HasColumnType("tinyint(4)").HasDefaultValue(0); builder.Property(x => x.IsDeleted).IsRequired().HasColumnType("tinyint(4)").HasDefaultValue(0); builder.Property(x => x.CreateUserId).HasMaxLength(512).IsRequired().HasDefaultValue("1"); builder.Property(x => x.CreateUserName).HasMaxLength(512).IsRequired().HasDefaultValue("System"); builder.Property(x => x.UpdateTime).IsRequired().HasColumnType("timestamp").HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(x => x.CreateTime).IsRequired().HasDefaultValue("1970-01-01 08:00:00"); builder.Property(x => x.UpdateUserId).HasMaxLength(512).IsRequired().HasDefaultValue(""); builder.Property(x => x.UpdateUserName).HasMaxLength(512).IsRequired().HasDefaultValue(""); builder.Property(x => x.Extend1).IsRequired().HasDefaultValue(0); builder.Property(x => x.Extend2).IsRequired().HasDefaultValue(0); builder.Property(x => x.Extend3).IsRequired().HasDefaultValue(0); builder.Property(x => x.Extend4).HasMaxLength(128).IsRequired().HasDefaultValue(""); builder.Property(x => x.Extend5).HasMaxLength(128).IsRequired().HasDefaultValue(""); builder.Property(x => x.Extend6).HasMaxLength(128).IsRequired().HasDefaultValue(""); builder.HasKey(x => x.KID); }
/// <summary> /// Adds configuration for StudyMaterialRating, so that one student can rate only one material, that is, combination /// of attributes StudentId and StudyMaterialId must be unique and it makes primary key. Attribute Rating is required. /// </summary> /// <param name="builder"></param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <StudyMaterialRating> builder) { builder.HasKey(x => new { x.StudentId, x.StudyMaterialId }); builder.Property(x => x.Rating).IsRequired(); }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <WaitingPage> builder) { #region Generated Configure // table builder.ToTable("WaitingPage"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("INTEGER"); builder.Property(t => t.Uri) .HasColumnName("Uri") .HasColumnType("TEXT"); builder.Property(t => t.UriHash) .HasColumnName("UriHash") .HasColumnType("TEXT"); builder.Property(t => t.Priority) .HasColumnName("Priority") .HasColumnType("REAL"); builder.Property(t => t.RequestTime) .HasColumnName("RequestTime") .HasColumnType("TEXT"); builder.Property(t => t.Verb) .HasColumnName("Verb") .HasColumnType("TEXT"); builder.Property(t => t.DownloadedTime) .HasColumnName("DownloadedTime") .HasColumnType("TEXT"); builder.Property(t => t.Parameters) .HasColumnName("Parameters") .HasColumnType("TEXT"); builder.Property(t => t.NeedUpdate) .HasColumnName("NeedUpdate") .HasColumnType("INTEGER"); builder.Property(t => t.RetrieveErrorAtStep) .HasColumnName("RetrieveErrorAtStep") .HasColumnType("TEXT"); builder.Property(t => t.Error) .HasColumnName("Error") .HasColumnType("TEXT"); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Domain.Entities.FiredTrigger> builder) { #region Generated Configure // table builder.ToTable("FIRED_TRIGGERS", "Quartz"); // key builder.HasKey(t => new { t.SchedName, t.EntryId }); // properties builder.Property(t => t.SchedName) .IsRequired() .HasColumnName("SCHED_NAME") .HasColumnType("nvarchar(120)") .HasMaxLength(120); builder.Property(t => t.EntryId) .IsRequired() .HasColumnName("ENTRY_ID") .HasColumnType("nvarchar(140)") .HasMaxLength(140); builder.Property(t => t.TriggerName) .IsRequired() .HasColumnName("TRIGGER_NAME") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.TriggerGroup) .IsRequired() .HasColumnName("TRIGGER_GROUP") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.InstanceName) .IsRequired() .HasColumnName("INSTANCE_NAME") .HasColumnType("nvarchar(200)") .HasMaxLength(200); builder.Property(t => t.FiredTime) .IsRequired() .HasColumnName("FIRED_TIME") .HasColumnType("bigint"); builder.Property(t => t.SchedTime) .IsRequired() .HasColumnName("SCHED_TIME") .HasColumnType("bigint"); builder.Property(t => t.Priority) .IsRequired() .HasColumnName("PRIORITY") .HasColumnType("int"); builder.Property(t => t.State) .IsRequired() .HasColumnName("STATE") .HasColumnType("nvarchar(16)") .HasMaxLength(16); builder.Property(t => t.JobName) .HasColumnName("JOB_NAME") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.JobGroup) .HasColumnName("JOB_GROUP") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.IsNonconcurrent) .HasColumnName("IS_NONCONCURRENT") .HasColumnType("bit"); builder.Property(t => t.RequestsRecovery) .HasColumnName("REQUESTS_RECOVERY") .HasColumnType("bit"); // relationships //triggers builder.HasIndex(e => new { e.SchedName, e.InstanceName }, "IDX_FT_TRIG_INST_NAME"); builder.HasIndex(e => new { e.SchedName, e.JobGroup }, "IDX_FT_JG"); builder.HasIndex(e => new { e.SchedName, e.TriggerGroup }, "IDX_FT_TG"); builder.HasIndex(e => new { e.SchedName, e.InstanceName, e.RequestsRecovery }, "IDX_FT_INST_JOB_REQ_RCVRY"); builder.HasIndex(e => new { e.SchedName, e.JobName, e.JobGroup }, "IDX_FT_J_G"); builder.HasIndex(e => new { e.SchedName, e.TriggerName, e.TriggerGroup }, "IDX_FT_T_G"); #endregion }
/// <summary> /// Configures the entity of type <see cref="InstructorIQ.Core.Data.Entities.Tenant" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <InstructorIQ.Core.Data.Entities.Tenant> builder) { #region Generated Configure // table builder.ToTable("Tenant", "IQ"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())"); builder.Property(t => t.Name) .IsRequired() .HasColumnName("Name") .HasColumnType("nvarchar(256)") .HasMaxLength(256); builder.Property(t => t.Slug) .IsRequired() .HasColumnName("Slug") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.Description) .HasColumnName("Description") .HasColumnType("nvarchar(max)"); builder.Property(t => t.City) .HasColumnName("City") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.StateProvince) .HasColumnName("StateProvince") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.TimeZone) .IsRequired() .HasColumnName("TimeZone") .HasColumnType("nvarchar(150)") .HasMaxLength(150) .HasDefaultValueSql("('Central Standard Time')"); builder.Property(t => t.DomainName) .HasColumnName("DomainName") .HasColumnType("nvarchar(150)") .HasMaxLength(150); builder.Property(t => t.IsDeleted) .IsRequired() .HasColumnName("IsDeleted") .HasColumnType("bit"); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .HasMaxLength(8) .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.PeriodStart) .IsRequired() .HasColumnName("PeriodStart") .HasColumnType("datetime2") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.PeriodEnd) .IsRequired() .HasColumnName("PeriodEnd") .HasColumnType("datetime2") .HasDefaultValueSql("('9999-12-31 23:59:59.9999999')"); // relationships #endregion builder.Property(t => t.PeriodStart) .ValueGeneratedOnAddOrUpdate(); builder.Property(t => t.PeriodEnd) .ValueGeneratedOnAddOrUpdate(); }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcCall> builder) { #region Generated Configure // table builder.ToTable("cc_call"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("id") .HasColumnType("bigint(20)") .ValueGeneratedOnAdd(); builder.Property(t => t.Sessionid) .IsRequired() .HasColumnName("sessionid") .HasColumnType("varchar(40)") .HasMaxLength(40); builder.Property(t => t.Uniqueid) .IsRequired() .HasColumnName("uniqueid") .HasColumnType("varchar(30)") .HasMaxLength(30); builder.Property(t => t.CardId) .IsRequired() .HasColumnName("card_id") .HasColumnType("bigint(20)"); builder.Property(t => t.Nasipaddress) .IsRequired() .HasColumnName("nasipaddress") .HasColumnType("varchar(30)") .HasMaxLength(30); builder.Property(t => t.Starttime) .IsRequired() .HasColumnName("starttime") .HasColumnType("timestamp(6)") .HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(t => t.Stoptime) .IsRequired() .HasColumnName("stoptime") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Sessiontime) .HasColumnName("sessiontime") .HasColumnType("int(11)"); builder.Property(t => t.Calledstation) .IsRequired() .HasColumnName("calledstation") .HasColumnType("varchar(100)") .HasMaxLength(100); builder.Property(t => t.Sessionbill) .HasColumnName("sessionbill") .HasColumnType("float"); builder.Property(t => t.IdTariffgroup) .HasColumnName("id_tariffgroup") .HasColumnType("int(11)"); builder.Property(t => t.IdTariffplan) .HasColumnName("id_tariffplan") .HasColumnType("int(11)"); builder.Property(t => t.IdRatecard) .HasColumnName("id_ratecard") .HasColumnType("int(11)"); builder.Property(t => t.IdTrunk) .HasColumnName("id_trunk") .HasColumnType("int(11)"); builder.Property(t => t.Sipiax) .HasColumnName("sipiax") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Src) .IsRequired() .HasColumnName("src") .HasColumnType("varchar(40)") .HasMaxLength(40); builder.Property(t => t.IdDid) .HasColumnName("id_did") .HasColumnType("int(11)"); builder.Property(t => t.Buycost) .HasColumnName("buycost") .HasColumnType("decimal(15,5)") .HasDefaultValueSql("'0.00000'"); builder.Property(t => t.IdCardPackageOffer) .HasColumnName("id_card_package_offer") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.RealSessiontime) .HasColumnName("real_sessiontime") .HasColumnType("int(11)"); builder.Property(t => t.Dnid) .IsRequired() .HasColumnName("dnid") .HasColumnType("varchar(40)") .HasMaxLength(40); builder.Property(t => t.Terminatecauseid) .HasColumnName("terminatecauseid") .HasColumnType("int(1)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Destination) .HasColumnName("destination") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.A2bCustom1) .HasColumnName("a2b_custom1") .HasColumnType("varchar(20)") .HasMaxLength(20); builder.Property(t => t.A2bCustom2) .HasColumnName("a2b_custom2") .HasColumnType("varchar(20)") .HasMaxLength(20); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Tracker.PostgreSQL.Core.Data.Entities.Task> builder) { #region Generated Configure // table builder.ToTable("Task", "public"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uuid"); builder.Property(t => t.StatusId) .IsRequired() .HasColumnName("StatusId") .HasColumnType("uuid"); builder.Property(t => t.PriorityId) .HasColumnName("PriorityId") .HasColumnType("uuid"); builder.Property(t => t.Title) .IsRequired() .HasColumnName("Title") .HasColumnType("character varying(255)") .HasMaxLength(255); builder.Property(t => t.Description) .HasColumnName("Description") .HasColumnType("text"); builder.Property(t => t.StartDate) .HasColumnName("StartDate") .HasColumnType("timestamp with time zone"); builder.Property(t => t.DueDate) .HasColumnName("DueDate") .HasColumnType("timestamp with time zone"); builder.Property(t => t.CompleteDate) .HasColumnName("CompleteDate") .HasColumnType("timestamp with time zone"); builder.Property(t => t.AssignedId) .HasColumnName("AssignedId") .HasColumnType("uuid"); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("timestamp with time zone") .HasDefaultValueSql("timezone('utc'::text, now())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("character varying(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("timestamp with time zone") .HasDefaultValueSql("timezone('utc'::text, now())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("character varying(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .HasColumnName("RowVersion") .HasColumnType("bytea"); // relationships builder.HasOne(t => t.Priority) .WithMany(t => t.Tasks) .HasForeignKey(d => d.PriorityId) .HasConstraintName("FK_Task_Priority_PriorityId"); builder.HasOne(t => t.Status) .WithMany(t => t.Tasks) .HasForeignKey(d => d.StatusId) .HasConstraintName("FK_Task_Status_StatusId"); builder.HasOne(t => t.AssignedUser) .WithMany(t => t.AssignedTasks) .HasForeignKey(d => d.AssignedId) .HasConstraintName("FK_Task_User_AssignedId"); #endregion }
/// <summary> /// Configures the entity of type <see cref="TrackerSchema.Core.Data.Tracker.Entities.TrackerAudit" /> /// </summary> /// <param name="builder">The builder to be used to configure the entity type.</param> public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <TrackerSchema.Core.Data.Tracker.Entities.TrackerAudit> builder) { #region Generated Configure // table builder.ToTable("Audit", "Tracker"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("Id") .HasColumnType("uniqueidentifier") .HasDefaultValueSql("(newsequentialid())"); builder.Property(t => t.Date) .IsRequired() .HasColumnName("Date") .HasColumnType("datetime"); builder.Property(t => t.UserId) .HasColumnName("UserId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.TaskId) .HasColumnName("TaskId") .HasColumnType("uniqueidentifier"); builder.Property(t => t.Content) .IsRequired() .HasColumnName("Content") .HasColumnType("nvarchar(max)"); builder.Property(t => t.Username) .IsRequired() .HasColumnName("Username") .HasColumnType("nvarchar(50)") .HasMaxLength(50); builder.Property(t => t.Created) .IsRequired() .HasColumnName("Created") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.CreatedBy) .HasColumnName("CreatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.Updated) .IsRequired() .HasColumnName("Updated") .HasColumnType("datetimeoffset") .HasDefaultValueSql("(sysutcdatetime())"); builder.Property(t => t.UpdatedBy) .HasColumnName("UpdatedBy") .HasColumnType("nvarchar(100)") .HasMaxLength(100); builder.Property(t => t.RowVersion) .IsRequired() .IsRowVersion() .HasColumnName("RowVersion") .HasColumnType("rowversion") .HasMaxLength(8) .ValueGeneratedOnAddOrUpdate(); // relationships #endregion }
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcCampaign> builder) { #region Generated Configure // table builder.ToTable("cc_campaign"); // key builder.HasKey(t => t.Id); // properties builder.Property(t => t.Id) .IsRequired() .HasColumnName("id") .HasColumnType("int(11)") .ValueGeneratedOnAdd(); builder.Property(t => t.Name) .IsRequired() .HasColumnName("name") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.Creationdate) .IsRequired() .HasColumnName("creationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("CURRENT_TIMESTAMP"); builder.Property(t => t.Startingdate) .IsRequired() .HasColumnName("startingdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Expirationdate) .IsRequired() .HasColumnName("expirationdate") .HasColumnType("timestamp(6)") .HasDefaultValueSql("'0000-00-00 00:00:00'"); builder.Property(t => t.Description) .HasColumnName("description") .HasColumnType("mediumtext"); builder.Property(t => t.IdCard) .IsRequired() .HasColumnName("id_card") .HasColumnType("bigint(20)"); builder.Property(t => t.Secondusedreal) .HasColumnName("secondusedreal") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.NbCallmade) .HasColumnName("nb_callmade") .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); builder.Property(t => t.Status) .IsRequired() .HasColumnName("status") .HasColumnType("int(11)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Frequency) .IsRequired() .HasColumnName("frequency") .HasColumnType("int(11)") .HasDefaultValueSql("'20'"); builder.Property(t => t.ForwardNumber) .HasColumnName("forward_number") .HasColumnType("char(50)") .HasMaxLength(50); builder.Property(t => t.DailyStartTime) .IsRequired() .HasColumnName("daily_start_time") .HasColumnType("time") .HasDefaultValueSql("'10:00:00'"); builder.Property(t => t.DailyStopTime) .IsRequired() .HasColumnName("daily_stop_time") .HasColumnType("time") .HasDefaultValueSql("'18:00:00'"); builder.Property(t => t.Monday) .IsRequired() .HasColumnName("monday") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Tuesday) .IsRequired() .HasColumnName("tuesday") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Wednesday) .IsRequired() .HasColumnName("wednesday") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Thursday) .IsRequired() .HasColumnName("thursday") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Friday) .IsRequired() .HasColumnName("friday") .HasColumnType("tinyint(4)") .HasDefaultValueSql("'1'"); builder.Property(t => t.Saturday) .IsRequired() .HasColumnName("saturday") .HasColumnType("tinyint(4)"); builder.Property(t => t.Sunday) .IsRequired() .HasColumnName("sunday") .HasColumnType("tinyint(4)"); builder.Property(t => t.IdCidGroup) .IsRequired() .HasColumnName("id_cid_group") .HasColumnType("int(11)"); builder.Property(t => t.IdCampaignConfig) .IsRequired() .HasColumnName("id_campaign_config") .HasColumnType("int(11)"); // relationships #endregion }