using Microsoft.EntityFrameworkCore;
using Domain.Entities.Common;
using Domain.Entities.Members;
using Domain.Entities.Page;
using Domain.Entities.Page.Faq;
using Domain.Entities.Page.Banner;
using Domain.Entities.Members.Logs;
using Domain.Entities.Wallets;
using Domain.Entities.Forum.Boards;
using Domain.Entities.Forum.Posts;
using Domain.Entities.Forum.Comments;
using Domain.Entities.Director;
using Domain.Entities.EmailVerification;
using Domain.Entities.Forum.Logs;
using Domain.Entities.Page.Popup;
using Domain.Entities.Notes;
using Domain.Entities.Payments.Toss;
using Domain.Entities.Feed;
using Domain.Entities.Store;
using Domain.Entities.Stocks;
using Domain.Entities.Chat;

namespace Application.Abstractions.Data;

// IAsyncDisposable: 팩토리(IAppDbContextFactory)로 만든 out-of-band 컨텍스트를 `await using` 으로 해제하기 위함.
// 스코프 등록 컨텍스트는 DI 가 해제하므로 이 계약 추가는 기존 사용처에 영향이 없다. (Phase 1.5)
public interface IAppDbContext : IAsyncDisposable
{
    // 관리자
    DbSet<AdminLoginLog> AdminLoginLog { get; set; }
    DbSet<AdminAccessLog> AdminAccessLog { get; set; }

    // 각종 설정 및 페이지
    DbSet<Config> Config { get; set;  }
    DbSet<EmailLog> EmailLog { get; set; }
    DbSet<Document> Document { get; set;  }
    DbSet<PopupPosition> PopupPosition { get; set; }
    DbSet<Popup> Popup { get; set;  }
    DbSet<FaqCategory> FaqCategory { get; set;  }
    DbSet<FaqItem> FaqItem { get; set;  }
    DbSet<BannerPosition> BannerPosition { get; set;  }
    DbSet<BannerItem> BannerItem { get; set;  }

    // 회원
    DbSet<Member> Member { get; set; }
    DbSet<MemberStats> MemberStats { get; set; }
    DbSet<MemberApprove> MemberApprove { get; set; }
    DbSet<MemberGrade> MemberGrade { get; set; }
    DbSet<MemberLoginLog> MemberLoginLog { get; set; }
    DbSet<MemberEmailChangeLog> MemberEmailChangeLog { get; set; }
    DbSet<MemberNameChangeLog> MemberNameChangeLog { get; set; }
    DbSet<MemberSummaryChangeLog> MemberSummaryChangeLog { get; set; }
    DbSet<MemberIntroChangeLog> MemberIntroChangeLog { get; set; }
    DbSet<MemberThumbChangeLog> MemberThumbChangeLog { get; set; }
    DbSet<MemberItemUsageLog> MemberItemUsageLog { get; set; }
    DbSet<MemberExpLog> MemberExpLog { get; set; }
    DbSet<MemberDailyRewardCounter> MemberDailyRewardCounter { get; set; }
    DbSet<Attendance> Attendance { get; set; }
    DbSet<MemberFollow> MemberFollow { get; set; }
    DbSet<MemberTrackRecord> MemberTrackRecord { get; set; }
    DbSet<MemberItem> MemberItem { get; set; }
    DbSet<Channel> Channel { get; set; }
    DbSet<ChannelHandleHistory> ChannelHandleHistory { get; set; }
    DbSet<BroadcastSession> BroadcastSession { get; set; }
    DbSet<ChannelBroadcastStats> ChannelBroadcastStats { get; set; }
    DbSet<RefreshToken> RefreshToken { get; set; }
    DbSet<MemberOAuthToken> MemberOAuthToken { get; set; }

    // 이메일 인증
    DbSet<EmailVerifyToken> EmailVerifyToken { get; set; }
    DbSet<EmailVerifyNumber> EmailVerifyNumber { get; set; }

    // 지갑
    DbSet<Wallet> Wallet { get; set; }
    DbSet<WalletTransaction> WalletTransaction { get; set; }

    // 게시판
    DbSet<BoardGroup> BoardGroup { get; set; }
    DbSet<Board> Board { get; set; }
    DbSet<BoardMeta> BoardMeta { get; set; }
    DbSet<BoardManager> BoardManager { get; set; }
    DbSet<BoardPrefix> BoardPrefix { get; set; }

    // 게시글
    DbSet<Post> Post { get; set; }
    DbSet<PostImage> PostImage { get; set; }
    DbSet<PostMedia> PostMedia { get; set; }
    DbSet<PostFile> PostFile { get; set; }
    DbSet<PostLink> PostLink { get; set; }
    DbSet<PostReaction> PostReaction { get; set; }
    DbSet<PostBookmark> PostBookmark { get; set; }
    DbSet<PostReport> PostReport { get; set; }
    DbSet<PostTag> PostTag { get; set; }
    DbSet<Tag> Tag { get; set; }
    DbSet<PostCheer> PostCheer { get; set; }
    DbSet<PostStockTag> PostStockTag { get; set; }
    DbSet<PostPrediction> PostPrediction { get; set; }

