ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Common/ConfigConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Common;

public sealed class ConfigConfiguration : IEntityTypeConfiguration<Config>
{
    public void Configure(EntityTypeBuilder<Config> builder)
    {
        builder.ToTable(nameof(Config), x => x.HasComment("운영 정보 설정 값"));

        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.LastUpdatedAt).IsRequired().HasComment("마지막 수정일시");
        builder.Property(x => x.RowVersion).IsRowVersion().HasComment("동시성 제어용");

        builder.OwnsOne(x => x.Basic, owned =>
        {
            owned.Property(x => x.SiteName).HasMaxLength(100).HasColumnName("Basic_SiteName").HasComment("사이트 이름");
            owned.Property(x => x.SiteURL).HasMaxLength(100).HasColumnName("Basic_SiteURL").HasComment("사이트 주소");
            owned.Property(x => x.RootID).HasMaxLength(100).HasColumnName("Basic_RootID").HasComment("최고 관리자 ID");
            owned.Property(x => x.FromEmail).HasMaxLength(100).HasColumnName("Basic_FromEmail").HasComment("송수신 이메일");
            owned.Property(x => x.FromName).HasMaxLength(30).HasColumnName("Basic_FromName").HasComment("송수신자 이름");
            owned.Property(x => x.SmtpServer).HasMaxLength(200).HasColumnName("Basic_SmtpServer").HasComment("SMTP Server");
            owned.Property(x => x.SmtpPort).HasColumnName("Basic_SmtpPort").HasComment("SMTP Port");
            owned.Property(x => x.SmtpEnableSSL).HasColumnName("Basic_SmtpEnableSSL").HasComment("SMTP Enable SSL");
            owned.Property(x => x.SmtpUsername).HasMaxLength(100).HasColumnName("Basic_SmtpUsername").HasComment("SMTP Username");
            owned.Property(x => x.SmtpPassword).HasMaxLength(200).HasColumnName("Basic_SmtpPassword").HasComment("SMTP Password");
            owned.Property(x => x.AdminWhiteIPList).HasMaxLength(1000).HasColumnName("Basic_AdminWhiteIPList").HasComment("관리자단 접근 가능 IP");
            owned.Property(x => x.FrontWhiteIPList).HasMaxLength(1000).HasColumnName("Basic_FrontWhiteIPList").HasComment("사용자단 접근 가능 IP");
            owned.Property(x => x.BlockAlertTitle).HasMaxLength(200).HasColumnName("Basic_BlockAlertTitle").HasComment("차단 시 안내문 제목");
            owned.Property(x => x.BlockAlertContent).HasMaxLength(5000).HasColumnName("Basic_BlockAlertContent").HasComment("차단 시 안내문 내용");
            owned.Property(x => x.IsMaintenance).HasColumnName("Basic_IsMaintenance").HasComment("점검 여부");
            owned.Property(x => x.MaintenanceContent).HasMaxLength(5000).HasColumnName("Basic_MaintenanceContent").HasComment("점검 내용");
            owned.Property(x => x.NoteDailySendLimit).HasColumnName("Basic_NoteDailySendLimit").HasDefaultValue(3).HasComment("쪽지 일일 발송 제한 (사용자 1인당, 시스템 제외)");
        });

        builder.OwnsOne(x => x.Images, owned =>
        {
            owned.Property(x => x.Favicon).HasMaxLength(255).HasColumnName("Images_Favicon").HasComment("Favicon");
            owned.Property(x => x.LogoSquare).HasMaxLength(255).HasColumnName("Images_LogoSquare").HasComment("Logo-square");
            owned.Property(x => x.LogoHorizontal).HasMaxLength(255).HasColumnName("Images_LogoHorizontal").HasComment("Logo-horizontal");
            owned.Property(x => x.OgDefault).HasMaxLength(255).HasColumnName("Images_OgDefault").HasComment("og-default");
            owned.Property(x => x.TwitterImage).HasMaxLength(255).HasColumnName("Images_TwitterImage").HasComment("Twitter-image");
            owned.Property(x => x.AppleTouchIcon).HasMaxLength(255).HasColumnName("Images_AppleTouchIcon").HasComment("Apple-touch-icon");
            owned.Property(x => x.AppIcon_192).HasMaxLength(255).HasColumnName("Images_AppIcon_192").HasComment("App-icon-192");
            owned.Property(x => x.AppIcon_512).HasMaxLength(255).HasColumnName("Images_AppIcon_512").HasComment("App-icon-512");
        });

