ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Members/MemberItemConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Members;

public sealed class MemberItemConfiguration : IEntityTypeConfiguration<MemberItem>
{
    public void Configure(EntityTypeBuilder<MemberItem> builder)
    {
        builder.ToTable(nameof(MemberItem), t => t.HasComment("계정 귀속 소모품 아이템"));
        builder.HasKey(x => x.ID);

        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.Product).WithMany().HasForeignKey(x => x.ProductID).IsRequired(false).OnDelete(DeleteBehavior.Restrict);

        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.MemberID).IsRequired().HasComment("회원 ID");
        builder.Property(x => x.ProductID).IsRequired().HasComment("상품 ID");
        builder.Property(x => x.OrderItemID).IsRequired().HasComment("발급 근거 주문항목 ID");
        builder.Property(x => x.Kind).HasComment("아이템 종류 (5~11)");
        builder.Property(x => x.DurationDays).IsRequired().HasDefaultValue(0).HasComment("효과 지속일 (0=즉시소모)");
        builder.Property(x => x.AcquiredAt).IsRequired().HasComment("획득 일시");
        builder.Property(x => x.UsedAt).HasComment("소모/활성 일시 (null=미사용)");
        builder.Property(x => x.RevokedAt).HasComment("회수 일시 (환불)");
        builder.Property(x => x.RowVersion).IsRowVersion();

        builder.HasIndex(x => new { x.MemberID, x.Kind, x.UsedAt });
        builder.HasIndex(x => x.OrderItemID);
    }
}