67 lines
3.1 KiB
C#
67 lines
3.1 KiB
C#
using System.ComponentModel.DataAnnotations.Schema;
|
|
using System.Data.Entity.ModelConfiguration;
|
|
|
|
namespace IntegrationTests.Models.Mapping
|
|
{
|
|
public class SC_TotalSeatsAcrossExpCatsMap : EntityTypeConfiguration<SC_TotalSeatsAcrossExpCats>
|
|
{
|
|
public SC_TotalSeatsAcrossExpCatsMap()
|
|
{
|
|
// Primary Key
|
|
this.HasKey(t => new { t.ScenarioType, t.ScenarioName, t.ShowObjectID, t.ShowName, t.ShowTypeObjectID, t.ShowStatusObjectID, t.Probability, t.ExpenditureCatObjectID });
|
|
|
|
// Properties
|
|
this.Property(t => t.CGEFX)
|
|
.IsFixedLength()
|
|
.HasMaxLength(10);
|
|
|
|
this.Property(t => t.ScenarioType)
|
|
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);
|
|
|
|
this.Property(t => t.ScenarioName)
|
|
.IsRequired()
|
|
.HasMaxLength(200);
|
|
|
|
this.Property(t => t.ShowName)
|
|
.IsRequired()
|
|
.HasMaxLength(200);
|
|
|
|
this.Property(t => t.ShowStatusName)
|
|
.HasMaxLength(200);
|
|
|
|
this.Property(t => t.Probability)
|
|
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);
|
|
|
|
this.Property(t => t.ShowColor)
|
|
.HasMaxLength(16);
|
|
|
|
this.Property(t => t.ScenarioColor)
|
|
.HasMaxLength(16);
|
|
|
|
// Table & Column Mappings
|
|
this.ToTable("SC_TotalSeatsAcrossExpCats");
|
|
this.Property(t => t.ScenarioObjectID).HasColumnName("ScenarioObjectID");
|
|
this.Property(t => t.WeekEndingDate).HasColumnName("WeekEndingDate");
|
|
this.Property(t => t.Quantity).HasColumnName("Quantity");
|
|
this.Property(t => t.Cost).HasColumnName("Cost");
|
|
this.Property(t => t.CGEFX).HasColumnName("CGEFX");
|
|
this.Property(t => t.ScenarioType).HasColumnName("ScenarioType");
|
|
this.Property(t => t.ScenarioName).HasColumnName("ScenarioName");
|
|
this.Property(t => t.ShowObjectID).HasColumnName("ShowObjectID");
|
|
this.Property(t => t.ShowName).HasColumnName("ShowName");
|
|
this.Property(t => t.ShowTypeObjectID).HasColumnName("ShowTypeObjectID");
|
|
this.Property(t => t.ShowStatusObjectID).HasColumnName("ShowStatusObjectID");
|
|
this.Property(t => t.ShowStatusName).HasColumnName("ShowStatusName");
|
|
this.Property(t => t.Probability).HasColumnName("Probability");
|
|
this.Property(t => t.ShowColor).HasColumnName("ShowColor");
|
|
this.Property(t => t.ScenarioColor).HasColumnName("ScenarioColor");
|
|
this.Property(t => t.ExpenditureCatObjectID).HasColumnName("ExpenditureCatObjectID");
|
|
this.Property(t => t.Status).HasColumnName("Status");
|
|
this.Property(t => t.SystemAttributeObjectID).HasColumnName("SystemAttributeObjectID");
|
|
this.Property(t => t.GroupId).HasColumnName("GroupId");
|
|
this.Property(t => t.SystemAttributeOne).HasColumnName("SystemAttributeOne");
|
|
this.Property(t => t.SystemAttributeTwo).HasColumnName("SystemAttributeTwo");
|
|
}
|
|
}
|
|
}
|