dpot-backend/Infrastructure/Persistence/Migrations/20260208090603_AddForumEntities.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Infrastructure.Infrastructure.Persistence.Migrations
{
    /// <inheritdoc />
    public partial class AddForumEntities : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "BoardGroup",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Code = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: false, comment: "게시판 분류 주소"),
                    Name = table.Column<string>(type: "nvarchar(70)", maxLength: 70, nullable: false, comment: "게시판 분류 명"),
                    Order = table.Column<short>(type: "smallint", nullable: false, comment: "순서"),
                    Boards = table.Column<short>(type: "smallint", nullable: false, comment: "게시판 수"),
                    Posts = table.Column<int>(type: "int", nullable: false, comment: "게시글 수"),
                    Comments = table.Column<int>(type: "int", nullable: false, comment: "댓글 수"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BoardGroup", x => x.ID);
                },
                comment: "게시판 분류");

            migrationBuilder.CreateTable(
                name: "Tag",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(450)", nullable: false),
                    Slug = table.Column<string>(type: "nvarchar(450)", nullable: false),
                    UsageCount = table.Column<long>(type: "bigint", nullable: false),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Tag", x => x.ID);
                },
                comment: "태그");

            migrationBuilder.CreateTable(
                name: "Board",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardGroupID = table.Column<int>(type: "int", nullable: false, comment: "분류 ID"),
                    Code = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: false, comment: "게시판 주소"),
                    Name = table.Column<string>(type: "nvarchar(70)", maxLength: 70, nullable: false, comment: "게시판 이름"),
                    Order = table.Column<short>(type: "smallint", nullable: false, comment: "순서"),
                    IsSearch = table.Column<bool>(type: "bit", nullable: false, comment: "검색 여부"),
                    IsActive = table.Column<bool>(type: "bit", nullable: false, comment: "사용 여부"),
                    Posts = table.Column<int>(type: "int", nullable: false, comment: "게시글 수"),
                    Comments = table.Column<int>(type: "int", nullable: false, comment: "댓글 수"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Board", x => x.ID);
                    table.ForeignKey(
                        name: "FK_Board_BoardGroup_BoardGroupID",
                        column: x => x.BoardGroupID,
                        principalTable: "BoardGroup",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "게시판");

            migrationBuilder.CreateTable(
                name: "BoardManager",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "관리자 ID"),
                    CanEdit = table.Column<bool>(type: "bit", nullable: false, comment: "수정 권한"),
                    CanDelete = table.Column<bool>(type: "bit", nullable: false, comment: "삭제 권한"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BoardManager", x => x.ID);
                    table.ForeignKey(
                        name: "FK_BoardManager_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_BoardManager_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시판 관리자");

            migrationBuilder.CreateTable(
                name: "BoardMeta",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    List_ShowHeader = table.Column<bool>(type: "bit", nullable: false),
                    List_HeaderContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    List_ShowFooter = table.Column<bool>(type: "bit", nullable: false),
                    List_FooterContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    List_Layout = table.Column<byte>(type: "tinyint", nullable: true),
                    List_Sort = table.Column<byte>(type: "tinyint", nullable: true),
                    List_PerPage = table.Column<byte>(type: "tinyint", nullable: false),
                    List_AlwaysShowWriteButton = table.Column<bool>(type: "bit", nullable: false),
                    List_ShowFooterListView = table.Column<bool>(type: "bit", nullable: false),
                    List_IsNewIcon = table.Column<bool>(type: "bit", nullable: false),
                    List_IsHotIcon = table.Column<bool>(type: "bit", nullable: false),
                    List_ExceptNotice = table.Column<bool>(type: "bit", nullable: false),
                    List_ExceptSpeaker = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowBookmark = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowLike = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowDislike = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowPrint = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowSnsShare = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowPrevNextBotton = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowBlame = table.Column<bool>(type: "bit", nullable: false),
                    View_BlameHideCount = table.Column<int>(type: "int", nullable: false),
                    View_AllowContentLinkTargetBlank = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowPostUrlCopy = table.Column<bool>(type: "bit", nullable: false),
                    View_AllowPostUrlQrCode = table.Column<bool>(type: "bit", nullable: false),
                    View_ShowMemberPhoto = table.Column<bool>(type: "bit", nullable: false),
                    View_ShowMemberIcon = table.Column<bool>(type: "bit", nullable: false),
                    View_ShowMemberRegDate = table.Column<bool>(type: "bit", nullable: false),
                    View_ShowMemberSummary = table.Column<bool>(type: "bit", nullable: false),
                    Write_ShowHeader = table.Column<bool>(type: "bit", nullable: false),
                    Write_HeaderContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Write_ShowFooter = table.Column<bool>(type: "bit", nullable: false),
                    Write_FooterContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Write_DefaultSubject = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Write_DefaultContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Write_AllowEditor = table.Column<bool>(type: "bit", nullable: false),
                    Write_AllowPrefix = table.Column<bool>(type: "bit", nullable: false),
                    Write_RequiredPrefix = table.Column<bool>(type: "bit", nullable: false),
                    Write_AllowSecret = table.Column<bool>(type: "bit", nullable: false),
                    Write_AllowTag = table.Column<bool>(type: "bit", nullable: false),
                    Write_TagLimit = table.Column<byte>(type: "tinyint", nullable: false),
                    Write_AllowImage = table.Column<bool>(type: "bit", nullable: false),
                    Write_ImageUploadLimit = table.Column<byte>(type: "tinyint", nullable: false),
                    Write_ImageUploadMaxSize = table.Column<int>(type: "int", nullable: false),
                    Write_AllowMedia = table.Column<bool>(type: "bit", nullable: false),
                    Write_MediaUploadLimit = table.Column<byte>(type: "tinyint", nullable: false),
                    Write_AllowFile = table.Column<bool>(type: "bit", nullable: false),
                    Write_FileUploadLimit = table.Column<byte>(type: "tinyint", nullable: false),
                    Write_FileUploadMaxSize = table.Column<int>(type: "int", nullable: false),
                    Write_FileUploadExtension = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Comment_EnableComment = table.Column<bool>(type: "bit", nullable: false),
                    Comment_PerPage = table.Column<int>(type: "int", nullable: false),
                    Comment_AllowLike = table.Column<bool>(type: "bit", nullable: false),
                    Comment_AllowDisLike = table.Column<bool>(type: "bit", nullable: false),
                    Comment_ShowMemberPhoto = table.Column<bool>(type: "bit", nullable: false),
                    Comment_ShowMemberIcon = table.Column<bool>(type: "bit", nullable: false),
                    Comment_ContentPlaceholder = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Comment_MinContentLength = table.Column<int>(type: "int", nullable: false),
                    Comment_MaxContentLength = table.Column<int>(type: "int", nullable: false),
                    Comment_EnableEditor = table.Column<bool>(type: "bit", nullable: false),
                    Comment_AllowSecret = table.Column<bool>(type: "bit", nullable: false),
                    Comment_BlameHideCount = table.Column<int>(type: "int", nullable: false),
                    Comment_DeleteProtectionDays = table.Column<int>(type: "int", nullable: false),
                    Comment_UpdateProtectionDays = table.Column<int>(type: "int", nullable: false),
                    Comment_AllowDeleteProtection = table.Column<bool>(type: "bit", nullable: false),
                    Comment_AllowUpdateProtection = table.Column<bool>(type: "bit", nullable: false),
                    Comment_EnableCommentUpdateLog = table.Column<bool>(type: "bit", nullable: false),
                    General_DeleteProtectionDays = table.Column<int>(type: "int", nullable: false),
                    General_UpdateProtectionDays = table.Column<int>(type: "int", nullable: false),
                    General_AllowDeleteProtection = table.Column<bool>(type: "bit", nullable: false),
                    General_AllowUpdateProtection = table.Column<bool>(type: "bit", nullable: false),
                    General_EnableFileDownLog = table.Column<bool>(type: "bit", nullable: false),
                    General_EnableLinkClickLog = table.Column<bool>(type: "bit", nullable: false),
                    General_EnablePostUpdateLog = table.Column<bool>(type: "bit", nullable: false),
                    Permission_BoardAccess = table.Column<short>(type: "smallint", nullable: false),
                    Permission_PostView = table.Column<short>(type: "smallint", nullable: false),
                    Permission_PostWrite = table.Column<short>(type: "smallint", nullable: false),
                    Permission_CommentView = table.Column<short>(type: "smallint", nullable: false),
                    Permission_CommentWrite = table.Column<short>(type: "smallint", nullable: false),
                    Permission_ReplyWrite = table.Column<short>(type: "smallint", nullable: false),
                    Permission_FileUpload = table.Column<short>(type: "smallint", nullable: false),
                    Permission_FileDownload = table.Column<short>(type: "smallint", nullable: false),
                    Notify_PostWriteNotify = table.Column<byte>(type: "tinyint", nullable: true),
                    Notify_CommentWriteNotify = table.Column<byte>(type: "tinyint", nullable: true),
                    Notify_ReplyWriteNotify = table.Column<byte>(type: "tinyint", nullable: true),
                    NotifyTemplate_PostWriteEmailNotifySubject = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    NotifyTemplate_PostWriteEmailNotifyContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    NotifyTemplate_CommentWriteEmailNotifySubject = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    NotifyTemplate_CommentWriteEmailNotifyContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    NotifyTemplate_ReplyWriteEmailNotifySubject = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    NotifyTemplate_ReplyWriteEmailNotifyContent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Exp_EnableExp = table.Column<bool>(type: "bit", nullable: false),
                    Exp_ShowExpGuide = table.Column<bool>(type: "bit", nullable: false),
                    Exp_PostWriteExp = table.Column<int>(type: "int", nullable: false),
                    Exp_CommentWriteExp = table.Column<int>(type: "int", nullable: false),
                    Exp_FileUploadExp = table.Column<int>(type: "int", nullable: false),
                    Exp_FileDownloadExp = table.Column<short>(type: "smallint", nullable: false),
                    Exp_OtherPostReadExp = table.Column<short>(type: "smallint", nullable: false),
                    Exp_OtherPostLikeExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostDisLikeExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherCommentLikeExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherCommentDisLikeExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostReadExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostLikeExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostDisLikeExp = table.Column<short>(type: "smallint", nullable: false),
                    Exp_OwnCommentLikeExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnCommentDisLikeExp = table.Column<short>(type: "smallint", nullable: false),
                    Exp_PostWriteUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_CommentWriteUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_FileUploadUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostReadUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostDisLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherCommentLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherCommentDisLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostReadUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostDisLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnCommentLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnCommentDisLikeUndoExp = table.Column<int>(type: "int", nullable: false),
                    Exp_PostWriteExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_CommentWriteExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_FileUploadExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostReadExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherPostDisLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherCommentLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OtherCommentDisLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostReadExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnPostDisLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnCommentLikeExpWithinDays = table.Column<int>(type: "int", nullable: false),
                    Exp_OwnCommentDisLikeExpWithinDays = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BoardMeta", x => x.ID);
                    table.ForeignKey(
                        name: "FK_BoardMeta_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시판 설정");

            migrationBuilder.CreateTable(
                name: "BoardPrefix",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "말머리"),
                    Color = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "색상"),
                    Order = table.Column<short>(type: "smallint", nullable: false, comment: "정렬 순서"),
                    Posts = table.Column<int>(type: "int", nullable: false, comment: "사용 게시글 수"),
                    IsActive = table.Column<bool>(type: "bit", nullable: false, comment: "사용 여부"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BoardPrefix", x => x.ID);
                    table.ForeignKey(
                        name: "FK_BoardPrefix_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시판 말머리");

            migrationBuilder.CreateTable(
                name: "Post",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    BoardPrefixID = table.Column<int>(type: "int", nullable: true, comment: "게시글 말머리 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    Subject = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: false, comment: "제목"),
                    Content = table.Column<string>(type: "nvarchar(max)", maxLength: 8000, nullable: false, comment: "내용"),
                    SID = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "회원 SID"),
                    Email = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true, comment: "회원 이메일"),
                    Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "회원 이름"),
                    Thumbnail = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "대표 이미지"),
                    IsReply = table.Column<bool>(type: "bit", nullable: false, comment: "답변 여부"),
                    IsAnonymous = table.Column<bool>(type: "bit", nullable: false, comment: "익명 글 여부"),
                    IsSecret = table.Column<bool>(type: "bit", nullable: false, comment: "비밀글 여부"),
                    IsNotice = table.Column<bool>(type: "bit", nullable: false, comment: "일반 공지 여부"),
                    IsSpeaker = table.Column<bool>(type: "bit", nullable: false, comment: "전체 공지 여부"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "삭제 여부"),
                    Views = table.Column<int>(type: "int", nullable: false, comment: "조회 수"),
                    Likes = table.Column<int>(type: "int", nullable: false, comment: "좋아요"),
                    Dislikes = table.Column<int>(type: "int", nullable: false, comment: "싫어요"),
                    Comments = table.Column<int>(type: "int", nullable: false, comment: "댓글 수"),
                    Bookmarks = table.Column<int>(type: "int", nullable: false, comment: "즐겨찾기 수"),
                    Reports = table.Column<int>(type: "int", nullable: false, comment: "신고 수"),
                    Images = table.Column<byte>(type: "tinyint", nullable: false, comment: "이미지 수"),
                    Medias = table.Column<byte>(type: "tinyint", nullable: false, comment: "미디어 수"),
                    Files = table.Column<byte>(type: "tinyint", nullable: false, comment: "파일 수"),
                    Tags = table.Column<byte>(type: "tinyint", nullable: false, comment: "Tag 수"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    LastReplyUpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "마지막 답변 일시"),
                    LastCommentUpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "마지막 댓글 일시"),
                    DeletedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "삭제 일시"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Post", x => x.ID);
                    table.ForeignKey(
                        name: "FK_Post_BoardPrefix_BoardPrefixID",
                        column: x => x.BoardPrefixID,
                        principalTable: "BoardPrefix",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.SetNull);
                    table.ForeignKey(
                        name: "FK_Post_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_Post_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "게시글");

            migrationBuilder.CreateTable(
                name: "Comment",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    ParentID = table.Column<int>(type: "int", nullable: true, comment: "부모 댓글 ID"),
                    MentionMemberID = table.Column<int>(type: "int", nullable: true, comment: "언급 대상 회원 ID"),
                    Depth = table.Column<short>(type: "smallint", nullable: false, comment: "댓글 깊이"),
                    Content = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: false, comment: "댓글 내용"),
                    SID = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Email = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    IsReply = table.Column<bool>(type: "bit", nullable: false),
                    IsSecret = table.Column<bool>(type: "bit", nullable: false),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "삭제 여부"),
                    Likes = table.Column<int>(type: "int", nullable: false),
                    Dislikes = table.Column<int>(type: "int", nullable: false),
                    Reports = table.Column<int>(type: "int", nullable: false),
                    Replies = table.Column<int>(type: "int", nullable: false),
                    Score = table.Column<int>(type: "int", nullable: false, comment: "점수"),
                    Images = table.Column<int>(type: "int", nullable: false),
                    Medias = table.Column<byte>(type: "tinyint", nullable: false),
                    Files = table.Column<byte>(type: "tinyint", nullable: false),
                    IpAddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    UserAgent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Status = table.Column<byte>(type: "tinyint", nullable: false, comment: "댓글 상태"),
                    DeletedAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Comment", x => x.ID);
                    table.ForeignKey(
                        name: "FK_Comment_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_Comment_Comment_ParentID",
                        column: x => x.ParentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_Comment_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_Comment_Member_MentionMemberID",
                        column: x => x.MentionMemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.SetNull);
                    table.ForeignKey(
                        name: "FK_Comment_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "댓글");

            migrationBuilder.CreateTable(
                name: "PostBookmark",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    MemberID = table.Column<int>(type: "int", nullable: false),
                    IpAddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    UserAgent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostBookmark", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostBookmark_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostBookmark_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_PostBookmark_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 즐겨찾기");

            migrationBuilder.CreateTable(
                name: "PostFile",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    UUID = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    FileName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    HashedName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Path = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Extension = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ContentType = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Size = table.Column<long>(type: "bigint", nullable: true),
                    Downloads = table.Column<int>(type: "int", nullable: false),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostFile", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostFile_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostFile_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 파일");

            migrationBuilder.CreateTable(
                name: "PostImage",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    UUID = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "이미지 ID"),
                    FileName = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: false, comment: "원본 파일명"),
                    HashedName = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: false, comment: "저장 파일명"),
                    Path = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: false, comment: "저장 경로"),
                    Url = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: false, comment: "URL"),
                    Extension = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "확장자"),
                    ContentType = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "MIME 타입"),
                    Size = table.Column<long>(type: "bigint", nullable: true, comment: "용량(byte)"),
                    Width = table.Column<short>(type: "smallint", nullable: true, comment: "가로 해상도(px)"),
                    Height = table.Column<short>(type: "smallint", nullable: true, comment: "세로 해상도(px)"),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false, comment: "비활성 여부"),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "비활성 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostImage", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostImage_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostImage_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 이미지");

            migrationBuilder.CreateTable(
                name: "PostLink",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    UUID = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Clicks = table.Column<int>(type: "int", nullable: false),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostLink", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostLink_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostLink_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 링크");

            migrationBuilder.CreateTable(
                name: "PostMedia",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostMedia", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostMedia_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostMedia_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 미디어");

            migrationBuilder.CreateTable(
                name: "PostReaction",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    Reaction = table.Column<byte>(type: "tinyint", nullable: false, comment: "반응 구분"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-agent"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostReaction", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostReaction_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostReaction_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_PostReaction_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 반응");

            migrationBuilder.CreateTable(
                name: "PostReport",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    Type = table.Column<byte>(type: "tinyint", nullable: false, comment: "신고 사유"),
                    Reason = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: true, comment: "신고 내용"),
                    Status = table.Column<byte>(type: "tinyint", nullable: false, comment: "처리 상태"),
                    Memo = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: true, comment: "처리 내용"),
                    IpAddress = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-agent"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostReport", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostReport_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostReport_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_PostReport_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 신고");

            migrationBuilder.CreateTable(
                name: "PostTag",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    TagID = table.Column<int>(type: "int", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostTag", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostTag_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostTag_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_PostTag_Tag_TagID",
                        column: x => x.TagID,
                        principalTable: "Tag",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 태그 연결");

            migrationBuilder.CreateTable(
                name: "PostUpdateLog",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    SubjectDiff = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true, comment: "변경 제목"),
                    ContentDiff = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true, comment: "변경 내용"),
                    Note = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "비고"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostUpdateLog", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostUpdateLog_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_PostUpdateLog_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 수정 로그");

            migrationBuilder.CreateTable(
                name: "CommentFile",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    CommentID = table.Column<int>(type: "int", nullable: false),
                    UUID = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    FileName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    HashedName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Path = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Extension = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ContentType = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Size = table.Column<long>(type: "bigint", nullable: true),
                    Downloads = table.Column<int>(type: "int", nullable: false),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentFile", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentFile_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentFile_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentFile_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 파일");

            migrationBuilder.CreateTable(
                name: "CommentImage",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    CommentID = table.Column<int>(type: "int", nullable: false),
                    UUID = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    FileName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    HashedName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Path = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Extension = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ContentType = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Size = table.Column<long>(type: "bigint", nullable: true),
                    Width = table.Column<short>(type: "smallint", nullable: true),
                    Height = table.Column<short>(type: "smallint", nullable: true),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentImage", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentImage_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentImage_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentImage_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 이미지");

            migrationBuilder.CreateTable(
                name: "CommentLink",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    CommentID = table.Column<int>(type: "int", nullable: false),
                    UUID = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Clicks = table.Column<int>(type: "int", nullable: false),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentLink", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentLink_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentLink_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentLink_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 링크");

            migrationBuilder.CreateTable(
                name: "CommentMedia",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false),
                    PostID = table.Column<int>(type: "int", nullable: false),
                    CommentID = table.Column<int>(type: "int", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false),
                    DisabledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentMedia", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentMedia_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentMedia_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentMedia_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 미디어");

            migrationBuilder.CreateTable(
                name: "CommentMention",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    CommentID = table.Column<int>(type: "int", nullable: false, comment: "댓글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "언급된 회원 ID"),
                    RawHandle = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false, comment: "원문 회원 언급값"),
                    Start = table.Column<int>(type: "int", nullable: false, comment: "본문 내 시작 인덱스"),
                    Length = table.Column<int>(type: "int", nullable: false, comment: "길이"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentMention", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentMention_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentMention_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentMention_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentMention_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 멘션");

            migrationBuilder.CreateTable(
                name: "CommentReaction",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    CommentID = table.Column<int>(type: "int", nullable: false, comment: "댓글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    Reaction = table.Column<byte>(type: "tinyint", nullable: false, comment: "반응 구분"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-agent"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentReaction", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentReaction_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentReaction_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentReaction_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentReaction_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 반응");

            migrationBuilder.CreateTable(
                name: "CommentReport",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BoardID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    CommentID = table.Column<int>(type: "int", nullable: false, comment: "댓글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    Type = table.Column<byte>(type: "tinyint", nullable: false, comment: "신고 사유"),
                    Reason = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: true, comment: "신고 내용"),
                    Status = table.Column<byte>(type: "tinyint", nullable: false, comment: "처리 상태"),
                    Memo = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: true, comment: "처리 내용"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-agent"),
                    UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentReport", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentReport_Board_BoardID",
                        column: x => x.BoardID,
                        principalTable: "Board",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentReport_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentReport_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentReport_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 신고");

            migrationBuilder.CreateTable(
                name: "CommentUpdateLog",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    CommentID = table.Column<int>(type: "int", nullable: false, comment: "댓글 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: false, comment: "회원 ID"),
                    ContentDiff = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true, comment: "변경 내용"),
                    Note = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "비고"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentUpdateLog", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentUpdateLog_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentUpdateLog_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "댓글 수정 로그");

            migrationBuilder.CreateTable(
                name: "PostFileDownLog",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시글 ID"),
                    PostFileID = table.Column<int>(type: "int", nullable: false, comment: "게시글 파일 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: true, comment: "회원 ID"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostFileDownLog", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostFileDownLog_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostFileDownLog_PostFile_PostFileID",
                        column: x => x.PostFileID,
                        principalTable: "PostFile",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostFileDownLog_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 파일 다운로드 로그");

            migrationBuilder.CreateTable(
                name: "PostLinkClickLog",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    PostID = table.Column<int>(type: "int", nullable: false, comment: "게시판 ID"),
                    PostLinkID = table.Column<int>(type: "int", nullable: false, comment: "게시글 파일 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: true, comment: "회원 ID"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostLinkClickLog", x => x.ID);
                    table.ForeignKey(
                        name: "FK_PostLinkClickLog_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostLinkClickLog_PostLink_PostLinkID",
                        column: x => x.PostLinkID,
                        principalTable: "PostLink",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PostLinkClickLog_Post_PostID",
                        column: x => x.PostID,
                        principalTable: "Post",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "게시글 링크 클릭 로그");

            migrationBuilder.CreateTable(
                name: "CommentFileDownLog",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    CommentID = table.Column<int>(type: "int", nullable: false, comment: "댓글 ID"),
                    CommentFileID = table.Column<int>(type: "int", nullable: false, comment: "댓글 파일 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: true, comment: "회원 ID"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentFileDownLog", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentFileDownLog_CommentFile_CommentFileID",
                        column: x => x.CommentFileID,
                        principalTable: "CommentFile",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentFileDownLog_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentFileDownLog_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 파일 다운로드 로그");

            migrationBuilder.CreateTable(
                name: "CommentLinkClickLog",
                columns: table => new
                {
                    ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                        .Annotation("SqlServer:Identity", "1, 1"),
                    CommentID = table.Column<int>(type: "int", nullable: false, comment: "댓글 ID"),
                    CommentLinkID = table.Column<int>(type: "int", nullable: false, comment: "댓글 링크 ID"),
                    MemberID = table.Column<int>(type: "int", nullable: true, comment: "회원 ID"),
                    IpAddress = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "IP Address"),
                    UserAgent = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "User-Agent"),
                    CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CommentLinkClickLog", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CommentLinkClickLog_CommentLink_CommentLinkID",
                        column: x => x.CommentLinkID,
                        principalTable: "CommentLink",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_CommentLinkClickLog_Comment_CommentID",
                        column: x => x.CommentID,
                        principalTable: "Comment",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_CommentLinkClickLog_Member_MemberID",
                        column: x => x.MemberID,
                        principalTable: "Member",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Restrict);
                },
                comment: "댓글 링크 클릭 로그");

            migrationBuilder.CreateIndex(
                name: "IX_Board_BoardGroupID",
                table: "Board",
                column: "BoardGroupID");

            migrationBuilder.CreateIndex(
                name: "IX_Board_Code",
                table: "Board",
                column: "Code",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_Board_Code_IsActive",
                table: "Board",
                columns: new[] { "Code", "IsActive" });

            migrationBuilder.CreateIndex(
                name: "IX_Board_Code_IsSearch",
                table: "Board",
                columns: new[] { "Code", "IsSearch" });

            migrationBuilder.CreateIndex(
                name: "IX_Board_Comments",
                table: "Board",
                column: "Comments");

            migrationBuilder.CreateIndex(
                name: "IX_Board_IsActive",
                table: "Board",
                column: "IsActive");

            migrationBuilder.CreateIndex(
                name: "IX_Board_IsSearch",
                table: "Board",
                column: "IsSearch");

            migrationBuilder.CreateIndex(
                name: "IX_Board_IsSearch_IsActive",
                table: "Board",
                columns: new[] { "IsSearch", "IsActive" });

            migrationBuilder.CreateIndex(
                name: "IX_Board_Name",
                table: "Board",
                column: "Name");

            migrationBuilder.CreateIndex(
                name: "IX_Board_Order",
                table: "Board",
                column: "Order");

            migrationBuilder.CreateIndex(
                name: "IX_Board_Posts",
                table: "Board",
                column: "Posts");

            migrationBuilder.CreateIndex(
                name: "IX_BoardGroup_Code",
                table: "BoardGroup",
                column: "Code",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_BoardGroup_Code_Order_CreatedAt",
                table: "BoardGroup",
                columns: new[] { "Code", "Order", "CreatedAt" });

            migrationBuilder.CreateIndex(
                name: "IX_BoardGroup_Order",
                table: "BoardGroup",
                column: "Order");

            migrationBuilder.CreateIndex(
                name: "IX_BoardGroup_Order_CreatedAt",
                table: "BoardGroup",
                columns: new[] { "Order", "CreatedAt" });

            migrationBuilder.CreateIndex(
                name: "IX_BoardManager_BoardID",
                table: "BoardManager",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_BoardManager_BoardID_MemberID",
                table: "BoardManager",
                columns: new[] { "BoardID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_BoardManager_MemberID",
                table: "BoardManager",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_BoardMeta_BoardID",
                table: "BoardMeta",
                column: "BoardID",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_BoardPrefix_BoardID_IsActive_Order_CreatedAt",
                table: "BoardPrefix",
                columns: new[] { "BoardID", "IsActive", "Order", "CreatedAt" });

            migrationBuilder.CreateIndex(
                name: "IX_Comment_BoardID",
                table: "Comment",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_Comment_MemberID",
                table: "Comment",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_Comment_MentionMemberID",
                table: "Comment",
                column: "MentionMemberID");

            migrationBuilder.CreateIndex(
                name: "IX_Comment_ParentID",
                table: "Comment",
                column: "ParentID");

            migrationBuilder.CreateIndex(
                name: "IX_Comment_PostID",
                table: "Comment",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_Comment_PostID_IsDeleted_ParentID_CreatedAt",
                table: "Comment",
                columns: new[] { "PostID", "IsDeleted", "ParentID", "CreatedAt" },
                descending: new[] { false, false, false, true });

            migrationBuilder.CreateIndex(
                name: "IX_Comment_PostID_IsDeleted_ParentID_Score_ID",
                table: "Comment",
                columns: new[] { "PostID", "IsDeleted", "ParentID", "Score", "ID" },
                descending: new[] { false, false, false, true, true });

            migrationBuilder.CreateIndex(
                name: "IX_Comment_PostID_MemberID_IsDeleted_ParentID_CreatedAt",
                table: "Comment",
                columns: new[] { "PostID", "MemberID", "IsDeleted", "ParentID", "CreatedAt" },
                descending: new[] { false, false, false, false, true });

            migrationBuilder.CreateIndex(
                name: "IX_Comment_PostID_MemberID_IsDeleted_ParentID_Score_ID",
                table: "Comment",
                columns: new[] { "PostID", "MemberID", "IsDeleted", "ParentID", "Score", "ID" },
                descending: new[] { false, false, false, false, true, true });

            migrationBuilder.CreateIndex(
                name: "IX_CommentFile_BoardID",
                table: "CommentFile",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentFile_CommentID",
                table: "CommentFile",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentFile_PostID",
                table: "CommentFile",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentFile_UUID",
                table: "CommentFile",
                column: "UUID",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_CommentFileDownLog_CommentFileID",
                table: "CommentFileDownLog",
                column: "CommentFileID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentFileDownLog_CommentID",
                table: "CommentFileDownLog",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentFileDownLog_CommentID_CommentFileID",
                table: "CommentFileDownLog",
                columns: new[] { "CommentID", "CommentFileID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentFileDownLog_CommentID_CommentFileID_MemberID",
                table: "CommentFileDownLog",
                columns: new[] { "CommentID", "CommentFileID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentFileDownLog_MemberID",
                table: "CommentFileDownLog",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentImage_BoardID",
                table: "CommentImage",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentImage_CommentID",
                table: "CommentImage",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentImage_PostID",
                table: "CommentImage",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentImage_UUID",
                table: "CommentImage",
                column: "UUID",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_CommentLink_BoardID",
                table: "CommentLink",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentLink_CommentID",
                table: "CommentLink",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentLink_PostID",
                table: "CommentLink",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentLinkClickLog_CommentID",
                table: "CommentLinkClickLog",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentLinkClickLog_CommentID_CommentLinkID",
                table: "CommentLinkClickLog",
                columns: new[] { "CommentID", "CommentLinkID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentLinkClickLog_CommentID_CommentLinkID_MemberID",
                table: "CommentLinkClickLog",
                columns: new[] { "CommentID", "CommentLinkID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentLinkClickLog_CommentLinkID",
                table: "CommentLinkClickLog",
                column: "CommentLinkID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentLinkClickLog_MemberID",
                table: "CommentLinkClickLog",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentMedia_BoardID",
                table: "CommentMedia",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentMedia_CommentID",
                table: "CommentMedia",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentMedia_PostID",
                table: "CommentMedia",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_BoardID",
                table: "CommentMention",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_CommentID",
                table: "CommentMention",
                column: "CommentID",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_CommentID_ID",
                table: "CommentMention",
                columns: new[] { "CommentID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_CommentID_MemberID_ID",
                table: "CommentMention",
                columns: new[] { "CommentID", "MemberID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_CommentID_MemberID_Start",
                table: "CommentMention",
                columns: new[] { "CommentID", "MemberID", "Start" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_MemberID",
                table: "CommentMention",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentMention_PostID",
                table: "CommentMention",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_BoardID",
                table: "CommentReaction",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_CommentID",
                table: "CommentReaction",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_CommentID_ID",
                table: "CommentReaction",
                columns: new[] { "CommentID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_CommentID_MemberID",
                table: "CommentReaction",
                columns: new[] { "CommentID", "MemberID" },
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_CreatedAt",
                table: "CommentReaction",
                column: "CreatedAt");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_MemberID",
                table: "CommentReaction",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_PostID",
                table: "CommentReaction",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReaction_Reaction",
                table: "CommentReaction",
                column: "Reaction");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_BoardID",
                table: "CommentReport",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_CommentID",
                table: "CommentReport",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_CommentID_ID",
                table: "CommentReport",
                columns: new[] { "CommentID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_CommentID_MemberID",
                table: "CommentReport",
                columns: new[] { "CommentID", "MemberID" },
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_CreatedAt",
                table: "CommentReport",
                column: "CreatedAt");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_MemberID",
                table: "CommentReport",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_PostID",
                table: "CommentReport",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_Status",
                table: "CommentReport",
                column: "Status");

            migrationBuilder.CreateIndex(
                name: "IX_CommentReport_Type",
                table: "CommentReport",
                column: "Type");

            migrationBuilder.CreateIndex(
                name: "IX_CommentUpdateLog_CommentID",
                table: "CommentUpdateLog",
                column: "CommentID");

            migrationBuilder.CreateIndex(
                name: "IX_CommentUpdateLog_CommentID_ID",
                table: "CommentUpdateLog",
                columns: new[] { "CommentID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentUpdateLog_CommentID_MemberID",
                table: "CommentUpdateLog",
                columns: new[] { "CommentID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentUpdateLog_CommentID_MemberID_ID",
                table: "CommentUpdateLog",
                columns: new[] { "CommentID", "MemberID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_CommentUpdateLog_ContentDiff",
                table: "CommentUpdateLog",
                column: "ContentDiff");

            migrationBuilder.CreateIndex(
                name: "IX_CommentUpdateLog_MemberID",
                table: "CommentUpdateLog",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_Post_BoardID",
                table: "Post",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_Post_BoardPrefixID",
                table: "Post",
                column: "BoardPrefixID");

            migrationBuilder.CreateIndex(
                name: "IX_Post_ID_BoardID",
                table: "Post",
                columns: new[] { "ID", "BoardID" });

            migrationBuilder.CreateIndex(
                name: "IX_Post_ID_BoardID_BoardPrefixID_IsDeleted_Comments",
                table: "Post",
                columns: new[] { "ID", "BoardID", "BoardPrefixID", "IsDeleted", "Comments" });

            migrationBuilder.CreateIndex(
                name: "IX_Post_ID_BoardID_BoardPrefixID_IsDeleted_CreatedAt",
                table: "Post",
                columns: new[] { "ID", "BoardID", "BoardPrefixID", "IsDeleted", "CreatedAt" });

            migrationBuilder.CreateIndex(
                name: "IX_Post_ID_BoardID_BoardPrefixID_IsDeleted_Likes",
                table: "Post",
                columns: new[] { "ID", "BoardID", "BoardPrefixID", "IsDeleted", "Likes" });

            migrationBuilder.CreateIndex(
                name: "IX_Post_ID_BoardID_BoardPrefixID_IsDeleted_Views",
                table: "Post",
                columns: new[] { "ID", "BoardID", "BoardPrefixID", "IsDeleted", "Views" });

            migrationBuilder.CreateIndex(
                name: "IX_Post_ID_BoardID_IsDeleted",
                table: "Post",
                columns: new[] { "ID", "BoardID", "IsDeleted" });

            migrationBuilder.CreateIndex(
                name: "IX_Post_MemberID",
                table: "Post",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostBookmark_BoardID",
                table: "PostBookmark",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostBookmark_MemberID",
                table: "PostBookmark",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostBookmark_PostID",
                table: "PostBookmark",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostBookmark_PostID_MemberID",
                table: "PostBookmark",
                columns: new[] { "PostID", "MemberID" },
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_PostFile_BoardID",
                table: "PostFile",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostFile_PostID",
                table: "PostFile",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostFile_UUID",
                table: "PostFile",
                column: "UUID",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_PostFileDownLog_MemberID",
                table: "PostFileDownLog",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostFileDownLog_PostFileID",
                table: "PostFileDownLog",
                column: "PostFileID");

            migrationBuilder.CreateIndex(
                name: "IX_PostFileDownLog_PostID",
                table: "PostFileDownLog",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostFileDownLog_PostID_PostFileID",
                table: "PostFileDownLog",
                columns: new[] { "PostID", "PostFileID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostFileDownLog_PostID_PostFileID_MemberID",
                table: "PostFileDownLog",
                columns: new[] { "PostID", "PostFileID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostImage_BoardID",
                table: "PostImage",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostImage_PostID",
                table: "PostImage",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostImage_PostID_HashedName",
                table: "PostImage",
                columns: new[] { "PostID", "HashedName" });

            migrationBuilder.CreateIndex(
                name: "IX_PostImage_PostID_HashedName_IsDisabled",
                table: "PostImage",
                columns: new[] { "PostID", "HashedName", "IsDisabled" });

            migrationBuilder.CreateIndex(
                name: "IX_PostImage_UUID",
                table: "PostImage",
                column: "UUID",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_PostLink_BoardID",
                table: "PostLink",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostLink_PostID",
                table: "PostLink",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostLinkClickLog_MemberID",
                table: "PostLinkClickLog",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostLinkClickLog_PostID",
                table: "PostLinkClickLog",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostLinkClickLog_PostID_PostLinkID",
                table: "PostLinkClickLog",
                columns: new[] { "PostID", "PostLinkID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostLinkClickLog_PostID_PostLinkID_MemberID",
                table: "PostLinkClickLog",
                columns: new[] { "PostID", "PostLinkID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostLinkClickLog_PostLinkID",
                table: "PostLinkClickLog",
                column: "PostLinkID");

            migrationBuilder.CreateIndex(
                name: "IX_PostMedia_BoardID",
                table: "PostMedia",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostMedia_PostID",
                table: "PostMedia",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReaction_BoardID",
                table: "PostReaction",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReaction_MemberID",
                table: "PostReaction",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReaction_PostID",
                table: "PostReaction",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReaction_PostID_MemberID",
                table: "PostReaction",
                columns: new[] { "PostID", "MemberID" },
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_PostReaction_Reaction",
                table: "PostReaction",
                column: "Reaction");

            migrationBuilder.CreateIndex(
                name: "IX_PostReport_BoardID",
                table: "PostReport",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReport_MemberID",
                table: "PostReport",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReport_PostID",
                table: "PostReport",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostReport_PostID_MemberID",
                table: "PostReport",
                columns: new[] { "PostID", "MemberID" },
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_PostReport_Status",
                table: "PostReport",
                column: "Status");

            migrationBuilder.CreateIndex(
                name: "IX_PostReport_Type",
                table: "PostReport",
                column: "Type");

            migrationBuilder.CreateIndex(
                name: "IX_PostTag_BoardID",
                table: "PostTag",
                column: "BoardID");

            migrationBuilder.CreateIndex(
                name: "IX_PostTag_PostID",
                table: "PostTag",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostTag_TagID",
                table: "PostTag",
                column: "TagID");

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_ContentDiff",
                table: "PostUpdateLog",
                column: "ContentDiff");

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_MemberID",
                table: "PostUpdateLog",
                column: "MemberID");

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_PostID",
                table: "PostUpdateLog",
                column: "PostID");

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_PostID_ID",
                table: "PostUpdateLog",
                columns: new[] { "PostID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_PostID_MemberID",
                table: "PostUpdateLog",
                columns: new[] { "PostID", "MemberID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_PostID_MemberID_ID",
                table: "PostUpdateLog",
                columns: new[] { "PostID", "MemberID", "ID" });

            migrationBuilder.CreateIndex(
                name: "IX_PostUpdateLog_SubjectDiff",
                table: "PostUpdateLog",
                column: "SubjectDiff");

            migrationBuilder.CreateIndex(
                name: "IX_Tag_Name",
                table: "Tag",
                column: "Name",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_Tag_Slug",
                table: "Tag",
                column: "Slug",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_Tag_UsageCount",
                table: "Tag",
                column: "UsageCount");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "BoardManager");

            migrationBuilder.DropTable(
                name: "BoardMeta");

            migrationBuilder.DropTable(
                name: "CommentFileDownLog");

            migrationBuilder.DropTable(
                name: "CommentImage");

            migrationBuilder.DropTable(
                name: "CommentLinkClickLog");

            migrationBuilder.DropTable(
                name: "CommentMedia");

            migrationBuilder.DropTable(
                name: "CommentMention");

            migrationBuilder.DropTable(
                name: "CommentReaction");

            migrationBuilder.DropTable(
                name: "CommentReport");

            migrationBuilder.DropTable(
                name: "CommentUpdateLog");

            migrationBuilder.DropTable(
                name: "PostBookmark");

            migrationBuilder.DropTable(
                name: "PostFileDownLog");

            migrationBuilder.DropTable(
                name: "PostImage");

            migrationBuilder.DropTable(
                name: "PostLinkClickLog");

            migrationBuilder.DropTable(
                name: "PostMedia");

            migrationBuilder.DropTable(
                name: "PostReaction");

            migrationBuilder.DropTable(
                name: "PostReport");

            migrationBuilder.DropTable(
                name: "PostTag");

            migrationBuilder.DropTable(
                name: "PostUpdateLog");

            migrationBuilder.DropTable(
                name: "CommentFile");

            migrationBuilder.DropTable(
                name: "CommentLink");

            migrationBuilder.DropTable(
                name: "PostFile");

            migrationBuilder.DropTable(
                name: "PostLink");

            migrationBuilder.DropTable(
                name: "Tag");

            migrationBuilder.DropTable(
                name: "Comment");

            migrationBuilder.DropTable(
                name: "Post");

            migrationBuilder.DropTable(
                name: "BoardPrefix");

            migrationBuilder.DropTable(
                name: "Board");

            migrationBuilder.DropTable(
                name: "BoardGroup");
        }
    }
}