POCAT 260617

Tables (26)

ai_chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • ai_chat_session_id — BIGINT — Foreign key → ai_chat_sessions.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • token_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

ai_chat_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • session_uuid — VARCHAR(36) — NOT NULL
  • total_tokens — INT — NOT NULL
  • is_expired — TINYINT(1) — NOT NULL
  • last_active_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

ai_prompt_template

  • id — BIGINT — Primary key — NOT NULL
  • card_grade — VARCHAR(20) — NOT NULL
  • prompt_text — TEXT — NOT NULL
  • version — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

auction_bids

  • id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → auctions.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • bid_price — BIGINT — NOT NULL
  • status — ENUM('CANCELLED','LEADING','LOST','OUTBID','WON') — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

auction_snapshots

  • id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → auctions.id — NOT NULL
  • final_price — BIGINT
  • snapshot_json — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

auctions

  • id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → users.id — NOT NULL
  • card_id — BIGINT — Foreign key → cards.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — ENUM('ACTIVE','APPROVED','CANCELLED','ENDED','INSPECTING','NO_BIDDER', 'PAYMENT_PENDING','PENDING','REJECTED') — NOT NULL
  • starting_price — BIGINT — NOT NULL
  • buyout_price — BIGINT
  • highest_price — BIGINT
  • highest_bidder_id — BIGINT
  • started_at — DATETIME(6)
  • ended_at — DATETIME(6)
  • inspected_at — DATETIME(6)
  • inspected_by — BIGINT
  • reason — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

card_ai_analysis

  • id — BIGINT — Primary key — NOT NULL
  • card_id — BIGINT — Foreign key → cards.id — NOT NULL
  • price_trend — VARCHAR(10) — NOT NULL
  • fair_value_estimate — BIGINT
  • demand_level — VARCHAR(10) — NOT NULL
  • summary — TEXT
  • highlights — TEXT
  • risk_factors — TEXT
  • keywords — TEXT
  • analysis_model — VARCHAR(100)
  • prompt_tokens — INT
  • completion_tokens — INT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

cards

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • tcgdex_id — VARCHAR(100)
  • name — VARCHAR(255) — NOT NULL
  • card_number — VARCHAR(20) — NOT NULL
  • rarity — VARCHAR(50) — NOT NULL
  • image_url — VARCHAR(500)
  • reject_reason — TEXT
  • category — ENUM('ENERGY','POKEMON','TRAINERS','UNKNOWN') — NOT NULL
  • grade — ENUM('BGS_10','PSA_10','PSA_9') — NOT NULL
  • source — ENUM('MANUAL','TCGDEX') — NOT NULL
  • status — ENUM('ACTIVE','PENDING','REJECTED') — NOT NULL
  • series_id — BIGINT — Foreign key → series.id
  • pokemon_set_id — BIGINT — Foreign key → pokemon_sets.id
  • pokemon_id — BIGINT — Foreign key → pokemon.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • chat_id — BIGINT — Foreign key → chats.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BIT(1) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

chats

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → trade_posts.id — NOT NULL
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • guest_id — BIGINT — Foreign key → users.id — NOT NULL
  • owner_left — BIT(1) — NOT NULL
  • guest_left — BIT(1) — NOT NULL
  • status — ENUM('ACTIVE','CANCELLED','COMPLETED') — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

comments

  • id — BIGINT — Primary key — NOT NULL
  • free_post_id — BIGINT — Foreign key → free_posts.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_id — BIGINT — Foreign key → comments.id
  • content — TEXT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

free_posts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

likes

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • auction_id — BIGINT — Foreign key → auctions.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — ENUM('AUCTION_ACTIVATED','AUCTION_CANCELLED','AUCTION_LOST','AUCTION_SOLD', 'AUCTION_WON','AUTO_PAYMENT_FAILED','BID_CREATED','BID_OUTBID', 'DIRECT_PAYMENT_FAILED','ESCALATED_PAYMENT_OPPORTUNITY','INSPECTION_FAILED', 'INSPECTION_PASSED','ORDER_CANCELLED','PAYMENT_COMPLETED','PAYMENT_FINAL_FAILED', 'REFUND_APPROVED','REFUND_REJECTED','REFUND_REQUESTED','SETTLEMENT_COMPLETED', 'SETTLEMENT_CREATED','CHAT_MESSAGE') — NOT NULL
  • message — VARCHAR(255) — NOT NULL
  • related_data — VARCHAR(255)
  • is_read — BIT(1) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

