barotoon
Tables (37)
analytics_settings
- id — BIGINT
- ga_measurement_id — VARCHAR(50)
- enabled — TINYINT(1) — NOT NULL
api_providers
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- vendor — VARCHAR(100)
audit_logs
- id — BIGINT
- actor_user_id — BIGINT
- action — VARCHAR(100) — NOT NULL
- payload — JSON
- created_at — DATETIME — NOT NULL
auto_translate_jobs
- id — BIGINT
- translation_id — BIGINT — NOT NULL
- source — ENUM('EXCEL','BULK') — NOT NULL
- status — ENUM('QUEUED','RUNNING','DONE','FAILED') — NOT NULL
- log — JSON
- created_at — DATETIME — NOT NULL
balloon_texts
- id — BIGINT
- translation_page_id — BIGINT — NOT NULL
- bbox — JSON — NOT NULL
- src_text — TEXT
- tgt_text — TEXT
- font_style_id — BIGINT
- style_overrides — JSON
banners
- id — BIGINT
- page — ENUM('HOME','DETAIL','CART','SEARCH','MY') — NOT NULL
- image_url — VARCHAR(512) — NOT NULL
- link_url — VARCHAR(512)
- active — TINYINT(1) — NOT NULL
- sort_no — INT — NOT NULL
coupon_redemptions
- id — BIGINT
- coupon_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- order_id — BIGINT — NOT NULL
- used_at — DATETIME — NOT NULL
coupons
- id — BIGINT
- code — VARCHAR(50) — NOT NULL
- discount_type — ENUM('PERCENT','FIXED') — NOT NULL
- percent — INT
- amount — INT
- min_purchase — INT
- starts_at — DATETIME
- ends_at — DATETIME
- max_uses — INT
download_assets
- id — BIGINT
- translation_id — BIGINT — NOT NULL
- format — ENUM('JPG','PSD','PNG') — NOT NULL
- path — VARCHAR(512) — NOT NULL
- created_at — DATETIME — NOT NULL
episode_versions
- id — BIGINT
- episode_id — BIGINT — NOT NULL
- lang — CHAR(5) — NOT NULL
- vtype — ENUM('ORIGINAL','TRANSLATED') — NOT NULL
- status — ENUM('READY','ON_SALE','BLOCKED') — NOT NULL
- api_provider_id — BIGINT
- allow_continue — TINYINT(1) — NOT NULL
episodes
- id — BIGINT
- work_id — BIGINT — NOT NULL
- episode_no — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- preview — TINYINT(1) — NOT NULL
- state — ENUM('ON','OFF','HIDDEN') — NOT NULL
- released_at — DATETIME
faqs
- id — BIGINT
- question — VARCHAR(255) — NOT NULL
- answer — TEXT — NOT NULL
- status — ENUM('DRAFT','PUBLISHED') — NOT NULL
- updated_at — DATETIME — NOT NULL
favorites
- user_id — BIGINT — Primary key — NOT NULL
- work_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
font_styles
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- family — VARCHAR(100) — NOT NULL
- size_px — INT — NOT NULL
- weight — ENUM('THIN','LIGHT','REGULAR','MEDIUM','BOLD','BLACK') — NOT NULL
- letter_spacing — FLOAT
inquiries
- id — BIGINT
- user_id — BIGINT
- email — VARCHAR(255)
- message — TEXT — NOT NULL
- status — ENUM('RECEIVED','ANSWERED','CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
library
- user_id — BIGINT — Primary key — NOT NULL
- episode_version_id — BIGINT — Primary key — NOT NULL
- last_read_at — DATETIME — NOT NULL
- last_position — VARCHAR(128)
order_items
- id — BIGINT
- order_id — BIGINT — NOT NULL
- episode_version_id — BIGINT — NOT NULL
- price — INT — NOT NULL
- qty — INT — NOT NULL
orders
- id — BIGINT
- user_id — BIGINT — NOT NULL
- subtotal — INT — NOT NULL
- discount — INT — NOT NULL
- total — INT — NOT NULL
- coupon_id — BIGINT
- status — ENUM('PENDING','PAID','CANCELED','REFUNDED') — NOT NULL
- created_at — DATETIME — NOT NULL
page_assets
- id — BIGINT
- episode_version_id — BIGINT — NOT NULL
- page_no — INT — NOT NULL
- image_url — VARCHAR(512)
- psd_url — VARCHAR(512)
- meta — JSON
payments
- id — BIGINT
- order_id — BIGINT — NOT NULL
- provider — ENUM('TOSS','KG','KCP','PAYPAL','INAPP') — NOT NULL
- tx_id — VARCHAR(128) — NOT NULL
- amount — INT — NOT NULL
- status — ENUM('READY','PAID','FAILED') — NOT NULL
- receipt_url — VARCHAR(512)
- paid_at — DATETIME
prices
- id — BIGINT
- scope_type — ENUM('EPISODE','WORK') — NOT NULL
- scope_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- currency — CHAR(3) — NOT NULL
project_files
- id — BIGINT
- project_id — BIGINT — NOT NULL
- ftype — ENUM('IMAGE','PSD','ZIP') — NOT NULL
- path — VARCHAR(512) — NOT NULL
- status — ENUM('UPLOADED','PARSED') — NOT NULL
- created_at — DATETIME — NOT NULL
projects
- id — BIGINT
- owner_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- visibility — ENUM('PRIVATE','PUBLIC') — NOT NULL
- thumbnail_url — VARCHAR(512)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
publish_requests
- id — BIGINT
- publisher_id — BIGINT — NOT NULL
- episode_id — BIGINT — NOT NULL
- requested_by — BIGINT — NOT NULL
- status — ENUM('REQUESTED','APPROVED','REJECTED') — NOT NULL
- reject_code — TINYINT
- reject_reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- reviewed_at — DATETIME
publishers
- id — BIGINT
- user_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- company_no — VARCHAR(50)
- created_at — DATETIME — NOT NULL
recently_viewed
- user_id — BIGINT — Primary key — NOT NULL
- episode_version_id — BIGINT — Primary key — NOT NULL
- last_read_at — DATETIME — NOT NULL
- last_position — VARCHAR(128)
refunds
- id — BIGINT
- order_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- status — ENUM('REQUESTED','APPROVED','DONE','REJECTED') — NOT NULL
- reason_code — TINYINT
- reason_text — VARCHAR(255)
- created_at — DATETIME — NOT NULL
settlement_items
- id — BIGINT
- settlement_id — BIGINT — NOT NULL
- order_id — BIGINT — NOT NULL
- work_id — BIGINT — NOT NULL
- episode_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
settlements
- id — BIGINT
- publisher_id — BIGINT — NOT NULL
- period_start — DATE — NOT NULL
- period_end — DATE — NOT NULL
- amount — INT — NOT NULL
- status — ENUM('PENDING','PAID') — NOT NULL
- created_at — DATETIME — NOT NULL
share_links
- id — BIGINT
- translation_id — BIGINT — NOT NULL
- token — VARCHAR(64) — NOT NULL
- short_url — VARCHAR(255)
- expires_at — DATETIME
- created_at — DATETIME — NOT NULL
tags
- id — BIGINT
- name — VARCHAR(64) — NOT NULL
translation_pages
- id — BIGINT
- translation_id — BIGINT — NOT NULL
- page_no — INT — NOT NULL
- src_image — VARCHAR(512)
- result_image — VARCHAR(512)
- meta — JSON
translations
- id — BIGINT
- project_id — BIGINT — NOT NULL
- src_lang — CHAR(5) — NOT NULL
- tgt_lang — CHAR(5) — NOT NULL
- primary_api_id — BIGINT
- secondary_api_id — BIGINT
- status — ENUM('EDITING','DONE','SHARED') — NOT NULL
- created_at — DATETIME — NOT NULL
user_identities
- id — BIGINT
- user_id — BIGINT — NOT NULL
- provider — ENUM('GOOGLE','KAKAO','NAVER','FACEBOOK') — NOT NULL
- provider_user_id — VARCHAR(191) — NOT NULL
- provider_email — VARCHAR(320)
- display_name — VARCHAR(100)
- profile_image_url — VARCHAR(500)
- token_expires_at — DATETIME
- linked_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_ui_user
- INDEX — idx_ui_provider
users
- id — BIGINT
- email — VARCHAR(320)
- email_verified_at — DATETIME
- password_hash — VARCHAR(255)
- name — VARCHAR(100)
- nickname — VARCHAR(50)
- profile_image_url — VARCHAR(500)
- phone — VARCHAR(30)
- role — ENUM('ADMIN','PUBLISHER','READER') — NOT NULL
- status — ENUM('ACTIVE','BLOCKED') — NOT NULL
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- INDEX — idx_users_status
- INDEX — idx_users_last_login
- INDEX — idx_users_deleted_at
work_tags
- work_id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Primary key — NOT NULL
works
- id — BIGINT
- publisher_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- synopsis — TEXT
- cover_url — VARCHAR(512)
- age_rating — ENUM('ALL','12','15','18') — NOT NULL
- status — ENUM('DRAFT','PUBLISHED','PRIVATE') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- FULLTEXT — KEY