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
}