order_snapshots

  • id — BIGINT — Primary key — NOT NULL
  • order_uid — VARCHAR(50) — NOT NULL
  • final_price — BIGINT — NOT NULL
  • fee — BIGINT — NOT NULL
  • fee_rate — BIGINT — NOT NULL
  • seller_amount — BIGINT — NOT NULL
  • snapshot_json — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

orders

  • id — BIGINT — Primary key — NOT NULL
  • order_uid — VARCHAR(50) — NOT NULL
  • buyer_id — BIGINT — Foreign key → users.id — NOT NULL
  • seller_id — BIGINT — Foreign key → users.id
  • card_id — BIGINT — Foreign key → cards.id — NOT NULL
  • auction_id — BIGINT — Foreign key → auctions.id
  • bidder_rank — INT
  • order_type — ENUM('AUCTION','BUYOUT') — NOT NULL
  • final_price — BIGINT — NOT NULL
  • status — ENUM('AUTO_PAYMENT_FAILED','CANCELLED','DIRECT_PAYMENT_FAILED', 'ORDER_COMPLETED','PAYMENT_COMPLETED','PAYMENT_PENDING','REFUNDED') — NOT NULL
  • cancel_reason — VARCHAR(255)
  • payment_deadline — DATETIME(6)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

outbox_events

  • id — BIGINT — Primary key — NOT NULL
  • topic — VARCHAR(50) — NOT NULL
  • partition_key — VARCHAR(100) — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • payload — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • processed_at — DATETIME(6)

payments

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • payment_uid — VARCHAR(50) — NOT NULL
  • payment_type — ENUM('BILLING_KEY','PG_DIRECT') — NOT NULL
  • payment_method — VARCHAR(50)
  • amount — BIGINT — NOT NULL
  • status — ENUM('CANCELLED','CANCEL_HTTP_ERROR','COMPLETED','FAILED','PENDING','REFUNDED') — NOT NULL
  • paid_at — DATETIME(6)
  • billing_key_requested_at — DATETIME(6)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

pokemon

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_ko — VARCHAR(100)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

pokemon_sets

  • id — BIGINT — Primary key — NOT NULL
  • series_id — BIGINT — Foreign key → series.id
  • set_id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_ko — VARCHAR(1000)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

refunds

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • payment_id — BIGINT — Foreign key → payments.id — NOT NULL
  • amount — BIGINT — NOT NULL
  • reason — VARCHAR(100) — NOT NULL
  • reject_reason — VARCHAR(100)
  • failure_reason — VARCHAR(255)
  • status — ENUM('COMPLETED','FAILED_FINAL','FAILED_RETRYABLE','PROCESSING','REJECTED','REQUESTED') — NOT NULL
  • retry_count — INT — NOT NULL
  • next_retry_at — DATETIME(6)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

series

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_ko — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

settlements

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • settlement_uid — VARCHAR(50) — NOT NULL
  • seller_id — BIGINT — Foreign key → users.id
  • total_price — BIGINT — NOT NULL
  • platform_fee — BIGINT — NOT NULL
  • seller_amount — BIGINT — NOT NULL
  • status — ENUM('COMPLETED','PENDING','REFUNDED') — NOT NULL
  • settled_at — DATETIME(6)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

trade_posts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • thumbnail — TEXT
  • price — BIGINT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • address — VARCHAR(255)
  • billing_key — VARCHAR(255)
  • user_role — ENUM('ADMIN','USER') — NOT NULL
  • is_bid_blocked — BIT(1) — NOT NULL
  • unpaid_strike — INT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

webhook_events

  • id — BIGINT — Primary key — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • payment_id — VARCHAR(100) — NOT NULL
  • raw_body — TEXT — NOT NULL
  • status — ENUM('FAILED','PROCESSED','RECEIVED') — NOT NULL
  • created_at — DATETIME(6)