using Domain.Entities.Forum.Posts; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Metadata.Builders; namespace Infrastructure.Persistence.Configurations.Forum.Posts; public sealed class PostPredictionConfiguration : IEntityTypeConfiguration { public void Configure(EntityTypeBuilder 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().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().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); } }