public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.TaskSignLog> builder)
{
#region Generated Configure
// table
builder.ToTable("Task_SignLog", "dbo");
// key
builder.HasKey(t => t.SignLogId);
// properties
builder.Property(t => t.SignLogId)
.IsRequired()
.HasColumnName("SignLogId")
.HasColumnType("int")
.ValueGeneratedOnAdd();
builder.Property(t => t.TaskId)
.HasColumnName("TaskId")
.HasColumnType("int");
builder.Property(t => t.MemberId)
.HasColumnName("MemberId")
.HasColumnType("int");
builder.Property(t => t.SignNumber)
.HasColumnName("SignNumber")
.HasColumnType("int");
builder.Property(t => t.CreateTime)
.HasColumnName("CreateTime")
.HasColumnType("datetime");
// relationships
builder.HasOne(t => t.TaskInfo)
.WithMany(t => t.TaskSignLogs)
.HasForeignKey(d => d.TaskId)
.HasConstraintName("FK_TASK_SIG_REFERENCE_TASK_INF");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.CcOutboundCidList> builder)
{
#region Generated Configure
// table
builder.ToTable("cc_outbound_cid_list");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("id")
.HasColumnType("int(11)")
.ValueGeneratedOnAdd();
builder.Property(t => t.OutboundCidGroup)
.IsRequired()
.HasColumnName("outbound_cid_group")
.HasColumnType("int(11)");
builder.Property(t => t.Cid)
.HasColumnName("cid")
.HasColumnType("char(100)")
.HasMaxLength(100);
builder.Property(t => t.Activated)
.IsRequired()
.HasColumnName("activated")
.HasColumnType("int(11)");
builder.Property(t => t.Creationdate)
.IsRequired()
.HasColumnName("creationdate")
.HasColumnType("timestamp(6)")
.HasDefaultValueSql("CURRENT_TIMESTAMP");
// relationships
#endregion
}
/// <summary>
/// Configures the entity of type <see cref="Tracker.Core.Data.Entities.UserRole" />
/// </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.UserRole> builder)
{
#region Generated Configure
// table
builder.ToTable("UserRole", "dbo");
// key
builder.HasKey(t => new {
t.UserId,
t.RoleId
});
// properties
builder.Property(t => t.UserId)
.IsRequired()
.HasColumnName("UserId")
.HasColumnType("uniqueidentifier")
;
builder.Property(t => t.RoleId)
.IsRequired()
.HasColumnName("RoleId")
.HasColumnType("uniqueidentifier")
;
// relationships
builder.HasOne(t => t.Role)
.WithMany(t => t.UserRoles)
.HasForeignKey(d => d.RoleId)
.HasConstraintName("FK_UserRole_Role_RoleId")
;
builder.HasOne(t => t.User)
.WithMany(t => t.UserRoles)
.HasForeignKey(d => d.UserId)
.HasConstraintName("FK_UserRole_User_UserId")
;
#endregion // Generated Configure
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.CcCampaignConfig> builder)
{
#region Generated Configure
// table
builder.ToTable("cc_campaign_config");
// 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("varchar(40)")
.HasMaxLength(40);
builder.Property(t => t.Flatrate)
.IsRequired()
.HasColumnName("flatrate")
.HasColumnType("decimal(15,5)");
builder.Property(t => t.Context)
.IsRequired()
.HasColumnName("context")
.HasColumnType("varchar(40)")
.HasMaxLength(40);
builder.Property(t => t.Description)
.HasColumnName("description")
.HasColumnType("mediumtext");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.CcCardPackageOffer> builder)
{
#region Generated Configure
// table
builder.ToTable("cc_card_package_offer");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("id")
.HasColumnType("bigint(20)")
.ValueGeneratedOnAdd();
builder.Property(t => t.IdCcCard)
.IsRequired()
.HasColumnName("id_cc_card")
.HasColumnType("bigint(20)");
builder.Property(t => t.IdCcPackageOffer)
.IsRequired()
.HasColumnName("id_cc_package_offer")
.HasColumnType("bigint(20)");
builder.Property(t => t.DateConsumption)
.IsRequired()
.HasColumnName("date_consumption")
.HasColumnType("timestamp(6)")
.HasDefaultValueSql("CURRENT_TIMESTAMP");
builder.Property(t => t.UsedSecondes)
.IsRequired()
.HasColumnName("used_secondes")
.HasColumnType("bigint(20)");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <aaronApplicationPlatform.Data.Entity.Role> builder)
{
#region Generated Configure
// table
builder.ToTable("Role", "aaap");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("Id")
.HasColumnType("int")
.ValueGeneratedOnAdd();
builder.Property(t => t.RolegroupId)
.IsRequired()
.HasColumnName("RolegroupId")
.HasColumnType("int");
builder.Property(t => t.Name)
.IsRequired()
.HasColumnName("Name")
.HasColumnType("nvarchar(128)")
.HasMaxLength(128);
builder.Property(t => t.Description)
.HasColumnName("Description")
.HasColumnType("nvarchar(255)")
.HasMaxLength(255);
// relationships
builder.HasOne(t => t.Rolegroup)
.WithMany(t => t.Roles)
.HasForeignKey(d => d.RolegroupId)
.HasConstraintName("FK_Role_RoleGroup");
#endregion
}
/// <summary>
/// Configures the entity of type <see cref="ConjureApp.Data.Entities.ProductDescription" />
/// </summary>
/// <param name="builder">The builder to be used to configure the entity type.</param>
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ConjureApp.Data.Entities.ProductDescription> builder)
{
#region Generated Configure
// table
builder.ToTable("ProductDescription", "SalesLT");
// key
builder.HasKey(t => t.ProductDescriptionID);
// properties
builder.Property(t => t.ProductDescriptionID)
.IsRequired()
.HasColumnName("ProductDescriptionID")
.HasColumnType("int")
.ValueGeneratedOnAdd()
;
builder.Property(t => t.Description)
.IsRequired()
.HasColumnName("Description")
.HasColumnType("nvarchar(400)")
.HasMaxLength(400)
;
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
#endregion // Generated Configure
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcCampaignPhonestatus> builder)
{
#region Generated Configure
// table
builder.ToTable("cc_campaign_phonestatus");
// key
builder.HasKey(t => new { t.IdPhonenumber, t.IdCampaign });
// properties
builder.Property(t => t.IdPhonenumber)
.IsRequired()
.HasColumnName("id_phonenumber")
.HasColumnType("bigint(20)");
builder.Property(t => t.IdCampaign)
.IsRequired()
.HasColumnName("id_campaign")
.HasColumnType("int(11)");
builder.Property(t => t.IdCallback)
.IsRequired()
.HasColumnName("id_callback")
.HasColumnType("varchar(40)")
.HasMaxLength(40);
builder.Property(t => t.Status)
.IsRequired()
.HasColumnName("status")
.HasColumnType("int(11)");
builder.Property(t => t.Lastuse)
.IsRequired()
.HasColumnName("lastuse")
.HasColumnType("timestamp(6)")
.HasDefaultValueSql("CURRENT_TIMESTAMP");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.SystemRole> builder)
{
#region Generated Configure
// table
builder.ToTable("System_Role", "dbo");
// key
builder.HasKey(t => t.RoleId);
// properties
builder.Property(t => t.RoleId)
.IsRequired()
.HasColumnName("RoleId")
.HasColumnType("int");
builder.Property(t => t.RoleName)
.HasColumnName("RoleName")
.HasColumnType("nvarchar(20)")
.HasMaxLength(20);
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.CreateDate)
.HasColumnName("CreateDate")
.HasColumnType("datetime");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.CcAgentSignup> builder)
{
#region Generated Configure
// table
builder.ToTable("cc_agent_signup");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("id")
.HasColumnType("bigint(20)")
.ValueGeneratedOnAdd();
builder.Property(t => t.IdAgent)
.IsRequired()
.HasColumnName("id_agent")
.HasColumnType("int(11)");
builder.Property(t => t.Code)
.IsRequired()
.HasColumnName("code")
.HasColumnType("varchar(30)")
.HasMaxLength(30);
builder.Property(t => t.IdTariffgroup)
.IsRequired()
.HasColumnName("id_tariffgroup")
.HasColumnType("int(11)");
builder.Property(t => t.IdGroup)
.IsRequired()
.HasColumnName("id_group")
.HasColumnType("int(11)");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.AspNetRoles> builder)
{
#region Generated Configure
// table
builder.ToTable("AspNetRoles", "dbo");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("Id")
.HasColumnType("uniqueidentifier");
builder.Property(t => t.Name)
.HasColumnName("Name")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
builder.Property(t => t.NormalizedName)
.HasColumnName("NormalizedName")
.HasColumnType("nvarchar(256)")
.HasMaxLength(256);
builder.Property(t => t.ConcurrencyStamp)
.HasColumnName("ConcurrencyStamp")
.HasColumnType("nvarchar(max)");
builder.Property(t => t.DisplayName)
.HasColumnName("DisplayName")
.HasColumnType("nvarchar(max)");
builder.Property(t => t.Description)
.HasColumnName("Description")
.HasColumnType("nvarchar(max)");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <CategoryTranslation> builder)
{
builder.ToTable("CategoryTranslations");
builder.HasKey(x => x.id);
builder.Property(x => x.id).UseIdentityColumn();
builder.Property(x => x.name).IsRequired().HasMaxLength(200);
builder.Property(x => x.slug).IsRequired().HasMaxLength(200);
builder.Property(x => x.brief).HasMaxLength(500);
builder.Property(x => x.title).HasMaxLength(200);
builder.Property(x => x.languageId).IsUnicode(false)
.IsRequired()
.HasMaxLength(5);
builder.HasOne(x => x.language)
.WithMany(x => x.categoryTranslations)
.HasForeignKey(x => x.languageId);
builder.HasOne(x => x.category)
.WithMany(x => x.categoryTranslations)
.HasForeignKey(x => x.categoryId);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ItemAudit> builder)
{
builder.HasKey(c => c.Id);
builder.ToTable("itemaudit");
builder.Property(p => p.Id)
.ValueGeneratedOnAdd();
builder.Property(p => p.HeaderAuditId);
builder.Property(p => p.FieldName)
.HasMaxLength(50);
builder.Property(p => p.PrimaryKey)
.HasMaxLength(50);
builder.Property(p => p.NewValue);
builder.HasOne <HeaderAudit>(s => s.HeaderAudit)
.WithMany(g => g.ItemAudits)
.HasForeignKey(s => s.HeaderAuditId);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.TaskNoviceLog> builder)
{
#region Generated Configure
// table
builder.ToTable("Task_NoviceLog", "dbo");
// key
builder.HasKey(t => t.NoviceLogId);
// properties
builder.Property(t => t.NoviceLogId)
.IsRequired()
.HasColumnName("NoviceLogId")
.HasColumnType("int")
.ValueGeneratedOnAdd();
builder.Property(t => t.TaskId)
.HasColumnName("TaskId")
.HasColumnType("int");
builder.Property(t => t.MemberId)
.HasColumnName("MemberId")
.HasColumnType("int");
builder.Property(t => t.CategoryDay)
.HasColumnName("CategoryDay")
.HasColumnType("int");
builder.Property(t => t.CategoryFixed)
.HasColumnName("CategoryFixed")
.HasColumnType("int");
builder.Property(t => t.IsEnable)
.HasColumnName("IsEnable")
.HasColumnType("int");
// relationships
#endregion
}
/// <summary>
/// Configures the entity of type <see cref="ConjureApp.Data.Entities.BuildVersion" />
/// </summary>
/// <param name="builder">The builder to be used to configure the entity type.</param>
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ConjureApp.Data.Entities.BuildVersion> builder)
{
#region Generated Configure
// table
builder.ToTable("BuildVersion", "dbo");
// key
builder.HasNoKey();
// properties
builder.Property(t => t.SystemInformationID)
.IsRequired()
.HasColumnName("SystemInformationID")
.HasColumnType("tinyint")
.ValueGeneratedOnAdd()
;
builder.Property(t => t.DatabaseVersion)
.IsRequired()
.HasColumnName("Database Version")
.HasColumnType("nvarchar(25)")
.HasMaxLength(25)
;
builder.Property(t => t.VersionDate)
.IsRequired()
.HasColumnName("VersionDate")
.HasColumnType("datetime")
;
builder.Property(t => t.ModifiedDate)
.IsRequired()
.HasColumnName("ModifiedDate")
.HasColumnType("datetime")
.HasDefaultValueSql("(getdate())")
;
// relationships
#endregion // Generated Configure
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Especialidad> builder)
{
var Especialidades = new List <Especialidad>();
Especialidades.Add(new Especialidad()
{
Id = 1, Nombre = "Especialidad 1"
});
Especialidades.Add(new Especialidad()
{
Id = 2, Nombre = "Especialidad 2"
});
Especialidades.Add(new Especialidad()
{
Id = 3, Nombre = "Especialidad 3"
});
Especialidades.Add(new Especialidad()
{
Id = 4, Nombre = "Especialidad 4"
});
builder.HasData(Especialidades.ToArray());
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Employee> entity)
{
entity.HasKey(e => e.Id);
entity.Property(e => e.FirstName)
.IsRequired(true)
.HasMaxLength(50);
entity.Property(e => e.LastName)
.IsRequired(true)
.HasMaxLength(50);
entity.Property(e => e.Birthday)
.IsRequired(false);
entity.Property(e => e.Address)
.IsRequired(false)
.HasMaxLength(250);
entity.Property(e => e.Salary)
.IsRequired(true);
}
public override void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Sysrole> 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.Rolename).HasMaxLength(500).IsRequired();
builder.Property(x => x.Roleremark).HasMaxLength(500).IsRequired();
builder.Property(x => x.MenuList).HasColumnType("text").IsRequired();
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Order> builder)
{
//Define properties to Order Entity
builder
.HasKey(o => o.Id);
builder
.ToTable("TB_ORDER");
//A order has many ExtraItems
builder
.HasMany(o => o.ExtraItems)
.WithOne()
.HasForeignKey(e => e.IdOrder)
.OnDelete(DeleteBehavior.Restrict);
//A order has only a car
//A car can exist witout a order but a order can't exist without a car
//>When you have a case when the relation is one to one yo have to put <Order> in the foreignKey to point that the order is the principal
builder
.HasOne(o => o.Car)
.WithOne()
.HasForeignKey <Order>(c => c.IdCar)
.OnDelete(DeleteBehavior.Restrict);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.AspNetUserLogins> builder)
{
#region Generated Configure
// table
builder.ToTable("AspNetUserLogins", "dbo");
// key
builder.HasKey(t => new { t.LoginProvider, t.ProviderKey });
// properties
builder.Property(t => t.LoginProvider)
.IsRequired()
.HasColumnName("LoginProvider")
.HasColumnType("nvarchar(450)")
.HasMaxLength(450);
builder.Property(t => t.ProviderKey)
.IsRequired()
.HasColumnName("ProviderKey")
.HasColumnType("nvarchar(450)")
.HasMaxLength(450);
builder.Property(t => t.ProviderDisplayName)
.HasColumnName("ProviderDisplayName")
.HasColumnType("nvarchar(max)");
builder.Property(t => t.UserId)
.IsRequired()
.HasColumnName("UserId")
.HasColumnType("uniqueidentifier");
// relationships
builder.HasOne(t => t.UserAspNetUsers)
.WithMany(t => t.UserAspNetUserLogins)
.HasForeignKey(d => d.UserId)
.HasConstraintName("FK_AspNetUserLogins_AspNetUsers_UserId");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AlternativaPergunta> builder)
{
builder.ToTable("alternativaprova");
builder.
Property(a => a.ID_alternativa).
HasColumnName("id_alternativaprova").IsRequired();
builder.
Property(a => a.ID_pergunta).
HasColumnName("id_pergunta").IsRequired();
builder.
Property(a => a.Resp_correto).
HasColumnName("resp_certa").
HasColumnType("varchar(1)").IsRequired();
builder.
Property(a => a.A).
HasColumnType("varchar(max)").IsRequired();
builder.
Property(a => a.B).
HasColumnType("varchar(max)").IsRequired();
builder.
Property(a => a.C).
HasColumnType("varchar(max)").IsRequired();
builder.
Property(a => a.D).
HasColumnType("varchar(max)").IsRequired();
builder.
Property(a => a.E).HasColumnType("varchar(max)");
builder.Property(a => a.figura_A).HasColumnType("figure");
builder.Property(a => a.figura_B).HasColumnType("figure");
builder.Property(a => a.figura_C).HasColumnType("figure");
builder.Property(a => a.figura_D).HasColumnType("figure");
builder.Property(a => a.figura_E).HasColumnType("figure");
builder.HasKey(a => a.ID_alternativa);
builder.HasKey(a => a.ID_pergunta);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <A2BillingService.Data.Entities.CcBillingCustomer> builder)
{
#region Generated Configure
// table
builder.ToTable("cc_billing_customer");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("id")
.HasColumnType("bigint(20)")
.ValueGeneratedOnAdd();
builder.Property(t => t.IdCard)
.IsRequired()
.HasColumnName("id_card")
.HasColumnType("bigint(20)");
builder.Property(t => t.Date)
.IsRequired()
.HasColumnName("date")
.HasColumnType("timestamp(6)")
.HasDefaultValueSql("CURRENT_TIMESTAMP");
builder.Property(t => t.IdInvoice)
.IsRequired()
.HasColumnName("id_invoice")
.HasColumnType("bigint(20)");
builder.Property(t => t.StartDate)
.HasColumnName("start_date")
.HasColumnType("timestamp(6)");
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <NesopsService.Data.Entities.AspNetUserTokens> builder)
{
#region Generated Configure
// table
builder.ToTable("AspNetUserTokens");
// key
builder.HasKey(t => new { t.UserId, t.LoginProvider, t.Name });
// properties
builder.Property(t => t.UserId)
.IsRequired()
.HasColumnName("UserId")
.HasColumnType("int(11)");
builder.Property(t => t.LoginProvider)
.IsRequired()
.HasColumnName("LoginProvider")
.HasColumnType("varchar(85)")
.HasMaxLength(85);
builder.Property(t => t.Name)
.IsRequired()
.HasColumnName("Name")
.HasColumnType("varchar(85)")
.HasMaxLength(85);
builder.Property(t => t.Value)
.HasColumnName("Value")
.HasColumnType("longtext");
// relationships
builder.HasOne(t => t.UserAspNetUsers)
.WithMany(t => t.UserAspNetUserTokens)
.HasForeignKey(d => d.UserId)
.HasConstraintName("FK_AspNetUserTokens_AspNetUsers_UserId");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.SystemUsersDictionary> builder)
{
#region Generated Configure
// table
builder.ToTable("System_UsersDictionary", "dbo");
// key
builder.HasKey(t => t.Id);
// properties
builder.Property(t => t.Id)
.IsRequired()
.HasColumnName("Id")
.HasColumnType("int")
.ValueGeneratedOnAdd();
builder.Property(t => t.UserId)
.IsRequired()
.HasColumnName("UserId")
.HasColumnType("int");
builder.Property(t => t.DictionaryKey)
.HasColumnName("DictionaryKey")
.HasColumnType("varchar(20)")
.HasMaxLength(20);
builder.Property(t => t.DictionaryValue)
.HasColumnName("DictionaryValue")
.HasColumnType("nvarchar(100)")
.HasMaxLength(100);
// relationships
builder.HasOne(t => t.UserSystemUsers)
.WithMany(t => t.UserSystemUsersDictionaries)
.HasForeignKey(d => d.UserId)
.HasConstraintName("FK_SYSTEM_U_REFERENCE_SYSTEM_UC");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.PersonCreditCard> builder)
{
#region Generated Configure
// table
builder.ToTable("PersonCreditCard", "Sales");
// key
builder.HasKey(t => new { t.BusinessEntityID, t.CreditCardID });
// properties
builder.Property(t => t.BusinessEntityID)
.IsRequired()
.HasColumnName("BusinessEntityID")
.HasColumnType("int");
builder.Property(t => t.CreditCardID)
.IsRequired()
.HasColumnName("CreditCardID")
.HasColumnType("int");
builder.Property(t => t.ModifiedDate)
.IsRequired()
.HasColumnName("ModifiedDate")
.HasColumnType("datetime")
.HasDefaultValueSql("(getdate())");
// relationships
builder.HasOne(t => t.CreditCard)
.WithMany(t => t.PersonCreditCards)
.HasForeignKey(d => d.CreditCardID)
.HasConstraintName("FK_PersonCreditCard_CreditCard_CreditCardID");
builder.HasOne(t => t.Person)
.WithMany(t => t.PersonCreditCards)
.HasForeignKey(d => d.BusinessEntityID)
.HasConstraintName("FK_PersonCreditCard_Person_BusinessEntityID");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AutoNews.Data.Entities.SystemDictionary> builder)
{
#region Generated Configure
// table
builder.ToTable("System_Dictionary", "dbo");
// key
builder.HasKey(t => t.DictionaryId);
// properties
builder.Property(t => t.DictionaryId)
.IsRequired()
.HasColumnName("DictionaryId")
.HasColumnType("int")
.ValueGeneratedOnAdd();
builder.Property(t => t.Keys)
.HasColumnName("Keys")
.HasColumnType("varchar(50)")
.HasMaxLength(50);
builder.Property(t => t.Name)
.HasColumnName("Name")
.HasColumnType("nvarchar(255)")
.HasMaxLength(255);
builder.Property(t => t.Value)
.HasColumnName("Value")
.HasColumnType("nvarchar(1000)")
.HasMaxLength(1000);
builder.Property(t => t.Remarks)
.HasColumnName("Remarks")
.HasColumnType("nvarchar(255)")
.HasMaxLength(255);
// relationships
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.ProductModelIllustration> builder)
{
#region Generated Configure
// table
builder.ToTable("ProductModelIllustration", "Production");
// key
builder.HasKey(t => new { t.ProductModelID, t.IllustrationID });
// properties
builder.Property(t => t.ProductModelID)
.IsRequired()
.HasColumnName("ProductModelID")
.HasColumnType("int");
builder.Property(t => t.IllustrationID)
.IsRequired()
.HasColumnName("IllustrationID")
.HasColumnType("int");
builder.Property(t => t.ModifiedDate)
.IsRequired()
.HasColumnName("ModifiedDate")
.HasColumnType("datetime")
.HasDefaultValueSql("(getdate())");
// relationships
builder.HasOne(t => t.Illustration)
.WithMany(t => t.ProductModelIllustrations)
.HasForeignKey(d => d.IllustrationID)
.HasConstraintName("FK_ProductModelIllustration_Illustration_IllustrationID");
builder.HasOne(t => t.ProductModel)
.WithMany(t => t.ProductModelIllustrations)
.HasForeignKey(d => d.ProductModelID)
.HasConstraintName("FK_ProductModelIllustration_ProductModel_ProductModelID");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AdventureWorks.Data.Models.JobCandidate> builder)
{
#region Generated Configure
// table
builder.ToTable("JobCandidate", "HumanResources");
// key
builder.HasKey(t => t.JobCandidateID);
// properties
builder.Property(t => t.JobCandidateID)
.IsRequired()
.HasColumnName("JobCandidateID")
.HasColumnType("int")
.ValueGeneratedOnAdd();
builder.Property(t => t.BusinessEntityID)
.HasColumnName("BusinessEntityID")
.HasColumnType("int");
builder.Property(t => t.Resume)
.HasColumnName("Resume")
.HasColumnType("xml");
builder.Property(t => t.ModifiedDate)
.IsRequired()
.HasColumnName("ModifiedDate")
.HasColumnType("datetime")
.HasDefaultValueSql("(getdate())");
// relationships
builder.HasOne(t => t.Employee)
.WithMany(t => t.JobCandidates)
.HasForeignKey(d => d.BusinessEntityID)
.HasConstraintName("FK_JobCandidate_Employee_BusinessEntityID");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Servuniv.Data.Entities.Plandeestudios> builder)
{
#region Generated Configure
// table
builder.ToTable("plandeestudios", "dbo");
// key
builder.HasKey(t => t.Idplan);
// properties
builder.Property(t => t.Idplan)
.IsRequired()
.HasColumnName("idplan")
.HasColumnType("int");
builder.Property(t => t.Idcarrera)
.IsRequired()
.HasColumnName("idcarrera")
.HasColumnType("int");
builder.Property(t => t.Fecha)
.IsRequired()
.HasColumnName("fecha")
.HasColumnType("date");
builder.Property(t => t.Idestado)
.IsRequired()
.HasColumnName("idestado")
.HasColumnType("int");
// relationships
builder.HasOne(t => t.Carreras)
.WithMany(t => t.Plandeestudios)
.HasForeignKey(d => d.Idcarrera)
.HasConstraintName("FK_plandeestudios_carreras");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Schedule> builder)
{
builder.ToTable("schedules", SchemaNames.Accessibility);
builder.HasKey(b => b.Id);
builder.Property(b => b.Id).HasColumnName("schedule_id");
builder.Property(b => b.FacilityId).HasColumnName("facility_id");
builder.Property("name");
builder.Property("startDate").HasColumnName("start_date");
builder.Property("endDate").HasColumnName("end_date");
builder.Property <EmployeeId>("creatorId").HasColumnName("creator_id");
builder.Property("creationDate").HasColumnName("creation_date");
builder.Property("modifyDate").HasColumnName("modify_date");
builder.Property("version").IsConcurrencyToken();
builder.OwnsMany <Availability>("availabilities", x =>
{
x.WithOwner().HasForeignKey("schedule_id");
x.ToTable("availabilities", SchemaNames.Accessibility);
x.HasKey("Id");
x.Property("Id").HasColumnName("availability_id");
x.Property <EmployeeId>("employeeId").HasColumnName("employee_id");
x.Property("StartTime").HasColumnName("start_time");
x.Property("EndTime").HasColumnName("end_time");
x.Property("Priority").HasColumnName("priority");
x.Property <EmployeeId>("creatorId").HasColumnName("creator_id");
x.Property("creationDate").HasColumnName("creation_date");
});
}
