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