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