ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Forum/Posts/PostPredictionConfiguration.cs

using Domain.Entities.Forum.Posts;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Persistence.Configurations.Forum.Posts;

public sealed class PostPredictionConfiguration : IEntityTypeConfiguration<PostPrediction>
{
    public void Configure(EntityTypeBuilder<PostPrediction> builder)
    {
        builder.ToTable(nameof(PostPrediction), t => t.HasComment("예측글 (방향/기간 예측 + 채점)"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.PostID).IsRequired().HasComment("게시글 ID (1:1)");
        builder.Property(x => x.MemberID).IsRequired().HasComment("작성 회원 ID");
        builder.Property(x => x.StockCode).HasMaxLength(6).IsFixedLength().IsRequired().HasComment("예측 종목 단축코드");
        builder.Property(x => x.Direction).HasConversion<byte>().IsRequired().HasComment("예측 방향 (1=상승, 2=하락)");
        builder.Property(x => x.BasePrice).HasPrecision(18, 2).IsRequired().HasComment("작성 시점 기준가");
        builder.Property(x => x.TargetPrice).HasPrecision(18, 2).HasComment("목표가 (선택)");
        builder.Property(x => x.HorizonDays).IsRequired().HasComment("예측 기간 (영업일 수)");
        builder.Property(x => x.DueDate).IsRequired().HasComment("채점 예정일");
        builder.Property(x => x.Status).HasConversion<byte>().IsRequired().HasComment("상태 (0=Pending/1=Hit/2=Miss/3=Void)");
        builder.Property(x => x.SettledPrice).HasPrecision(18, 2).HasComment("채점 시점 종가");
        builder.Property(x => x.SettledAt).HasComment("채점 일시");
        builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");

        builder.HasIndex(x => x.PostID).IsUnique();
        builder.HasIndex(x => new { x.Status, x.DueDate });
        builder.HasIndex(x => new { x.MemberID, x.Status });

        builder.HasOne(x => x.Post).WithMany().HasForeignKey(x => x.PostID).OnDelete(DeleteBehavior.Cascade);
        // MemberID 는 필수 — 예측 작성자는 항상 보존(채점·트랙레코드 귀속). 회원 삭제 시 삭제 차단.
        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).IsRequired().OnDelete(DeleteBehavior.Restrict);
    }
}