        builder.OwnsOne(x => x.Meta, owned =>
        {
            owned.Property(x => x.Keywords).HasMaxLength(255).HasColumnName("Meta_Keywords").HasComment("Meta Keywords");
            owned.Property(x => x.Description).HasMaxLength(255).HasColumnName("Meta_Description").HasComment("Meta Description");
            owned.Property(x => x.Author).HasMaxLength(255).HasColumnName("Meta_Author").HasComment("Meta Author");
            owned.Property(x => x.Viewport).HasMaxLength(255).HasColumnName("Meta_Viewport").HasComment("Meta Viewport");
            owned.Property(x => x.ApplicationName).HasMaxLength(255).HasColumnName("Meta_ApplicationName").HasComment("Meta Application Name");
            owned.Property(x => x.Generator).HasMaxLength(255).HasColumnName("Meta_Generator").HasComment("Meta Generator");
            owned.Property(x => x.Robots).HasMaxLength(255).HasColumnName("Meta_Robots").HasComment("Meta Robots");
        });

        builder.OwnsOne(x => x.Company, owned =>
        {
            owned.Property(x => x.Name).HasMaxLength(70).HasColumnName("Company_Name").HasComment("상호 명");
            owned.Property(x => x.RegNo).HasMaxLength(100).HasColumnName("Company_RegNo").HasComment("사업자 등록 번호");
            owned.Property(x => x.Address).HasMaxLength(255).HasColumnName("Company_Address").HasComment("사업장 소재지");
            owned.Property(x => x.ZipCode).HasMaxLength(8).HasColumnName("Company_ZipCode").HasComment("사업장 주소(우편번호)");
            owned.Property(x => x.Owner).HasMaxLength(50).HasColumnName("Company_Owner").HasComment("대표자 명");
            owned.Property(x => x.Tel).HasMaxLength(20).HasColumnName("Company_Tel").HasComment("대표 전화번호");
            owned.Property(x => x.Fax).HasMaxLength(20).HasColumnName("Company_Fax").HasComment("FAX");
            owned.Property(x => x.RetailSaleNo).HasMaxLength(20).HasColumnName("Company_RetailSaleNo").HasComment("통신판매업 신고번호");
            owned.Property(x => x.AddedSaleNo).HasMaxLength(20).HasColumnName("Company_AddedSaleNo").HasComment("부가통신 사업자번호");
            owned.Property(x => x.Hosting).HasMaxLength(100).HasColumnName("Company_Hosting").HasComment("호스팅 서비스");
            owned.Property(x => x.AdminName).HasMaxLength(70).HasColumnName("Company_AdminName").HasComment("정보관리책임자");
            owned.Property(x => x.AdminEmail).HasMaxLength(100).HasColumnName("Company_AdminEmail").HasComment("정보관리책임자 이메일");
            owned.Property(x => x.SiteUrl).HasMaxLength(200).HasColumnName("Company_SiteUrl").HasComment("사이트 주소");
            owned.Property(x => x.BankCode).HasMaxLength(10).HasColumnName("Company_BankCode").HasComment("입금계좌 - 은행");
            owned.Property(x => x.BankOwner).HasMaxLength(70).HasColumnName("Company_BankOwner").HasComment("입금계좌 - 예금주");
            owned.Property(x => x.BankNumber).HasMaxLength(100).HasColumnName("Company_BankNumber").HasComment("입금계좌 - 계좌번호");
        });

