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