    // 댓글
    DbSet<Comment> Comment { get; set; }
    DbSet<CommentFile> CommentFile { get; set; }
    DbSet<CommentImage> CommentImage { get; set; }
    DbSet<CommentMedia> CommentMedia { get; set; }
    DbSet<CommentLink> CommentLink { get; set; }
    DbSet<CommentReaction> CommentReaction { get; set; }
    DbSet<CommentReport> CommentReport { get; set; }
    DbSet<CommentMention> CommentMention { get; set; }

    // 게시글/댓글 로그
    DbSet<PostUpdateLog> PostUpdateLog { get; set; }
    DbSet<PostFileDownLog> PostFileDownLog { get; set; }
    DbSet<PostLinkClickLog> PostLinkClickLog { get; set; }
    DbSet<PostViewLog> PostViewLog { get; set; }
    DbSet<CommentUpdateLog> CommentUpdateLog { get; set; }
    DbSet<CommentFileDownLog> CommentFileDownLog { get; set; }
    DbSet<CommentLinkClickLog> CommentLinkClickLog { get; set; }

    // 피드 (X/Twitter + Reddit 스타일 — Forum과 완전 분리)
    DbSet<FeedPost> FeedPost { get; set; }
    DbSet<FeedComment> FeedComment { get; set; }
    DbSet<FeedLike> FeedLike { get; set; }
    DbSet<FeedCommentLike> FeedCommentLike { get; set; }
    DbSet<FeedBookmark> FeedBookmark { get; set; }
    DbSet<FeedTag> FeedTag { get; set; }
    DbSet<FeedPostTag> FeedPostTag { get; set; }
    DbSet<FeedPostImage> FeedPostImage { get; set; }
    DbSet<FeedPostMedia> FeedPostMedia { get; set; }
    DbSet<FeedPostMention> FeedPostMention { get; set; }

    // 쪽지
    DbSet<Note> Note { get; set; }

    // 알림
    DbSet<Domain.Entities.Notifications.Notification> Notification { get; set; }

    // 결제
    DbSet<Domain.Entities.Payments.PaymentOrder> PaymentOrder { get; set; }
    DbSet<TossConfirm> TossConfirm { get; set; }
    DbSet<TossCancel> TossCancel { get; set; }
    DbSet<TossLog> TossLog { get; set; }
    DbSet<Domain.Entities.Payments.PaymentReconcileLog> PaymentReconcileLog { get; set; }

    // 상점 (Store)
    DbSet<Game> Game { get; set; }
    DbSet<GameGenre> GameGenre { get; set; }
    DbSet<GameCategory> GameCategory { get; set; }
    DbSet<GameGenreMap> GameGenreMap { get; set; }
    DbSet<GameCategoryMap> GameCategoryMap { get; set; }
    DbSet<GameImage> GameImage { get; set; }
    DbSet<GameLanguage> GameLanguage { get; set; }
    DbSet<GameLanguageSupport> GameLanguageSupport { get; set; }
    DbSet<Product> Product { get; set; }
    DbSet<Coupon> Coupon { get; set; }
    DbSet<CouponCode> CouponCode { get; set; }
    DbSet<Order> Order { get; set; }
    DbSet<OrderItem> OrderItem { get; set; }
    DbSet<OrderRefund> OrderRefund { get; set; }
    DbSet<OrderRefundItem> OrderRefundItem { get; set; }
    DbSet<MemberInventory> MemberInventory { get; set; }
    DbSet<MemberAddress> MemberAddress { get; set; }
    DbSet<Shipment> Shipment { get; set; }
    DbSet<GameSettlement> GameSettlement { get; set; }
    DbSet<ProductLimitConfig> ProductLimitConfig { get; set; }

    // 주식 (Stocks — 개미투자 D1)
    DbSet<Stock> Stock { get; set; }
    DbSet<StockDailyPrice> StockDailyPrice { get; set; }
    DbSet<IndexDailyPrice> IndexDailyPrice { get; set; }
    DbSet<BondIndexDailyPrice> BondIndexDailyPrice { get; set; }
    DbSet<EtpDailyTrade> EtpDailyTrade { get; set; }
    DbSet<WarrantDailyTrade> WarrantDailyTrade { get; set; }
    DbSet<BondDailyTrade> BondDailyTrade { get; set; }
    DbSet<MarketHoliday> MarketHoliday { get; set; }
    DbSet<StockBoardStats> StockBoardStats { get; set; }

    // 채팅 (Chat — 개미투자 D2)
    DbSet<ChatRoomConfig> ChatRoomConfig { get; set; }
    DbSet<ChatBan> ChatBan { get; set; }

    // 모의투자 (Paper — 개미투자 D4)
    DbSet<Domain.Entities.Paper.PaperAccount> PaperAccount { get; set; }
    DbSet<Domain.Entities.Paper.PaperPosition> PaperPosition { get; set; }
    DbSet<Domain.Entities.Paper.PaperOrder> PaperOrder { get; set; }
    DbSet<Domain.Entities.Paper.PaperFill> PaperFill { get; set; }
    DbSet<Domain.Entities.Paper.PaperLedger> PaperLedger { get; set; }
    DbSet<Domain.Entities.Paper.PaperDailySnapshot> PaperDailySnapshot { get; set; }

    Task<int> SaveChangesAsync(CancellationToken ct = default);
}