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