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