ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Paper/PaperDailySnapshotConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Paper;

public sealed class PaperDailySnapshotConfiguration : IEntityTypeConfiguration<PaperDailySnapshot>
{
    public void Configure(EntityTypeBuilder<PaperDailySnapshot> builder)
    {
        builder.HasOne(x => x.Account).WithMany().HasForeignKey(x => x.AccountID).OnDelete(DeleteBehavior.Cascade);
        builder.HasIndex(x => new { x.AccountID, x.TradeDate }).IsUnique();
        builder.HasIndex(x => new { x.TradeDate, x.CumReturnBp }).IsDescending(false, true);

        builder.ToTable(nameof(PaperDailySnapshot), t => t.HasComment("모의투자 계좌 일별 스냅샷 (좌수 NAV·수익률·MDD)"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.AccountID).IsRequired().HasComment("계좌 ID");
        builder.Property(x => x.TradeDate).IsRequired().HasComment("거래일");
        builder.Property(x => x.Token).HasPrecision(18, 0).IsRequired().HasComment("자유+예약 토큰");
        builder.Property(x => x.PositionsValue).HasPrecision(18, 0).IsRequired().HasComment("포지션 평가액");
        builder.Property(x => x.Equity).HasPrecision(18, 0).IsRequired().HasComment("순자산");
        builder.Property(x => x.UnitNav).HasPrecision(18, 8).IsRequired().HasComment("좌당 순자산");
        builder.Property(x => x.DailyReturnBp).IsRequired().HasComment("일간 수익률 Bp");
        builder.Property(x => x.CumReturnBp).IsRequired().HasComment("누적 수익률 Bp");
        builder.Property(x => x.PeakEquity).HasPrecision(18, 0).IsRequired().HasComment("최고 순자산");
        builder.Property(x => x.MddBp).IsRequired().HasComment("최대 낙폭 Bp");
        builder.Property(x => x.FillCountCum).IsRequired().HasComment("누적 체결 수");
        builder.Property(x => x.CreatedAt).IsRequired();
    }
}