TextFlow-ERD new

Tables (12)

comment_likes

  • like_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • comment_id — bigint — Foreign key → comments.comment_id — NOT NULL
  • created_at — datetime — NOT NULL

comments

  • comment_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id
  • episode_id — bigint — Foreign key → episodes.episode_id — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • parent_id — bigint — Foreign key → comments.comment_id

episode_daily_metrics

  • id — bigint — Primary key — NOT NULL
  • episode_id — bigint — Foreign key → episodes.episode_id — NOT NULL
  • metric_date — date — NOT NULL
  • view_count — bigint — NOT NULL
  • like_count — bigint — NOT NULL
  • comment_count — bigint — NOT NULL

episode_likes

  • like_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • episode_id — bigint — Foreign key → episodes.episode_id — NOT NULL
  • created_at — datetime — NOT NULL

episodes

  • episode_id — bigint — Primary key — NOT NULL
  • work_id — bigint — Foreign key → works.work_id — NOT NULL
  • episode_no — int — NOT NULL
  • title — varchar(255)
  • content — longtext
  • content_meta — json
  • content_type — enum('TEXT', 'IMAGE', 'MIXED') — NOT NULL
  • episode_length — int — 웹소설 글자수 또는 웹툰 컷수
  • price — decimal(10, 2) — NOT NULL
  • status — enum('PENDING', 'APPROVED', 'REJECTED') — NOT NULL
  • is_adult — tinyint(1) — NOT NULL
  • view_count — bigint — NOT NULL
  • like_count — bigint — NOT NULL
  • comment_count — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

payments

  • payment_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • episode_id — bigint — Foreign key → episodes.episode_id
  • amount — decimal(10,2) — NOT NULL
  • currency — varchar(10) — NOT NULL
  • provider — varchar(50) — NOT NULL
  • provider_payment_id — varchar(255)
  • status — enum('PENDING','SUCCESS','FAILED','CANCELLED') — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • method — varchar(50) — NOT NULL

points_ledger

  • ledger_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • delta — bigint — NOT NULL
  • balance_after — bigint — NOT NULL
  • reason — varchar(100) — NOT NULL
  • reference_payment_id — bigint — Foreign key → payments.payment_id
  • created_at — datetime — NOT NULL

reports

  • report_id — bigint — Primary key — NOT NULL
  • reporter_id — bigint — Foreign key → users.user_id
  • reason — varchar(500) — NOT NULL
  • status — enum('OPEN','RESOLVED','REJECTED') — NOT NULL
  • admin_note — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • target_type — enum('USER','WORK','EPISODE','COMMENT')
  • target_id — bigint

user_balances

  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • balance — bigint — NOT NULL
  • updated_at — datetime — NOT NULL

user_episode_access

  • access_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • episode_id — bigint — Foreign key → episodes.episode_id — NOT NULL
  • type — enum('OWN','RENT') — NOT NULL
  • price — decimal(10,2) — NOT NULL
  • payment_id — bigint — Foreign key → payments.payment_id
  • ledger_id — bigint — Foreign key → points_ledger.ledger_id
  • purchased_at — datetime — NOT NULL
  • expires_at — datetime
  • active — tinyint(1) — NOT NULL

users

  • user_id — bigint — Primary key — NOT NULL
  • username — varchar(50) — NOT NULL
  • password_hash — varchar(255)
  • role — enum('READER','AUTHOR','ADMIN') — NOT NULL
  • email — varchar(255)
  • display_name — varchar(100)
  • bio — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

works

  • work_id — bigint — Primary key — NOT NULL
  • author_id — bigint — Foreign key → users.user_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • slug — varchar(255)
  • description — longtext
  • category — varchar(100)
  • thumbnail_url — varchar(500)
  • status — enum('PENDING','APPROVED','REJECTED') — NOT NULL
  • view_count — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • is_adult — tinyint(1) — NOT NULL
  • publication_status — varchar(20) — NOT NULL