        builder.OwnsOne(x => x.Account, owned =>
        {
            owned.Property(x => x.IsRegisterBlock).HasColumnName("Account_IsRegisterBlock").HasComment("회원가입 차단");
            owned.Property(x => x.IsRegisterEmailAuth).HasColumnName("Account_IsRegisterEmailAuth").HasComment("회원가입 시 이메일 인증");
            owned.Property(x => x.PasswordMinLength).HasColumnName("Account_PasswordMinLength").HasComment("비밀번호 최소 길이");
            owned.Property(x => x.PasswordUppercaseLength).HasColumnName("Account_PasswordUppercaseLength").HasComment("비밀번호 최소 대문자 수");
            owned.Property(x => x.PasswordNumbersLength).HasColumnName("Account_PasswordNumbersLength").HasComment("비밀번호 최소 숫자 수");
            owned.Property(x => x.PasswordSpecialcharsLength).HasColumnName("Account_PasswordSpecialcharsLength").HasComment("비밀번호 최소 특수문자 수");
            owned.Property(x => x.DeniedEmailList).HasColumnName("Account_DeniedEmailList").HasComment("금지 이메일");
            owned.Property(x => x.DeniedNameList).HasColumnName("Account_DeniedNameList").HasComment("금지 별명");
            owned.Property(x => x.ChangeEmailDay).HasColumnName("Account_ChangeEmailDay").HasComment("이메일 갱신 주기(일)");
            owned.Property(x => x.ChangeNameDay).HasColumnName("Account_ChangeNameDay").HasComment("별명 갱신 주기(일)");
            owned.Property(x => x.ChangeSummaryDay).HasColumnName("Account_ChangeSummaryDay").HasComment("한마디 갱신 주기(일)");
            owned.Property(x => x.ChangeIntroDay).HasColumnName("Account_ChangeIntroDay").HasComment("자기소개 갱신 주기(일)");
            owned.Property(x => x.ChangeThumbDay).HasColumnName("Account_ChangeThumbDay").HasComment("프로필 이미지 갱신 주기(일)");
            owned.Property(x => x.ChangePasswordDay).HasColumnName("Account_ChangePasswordDay").HasComment("비밀번호 갱신 주기(일)");
            owned.Property(x => x.MaxLoginTryCount).HasColumnName("Account_MaxLoginTryCount").HasComment("로그인 시도 제한 횟수");
            owned.Property(x => x.MaxLoginTryLimitSecond).HasColumnName("Account_MaxLoginTryLimitSecond").HasComment("로그인 시도 제한 시간(초)");
        });

        builder.OwnsOne(x => x.EmailTemplate, owned =>
        {
            owned.Property(x => x.RegisterEmailFormTitle).HasColumnName("EmailTemplate_RegisterEmailFormTitle").HasComment("회원가입 시 - 제목");
            owned.Property(x => x.RegisterEmailFormContent).HasColumnName("EmailTemplate_RegisterEmailFormContent").HasComment("회원가입 시 - 내용");
            owned.Property(x => x.RegistrationEmailFormTitle).HasColumnName("EmailTemplate_RegistrationEmailFormTitle").HasComment("회원가입 완료 - 제목");
            owned.Property(x => x.RegistrationEmailFormContent).HasColumnName("EmailTemplate_RegistrationEmailFormContent").HasComment("회원가입 완료 - 내용");
            owned.Property(x => x.ResetPasswordEmailFormTitle).HasColumnName("EmailTemplate_ResetPasswordEmailFormTitle").HasComment("비밀번호 재설정 - 제목");
            owned.Property(x => x.ResetPasswordEmailFormContent).HasColumnName("EmailTemplate_ResetPasswordEmailFormContent").HasComment("비밀번호 재설정 - 내용");
            owned.Property(x => x.ChangedPasswordEmailFormTitle).HasColumnName("EmailTemplate_ChangedPasswordEmailFormTitle").HasComment("비밀번호 변경 완료 - 제목");
            owned.Property(x => x.ChangedPasswordEmailFormContent).HasColumnName("EmailTemplate_ChangedPasswordEmailFormContent").HasComment("비밀번호 변경 완료 - 내용");
            owned.Property(x => x.WithdrawEmailFormTitle).HasColumnName("EmailTemplate_WithdrawEmailFormTitle").HasComment("회원탈퇴 시 - 제목");
            owned.Property(x => x.WithdrawEmailFormContent).HasColumnName("EmailTemplate_WithdrawEmailFormContent").HasComment("회원탈퇴 시 - 내용");
            owned.Property(x => x.WithdrawVerifyEmailFormTitle).HasColumnName("EmailTemplate_WithdrawVerifyEmailFormTitle").HasComment("회원탈퇴 인증 - 제목");
            owned.Property(x => x.WithdrawVerifyEmailFormContent).HasColumnName("EmailTemplate_WithdrawVerifyEmailFormContent").HasComment("회원탈퇴 인증 - 내용");
            owned.Property(x => x.EmailVerifyFormTitle).HasColumnName("EmailTemplate_EmailVerifyFormTitle").HasComment("이메일 변경 시 - 제목");
            owned.Property(x => x.EmailVerifyFormContent).HasColumnName("EmailTemplate_EmailVerifyFormContent").HasComment("이메일 변경 시 - 내용");
            owned.Property(x => x.ChangedEmailFormTitle).HasColumnName("EmailTemplate_ChangedEmailFormTitle").HasComment("이메일 변경 완료 - 제목");
            owned.Property(x => x.ChangedEmailFormContent).HasColumnName("EmailTemplate_ChangedEmailFormContent").HasComment("이메일 변경 완료 - 내용");
        });

