ConfigConfiguration.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. using Domain.Entities.Common;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Common;
  5. public sealed class ConfigConfiguration : IEntityTypeConfiguration<Config>
  6. {
  7. public void Configure(EntityTypeBuilder<Config> builder)
  8. {
  9. builder.ToTable(nameof(Config), x => x.HasComment("운영 정보 설정 값"));
  10. builder.HasKey(x => x.ID);
  11. builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
  12. builder.Property(x => x.LastUpdatedAt).IsRequired().HasComment("마지막 수정일시");
  13. builder.Property(x => x.RowVersion).IsRowVersion().HasComment("동시성 제어용");
  14. builder.OwnsOne(x => x.Basic, owned =>
  15. {
  16. owned.Property(x => x.SiteName).HasMaxLength(100).HasColumnName("Basic_SiteName").HasComment("사이트 이름");
  17. owned.Property(x => x.RootID).HasMaxLength(100).HasColumnName("Basic_RootID").HasComment("최고 관리자 ID");
  18. owned.Property(x => x.FromEmail).HasMaxLength(200).HasColumnName("Basic_FromEmail").HasComment("송수신 이메일");
  19. owned.Property(x => x.FromName).HasMaxLength(100).HasColumnName("Basic_FromName").HasComment("송수신자 이름");
  20. owned.Property(x => x.SmtpServer).HasMaxLength(200).HasColumnName("Basic_SmtpServer").HasComment("SMTP Server");
  21. owned.Property(x => x.SmtpPort).HasColumnName("Basic_SmtpPort").HasComment("SMTP Port");
  22. owned.Property(x => x.SmtpEnableSsl).HasColumnName("Basic_SmtpEnableSsl").HasComment("SMTP Enable SSL");
  23. owned.Property(x => x.SmtpUsername).HasMaxLength(200).HasColumnName("Basic_SmtpUsername").HasComment("SMTP Username");
  24. owned.Property(x => x.SmtpPasswordEnc).HasColumnName("Basic_SmtpPasswordEnc").HasComment("SMTP Password (암호화 저장 권장)");
  25. owned.Property(x => x.AdminWhiteIpList).HasColumnName("Basic_AdminWhiteIpList").HasComment("관리자단 접근 가능 IP");
  26. owned.Property(x => x.FrontWhiteIpList).HasColumnName("Basic_FrontWhiteIpList").HasComment("사용자단 접근 가능 IP");
  27. owned.Property(x => x.BlockAlertTitle).HasMaxLength(200).HasColumnName("Basic_BlockAlertTitle").HasComment("차단 시 안내문 제목");
  28. owned.Property(x => x.BlockAlertContent).HasColumnName("Basic_BlockAlertContent").HasComment("차단 시 안내문 내용");
  29. owned.Property(x => x.IsMaintenance).HasColumnName("Basic_IsMaintenance").HasComment("점검 여부");
  30. owned.Property(x => x.MaintenanceContent).HasColumnName("Basic_MaintenanceContent").HasComment("점검 내용");
  31. owned.Property(x => x.DefaultPaymentGateway).HasMaxLength(50).HasColumnName("Basic_DefaultPaymentGateway").HasComment("기본 PG");
  32. owned.Property(x => x.DefaultFeeAmount).HasPrecision(18, 0).HasColumnName("Basic_DefaultFeeAmount").HasComment("기본 수수료(원)");
  33. owned.Property(x => x.DefaultFeeRate).HasPrecision(5, 2).HasColumnName("Basic_DefaultFeeRate").HasComment("기본 수수료(%)");
  34. });
  35. builder.OwnsOne(x => x.Meta, owned =>
  36. {
  37. owned.Property(x => x.Keywords).HasColumnName("Meta_Keywords").HasComment("Meta Keywords");
  38. owned.Property(x => x.Description).HasColumnName("Meta_Description").HasComment("Meta Description");
  39. owned.Property(x => x.Author).HasColumnName("Meta_Author").HasComment("Meta Author");
  40. owned.Property(x => x.Viewport).HasColumnName("Meta_Viewport").HasComment("Meta Viewport");
  41. owned.Property(x => x.ApplicationName).HasColumnName("Meta_ApplicationName").HasComment("Meta Application Name");
  42. owned.Property(x => x.Generator).HasColumnName("Meta_Generator").HasComment("Meta Generator");
  43. owned.Property(x => x.Robots).HasColumnName("Meta_Robots").HasComment("Meta Robots");
  44. });
  45. builder.OwnsOne(x => x.Company, owned =>
  46. {
  47. owned.Property(x => x.ZipCode).HasMaxLength(20).HasColumnName("Company_ZipCode").HasComment("사업장 주소(우편번호)");
  48. owned.Property(x => x.Hosting).HasMaxLength(200).HasColumnName("Company_Hosting").HasComment("호스팅 서비스");
  49. owned.Property(x => x.AdminName).HasMaxLength(100).HasColumnName("Company_AdminName").HasComment("정보관리책임자");
  50. owned.Property(x => x.AdminEmail).HasMaxLength(200).HasColumnName("Company_AdminEmail").HasComment("정보관리책임자 E-mail");
  51. owned.Property(x => x.SiteUrl).HasMaxLength(300).HasColumnName("Company_SiteUrl").HasComment("사이트 주소");
  52. owned.Property(x => x.BankCode).HasMaxLength(20).HasColumnName("Company_BankCode").HasComment("입금 계좌(은행 코드)");
  53. owned.Property(x => x.BankOwner).HasMaxLength(100).HasColumnName("Company_BankOwner").HasComment("예금주");
  54. owned.Property(x => x.BankNumber).HasMaxLength(50).HasColumnName("Company_BankNumber").HasComment("계좌번호");
  55. });
  56. builder.OwnsOne(x => x.Account, owned =>
  57. {
  58. owned.Property(x => x.IsRegisterBlock).HasColumnName("Account_IsRegisterBlock").HasComment("회원가입 차단");
  59. owned.Property(x => x.IsRegisterEmailAuth).HasColumnName("Account_IsRegisterEmailAuth").HasComment("회원가입 시 이메일 인증");
  60. owned.Property(x => x.PasswordMinLength).HasColumnName("Account_PasswordMinLength").HasComment("비밀번호 최소 길이");
  61. owned.Property(x => x.PasswordUppercaseLength).HasColumnName("Account_PasswordUppercaseLength").HasComment("비밀번호 최소 대문자 수");
  62. owned.Property(x => x.PasswordNumbersLength).HasColumnName("Account_PasswordNumbersLength").HasComment("비밀번호 최소 숫자 수");
  63. owned.Property(x => x.PasswordSpecialcharsLength).HasColumnName("Account_PasswordSpecialcharsLength").HasComment("비밀번호 최소 특수문자 수");
  64. owned.Property(x => x.DeniedEmailList).HasColumnName("Account_DeniedEmailList").HasComment("금지 이메일");
  65. owned.Property(x => x.DeniedNameList).HasColumnName("Account_DeniedNameList").HasComment("금지 별명");
  66. owned.Property(x => x.ChangeEmailDay).HasColumnName("Account_ChangeEmailDay").HasComment("이메일 갱신 주기(일)");
  67. owned.Property(x => x.ChangeNameDay).HasColumnName("Account_ChangeNameDay").HasComment("별명 갱신 주기(일)");
  68. owned.Property(x => x.ChangeSummaryDay).HasColumnName("Account_ChangeSummaryDay").HasComment("한마디 갱신 주기(일)");
  69. owned.Property(x => x.ChangeIntroDay).HasColumnName("Account_ChangeIntroDay").HasComment("자기소개 갱신 주기(일)");
  70. owned.Property(x => x.ChangePasswordDay).HasColumnName("Account_ChangePasswordDay").HasComment("비밀번호 갱신 주기(일)");
  71. owned.Property(x => x.MaxLoginTryCount).HasColumnName("Account_MaxLoginTryCount").HasComment("로그인 시도 제한 횟수");
  72. owned.Property(x => x.MaxLoginTryLimitSecond).HasColumnName("Account_MaxLoginTryLimitSecond").HasComment("로그인 시도 제한 시간(초)");
  73. });
  74. builder.OwnsOne(x => x.EmailTemplate, owned =>
  75. {
  76. owned.Property(x => x.RegisterEmailFormTitle).HasColumnName("EmailTemplate_RegisterEmailFormTitle").HasComment("회원가입 시 - 제목");
  77. owned.Property(x => x.RegisterEmailFormContent).HasColumnName("EmailTemplate_RegisterEmailFormContent").HasComment("회원가입 시 - 내용");
  78. owned.Property(x => x.RegistrationEmailFormTitle).HasColumnName("EmailTemplate_RegistrationEmailFormTitle").HasComment("회원가입 완료 - 제목");
  79. owned.Property(x => x.RegistrationEmailFormContent).HasColumnName("EmailTemplate_RegistrationEmailFormContent").HasComment("회원가입 완료 - 내용");
  80. owned.Property(x => x.ResetPasswordEmailFormTitle).HasColumnName("EmailTemplate_ResetPasswordEmailFormTitle").HasComment("비밀번호 재설정 - 제목");
  81. owned.Property(x => x.ResetPasswordEmailFormContent).HasColumnName("EmailTemplate_ResetPasswordEmailFormContent").HasComment("비밀번호 재설정 - 내용");
  82. owned.Property(x => x.ChangedPasswordEmailFormTitle).HasColumnName("EmailTemplate_ChangedPasswordEmailFormTitle").HasComment("비밀번호 변경 완료 - 제목");
  83. owned.Property(x => x.ChangedPasswordEmailFormContent).HasColumnName("EmailTemplate_ChangedPasswordEmailFormContent").HasComment("비밀번호 변경 완료 - 내용");
  84. owned.Property(x => x.WithdrawEmailFormTitle).HasColumnName("EmailTemplate_WithdrawEmailFormTitle").HasComment("회원탈퇴 시 - 제목");
  85. owned.Property(x => x.WithdrawEmailFormContent).HasColumnName("EmailTemplate_WithdrawEmailFormContent").HasComment("회원탈퇴 시 - 내용");
  86. owned.Property(x => x.EmailVerifyFormTitle).HasColumnName("EmailTemplate_EmailVerifyFormTitle").HasComment("이메일 변경 시 - 제목");
  87. owned.Property(x => x.EmailVerifyFormContent).HasColumnName("EmailTemplate_EmailVerifyFormContent").HasComment("이메일 변경 시 - 내용");
  88. owned.Property(x => x.ChangedEmailFormTitle).HasColumnName("EmailTemplate_ChangedEmailFormTitle").HasComment("이메일 변경 완료 - 제목");
  89. owned.Property(x => x.ChangedEmailFormContent).HasColumnName("EmailTemplate_ChangedEmailFormContent").HasComment("이메일 변경 완료 - 내용");
  90. });
  91. builder.OwnsOne(x => x.External, owned =>
  92. {
  93. owned.Property(x => x.YouTubeApiKeyEnc).HasColumnName("External_YouTubeApiKeyEnc").HasComment("YouTube API Key (암호화 저장 권장)");
  94. owned.Property(x => x.YouTubeApiName).HasColumnName("External_YouTubeApiName").HasComment("YouTube API Name");
  95. owned.Property(x => x.GoogleClientId).HasColumnName("External_GoogleClientId").HasComment("Google Client ID");
  96. owned.Property(x => x.GoogleClientSecretEnc).HasColumnName("External_GoogleClientSecretEnc").HasComment("Google Client Secret (암호화 저장 권장)");
  97. owned.Property(x => x.GoogleAppId).HasColumnName("External_GoogleAppId").HasComment("Google APP ID");
  98. });
  99. builder.OwnsOne(x => x.Payment, owned => { });
  100. }
  101. }