| 123456789101112131415161718192021222324252627282930313233 |
- using Domain.Entities.Stocks;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Metadata.Builders;
- namespace Infrastructure.Persistence.Configurations.Stocks;
- public sealed class DerivAssetConfiguration : IEntityTypeConfiguration<DerivAsset>
- {
- public void Configure(EntityTypeBuilder<DerivAsset> builder)
- {
- builder.ToTable(nameof(DerivAsset), t => t.HasComment("SEIBro 파생결합증권 기초자산 정보 (getAssetInfo) — 기초자산명·행사기준가·평가일. StndBassetCd 는 반환 원문(KSD31* 체계 가능)"));
- builder.HasKey(x => x.ID);
- builder.HasIndex(x => new { x.Isin, x.AssetSeq }).IsUnique();
- builder.HasIndex(x => x.StndBassetCd);
- builder.Property(x => x.Isin).HasMaxLength(12).IsRequired().HasComment("종목코드 (ISIN, 스탬핑)");
- builder.Property(x => x.AssetSeq).HasComment("자산일련번호 (ASSET_SEQ)");
- builder.Property(x => x.StndBassetCd).HasMaxLength(12).HasComment("표준기초자산코드 (STND_BASSET_CD) — 원문(KSD31*·KR7* 등)");
- builder.Property(x => x.StndBassetNm).HasMaxLength(200).HasComment("표준기초자산명 (STND_BASSET_NM)");
- builder.Property(x => x.XrcStdprc).HasColumnType("decimal(28,10)").HasComment("행사기준가 (XRC_STDPRC)");
- builder.Property(x => x.XrcStopLolmtRatio).HasColumnType("decimal(8,3)").HasComment("행사정지하한비율 (XRC_STOP_LOLMT_RATIO)");
- builder.Property(x => x.XrcStopLolmtPrice).HasColumnType("decimal(28,10)").HasComment("행사정지하한가격 (XRC_STOP_LOLMT_PRICE)");
- builder.Property(x => x.XrcStopUplmtRatio).HasColumnType("decimal(8,3)").HasComment("행사정지상한비율 (XRC_STOP_UPLMT_RATIO)");
- builder.Property(x => x.XrcStopUplmtPrice).HasColumnType("decimal(28,10)").HasComment("행사정지상한가격 (XRC_STOP_UPLMT_PRICE)");
- builder.Property(x => x.BassetFirstValatTpcd).HasMaxLength(1).HasComment("기초자산최초평가구분코드 (BASSET_FIRST_VALAT_TPCD)");
- builder.Property(x => x.BassetLastValatTpcd).HasMaxLength(1).HasComment("기초자산최종평가구분코드 (BASSET_LAST_VALAT_TPCD)");
- builder.Property(x => x.FirstStdprcDecsnBeginDt).HasComment("최초기준가결정시작일자 (FIRST_STDPRC_DECSN_BEGIN_DT)");
- builder.Property(x => x.FirstStdprcDecsnExpryDt).HasComment("최초기준가결정종료일자 (FIRST_STDPRC_DECSN_EXPRY_DT)");
- builder.Property(x => x.LastStdprcDecsnBeginDt).HasComment("최종기준가결정시작일자 (LAST_STDPRC_DECSN_BEGIN_DT)");
- builder.Property(x => x.LastStdprcDecsnExpryDt).HasComment("최종기준가결정종료일자 (LAST_STDPRC_DECSN_EXPRY_DT)");
- builder.Property(x => x.RvltSeverTpcd).HasMaxLength(1).HasComment("절상절사구분코드 (RVLT_SEVER_TPCD)");
- }
- }
|