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)