123

Tables (14)

authors

  • authors_id — serial — Primary key — NOT NULL
  • nickname — character
  • created_at — timestamp

cash_accounts

  • user_id — integer — Primary key — NOT NULL
  • balance — bigint — NOT NULL
  • version — integer — NOT NULL
  • updated_at — timestamp — NOT NULL

cash_payments

  • payment_id — serial — Primary key — NOT NULL
  • user_id — integer — NOT NULL
  • provider — provider — NOT NULL
  • tx_id — character — NOT NULL
  • amount — bigint — NOT NULL
  • status — payment_status — NOT NULL
  • paid_at — timestamp
  • receipt_url — character
  • created_at — timestamp — NOT NULL

cash_refunds

  • refund_id — serial — Primary key — NOT NULL
  • user_id — integer — NOT NULL
  • target_transaction_id — integer
  • amount — bigint — NOT NULL
  • reason_code — smallint
  • reason_text — character
  • status — refund_status — NOT NULL
  • processed_by — integer
  • created_at — timestamp — NOT NULL
  • processed_at — timestamp

cash_transactions

  • txn_id — serial — Primary key — NOT NULL
  • user_id — integer — NOT NULL
  • direction — direction — NOT NULL
  • amount — bigint — NOT NULL
  • balance_after — bigint — NOT NULL
  • ref_type — ref_type — NOT NULL
  • ref_id — integer
  • idempotency_key — character
  • created_at — timestamp — NOT NULL

day

  • day_id — serial — Primary key — NOT NULL
  • day — days

episodes

  • episode_id — serial — Primary key — NOT NULL
  • webtoon_id — integer — NOT NULL
  • episode_title — character
  • episode_no — smallint
  • price — smallint
  • is_free — boolean
  • created_at — timestamp

favorites

  • favorite_id — serial — Primary key — NOT NULL
  • user_id — integer — NOT NULL
  • webtoon_id — integer — NOT NULL
  • created_at — timestamp

users

  • user_id — serial — Primary key — NOT NULL
  • email — character
  • email_verified_at — timestamp
  • password_hash — character
  • name — character
  • nickname — character
  • profile_image_url — character
  • phone — character
  • role — user_type — NOT NULL
  • status — active_state — NOT NULL
  • last_login_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

view_history

  • view_history_id — serial — Primary key — NOT NULL
  • episode_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • viewed_at — timestamp
  • created_at — timestamp

webtoon_authors

  • webtoon_authors_id — serial — Primary key — NOT NULL
  • webtoon_id — integer — NOT NULL
  • authors_id — integer — NOT NULL

webtoon_purchases

  • purchase_id — serial — Primary key — NOT NULL
  • user_id — integer — NOT NULL
  • episode_id — integer — NOT NULL
  • price — bigint — NOT NULL
  • created_at — timestamp — NOT NULL

webtoon_schedule

  • webtoon_schedule_id — serial — Primary key — NOT NULL
  • webtoon_id — integer — NOT NULL
  • day_id — integer — NOT NULL

webtoons

  • webtoon_id — serial — Primary key — NOT NULL
  • publisher_id — integer — NOT NULL
  • title — character — NOT NULL
  • thumbnail_url — character
  • description — character
  • genre — character
  • tags — character
  • status — webtoon_state
  • rating — real
  • language — character
  • age_rating — rating
  • created_at — timestamp