pickup

Tables (13)

AUCTION

  • auction_id — BIGINT — Primary key — NOT NULL
  • consignment_id — BIGINT — Foreign key → CONSIGNMENT.consignment_id — NOT NULL
  • winning_bid_id — BIGINT — Foreign key → BID.bid_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME
  • auction_status — VARCHAR(255) — NOT NULL
  • starting_price — BIGINT — NOT NULL
  • reserve_price — BIGINT — NOT NULL
  • bid_increment — BIGINT — NOT NULL
  • winning_price — BIGINT
  • watch_count — BIGINT — NOT NULL
  • legacy_unreserved_bid — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

BID

  • bid_id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → AUCTION.auction_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • bid_request_id — BIGINT — Foreign key → BID_REQUEST.bid_request_id
  • bid_price — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

BID_REQUEST

  • bid_request_id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → AUCTION.auction_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • bid_price — BIGINT — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • failure_code — VARCHAR(255)
  • failure_message — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • processed_at — DATETIME

CARD

  • card_id — BIGINT — Primary key — NOT NULL
  • tcgdex_id — VARCHAR(255)
  • tcgdex_set_id — VARCHAR(255)
  • card_name — VARCHAR(255) — NOT NULL
  • card_number — VARCHAR(255) — NOT NULL
  • set_name — VARCHAR(255) — NOT NULL
  • language — VARCHAR(255) — NOT NULL
  • rarity — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

CERTIFICATE

  • certificate_id — BIGINT — Primary key — NOT NULL
  • consignment_id — BIGINT — Foreign key → CONSIGNMENT.consignment_id — NOT NULL
  • serial_number — VARCHAR(255) — NOT NULL
  • grade — VARCHAR(255) — NOT NULL
  • certification_body — VARCHAR(255) — NOT NULL
  • inspected_at — DATE — NOT NULL

CONSIGNMENT

  • consignment_id — BIGINT — Primary key — NOT NULL
  • card_id — BIGINT — Foreign key → CARD.card_id — NOT NULL
  • seller_member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • card_state — VARCHAR(255)
  • major_defect — VARCHAR(255)
  • status — VARCHAR(255) — NOT NULL

CONSIGNMENT_IMAGE

  • consignment_image_id — BIGINT — Primary key — NOT NULL
  • consignment_id — BIGINT — Foreign key → CONSIGNMENT.consignment_id — NOT NULL
  • image_order — INT — NOT NULL
  • object_key — VARCHAR(255) — NOT NULL

MEMBER

  • member_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(255)
  • password — VARCHAR(255)
  • nickname — VARCHAR(255)
  • profile_image_object_key — VARCHAR(255)
  • oauth_provider — VARCHAR(255)
  • oauth_subject — VARCHAR(255)
  • status — VARCHAR(255) — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • withdrawn_at — DATETIME

MEMBER_POINT

  • point_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • balance — BIGINT — NOT NULL
  • reserved_balance — BIGINT — NOT NULL

POINT_RESERVATION

  • point_reservation_id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → AUCTION.auction_id — NOT NULL
  • bid_id — BIGINT — Foreign key → BID.bid_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • amount — BIGINT — NOT NULL
  • reservation_status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

POINT_TRANSACTION

  • point_transaction_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • auction_id — BIGINT — Foreign key → AUCTION.auction_id
  • transaction_type — VARCHAR(255) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

SETTLEMENT

  • settlement_id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → AUCTION.auction_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • settlement_type — VARCHAR(255) — NOT NULL
  • amount — BIGINT — NOT NULL
  • settlement_status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

WATCH

  • watch_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • auction_id — BIGINT — Foreign key → AUCTION.auction_id — NOT NULL
  • created_at — DATETIME — NOT NULL