public void Configure(EntityTypeBuilder <GarmentPreparingItemReadModel> builder)
{
builder.ToTable("GarmentPreparingItems");
builder.HasKey(e => e.Identity);
builder.HasOne(a => a.GarmentPreparingIdentity)
.WithMany(a => a.GarmentPreparingItem)
.HasForeignKey(a => a.GarmentPreparingId);
builder.Property(o => o.ProductCode)
.HasMaxLength(25);
builder.Property(o => o.ProductName)
.HasMaxLength(100);
builder.Property(o => o.UomUnit)
.HasMaxLength(100);
builder.Property(o => o.DesignColor)
.HasMaxLength(2000);
builder.Property(o => o.FabricType)
.HasMaxLength(100);
builder.Property(o => o.ROSource)
.HasMaxLength(100);
builder.Property(o => o.UId)
.HasMaxLength(255);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentSubconCuttingReadModel> builder)
{
builder.ToTable("GarmentSubconCuttings");
builder.HasKey(e => e.Identity);
builder.Property(a => a.SizeName)
.HasMaxLength(100);
builder.Property(a => a.RONo)
.HasMaxLength(50);
builder.Property(a => a.ProductCode)
.HasMaxLength(25);
builder.Property(a => a.ProductName)
.HasMaxLength(100);
builder.Property(a => a.DesignColor)
.HasMaxLength(2000);
builder.Property(a => a.ComodityCode)
.HasMaxLength(25);
builder.Property(a => a.ComodityName)
.HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentDeliveryReturnReadModel> builder)
{
builder.ToTable("GarmentDeliveryReturns");
builder.HasKey(e => e.Identity);
builder.Property(a => a.DRNo)
.HasMaxLength(25);
builder.Property(a => a.RONo)
.HasMaxLength(100);
builder.Property(a => a.Article)
.HasMaxLength(100);
builder.Property(a => a.UnitDONo)
.HasMaxLength(100);
builder.Property(a => a.ReturnType)
.HasMaxLength(25);
builder.Property(a => a.UnitCode)
.HasMaxLength(25);
builder.Property(a => a.UnitName)
.HasMaxLength(100);
builder.Property(a => a.StorageCode)
.HasMaxLength(25);
builder.Property(a => a.StorageName)
.HasMaxLength(100);
builder.HasIndex(i => i.DRNo).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentSubconCuttingRelationReadModel> builder)
{
builder.ToTable("GarmentSubconCuttingRelations");
builder.HasKey(e => e.Identity);
builder.HasIndex(i => i.GarmentCuttingOutDetailId).IsUnique().HasFilter("[Deleted]=(0)");
builder.HasIndex(i => new { i.GarmentCuttingOutDetailId, i.GarmentSubconCuttingId }).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentBalanceStockProductionReadModel> builder)
{
builder.ToTable("GarmentBalanceStockProductions");
builder.HasKey(e => e.Identity);
builder.Property(a => a.RO)
.HasMaxLength(25);
builder.Property(a => a.ArticleNo)
.HasMaxLength(100);
builder.Property(a => a.ComodityName)
.HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentComodityPriceReadModel> builder)
{
builder.ToTable("GarmentComodityPrices");
builder.HasKey(e => e.Identity);
builder.Property(p => p.UnitCode).HasMaxLength(25);
builder.Property(p => p.UnitName).HasMaxLength(100);
builder.Property(p => p.ComodityCode).HasMaxLength(25);
builder.Property(p => p.ComodityName).HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentAvalProductReadModel> builder)
{
builder.ToTable("GarmentAvalProducts");
builder.HasKey(e => e.Identity);
builder.Property(a => a.RONo).HasMaxLength(100);
builder.Property(a => a.Article).HasMaxLength(100);
builder.Property(p => p.UnitCode).HasMaxLength(25);
builder.Property(p => p.UnitName).HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentExpenditureGoodItemReadModel> builder)
{
builder.ToTable("GarmentExpenditureGoodItems");
builder.HasKey(e => e.Identity);
builder.HasOne(a => a.GarmentExpenditureGood)
.WithMany(a => a.Items)
.HasForeignKey(a => a.ExpenditureGoodId);
builder.Property(a => a.SizeName).HasMaxLength(100);
builder.Property(a => a.UomUnit).HasMaxLength(10);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentScrapStockReadModel> builder)
{
builder.ToTable("GarmentScrapStocks");
builder.HasKey(e => e.Identity);
builder.Property(a => a.UomUnit)
.HasMaxLength(25);
builder.Property(a => a.ScrapDestinationName)
.HasMaxLength(100);
builder.Property(a => a.ScrapClassificationName)
.HasMaxLength(100);
builder.Property(a => a.UomUnit)
.HasMaxLength(25);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentCuttingInItemReadModel> builder)
{
builder.ToTable("GarmentCuttingInItems");
builder.HasKey(e => e.Identity);
builder.Property(p => p.UENNo).HasMaxLength(100);
builder.Property(p => p.SewingOutNo).HasMaxLength(50);
builder.Property(p => p.UId).HasMaxLength(255);
builder.HasOne(w => w.GarmentCuttingIn)
.WithMany(h => h.Items)
.HasForeignKey(f => f.CutInId);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentScrapDestinationReadModel> builder)
{
builder.ToTable("GarmentScrapDestinations");
builder.HasKey(e => e.Identity);
builder.Property(a => a.Code)
.HasMaxLength(25);
builder.Property(a => a.Name)
.HasMaxLength(50);
builder.Property(a => a.UId)
.HasMaxLength(10);
builder.Property(a => a.Description)
.HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentFinishingOutDetailReadModel> builder)
{
builder.ToTable("GarmentFinishingOutDetails");
builder.HasKey(e => e.Identity);
builder.HasOne(a => a.GarmentFinishingOutItemIdentity)
.WithMany(a => a.GarmentFinishingOutDetail)
.HasForeignKey(a => a.FinishingOutItemId);
builder.Property(a => a.SizeName)
.HasMaxLength(100);
builder.Property(a => a.UomUnit)
.HasMaxLength(25);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentScrapTransactionItemReadModel> builder)
{
builder.ToTable("GarmentScrapTransactionItems");
builder.HasKey(e => e.Identity);
builder.HasOne(a => a.GarmentScrapTransactionIdentity)
.WithMany(a => a.GarmentScrapTransactionItem)
.HasForeignKey(a => a.ScrapTransactionId);
builder.Property(a => a.UomUnit)
.HasMaxLength(25);
builder.Property(a => a.Description)
.HasMaxLength(100);
builder.Property(a => a.ScrapClassificationName)
.HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentScrapTransactionReadModel> builder)
{
builder.ToTable("GarmentScrapTransactions");
builder.HasKey(e => e.Identity);
builder.Property(o => o.TransactionNo)
.HasMaxLength(25);
builder.Property(o => o.TransactionType)
.HasMaxLength(25);
builder.Property(o => o.ScrapDestinationName)
.HasMaxLength(100);
builder.Property(o => o.ScrapSourceName)
.HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentAvalComponentItemReadModel> builder)
{
builder.ToTable("GarmentAvalComponentItems");
builder.HasKey(e => e.Identity);
builder.Property(p => p.ProductCode).HasMaxLength(25);
builder.Property(p => p.ProductName).HasMaxLength(100);
builder.Property(p => p.DesignColor).HasMaxLength(2000);
builder.Property(p => p.Color).HasMaxLength(50);
builder.Property(p => p.SizeName).HasMaxLength(100);
builder.HasOne(w => w.GarmentAvalComponent)
.WithMany(h => h.Items)
.HasForeignKey(f => f.AvalComponentId);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentFinishedGoodStockHistoryReadModel> builder)
{
builder.ToTable("GarmentFinishedGoodStockHistories");
builder.HasKey(e => e.Identity);
builder.Property(a => a.StockType).HasMaxLength(50);
builder.Property(a => a.RONo).HasMaxLength(25);
builder.Property(a => a.Article).HasMaxLength(50);
builder.Property(a => a.UnitCode).HasMaxLength(25);
builder.Property(a => a.UnitName).HasMaxLength(100);
builder.Property(a => a.ComodityCode).HasMaxLength(25);
builder.Property(a => a.ComodityName).HasMaxLength(100);
builder.Property(a => a.SizeName).HasMaxLength(50);
builder.Property(a => a.UomUnit).HasMaxLength(100);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentCuttingInReadModel> builder)
{
builder.ToTable("GarmentCuttingIns");
builder.HasKey(e => e.Identity);
builder.Property(p => p.CutInNo).HasMaxLength(25);
builder.Property(p => p.CuttingType).HasMaxLength(25);
builder.Property(p => p.CuttingFrom).HasMaxLength(25);
builder.Property(p => p.RONo).HasMaxLength(25);
builder.Property(p => p.Article).HasMaxLength(50);
builder.Property(p => p.UnitCode).HasMaxLength(25);
builder.Property(p => p.UnitName).HasMaxLength(100);
builder.Property(p => p.UId).HasMaxLength(255);
builder.HasIndex(i => i.CutInNo).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentSewingDOItemReadModel> builder)
{
builder.ToTable("GarmentSewingDOItems");
builder.HasKey(e => e.Identity);
builder.HasOne(a => a.GarmentSewingDOIdentity)
.WithMany(a => a.GarmentSewingDOItem)
.HasForeignKey(a => a.SewingDOId);
builder.Property(a => a.ProductCode).HasMaxLength(25);
builder.Property(a => a.ProductName).HasMaxLength(100);
builder.Property(a => a.DesignColor).HasMaxLength(2000);
builder.Property(a => a.SizeName).HasMaxLength(100);
builder.Property(a => a.UomUnit).HasMaxLength(10);
builder.Property(a => a.Color).HasMaxLength(1000);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder<GarmentAvalComponentReadModel> builder)
{
builder.ToTable("GarmentAvalComponents");
builder.HasKey(e => e.Identity);
builder.Property(p => p.AvalComponentNo).HasMaxLength(25);
builder.Property(p => p.UnitCode).HasMaxLength(25);
builder.Property(p => p.UnitName).HasMaxLength(100);
builder.Property(p => p.AvalComponentType).HasMaxLength(25);
builder.Property(p => p.RONo).HasMaxLength(25);
builder.Property(p => p.Article).HasMaxLength(50);
builder.Property(p => p.ComodityCode).HasMaxLength(25);
builder.Property(p => p.ComodityName).HasMaxLength(100);
builder.HasIndex(i => i.AvalComponentNo).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentFinishedGoodStockReadModel> builder)
{
builder.ToTable("GarmentFinishedGoodStocks");
builder.HasKey(e => e.Identity);
builder.Property(a => a.FinishedGoodStockNo).HasMaxLength(25);
builder.Property(a => a.RONo).HasMaxLength(25);
builder.Property(a => a.Article).HasMaxLength(50);
builder.Property(a => a.UnitCode).HasMaxLength(25);
builder.Property(a => a.UnitName).HasMaxLength(100);
builder.Property(a => a.ComodityCode).HasMaxLength(25);
builder.Property(a => a.ComodityName).HasMaxLength(100);
builder.Property(a => a.SizeName).HasMaxLength(50);
builder.Property(a => a.UomUnit).HasMaxLength(100);
builder.HasIndex(i => i.FinishedGoodStockNo).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentSewingDOReadModel> builder)
{
builder.ToTable("GarmentSewingDOs");
builder.HasKey(e => e.Identity);
builder.Property(a => a.SewingDONo).HasMaxLength(25);
builder.Property(a => a.UnitFromCode).HasMaxLength(25);
builder.Property(a => a.UnitFromName).HasMaxLength(100);
builder.Property(a => a.UnitCode).HasMaxLength(25);
builder.Property(a => a.UnitName).HasMaxLength(100);
builder.Property(a => a.RONo).HasMaxLength(25);
builder.Property(a => a.Article).HasMaxLength(50);
builder.Property(a => a.ComodityCode).HasMaxLength(25);
builder.Property(a => a.ComodityName).HasMaxLength(100);
builder.HasIndex(i => i.SewingDONo).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentCuttingInDetailReadModel> builder)
{
builder.ToTable("GarmentCuttingInDetails");
builder.HasKey(e => e.Identity);
builder.Property(p => p.ProductCode).HasMaxLength(25);
builder.Property(p => p.ProductName).HasMaxLength(100);
builder.Property(p => p.DesignColor).HasMaxLength(2000);
builder.Property(p => p.FabricType).HasMaxLength(25);
builder.Property(p => p.PreparingUomUnit).HasMaxLength(10);
builder.Property(p => p.CuttingInUomUnit).HasMaxLength(10);
builder.Property(p => p.Color).HasMaxLength(50);
builder.Property(p => p.UId).HasMaxLength(255);
builder.HasOne(w => w.GarmentCuttingInItem)
.WithMany(h => h.Details)
.HasForeignKey(f => f.CutInItemId);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentExpenditureGoodReadModel> builder)
{
builder.ToTable("GarmentExpenditureGoods");
builder.HasKey(e => e.Identity);
builder.Property(a => a.ExpenditureGoodNo).HasMaxLength(25);
builder.Property(a => a.RONo).HasMaxLength(25);
builder.Property(a => a.Article).HasMaxLength(50);
builder.Property(a => a.UnitCode).HasMaxLength(25);
builder.Property(a => a.UnitName).HasMaxLength(100);
builder.Property(a => a.ComodityCode).HasMaxLength(25);
builder.Property(a => a.ComodityName).HasMaxLength(100);
builder.Property(a => a.Invoice).HasMaxLength(50);
builder.Property(a => a.BuyerName).HasMaxLength(100);
builder.Property(a => a.BuyerCode).HasMaxLength(25);
builder.Property(a => a.ExpenditureType).HasMaxLength(25);
builder.HasIndex(i => i.ExpenditureGoodNo).IsUnique().HasFilter("[Deleted]=(0)");
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
public void Configure(EntityTypeBuilder <GarmentPreparingReadModel> builder)
{
builder.ToTable("GarmentPreparings");
builder.HasKey(e => e.Identity);
builder.Property(o => o.UENNo)
.HasMaxLength(100);
builder.Property(o => o.UnitCode)
.HasMaxLength(25);
builder.Property(o => o.UnitName)
.HasMaxLength(100);
builder.Property(o => o.RONo)
.HasMaxLength(100);
builder.Property(o => o.Article)
.HasMaxLength(500);
builder.Property(o => o.BuyerCode)
.HasMaxLength(100);
builder.Property(o => o.BuyerName)
.HasMaxLength(500);
builder.Property(o => o.UId)
.HasMaxLength(255);
builder.ApplyAuditTrail();
builder.ApplySoftDelete();
}
