| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160 |
- // <auto-generated />
- using System;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Metadata;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- #nullable disable
- namespace bitforum.Migrations.DefaultDb
- {
- [DbContext(typeof(DefaultDbContext))]
- [Migration("20250222130451_a2")]
- partial class a2
- {
- /// <inheritdoc />
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "8.0.13")
- .HasAnnotation("Relational:MaxIdentifierLength", 128);
- SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
- modelBuilder.Entity("bitforum.Models.Account.EmailVerifyNumber", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Code")
- .IsRequired()
- .HasMaxLength(10)
- .HasColumnType("nvarchar(10)")
- .HasComment("Code");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<string>("Email")
- .IsRequired()
- .HasMaxLength(60)
- .HasColumnType("nvarchar(60)")
- .HasComment("이메일");
- b.Property<DateTime>("Expiration")
- .HasColumnType("datetime2")
- .HasComment("만료 일시");
- b.Property<bool>("IsVerified")
- .HasColumnType("bit")
- .HasComment("인증 여부");
- b.Property<int>("Type")
- .HasColumnType("int")
- .HasComment("인증 유형 (이메일 인증 / 비밀번호 재설정)");
- b.HasKey("ID");
- b.HasIndex(new[] { "Code" }, "IX_EmailVerifyNumber_Code");
- b.HasIndex(new[] { "Email" }, "IX_EmailVerifyNumber_Email");
- b.HasIndex(new[] { "Expiration" }, "IX_EmailVerifyNumber_Expiration");
- b.HasIndex(new[] { "IsVerified" }, "IX_EmailVerifyNumber_IsVerified");
- b.HasIndex(new[] { "Type" }, "IX_EmailVerifyNumber_Type");
- b.ToTable("EmailVerifyNumber", t =>
- {
- t.HasComment("이메일 인증 번호들");
- });
- });
- modelBuilder.Entity("bitforum.Models.Account.EmailVerifyToken", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Additional")
- .HasColumnType("nvarchar(max)")
- .HasComment("추가 정보(JSON)");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<string>("Email")
- .IsRequired()
- .HasMaxLength(60)
- .HasColumnType("nvarchar(60)")
- .HasComment("이메일");
- b.Property<DateTime>("Expiration")
- .HasColumnType("datetime2")
- .HasComment("만료 일시");
- b.Property<bool>("IsVerified")
- .HasColumnType("bit")
- .HasComment("인증 여부");
- b.Property<string>("Token")
- .IsRequired()
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)")
- .HasComment("Token");
- b.Property<int>("Type")
- .HasColumnType("int")
- .HasComment("인증 유형 (이메일 인증 / 비밀번호 재설정)");
- b.HasKey("ID");
- b.HasIndex(new[] { "Email" }, "IX_EmailVerifyToken_Email");
- b.HasIndex(new[] { "Expiration" }, "IX_EmailVerifyToken_Expiration");
- b.HasIndex(new[] { "IsVerified" }, "IX_EmailVerifyToken_IsVerified");
- b.HasIndex(new[] { "Token" }, "IX_EmailVerifyToken_Token");
- b.HasIndex(new[] { "Type" }, "IX_EmailVerifyToken_Type");
- b.ToTable("EmailVerifyToken", t =>
- {
- t.HasComment("이메일 인증 토큰들");
- });
- });
- modelBuilder.Entity("bitforum.Models.Account.Member", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<DateTime?>("AuthCertifiedAt")
- .HasColumnType("datetime2")
- .HasComment("본인인증 일시");
- b.Property<DateOnly?>("Birthday")
- .HasColumnType("date")
- .HasComment("생년월일");
- b.Property<long>("Coin")
- .HasColumnType("bigint")
- .HasComment("코인");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("가입 일시");
- b.Property<DateTime?>("DeletedAt")
- .HasColumnType("datetime2")
- .HasComment("탈퇴 일시");
- b.Property<string>("DeviceInfo")
- .HasMaxLength(400)
- .HasColumnType("nvarchar(400)")
- .HasComment("로그인 단말기 정보");
- b.Property<string>("Email")
- .IsRequired()
- .HasMaxLength(60)
- .HasColumnType("nvarchar(60)")
- .HasComment("이메일");
- b.Property<DateTime?>("EmailVerifiedAt")
- .HasColumnType("datetime2")
- .HasComment("이메일 인증 일시");
- b.Property<int>("Exp")
- .HasColumnType("int")
- .HasComment("경험치");
- b.Property<string>("FirstName")
- .HasMaxLength(20)
- .HasColumnType("nvarchar(20)")
- .HasComment("본명(성)");
- b.Property<int>("Followed")
- .HasColumnType("int")
- .HasComment("구독자");
- b.Property<int>("Following")
- .HasColumnType("int")
- .HasComment("구독 중");
- b.Property<string>("FullName")
- .HasMaxLength(40)
- .HasColumnType("nvarchar(40)")
- .HasComment("본명");
- b.Property<int?>("Gender")
- .HasColumnType("int")
- .HasComment("성별");
- b.Property<int?>("GradeID")
- .HasColumnType("int")
- .HasComment("회원등급 ID");
- b.Property<string>("Icon")
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("아이콘");
- b.Property<string>("Intro")
- .HasMaxLength(1000)
- .HasColumnType("nvarchar(1000)")
- .HasComment("자기소개");
- b.Property<bool>("IsAdmin")
- .HasColumnType("bit")
- .HasComment("운영진 여부");
- b.Property<bool>("IsAuthCertified")
- .HasColumnType("bit")
- .HasComment("본인 인증 여부");
- b.Property<bool>("IsDenied")
- .HasColumnType("bit")
- .HasComment("차단 여부");
- b.Property<bool>("IsEmailVerified")
- .HasColumnType("bit")
- .HasComment("이메일 인증 여부");
- b.Property<bool>("IsWithdraw")
- .HasColumnType("bit")
- .HasComment("탈퇴 여부");
- b.Property<DateTime?>("LastEmailChangedAt")
- .HasColumnType("datetime2")
- .HasComment("마지막 이메일 변경 일시");
- b.Property<DateTime?>("LastLoginAt")
- .HasColumnType("datetime2")
- .HasComment("마지막 로그인 일시");
- b.Property<string>("LastLoginIp")
- .HasMaxLength(15)
- .HasColumnType("nvarchar(15)")
- .HasComment("마지막 로그인 IP");
- b.Property<string>("LastName")
- .HasMaxLength(40)
- .HasColumnType("nvarchar(40)")
- .HasComment("본명(이름)");
- b.Property<DateTime?>("LastNameChangedAt")
- .HasColumnType("datetime2")
- .HasComment("마지막 별명 변경 일시");
- b.Property<string>("Name")
- .HasMaxLength(20)
- .HasColumnType("nvarchar(20)")
- .HasComment("별명");
- b.Property<string>("Password")
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("비밀번호");
- b.Property<DateTime>("PasswordUpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("비밀번호 변경 일시");
- b.Property<string>("Phone")
- .HasMaxLength(15)
- .HasColumnType("nvarchar(15)")
- .HasComment("연락처");
- b.Property<string>("Photo")
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("사진");
- b.Property<string>("SID")
- .IsRequired()
- .HasMaxLength(20)
- .HasColumnType("nvarchar(20)")
- .HasComment("SID");
- b.Property<string>("SignupIP")
- .IsRequired()
- .HasMaxLength(15)
- .HasColumnType("nvarchar(15)")
- .HasComment("회원가입 시 IP");
- b.Property<string>("Summary")
- .HasMaxLength(50)
- .HasColumnType("nvarchar(50)")
- .HasComment("한마디");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.HasKey("ID");
- b.HasIndex("GradeID");
- b.HasIndex(new[] { "CreatedAt" }, "IX_Member_CreatedAt");
- b.HasIndex(new[] { "DeletedAt" }, "IX_Member_DeletedAt");
- b.HasIndex(new[] { "Email" }, "IX_Member_Email")
- .IsUnique();
- b.HasIndex(new[] { "FullName" }, "IX_Member_FullName");
- b.HasIndex(new[] { "Gender" }, "IX_Member_Gender");
- b.HasIndex(new[] { "IsAdmin" }, "IX_Member_IsAdmin");
- b.HasIndex(new[] { "IsAuthCertified" }, "IX_Member_IsAuthCertified");
- b.HasIndex(new[] { "IsDenied" }, "IX_Member_IsDenied");
- b.HasIndex(new[] { "IsEmailVerified" }, "IX_Member_IsEmailVerified");
- b.HasIndex(new[] { "IsWithdraw" }, "IX_Member_IsWithdraw");
- b.HasIndex(new[] { "Name" }, "IX_Member_Name")
- .IsUnique()
- .HasFilter("[Name] IS NOT NULL");
- b.HasIndex(new[] { "Phone" }, "IX_Member_Phone");
- b.HasIndex(new[] { "SID" }, "IX_Member_SID")
- .IsUnique();
- b.ToTable("Member", t =>
- {
- t.HasComment("회원 정보");
- });
- });
- modelBuilder.Entity("bitforum.Models.Account.MemberApprove", b =>
- {
- b.Property<int>("MemberID")
- .HasColumnType("int")
- .HasComment("회원 ID");
- b.Property<bool>("IsDisclosureInvest")
- .HasColumnType("bit")
- .HasComment("투자 현황 공개 여부");
- b.Property<bool>("IsReceiveEmail")
- .HasColumnType("bit")
- .HasComment("E-MAIL 수신 여부");
- b.Property<bool>("IsReceiveNote")
- .HasColumnType("bit")
- .HasComment("쪽지 수신 여부");
- b.Property<bool>("IsReceiveSMS")
- .HasColumnType("bit")
- .HasComment("SMS 수신 여부");
- b.HasKey("MemberID");
- b.ToTable("MemberApprove", t =>
- {
- t.HasComment("회원 동의 및 수신 여부");
- });
- });
- modelBuilder.Entity("bitforum.Models.Account.MemberGrade", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<string>("Description")
- .HasMaxLength(1000)
- .HasColumnType("nvarchar(1000)")
- .HasComment("설명");
- b.Property<string>("EngName")
- .IsRequired()
- .HasMaxLength(120)
- .HasColumnType("nvarchar(120)")
- .HasComment("영문 명");
- b.Property<string>("Image")
- .HasColumnType("nvarchar(max)")
- .HasComment("이미지");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<string>("KorName")
- .IsRequired()
- .HasMaxLength(120)
- .HasColumnType("nvarchar(120)")
- .HasComment("한글 명");
- b.Property<short>("Order")
- .HasColumnType("smallint")
- .HasComment("순서");
- b.Property<int>("RequiredCoin")
- .HasColumnType("int")
- .HasComment("최소 코인(Coin)");
- b.Property<int>("RequiredExp")
- .HasColumnType("int")
- .HasComment("최소 경험치(Exp)");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.HasKey("ID");
- b.HasIndex(new[] { "EngName" }, "IX_MemberGrade_EngName")
- .IsUnique();
- b.HasIndex(new[] { "IsActive" }, "IX_MemberGrade_IsActive");
- b.HasIndex(new[] { "KorName" }, "IX_MemberGrade_KorName")
- .IsUnique();
- b.HasIndex(new[] { "Order" }, "IX_MemberGrade_Order");
- b.ToTable("MemberGrade", t =>
- {
- t.HasComment("회원 등급");
- });
- });
- modelBuilder.Entity("bitforum.Models.Account.RefreshToken", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<DateTime>("Expiration")
- .HasColumnType("datetime2")
- .HasComment("만료 일시");
- b.Property<int>("MemberID")
- .HasColumnType("int")
- .HasComment("회원 ID");
- b.Property<string>("Token")
- .IsRequired()
- .HasMaxLength(128)
- .HasColumnType("nvarchar(128)")
- .HasComment("Token");
- b.HasKey("ID");
- b.ToTable("RefreshToken");
- });
- modelBuilder.Entity("bitforum.Models.Config", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2");
- b.Property<string>("Description")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Key")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.Property<string>("Value")
- .HasColumnType("nvarchar(max)");
- b.HasKey("ID");
- b.HasIndex("Key")
- .IsUnique();
- b.ToTable("Config");
- });
- modelBuilder.Entity("bitforum.Models.Log.EmailChangeLog", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("AfterEmail")
- .IsRequired()
- .HasMaxLength(40)
- .HasColumnType("nvarchar(40)")
- .HasComment("바꾼 이메일");
- b.Property<string>("BeforeEmail")
- .HasMaxLength(40)
- .HasColumnType("nvarchar(40)")
- .HasComment("이전 이메일");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<int>("MemberID")
- .HasColumnType("int")
- .HasComment("회원 ID");
- b.HasKey("ID");
- b.HasIndex(new[] { "MemberID" }, "IX_EmailChangeLog_MemberID");
- b.ToTable("EmailChangeLog", t =>
- {
- t.HasComment("이메일 변경 내역");
- });
- });
- modelBuilder.Entity("bitforum.Models.Log.EmailLog", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<string>("FromAddress")
- .IsRequired()
- .HasMaxLength(120)
- .HasColumnType("nvarchar(120)")
- .HasComment("발신 주소");
- b.Property<string>("FromName")
- .HasMaxLength(60)
- .HasColumnType("nvarchar(60)")
- .HasComment("발신자");
- b.Property<int?>("MemberID")
- .HasColumnType("int")
- .HasComment("회원 ID");
- b.Property<string>("Message")
- .HasColumnType("nvarchar(max)")
- .HasComment("내용");
- b.Property<DateTime?>("ProcessedAt")
- .HasColumnType("datetime2")
- .HasComment("처리 일시");
- b.Property<string>("Status")
- .IsRequired()
- .HasColumnType("nvarchar(20)")
- .HasComment("처리 여부");
- b.Property<string>("Subject")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("제목");
- b.Property<string>("ToAddress")
- .IsRequired()
- .HasMaxLength(120)
- .HasColumnType("nvarchar(120)")
- .HasComment("수신 주소");
- b.Property<string>("ToName")
- .HasMaxLength(60)
- .HasColumnType("nvarchar(60)")
- .HasComment("수신자");
- b.HasKey("ID");
- b.HasIndex(new[] { "MemberID" }, "IX_EmailLog_MemberID");
- b.HasIndex(new[] { "Status" }, "IX_EmailLog_Status");
- b.ToTable("EmailLog");
- });
- modelBuilder.Entity("bitforum.Models.Log.LoginLog", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Account")
- .IsRequired()
- .HasMaxLength(120)
- .HasColumnType("nvarchar(120)")
- .HasComment("로그인 시도한 계정");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<string>("IpAddress")
- .HasMaxLength(15)
- .HasColumnType("nvarchar(15)")
- .HasComment("IP Address");
- b.Property<int?>("MemberID")
- .HasColumnType("int")
- .HasComment("회원 ID");
- b.Property<string>("Reason")
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("실패 이유");
- b.Property<string>("Referer")
- .HasColumnType("nvarchar(max)")
- .HasComment("이전 페이지 주소");
- b.Property<bool>("Success")
- .HasColumnType("bit")
- .HasComment("로그인 성공 여부 (0: 실패, 1: 성공)");
- b.Property<string>("Url")
- .HasMaxLength(500)
- .HasColumnType("nvarchar(500)")
- .HasComment("요청 주소");
- b.Property<string>("UserAgent")
- .HasMaxLength(512)
- .HasColumnType("nvarchar(512)")
- .HasComment("User Agent");
- b.HasKey("ID");
- b.HasIndex("MemberID");
- b.ToTable("LoginLog", t =>
- {
- t.HasComment("로그인 기록");
- });
- });
- modelBuilder.Entity("bitforum.Models.Log.NameChangeLog", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("AfterName")
- .IsRequired()
- .HasMaxLength(40)
- .HasColumnType("nvarchar(40)")
- .HasComment("바꾼 별명");
- b.Property<string>("BeforeName")
- .HasMaxLength(40)
- .HasColumnType("nvarchar(40)")
- .HasComment("이전 별명");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<int>("MemberID")
- .HasColumnType("int")
- .HasComment("회원 ID");
- b.HasKey("ID");
- b.HasIndex(new[] { "MemberID" }, "IX_NameChangeLog_MemberID");
- b.ToTable("NameChangeLog", t =>
- {
- t.HasComment("별명 변경 내역");
- });
- });
- modelBuilder.Entity("bitforum.Models.Page.Banner.BannerItem", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<DateTime?>("EndAt")
- .HasColumnType("datetime2")
- .HasComment("사용 기간 - 종료");
- b.Property<int?>("Height")
- .HasColumnType("int")
- .HasComment("세로 크기");
- b.Property<string>("Image")
- .HasMaxLength(1024)
- .HasColumnType("nvarchar(1024)")
- .HasComment("이미지");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<string>("Link")
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("주소");
- b.Property<int>("Order")
- .HasColumnType("int")
- .HasComment("순서");
- b.Property<int>("PositionID")
- .HasColumnType("int")
- .HasComment("배너 위치 ID");
- b.Property<DateTime?>("StartAt")
- .HasColumnType("datetime2")
- .HasComment("사용 기간 - 시작");
- b.Property<string>("Subject")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("배너 명");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.Property<int>("Views")
- .HasColumnType("int")
- .HasComment("조회 수");
- b.Property<int?>("Width")
- .HasColumnType("int")
- .HasComment("가로 크기");
- b.HasKey("ID");
- b.HasIndex("PositionID");
- b.HasIndex(new[] { "IsActive" }, "IX_BannerItem_IsActive");
- b.HasIndex(new[] { "Order" }, "IX_BannerItem_Order");
- b.ToTable("BannerItem");
- });
- modelBuilder.Entity("bitforum.Models.Page.Banner.BannerPosition", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Code")
- .IsRequired()
- .HasMaxLength(30)
- .HasColumnType("nvarchar(30)")
- .HasComment("위치 구분");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<string>("Subject")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("위치 명");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.HasKey("ID");
- b.HasIndex(new[] { "Code" }, "IX_BannerPosition_Code")
- .IsUnique();
- b.HasIndex(new[] { "IsActive" }, "IX_BannerPosition_IsActive");
- b.ToTable("BannerPosition");
- });
- modelBuilder.Entity("bitforum.Models.Page.Document", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Code")
- .IsRequired()
- .HasMaxLength(30)
- .HasColumnType("nvarchar(30)")
- .HasComment("주소");
- b.Property<string>("Content")
- .HasColumnType("nvarchar(max)")
- .HasComment("내용");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<string>("Subject")
- .IsRequired()
- .HasMaxLength(120)
- .HasColumnType("nvarchar(120)")
- .HasComment("제목");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.Property<int>("Views")
- .HasColumnType("int")
- .HasComment("조회 수");
- b.HasKey("ID");
- b.HasIndex(new[] { "Code" }, "IX_Document_Code")
- .IsUnique();
- b.HasIndex(new[] { "IsActive" }, "IX_Document_IsActive");
- b.ToTable("Document");
- });
- modelBuilder.Entity("bitforum.Models.Page.Faq.FaqCategory", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Code")
- .IsRequired()
- .HasMaxLength(30)
- .HasColumnType("nvarchar(30)")
- .HasComment("주소");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<int>("Order")
- .HasColumnType("int")
- .HasComment("순서");
- b.Property<string>("Subject")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("분류 명");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.HasKey("ID");
- b.HasIndex(new[] { "Code" }, "IX_FaqCategory_Code")
- .IsUnique();
- b.HasIndex(new[] { "Order" }, "IX_FaqCategory_Order");
- b.ToTable("FaqCategory");
- });
- modelBuilder.Entity("bitforum.Models.Page.Faq.FaqItem", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Answer")
- .HasColumnType("nvarchar(max)")
- .HasComment("답변");
- b.Property<int>("CategoryID")
- .HasColumnType("int")
- .HasComment("분류 ID");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<int>("Order")
- .HasColumnType("int")
- .HasComment("순서");
- b.Property<string>("Question")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("질문");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.Property<int>("Views")
- .HasColumnType("int")
- .HasComment("조회 수");
- b.HasKey("ID");
- b.HasIndex("CategoryID");
- b.HasIndex(new[] { "IsActive" }, "IX_FaqItem_IsActive");
- b.HasIndex(new[] { "Order" }, "IX_FaqItem_Order");
- b.ToTable("FaqItem");
- });
- modelBuilder.Entity("bitforum.Models.Page.Popup", b =>
- {
- b.Property<int>("ID")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasComment("PK");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ID"));
- b.Property<string>("Content")
- .HasColumnType("nvarchar(max)")
- .HasComment("내용");
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("datetime2")
- .HasComment("등록 일시");
- b.Property<DateTime?>("EndAt")
- .HasColumnType("datetime2")
- .HasComment("사용 기간 - 종료");
- b.Property<bool>("IsActive")
- .HasColumnType("bit")
- .HasComment("사용 여부");
- b.Property<string>("Link")
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("주소");
- b.Property<short>("Order")
- .HasColumnType("smallint")
- .HasComment("순서");
- b.Property<DateTime?>("StartAt")
- .HasColumnType("datetime2")
- .HasComment("사용 기간 - 시작");
- b.Property<string>("Subject")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("nvarchar(255)")
- .HasComment("제목");
- b.Property<DateTime?>("UpdatedAt")
- .HasColumnType("datetime2")
- .HasComment("수정 일시");
- b.Property<int>("Views")
- .HasColumnType("int")
- .HasComment("조회 수");
- b.HasKey("ID");
- b.HasIndex(new[] { "IsActive" }, "IX_Popup_IsActive");
- b.HasIndex(new[] { "Order" }, "IX_Popup_Order");
- b.ToTable("Popup");
- });
- modelBuilder.Entity("bitforum.Models.Account.Member", b =>
- {
- b.HasOne("bitforum.Models.Account.MemberGrade", "MemberGrade")
- .WithMany()
- .HasForeignKey("GradeID");
- b.Navigation("MemberGrade");
- });
- modelBuilder.Entity("bitforum.Models.Account.MemberApprove", b =>
- {
- b.HasOne("bitforum.Models.Account.Member", "Member")
- .WithOne("MemberApprove")
- .HasForeignKey("bitforum.Models.Account.MemberApprove", "MemberID")
- .OnDelete(DeleteBehavior.NoAction)
- .IsRequired();
- b.Navigation("Member");
- });
- modelBuilder.Entity("bitforum.Models.Log.EmailChangeLog", b =>
- {
- b.HasOne("bitforum.Models.Account.Member", "Member")
- .WithMany("EmailChangeLog")
- .HasForeignKey("MemberID")
- .OnDelete(DeleteBehavior.NoAction)
- .IsRequired();
- b.Navigation("Member");
- });
- modelBuilder.Entity("bitforum.Models.Log.EmailLog", b =>
- {
- b.HasOne("bitforum.Models.Account.Member", "Member")
- .WithMany("EmailLog")
- .HasForeignKey("MemberID")
- .OnDelete(DeleteBehavior.SetNull);
- b.Navigation("Member");
- });
- modelBuilder.Entity("bitforum.Models.Log.LoginLog", b =>
- {
- b.HasOne("bitforum.Models.Account.Member", "Member")
- .WithMany("LoginLog")
- .HasForeignKey("MemberID")
- .OnDelete(DeleteBehavior.SetNull);
- b.Navigation("Member");
- });
- modelBuilder.Entity("bitforum.Models.Log.NameChangeLog", b =>
- {
- b.HasOne("bitforum.Models.Account.Member", "Member")
- .WithMany("NameChangeLog")
- .HasForeignKey("MemberID")
- .OnDelete(DeleteBehavior.NoAction)
- .IsRequired();
- b.Navigation("Member");
- });
- modelBuilder.Entity("bitforum.Models.Page.Banner.BannerItem", b =>
- {
- b.HasOne("bitforum.Models.Page.Banner.BannerPosition", "BannerPosition")
- .WithMany("BannerItem")
- .HasForeignKey("PositionID")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("BannerPosition");
- });
- modelBuilder.Entity("bitforum.Models.Page.Faq.FaqItem", b =>
- {
- b.HasOne("bitforum.Models.Page.Faq.FaqCategory", "FaqCategory")
- .WithMany("FaqItem")
- .HasForeignKey("CategoryID")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("FaqCategory");
- });
- modelBuilder.Entity("bitforum.Models.Account.Member", b =>
- {
- b.Navigation("EmailChangeLog");
- b.Navigation("EmailLog");
- b.Navigation("LoginLog");
- b.Navigation("MemberApprove");
- b.Navigation("NameChangeLog");
- });
- modelBuilder.Entity("bitforum.Models.Page.Banner.BannerPosition", b =>
- {
- b.Navigation("BannerItem");
- });
- modelBuilder.Entity("bitforum.Models.Page.Faq.FaqCategory", b =>
- {
- b.Navigation("FaqItem");
- });
- #pragma warning restore 612, 618
- }
- }
- }
|