public ContingentMapping()
{
ToTable(UniversityMappingHelper.GetTableName <ContingentInfo> (pluralize: false));
HasKey(m => m.ContingentId);
Property(m => m.AvgAdmScore).IsOptional();
Property(m => m.AdmittedFB).IsOptional();
Property(m => m.AdmittedRB).IsOptional();
Property(m => m.AdmittedMB).IsOptional();
Property(m => m.AdmittedBC).IsOptional();
Property(m => m.ActualFB).IsOptional();
Property(m => m.ActualRB).IsOptional();
Property(m => m.ActualMB).IsOptional();
Property(m => m.ActualBC).IsOptional();
Property(m => m.VacantFB).IsOptional();
Property(m => m.VacantRB).IsOptional();
Property(m => m.VacantMB).IsOptional();
Property(m => m.VacantBC).IsOptional();
Property(m => m.MovedIn).IsOptional();
Property(m => m.MovedOut).IsOptional();
Property(m => m.Restored).IsOptional();
Property(m => m.Expelled).IsOptional();
HasRequired(m => m.EduProgramProfileFormYear).WithOptional(x => x.Contingent);
}
public EduProgramProfileMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduProgramProfileInfo> ());
HasKey(m => m.EduProgramProfileID);
Property(m => m.EduProgramProfileID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.EduProgramID).IsRequired();
Property(m => m.EduLevelId).IsRequired();
Property(m => m.ProfileCode).IsOptional();
Property(m => m.ProfileTitle).IsOptional();
Property(m => m.Languages).IsOptional();
Property(m => m.IsAdopted).IsRequired();
Property(m => m.ELearning).IsRequired();
Property(m => m.DistanceEducation).IsRequired();
Property(m => m.AccreditedToDate).IsOptional();
Property(m => m.CommunityAccreditedToDate).IsOptional();
Property(m => m.StartDate).IsOptional();
Property(m => m.EndDate).IsOptional();
Property(m => m.LastModifiedByUserId);
Property(m => m.LastModifiedOnDate);
Property(m => m.CreatedByUserId);
Property(m => m.CreatedOnDate);
HasRequired(m => m.EduProgram).WithMany().HasForeignKey(m => m.EduProgramID);
HasRequired(m => m.EduLevel).WithMany().HasForeignKey(m => m.EduLevelId);
HasMany(m => m.Documents).WithOptional().HasForeignKey(d => d.EduProgramProfileId);
HasMany(m => m.EduProgramProfileFormYears).WithRequired().HasForeignKey(eppfy => eppfy.EduProgramProfileId);
}
public EduFormMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduFormInfo> ());
HasKey(m => m.EduFormID);
Property(m => m.EduFormID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.IsSystem).IsRequired();
Property(m => m.Title).IsRequired();
Property(m => m.ShortTitle).IsOptional();
}
public YearMapping()
{
ToTable(UniversityMappingHelper.GetTableName <YearInfo> ());
HasKey(m => m.YearId);
Property(m => m.YearId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.Year).IsRequired();
Property(m => m.AdmissionIsOpen).IsRequired();
}
public AchievementTypeMapping()
{
ToTable(UniversityMappingHelper.GetTableName <AchievementTypeInfo> ());
HasKey(m => m.AchievementTypeId);
Property(m => m.AchievementTypeId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.Type).IsRequired();
Property(m => m.Description).IsOptional();
Property(m => m.IsSystem).IsRequired();
}
public PositionMapping()
{
ToTable(UniversityMappingHelper.GetTableName <PositionInfo> ());
HasKey(m => m.PositionID);
Property(m => m.PositionID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.Title).IsRequired();
Property(m => m.ShortTitle).IsOptional();
Property(m => m.Weight).IsRequired();
Property(m => m.IsTeacher).IsRequired();
}
public DocumentTypeMapping()
{
ToTable(UniversityMappingHelper.GetTableName <DocumentTypeInfo> ());
HasKey(m => m.DocumentTypeID);
Property(m => m.DocumentTypeID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.Type).IsRequired();
Property(m => m.Description).IsOptional();
Property(m => m.IsSystem).IsRequired();
Property(m => m.FilenameFormat).IsOptional();
}
public AchievementMapping()
{
ToTable(UniversityMappingHelper.GetTableName <AchievementInfo> ());
HasKey(m => m.AchievementID);
Property(m => m.AchievementID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.AchievementTypeId).IsOptional();
Property(m => m.Title).IsRequired();
Property(m => m.ShortTitle).IsOptional();
HasOptional(m => m.AchievementType).WithMany().HasForeignKey(m => m.AchievementTypeId);
}
public EduLevelMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduLevelInfo> ());
HasKey(m => m.EduLevelID);
Property(m => m.EduLevelID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.Title).IsRequired();
Property(m => m.ShortTitle).IsOptional();
Property(m => m.SortIndex).IsRequired();
Property(m => m.ParentEduLevelId);
HasOptional(m => m.ParentEduLevel).WithMany().HasForeignKey(m => m.ParentEduLevelId);
}
public EmployeeDisciplineMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EmployeeDisciplineInfo> ());
HasKey(m => m.EmployeeDisciplineID);
Property(m => m.EmployeeDisciplineID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.EmployeeID).IsRequired();
Property(m => m.EduProgramProfileID).IsRequired();
Property(m => m.Disciplines).IsOptional();
HasRequired(m => m.Employee).WithMany(e => e.Disciplines).HasForeignKey(m => m.EmployeeID);
HasRequired(m => m.EduProgramProfile).WithMany().HasForeignKey(m => m.EduProgramProfileID);
}
public ScienceRecordTypeMapping()
{
ToTable(UniversityMappingHelper.GetTableName <ScienceRecordTypeInfo> ());
HasKey(m => m.ScienceRecordTypeId);
Property(m => m.ScienceRecordTypeId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.Type).IsRequired();
Property(m => m.IsSystem).IsRequired();
Property(m => m.DescriptionIsRequired).IsRequired();
Property(m => m.NumOfValues).IsRequired();
Property(m => m.TypeOfValues).IsRequired();
Property(m => m.SortIndex).IsRequired();
}
public EduProgramProfileFormMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduProgramProfileFormInfo> ());
HasKey(m => m.EduProgramProfileFormID);
Property(m => m.EduProgramProfileFormID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.EduProgramProfileID).IsRequired();
Property(m => m.EduFormID).IsRequired();
Property(m => m.TimeToLearn).IsRequired();
Property(m => m.TimeToLearnHours).IsRequired();
Property(m => m.IsAdmissive).IsRequired();
HasRequired(m => m.EduForm).WithMany().HasForeignKey(m => m.EduFormID);
}
public EduProgramDivisionMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduProgramDivisionInfo> ());
HasKey(m => m.EduProgramDivisionId);
Property(m => m.EduProgramDivisionId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.DivisionId).IsRequired();
Property(m => m.EduProgramId).IsOptional();
Property(m => m.EduProgramProfileId).IsOptional();
Property(m => m.DivisionRole).IsOptional();
HasRequired(m => m.Division).WithMany().HasForeignKey(m => m.DivisionId);
}
public ScienceRecordMapping()
{
ToTable(UniversityMappingHelper.GetTableName <ScienceRecordInfo> ());
HasKey(m => m.ScienceRecordId);
Property(m => m.ScienceRecordId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.ScienceRecordId).IsRequired();
Property(m => m.ScienceRecordTypeId).IsRequired();
Property(m => m.EduProgramId).IsRequired();
Property(m => m.Description).IsOptional();
Property(m => m.Value1).IsOptional();
Property(m => m.Value2).IsOptional();
HasRequired(m => m.ScienceRecordType).WithMany().HasForeignKey(m => m.ScienceRecordTypeId);
}
public DocumentMapping()
{
ToTable(UniversityMappingHelper.GetTableName <DocumentInfo> ());
HasKey(m => m.DocumentID);
Property(m => m.DocumentID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.DocumentTypeID).IsRequired();
Property(m => m.EduProgramId).IsOptional();
Property(m => m.EduProgramProfileId).IsOptional();
Property(m => m.Title).IsOptional();
Property(m => m.Group).IsOptional();
Property(m => m.Url).IsOptional();
Property(m => m.SortIndex).IsRequired();
Property(m => m.StartDate).IsOptional();
Property(m => m.EndDate).IsOptional();
HasRequired(m => m.DocumentType).WithMany().HasForeignKey(m => m.DocumentTypeID);
}
public OccupiedPositionMapping()
{
ToTable(UniversityMappingHelper.GetTableName <OccupiedPositionInfo> ());
HasKey(m => m.OccupiedPositionID);
Property(m => m.OccupiedPositionID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.PositionID).IsRequired();
Property(m => m.DivisionID).IsRequired();
Property(m => m.EmployeeID).IsRequired();
HasRequired <PositionInfo> (m => m.Position).WithMany().HasForeignKey(m => m.PositionID);
HasRequired <DivisionInfo> (m => m.Division).WithMany().HasForeignKey(m => m.DivisionID);
HasRequired <EmployeeInfo> (m => m.Employee).WithMany().HasForeignKey(m => m.EmployeeID);
Property(m => m.IsPrime);
Property(m => m.TitleSuffix);
}
public EmployeeAchievementMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EmployeeAchievementInfo> ());
HasKey(m => m.EmployeeAchievementID);
Property(m => m.EmployeeAchievementID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.AchievementID).IsOptional();
Property(m => m.AchievementTypeId).IsOptional();
Property(m => m.Description).IsOptional();
Property(m => m.Title).IsOptional();
Property(m => m.ShortTitle).IsOptional();
Property(m => m.YearBegin).IsOptional();
Property(m => m.YearEnd).IsOptional();
Property(m => m.IsTitle).IsRequired();
Property(m => m.DocumentURL).IsRequired();
Property(m => m.TitleSuffix).IsOptional();
HasOptional(m => m.Achievement).WithMany().HasForeignKey(m => m.AchievementID);
HasOptional(m => m.AchievementType).WithMany().HasForeignKey(m => m.AchievementTypeId);
}
public DivisionMapping()
{
ToTable(UniversityMappingHelper.GetTableName <DivisionInfo> ());
HasKey(m => m.DivisionID);
Property(m => m.DivisionID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.ParentDivisionID).IsOptional();
Property(m => m.DivisionTermID).IsOptional();
Property(m => m.HeadPositionID).IsOptional();
Property(m => m.Title).IsRequired();
Property(m => m.ShortTitle);
Property(m => m.HomePage);
Property(m => m.WebSite);
Property(m => m.WebSiteLabel);
Property(m => m.Phone);
Property(m => m.Fax);
Property(m => m.Email);
Property(m => m.SecondaryEmail);
Property(m => m.Address);
Property(m => m.Location);
Property(m => m.WorkingHours);
Property(m => m.DocumentUrl);
Property(m => m.IsSingleEntity);
Property(m => m.IsInformal);
Property(m => m.IsGoverning);
Property(m => m.StartDate).IsOptional();
Property(m => m.EndDate).IsOptional();
Property(m => m.LastModifiedByUserID);
Property(m => m.LastModifiedOnDate);
Property(m => m.CreatedByUserID);
Property(m => m.CreatedOnDate);
Ignore(m => m.Level);
Ignore(m => m.Path);
HasMany(m => m.SubDivisions).WithRequired().HasForeignKey(sd => sd.ParentDivisionID);
HasMany(m => m.OccupiedPositions).WithRequired().HasForeignKey(op => op.DivisionID);
}
public EduProgramProfileFormYearMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduProgramProfileFormYearInfo> ());
HasKey(m => m.EduProgramProfileFormYearId);
Property(m => m.EduProgramProfileFormYearId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.EduProgramProfileId).IsRequired();
Property(m => m.EduFormId).IsRequired();
Property(m => m.YearId).IsRequired();
Property(m => m.StartDate).IsOptional();
Property(m => m.EndDate).IsOptional();
HasRequired(m => m.EduProgramProfile).WithMany(x => x.EduProgramProfileFormYears).HasForeignKey(m => m.EduProgramProfileId);
HasRequired(m => m.EduForm).WithMany().HasForeignKey(m => m.EduFormId);
HasRequired(m => m.Year).WithMany().HasForeignKey(m => m.YearId);
HasOptional(m => m.EduVolume).WithRequired(x => x.EduProgramProfileFormYear);
HasOptional(m => m.Contingent).WithRequired(x => x.EduProgramProfileFormYear);
}
public EduVolumeMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduVolumeInfo> (pluralize: false));
HasKey(m => m.EduVolumeId);
Property(m => m.TimeToLearnHours).IsRequired();
Property(m => m.TimeToLearnMonths).IsRequired();
Property(m => m.Year1Cu).IsOptional();
Property(m => m.Year2Cu).IsOptional();
Property(m => m.Year3Cu).IsOptional();
Property(m => m.Year4Cu).IsOptional();
Property(m => m.Year5Cu).IsOptional();
Property(m => m.Year6Cu).IsOptional();
Property(m => m.PracticeType1Cu).IsOptional();
Property(m => m.PracticeType2Cu).IsOptional();
Property(m => m.PracticeType3Cu).IsOptional();
HasRequired(m => m.EduProgramProfileFormYear).WithOptional(x => x.EduVolume);
}
public ScienceMapping()
{
ToTable(UniversityMappingHelper.GetTableName <ScienceInfo> (pluralize: false));
HasKey(m => m.ScienceId);
Property(m => m.Directions).IsOptional();
Property(m => m.Base).IsOptional();
Property(m => m.Scientists).IsOptional();
Property(m => m.Students).IsOptional();
Property(m => m.Monographs).IsOptional();
Property(m => m.Articles).IsOptional();
Property(m => m.ArticlesForeign).IsOptional();
Property(m => m.Patents).IsOptional();
Property(m => m.PatentsForeign).IsOptional();
Property(m => m.Certificates).IsOptional();
Property(m => m.CertificatesForeign).IsOptional();
Property(m => m.FinancingByScientist).HasPrecision(18, 3).IsOptional();
HasRequired(m => m.EduProgram).WithOptional(x => x.Science);
}
public EmployeeMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EmployeeInfo> ());
HasKey(m => m.EmployeeID);
Property(m => m.EmployeeID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.UserID).IsOptional();
Property(m => m.PhotoFileID).IsOptional();
Property(m => m.LastName).IsRequired();
Property(m => m.FirstName).IsRequired();
Property(m => m.OtherName);
Property(m => m.Phone);
Property(m => m.CellPhone);
Property(m => m.Fax);
Property(m => m.Email);
Property(m => m.SecondaryEmail);
Property(m => m.WebSite);
Property(m => m.WebSiteLabel);
Property(m => m.Messenger);
Property(m => m.Biography);
Property(m => m.WorkingPlace);
Property(m => m.WorkingHours);
Property(m => m.ExperienceYears).IsOptional();
Property(m => m.ExperienceYearsBySpec).IsOptional();
Property(m => m.StartDate).IsOptional();
Property(m => m.EndDate).IsOptional();
Property(m => m.LastModifiedByUserId);
Property(m => m.LastModifiedOnDate);
Property(m => m.CreatedByUserId);
Property(m => m.CreatedOnDate);
Property(m => m.ShowBarcode);
HasMany(m => m.Positions).WithRequired().HasForeignKey(x => x.EmployeeID);
HasMany(m => m.Disciplines).WithRequired(ed => ed.Employee).HasForeignKey(x => x.EmployeeID);
HasMany(m => m.Achievements).WithRequired().HasForeignKey(x => x.EmployeeID);
}
public EduProgramMapping()
{
ToTable(UniversityMappingHelper.GetTableName <EduProgramInfo> ());
HasKey(m => m.EduProgramID);
Property(m => m.EduProgramID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
Property(m => m.EduLevelID).IsRequired();
Property(m => m.Code).IsRequired();
Property(m => m.Title).IsRequired();
Property(m => m.Generation).IsOptional();
Property(m => m.HomePage).IsOptional();
Property(m => m.StartDate).IsOptional();
Property(m => m.EndDate).IsOptional();
Property(m => m.LastModifiedByUserId);
Property(m => m.LastModifiedOnDate);
Property(m => m.CreatedByUserId);
Property(m => m.CreatedOnDate);
HasRequired(m => m.EduLevel).WithMany().HasForeignKey(m => m.EduLevelID);
HasMany(m => m.Documents).WithOptional().HasForeignKey(x => x.EduProgramId);
HasMany(m => m.EduProgramProfiles).WithRequired(epp => epp.EduProgram).HasForeignKey(epp => epp.EduProgramID);
}
