ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Stocks/DerivMasterConfiguration.cs

using Domain.Entities.Stocks;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Persistence.Configurations.Stocks;

public sealed class DerivMasterConfiguration : IEntityTypeConfiguration<DerivMaster>
{
    public void Configure(EntityTypeBuilder<DerivMaster> builder)
    {
        builder.ToTable(nameof(DerivMaster), t => t.HasComment("SEIBro 파생결합증권 종목 정보 (getDerivCombiIsinInfo) — 원금보전·만기·발행잔량·기초자산수. ELS/DLS 상세 마스터"));
        builder.HasKey(x => x.Isin);
        builder.HasIndex(x => x.IssucoCustno);
        builder.HasIndex(x => x.XpirDt);

        builder.Property(x => x.Isin).HasMaxLength(12).HasComment("종목코드 (ISIN)");
        builder.Property(x => x.KorSecnNm).HasMaxLength(100).HasComment("한글종목명 (KOR_SECN_NM)");
        builder.Property(x => x.IssucoCustno).HasComment("발행회사고객번호 (ISSUCO_CUSTNO)");
        builder.Property(x => x.SecnKanm).HasMaxLength(20).HasComment("종목구분명 (SECN_KANM) — ELS/ELB/ELW/DLS/DLB/ETN");
        builder.Property(x => x.IssuCurCd).HasMaxLength(3).HasComment("발행통화코드 (ISSU_CUR_CD)");
        builder.Property(x => x.RecuWhcd).HasMaxLength(2).HasComment("모집방법코드 (RECU_WHCD) — 11공모 21사모");
        builder.Property(x => x.FirstIssuQty).HasColumnType("decimal(20,2)").HasComment("최초발행수량 (FIRST_ISSU_QTY)");
        builder.Property(x => x.IssuRemq).HasColumnType("decimal(20,2)").HasComment("발행잔량 (ISSU_REMQ)");
        builder.Property(x => x.PayinAmtRatio).HasColumnType("decimal(15,10)").HasComment("납입금액비율 (PAYIN_AMT_RATIO)");
        builder.Property(x => x.PayinAmt).HasColumnType("decimal(20,2)").HasComment("납입금액 (PAYIN_AMT)");
        builder.Property(x => x.IssuDt).HasComment("발행일자 (ISSU_DT)");
        builder.Property(x => x.ContDt).HasComment("계약일자 (CONT_DT)");
        builder.Property(x => x.XpirDt).HasComment("만기일자 (XPIR_DT)");
        builder.Property(x => x.MidredPossYn).HasComment("중도상환가능여부 (MIDRED_POSS_YN)");
        builder.Property(x => x.RedDt).HasComment("상환일자 (RED_DT)");
        builder.Property(x => x.DerisecExerTpcd).HasMaxLength(1).HasComment("파생증권권리행사구분코드 (DERISEC_EXER_TPCD) — 2만기 3조기");
        builder.Property(x => x.PrcpPrsvTpcd).HasMaxLength(1).HasComment("원금보전구분코드 (PRCP_PRSV_TPCD) — 1보장 2부분 3비보장");
        builder.Property(x => x.PrcpPrsvRate).HasColumnType("decimal(8,3)").HasComment("원금보전율 (PRCP_PRSV_RATE)");
        builder.Property(x => x.ColatSetupTpcd).HasMaxLength(1).HasComment("담보설정구분코드 (COLAT_SETUP_TPCD) — 1설정 2미설정");
        builder.Property(x => x.BassetCnt).HasComment("기초자산 개수 (BASSET_CNT)");
        builder.Property(x => x.MmPayYn).HasComment("월지급여부 (MM_PAY_YN)");
    }
}