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

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

namespace Infrastructure.Persistence.Configurations.Stocks;

public sealed class EsgIndexDailyPriceConfiguration : IEntityTypeConfiguration<EsgIndexDailyPrice>
{
    public void Configure(EntityTypeBuilder<EsgIndexDailyPrice> builder)
    {
        builder.ToTable(nameof(EsgIndexDailyPrice), t => t.HasComment("ESG 지수 일별시세 (KRX OpenAPI esg/esg_index_info)"));
        builder.HasKey(x => x.ID);
        builder.HasIndex(x => new { x.IndexName, x.TradeDate }).IsUnique();
        builder.HasIndex(x => x.TradeDate);

        builder.Property(x => x.IndexName).HasMaxLength(100).IsRequired().HasComment("지수명 (IDX_NM)");
        builder.Property(x => x.Close).HasPrecision(18, 2).HasComment("현재가/종가 (CLSPRC_IDX)");
        builder.Property(x => x.ChangeVal).HasPrecision(18, 2).HasComment("전일비 (PRV_DD_CMPR)");
        builder.Property(x => x.FlucRateBp).HasComment("등락률 basis point (%×100, UPDN_RATE)");
        builder.Property(x => x.ConstituentCount).HasComment("구성종목수 (TRD_ISU_CNT)");
        builder.Property(x => x.Volume).HasComment("거래량 (ACC_TRDVOL, 천주)");
        builder.Property(x => x.Value).HasComment("거래대금 (ACC_TRDVAL, 백만원)");
    }
}