art bid
Tables (18)
ARTIST
- id — VARCHAR(36) — Primary key — NOT NULL
- memberId — VARCHAR(36) — Foreign key → MEMBER.id
- name — VARCHAR(100) — NOT NULL
- biography — VARCHAR(2000)
- profileImageUrl — VARCHAR(500)
- status — VARCHAR(30) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ARTWORK
- id — VARCHAR(36) — Primary key — NOT NULL
- consignorId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- artistId — VARCHAR(36) — Foreign key → ARTIST.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- productionYear — INT
- category — VARCHAR(50) — NOT NULL
- material — VARCHAR(100)
- width — DECIMAL(10,2)
- height — DECIMAL(10,2)
- depth — DECIMAL(10,2)
- description — VARCHAR(2000)
- conditionDescription — VARCHAR(1000)
- estimatedPriceMin — INT
- estimatedPriceMax — INT
- certificateUrl — VARCHAR(500)
- reviewStatus — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ARTWORK_MEDIA
- id — VARCHAR(36) — Primary key — NOT NULL
- artworkId — VARCHAR(36) — Foreign key → ARTWORK.id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- url — VARCHAR(500) — NOT NULL
- thumbnailUrl — VARCHAR(500)
- sortOrder — INT — NOT NULL
- processingStatus — VARCHAR(30) — NOT NULL
- createdAt — DATETIME — NOT NULL
ARTWORK_REVIEW
- id — VARCHAR(36) — Primary key — NOT NULL
- artworkId — VARCHAR(36) — Foreign key → ARTWORK.id — NOT NULL
- reviewerId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- result — VARCHAR(30) — NOT NULL
- comment — VARCHAR(1000)
- reviewedAt — DATETIME — NOT NULL
AUCTION_CONTROL_LOG
- id — VARCHAR(36) — Primary key — NOT NULL
- auctionEventId — VARCHAR(36) — Foreign key → AUCTION_EVENT.id — NOT NULL
- auctionLotId — VARCHAR(36) — Foreign key → AUCTION_LOT.id
- operatorId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- action — VARCHAR(50) — NOT NULL
- previousStatus — VARCHAR(30)
- newStatus — VARCHAR(30)
- reason — VARCHAR(500)
- createdAt — DATETIME — NOT NULL
AUCTION_EVENT
- id — VARCHAR(36) — Primary key — NOT NULL
- type — VARCHAR(30) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — VARCHAR(2000)
- currentLotId — VARCHAR(36)
- previewStartAt — DATETIME
- previewEndAt — DATETIME
- scheduledStartAt — DATETIME — NOT NULL
- scheduledEndAt — DATETIME — NOT NULL
- actualStartAt — DATETIME
- actualEndAt — DATETIME
- status — VARCHAR(30) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
AUCTION_LOT
- id — VARCHAR(36) — Primary key — NOT NULL
- auctionEventId — VARCHAR(36) — Foreign key → AUCTION_EVENT.id — NOT NULL
- artworkId — VARCHAR(36) — Foreign key → ARTWORK.id — NOT NULL
- lotNumber — INT — NOT NULL
- startPrice — INT — NOT NULL
- reservePrice — INT
- currentPrice — INT — NOT NULL
- bidIncrement — INT — NOT NULL
- buyerPremiumRate — DECIMAL(5,4) — NOT NULL
- shippingFee — INT
- preBidStartAt — DATETIME
- biddingStartAt — DATETIME — NOT NULL
- biddingEndAt — DATETIME — NOT NULL
- extendedEndAt — DATETIME
- status — VARCHAR(30) — NOT NULL
- result — VARCHAR(30)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
AUTO_BID
- id — VARCHAR(36) — Primary key — NOT NULL
- auctionLotId — VARCHAR(36) — Foreign key → AUCTION_LOT.id — NOT NULL
- bidderId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- maxAmount — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
BID
- id — VARCHAR(36) — Primary key — NOT NULL
- auctionLotId — VARCHAR(36) — Foreign key → AUCTION_LOT.id — NOT NULL
- bidderId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- autoBidId — VARCHAR(36) — Foreign key → AUTO_BID.id
- idempotencyKey — VARCHAR(100) — NOT NULL
- amount — INT — NOT NULL
- bidType — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- cancelReason — VARCHAR(500)
- createdAt — DATETIME — NOT NULL
- cancelledAt — DATETIME
FAVORITE
- id — VARCHAR(36) — Primary key — NOT NULL
- memberId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- artworkId — VARCHAR(36) — Foreign key → ARTWORK.id — NOT NULL
- createdAt — DATETIME — NOT NULL
LIVESTREAM
- id — VARCHAR(36) — Primary key — NOT NULL
- auctionEventId — VARCHAR(36) — Foreign key → AUCTION_EVENT.id — NOT NULL
- platform — VARCHAR(30) — NOT NULL
- broadcastUrl — VARCHAR(500) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- scheduledStartAt — DATETIME
- startedAt — DATETIME
- endedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
MEMBER
- id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
MEMBER_RESTRICTION
- id — VARCHAR(36) — Primary key — NOT NULL
- memberId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- restrictionType — VARCHAR(30) — NOT NULL
- reason — VARCHAR(500) — NOT NULL
- startsAt — DATETIME — NOT NULL
- endsAt — DATETIME
- createdAt — DATETIME — NOT NULL
NOTIFICATION
- id — VARCHAR(36) — Primary key — NOT NULL
- memberId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- message — VARCHAR(1000) — NOT NULL
- targetType — VARCHAR(30)
- targetId — VARCHAR(36)
- isRead — TINYINT(1) — NOT NULL
- createdAt — DATETIME — NOT NULL
- readAt — DATETIME
PAYMENT
- id — VARCHAR(36) — Primary key — NOT NULL
- settlementId — VARCHAR(36) — Foreign key → SETTLEMENT.id — NOT NULL
- transactionId — VARCHAR(100)
- amount — INT — NOT NULL
- method — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- failureReason — VARCHAR(500)
- requestedAt — DATETIME — NOT NULL
- paidAt — DATETIME
- refundedAt — DATETIME
SELLER_PROFILE
- id — VARCHAR(36) — Primary key — NOT NULL
- memberId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- sellerType — VARCHAR(30) — NOT NULL
- displayName — VARCHAR(100) — NOT NULL
- introduction — VARCHAR(1000)
- verificationStatus — VARCHAR(30) — NOT NULL
- verificationDocumentUrl — VARCHAR(500)
- rejectionReason — VARCHAR(500)
- verifiedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
SETTLEMENT
- id — VARCHAR(36) — Primary key — NOT NULL
- auctionLotId — VARCHAR(36) — Foreign key → AUCTION_LOT.id — NOT NULL
- winnerId — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
- hammerPrice — INT — NOT NULL
- buyerPremium — INT — NOT NULL
- shippingFee — INT
- totalAmount — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- paymentDeadlineAt — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
SHIPMENT
- id — VARCHAR(36) — Primary key — NOT NULL
- settlementId — VARCHAR(36) — Foreign key → SETTLEMENT.id — NOT NULL
- recipientName — VARCHAR(100) — NOT NULL
- recipientPhone — VARCHAR(30) — NOT NULL
- postalCode — VARCHAR(20)
- address — VARCHAR(500) — NOT NULL
- addressDetail — VARCHAR(500)
- carrier — VARCHAR(50)
- trackingNumber — VARCHAR(100)
- status — VARCHAR(30) — NOT NULL
- shippedAt — DATETIME
- deliveredAt — DATETIME
- updatedAt — DATETIME — NOT NULL