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

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

namespace Infrastructure.Persistence.Configurations.Stocks;

public sealed class BondIndexDailyPriceConfiguration : IEntityTypeConfiguration<BondIndexDailyPrice>
{
    public void Configure(EntityTypeBuilder<BondIndexDailyPrice> builder)
    {
        builder.ToTable(nameof(BondIndexDailyPrice), t => t.HasComment("채권지수 일별시세 (KRX OpenAPI idx/bon_dd_trd)"));
        builder.HasKey(x => x.ID);
        builder.HasIndex(x => new { x.GroupName, x.TradeDate }).IsUnique();
        builder.HasIndex(x => x.TradeDate);

        builder.Property(x => x.GroupName).HasMaxLength(100).IsRequired().HasComment("채권지수 그룹명 (BND_IDX_GRP_NM)");
        builder.Property(x => x.TotalEarningIndex).HasPrecision(18, 4).HasComment("총수익지수 (TOT_EARNG_IDX)");
        builder.Property(x => x.TotalEarningChange).HasPrecision(18, 4).HasComment("총수익지수 전일 대비");
        builder.Property(x => x.NetPriceIndex).HasPrecision(18, 4).HasComment("순가격지수 (NETPRC_IDX)");
        builder.Property(x => x.NetPriceChange).HasPrecision(18, 4).HasComment("순가격지수 전일 대비");
        builder.Property(x => x.ZeroReinvestIndex).HasPrecision(18, 4).HasComment("제로재투자지수 (ZERO_REINVST_IDX)");
        builder.Property(x => x.ZeroReinvestChange).HasPrecision(18, 4).HasComment("제로재투자지수 전일 대비");
        builder.Property(x => x.CallReinvestIndex).HasPrecision(18, 4).HasComment("Call재투자지수 (CALL_REINVST_IDX)");
        builder.Property(x => x.CallReinvestChange).HasPrecision(18, 4).HasComment("Call재투자지수 전일 대비");
        builder.Property(x => x.MarketPriceIndex).HasPrecision(18, 4).HasComment("시장가격지수 (MKT_PRC_IDX)");
        builder.Property(x => x.MarketPriceChange).HasPrecision(18, 4).HasComment("시장가격지수 전일 대비");
        builder.Property(x => x.AvgDuration).HasPrecision(18, 4).HasComment("평균 듀레이션 (AVG_DURATION)");
        builder.Property(x => x.AvgConvexity).HasPrecision(18, 4).HasComment("평균 컨벡시티 (AVG_CONVEXITY_PRC)");
        builder.Property(x => x.AvgYield).HasPrecision(18, 4).HasComment("평균 만기수익률 YTM (BND_IDX_AVG_YD)");
    }
}