poketmon
Tables (14)
addresses
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- address_detail — VARCHAR(255)
- is_default — BOOLEAN
- created_at — TIMESTAMP
auction_bids
- id — BIGINT
- auction_id — BIGINT — Foreign key → auctions.id — NOT NULL
- bidder_id — BIGINT — Foreign key → users.id — NOT NULL
- bid_price — DECIMAL(12, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE / WON / LOST / CANCELLED
- created_at — TIMESTAMP
auctions
- id — BIGINT
- card_catalog_id — BIGINT — Foreign key → card_catalogs.id — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- grade — VARCHAR(20) — NOT NULL — PSA_10 / PSA_9 / BGS_10 등
- edition — VARCHAR(50) — 1ST_EDITION / UNLIMITED 등
- starting_price — DECIMAL(12, 2) — NOT NULL — 시작가
- buyout_price — DECIMAL(12, 2) — 즉시구매가 (선택)
- current_highest_price — DECIMAL(12, 2) — 현재 최고 입찰가
- highest_bidder_id — BIGINT — Foreign key → users.id — 현재 최고 입찰자
- status — VARCHAR(20) — NOT NULL — ACTIVE / ENDED / NO_BIDDER / CANCELLED
- started_at — TIMESTAMP — NOT NULL
- ended_at — TIMESTAMP — NOT NULL — 경매 종료 시점
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
card_catalogs
- id — BIGINT
- tcgdex_id — VARCHAR(100) — TCGdex 외부 ID (없으면 null)
- name — VARCHAR(255) — NOT NULL
- series — VARCHAR(100) — 시리즈명
- set_name — VARCHAR(100) — 세트명
- rarity — VARCHAR(50) — 레어도
- image_url — VARCHAR(500)
- source — VARCHAR(20) — NOT NULL — TCGDEX / MANUAL
- status — VARCHAR(20) — NOT NULL — ACTIVE / PENDING
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
chat_messages
- id — BIGINT
- chat_id — BIGINT — NOT NULL
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP
chats
- id — BIGINT
- direct_listing_id — BIGINT — Foreign key → direct_listings.id — NOT NULL
- buyer_id — BIGINT — Foreign key → users.id — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE / COMPLETED / CANCELLED
- created_at — TIMESTAMP
direct_listings
- id — BIGINT
- card_catalog_id — BIGINT — Foreign key → card_catalogs.id — 선택 연결
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- grade — VARCHAR(50) — PSA / BGS / RAW 등
- price — DECIMAL(12, 2) — NOT NULL
- card_image_url — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL — ACTIVE / RESERVED / COMPLETED / CANCELLED
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
inspections
- id — BIGINT
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- inspector_id — BIGINT — 검수 담당자
- status — VARCHAR(20) — NOT NULL — IN_PROGRESS / PASSED / FAILED
- note — TEXT — 검수 메모
- inspected_at — TIMESTAMP
- created_at — TIMESTAMP
notifications
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL — BID_OUTBID / AUCTION_WON / AUCTION_LOST / INSPECTION_PASSED / INSPECTION_FAILED / SHIPPING / COMPLETED / CHAT_MESSAGE
- title — VARCHAR(255) — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
orders
- id — BIGINT
- order_type — VARCHAR(20) — NOT NULL — AUCTION / DIRECT
- auction_id — BIGINT — Foreign key → auctions.id — AUCTION 타입일 때
- direct_listing_id — BIGINT — Foreign key → direct_listings.id — DIRECT 타입일 때
- buyer_id — BIGINT — Foreign key → users.id — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- address_id — BIGINT — Foreign key → addresses.id — NOT NULL
- final_price — DECIMAL(12, 2) — NOT NULL
- status — VARCHAR(30) — NOT NULL — PAYMENT_PENDING / PAYMENT_COMPLETED / INSPECTION / INSPECTION_FAILED / SHIPPING / COMPLETED / CANCELLED
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payments
- id — BIGINT
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- amount — DECIMAL(12, 2) — NOT NULL
- payment_method — VARCHAR(50) — CARD / KAKAO_PAY 등
- status — VARCHAR(20) — NOT NULL — PENDING / COMPLETED / FAILED / REFUNDED
- paid_at — TIMESTAMP
- created_at — TIMESTAMP
reviews
- id — BIGINT
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- reviewer_id — BIGINT — Foreign key → users.id — NOT NULL
- reviewee_id — BIGINT — Foreign key → users.id — NOT NULL
- score — INT — NOT NULL — 1~5점
- comment — TEXT — EX
- created_at — TIMESTAMP
settlements
- id — BIGINT
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- seller_id — BIGINT — NOT NULL
- total_price — DECIMAL(12, 2) — NOT NULL
- platform_fee — DECIMAL(12, 2) — NOT NULL — 플랫폼 수수료
- seller_amount — DECIMAL(12, 2) — NOT NULL — 판매자 정산 금액
- status — VARCHAR(20) — NOT NULL — PENDING / COMPLETED
- settled_at — TIMESTAMP
- created_at — TIMESTAMP
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- role — VARCHAR(20) — NOT NULL — USER / ADMIN
- manner_score — DECIMAL(3, 1) — 일반거래 매너 점수
- created_at — TIMESTAMP
- updated_at — TIMESTAMP