        builder.OwnsOne(x => x.External, owned =>
        {
            owned.Property(x => x.YouTubeApiKeyEnc).HasColumnName("External_YouTubeApiKeyEnc").HasComment("YouTube API Key (암호화 저장 권장)");
            owned.Property(x => x.YouTubeApiName).HasColumnName("External_YouTubeApiName").HasComment("YouTube API Name");
            owned.Property(x => x.GoogleClientId).HasColumnName("External_GoogleClientId").HasComment("Google Client ID");
            owned.Property(x => x.GoogleClientSecretEnc).HasColumnName("External_GoogleClientSecretEnc").HasComment("Google Client Secret (암호화 저장 권장)");
            owned.Property(x => x.GoogleAppId).HasColumnName("External_GoogleAppId").HasComment("Google APP ID");
        });

        builder.OwnsOne(x => x.Crypto, owned =>
        {
            owned.Property(x => x.TickerRefreshSeconds).IsRequired().HasColumnName("Crypto_TickerRefreshSeconds").HasDefaultValue(5).HasComment("시세 업데이트 주기 (초)");
            owned.Property(x => x.SurgeThreshold).IsRequired().HasColumnType("decimal(5,2)").HasColumnName("Crypto_SurgeThreshold").HasDefaultValue(5.0m).HasComment("급등 임계값 (%)");
            owned.Property(x => x.PlungeThreshold).IsRequired().HasColumnType("decimal(5,2)").HasColumnName("Crypto_PlungeThreshold").HasDefaultValue(-5.0m).HasComment("급락 임계값 (%)");
            owned.Property(x => x.MainPageCoinCount).IsRequired().HasColumnName("Crypto_MainPageCoinCount").HasDefaultValue(10).HasComment("메인 페이지 기본 표시 코인 수");
        });

        builder.OwnsOne(x => x.Attendance, owned =>
        {
            // bool/int 의 HasDefaultValue 제거 — sentinel 충돌로 UPDATE 누락 방지. (Payment 이슈와 동일 원인)
            owned.Property(x => x.IsEnabled).HasColumnName("Attendance_IsEnabled").HasComment("출석 기능 활성화");
            owned.Property(x => x.BaseExp).HasColumnName("Attendance_BaseExp").HasComment("기본 경험치");
            owned.Property(x => x.BasePoint).HasColumnName("Attendance_BasePoint").HasComment("기본 포인트");
            owned.Property(x => x.UseStreakBonus).HasColumnName("Attendance_UseStreakBonus").HasComment("연속 출석 가중치 사용");
            owned.Property(x => x.StreakBonusPerDay).HasColumnName("Attendance_StreakBonusPerDay").HasComment("1일당 추가 경험치");
            owned.Property(x => x.StreakBonusPointPerDay).HasColumnName("Attendance_StreakBonusPointPerDay").HasComment("1일당 추가 포인트");
            owned.Property(x => x.StreakBonusMaxDays).HasColumnName("Attendance_StreakBonusMaxDays").HasComment("가중치 최대 적용 일수");
            owned.Property(x => x.UseRankBonus).HasColumnName("Attendance_UseRankBonus").HasComment("순위 보상 사용");
            owned.Property(x => x.RankBonusConfig).HasColumnName("Attendance_RankBonusConfig").HasMaxLength(2000).HasComment("순위별 보상 설정 (JSON)");
        });

        builder.OwnsOne(x => x.SignupReward, owned =>
        {
            // bool/int 의 HasDefaultValue 제거 — sentinel 충돌로 UPDATE 누락 방지. (Attendance 와 동일)
            owned.Property(x => x.Enabled).HasColumnName("SignupReward_Enabled").HasComment("가입 축하 보상 활성화");
            owned.Property(x => x.CoinAmount).HasColumnName("SignupReward_CoinAmount").HasComment("지급 코인 (Airdrop)");
            owned.Property(x => x.CashAmount).HasColumnName("SignupReward_CashAmount").HasComment("지급 캐시 (Adjusted)");
            owned.Property(x => x.ExpAmount).HasColumnName("SignupReward_ExpAmount").HasComment("지급 경험치");
        });

