ShortTermIssuanceConfiguration.cs 1.4 KB

1234567891011121314151617181920212223
  1. using Domain.Entities.Stocks;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Stocks;
  5. public sealed class ShortTermIssuanceConfiguration : IEntityTypeConfiguration<ShortTermIssuance>
  6. {
  7. public void Configure(EntityTypeBuilder<ShortTermIssuance> builder)
  8. {
  9. builder.ToTable(nameof(ShortTermIssuance), t => t.HasComment("SEIBro 단기금융증권 발행내역 (getShortmIssuInfo) — CD/CP/전단채. Cd/Cp/EstbMaster rolling 발견 소스"));
  10. builder.HasKey(x => x.ID);
  11. builder.HasIndex(x => x.Isin).IsUnique();
  12. builder.HasIndex(x => new { x.SecnTpcd, x.IssuDt });
  13. builder.Property(x => x.Isin).HasMaxLength(12).IsRequired().HasComment("종목코드 (ISIN)");
  14. builder.Property(x => x.KorSecnNm).HasMaxLength(100).HasComment("한글종목명 (KOR_SECN_NM)");
  15. builder.Property(x => x.IssucoCustno).HasComment("발행회사고객번호 (ISSUCO_CUSTNO)");
  16. builder.Property(x => x.IssucoCustNm).HasMaxLength(100).HasComment("발행회사 명칭 (ISSUCO_CUST_NM)");
  17. builder.Property(x => x.SecnTpcd).HasMaxLength(2).IsRequired().HasComment("종목구분코드 (SECN_TPCD, 요청값 스탬핑) — 12어음(CP) 13CD 14전단채");
  18. builder.Property(x => x.IssuDt).IsRequired().HasComment("발행일자 (ISSU_DT, 요청값 스탬핑)");
  19. }
  20. }