        builder.OwnsOne(x => x.ActivityToken, owned =>
        {
            // bool/int 의 HasDefaultValue 제거 — sentinel 충돌로 UPDATE 누락 방지. (SignupReward 와 동일)
            owned.Property(x => x.PostToken).HasColumnName("ActivityToken_PostToken").HasComment("게시글 작성 지급 토큰");
            owned.Property(x => x.CommentToken).HasColumnName("ActivityToken_CommentToken").HasComment("댓글 작성 지급 토큰");
            owned.Property(x => x.DailyTokenCap).HasColumnName("ActivityToken_DailyTokenCap").HasComment("활동 토큰 일일 상한 (0=무제한)");
        });

        builder.OwnsOne(x => x.ChatExp, owned =>
        {
            owned.Property(x => x.ChatXpPerMessage).HasColumnName("ChatExp_ChatXpPerMessage").HasDefaultValue(1).HasComment("채팅 1건당 지급 XP");
            owned.Property(x => x.DonationXpPerAmount).HasColumnName("ChatExp_DonationXpPerAmount").HasDefaultValue(1000).HasComment("후원 N POINT당 1 XP");
            owned.Property(x => x.ChatXpSessionLimit).HasColumnName("ChatExp_ChatXpSessionLimit").HasDefaultValue(50).HasComment("방송 세션당 채팅 XP 상한");
            owned.Property(x => x.MinContentLength).HasColumnName("ChatExp_MinContentLength").HasDefaultValue(2).HasComment("XP 적립 최소 글자수");
            owned.Property(x => x.RateLimitSec).HasColumnName("ChatExp_RateLimitSec").HasDefaultValue(2).HasComment("채팅 쿨다운(초)");
            owned.Property(x => x.LeaderboardSize).HasColumnName("ChatExp_LeaderboardSize").HasDefaultValue(50).HasComment("리더보드 Top N");
            owned.Property(x => x.CrownTopN).HasColumnName("ChatExp_CrownTopN").HasDefaultValue(3).HasComment("크라운 뱃지 Top N");
            // HasDefaultValue(true) 는 더 위험 — 기본값이 true 인 bool 은 EF 가 true 를 sentinel 로 오인.
            // 사용자가 체크 해제 시 false 로 UPDATE 누락. C# 클래스 init 값으로 동일 default 효과 보장.
            owned.Property(x => x.UxShowLeaderboard).HasColumnName("ChatExp_UxShowLeaderboard").HasComment("watch에서 리더보드 노출");
            owned.Property(x => x.UxShowMyXpBadge).HasColumnName("ChatExp_UxShowMyXpBadge").HasComment("내 XP 뱃지 노출");
        });

        builder.OwnsOne(x => x.Paper, owned =>
        {
            // bool/int 의 HasDefaultValue 제거 — sentinel 충돌로 UPDATE 누락 방지. (SignupReward 와 동일)
            owned.Property(x => x.Enabled).HasColumnName("Paper_Enabled").HasComment("모의투자 활성화");
            owned.Property(x => x.FeeRateBp).HasColumnName("Paper_FeeRateBp").HasComment("매매 수수료 Bp");
            owned.Property(x => x.TaxRateBp).HasColumnName("Paper_TaxRateBp").HasComment("매도 거래세 Bp");
            owned.Property(x => x.MinDeposit).HasColumnName("Paper_MinDeposit").HasComment("최소 입금 토큰");
            owned.Property(x => x.MaxHolding).HasColumnName("Paper_MaxHolding").HasComment("계좌 최대 보유 토큰 (0=무제한)");
            owned.Property(x => x.WithdrawProfitBurnBp).HasColumnName("Paper_WithdrawProfitBurnBp").HasComment("출금 수익분 소각 Bp");
            owned.Property(x => x.OrderMaxPctBp).HasColumnName("Paper_OrderMaxPctBp").HasComment("1주문 상한 Bp");
            owned.Property(x => x.MinFillsForRank).HasColumnName("Paper_MinFillsForRank").HasComment("리더보드 등재 최소 체결 수");
        });
    }
}