0078_backup
Tables (44)
Agreement
- id — BIGINT — NOT NULL
- agreementUuid — VARCHAR — NOT NULL
- title — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- required — BOOLEAN — NOT NULL
Auction
- id — VARCHAR(255) — NOT NULL
- auctionUuid — VARCHAR(255)
- productUuid — VARCHAR(255)
- startingPrice — VARCHAR(255)
- highestBid — VARCHAR(255)
- highestBidderUuid — VARCHAR(255)
- startDate — VARCHAR(255)
- endDate — VARCHAR(255)
- auctionStatus — VARCHAR(255)
AuctionBidHistory
- id — VARCHAR(255) — NOT NULL
- bidHistoryUuid — VARCHAR(255)
- auctionUuid — VARCHAR(255)
- memberUuid — VARCHAR(255)
- bidAmount — VARCHAR(255)
- isHighestBid — VARCHAR(255)
- isHidden — VARCHAR(255)
BlackList
- id — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
CommentLike
- id — BIGINT — NOT NULL
- memberUUid — VARCHAR — NOT NULL
- commentUuid — VARCHAR — NOT NULL
CopyOfPieceHistory2
- Key — VARCHAR(255) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
Delivery
- id — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- zipCode — VARCHAR — NOT NULL
- mainAddress — VARCHAR — NOT NULL
- detailAddress — VARCHAR — NOT NULL
Event
- id — BIGINT — NOT NULL
- title — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- adminUuid — VARCHAR — NOT NULL
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
FAQ
- id — BIGINT — NOT NULL
- title — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- adminUuid — VARCHAR — NOT NULL
- category — ENUM — NOT NULL
Funding
- id — BIGINT — NOT NULL
- fundingUuid — VARCHAR — NOT NULL
- productUuid — VARCHAR — NOT NULL
- fundingAmount — BIGINT — NOT NULL
- piecePrice — BIGINT — NOT NULL
- totalPieces — INT — NOT NULL
- remainingPieces — INT — NOT NULL
- fundingDeadline — DATETIME — NOT NULL
- fundingStatus — ENUM — NOT NULL
FundingComment
- id — BIGINT — NOT NULL
- commentUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
FundingMember
- id — BIGINT — NOT NULL
- fundingMemberUuid — VARCHAR — NOT NULL
- fundingUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- quantity — BIGINT — NOT NULL
- status — ENUM — NOT NULL
FundingSubComment
- id — BIGINT — NOT NULL
- subCommentUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- commentUuid — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
Inquiry
- id — BIGINT — NOT NULL
- title — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- category — ENUM — NOT NULL
- status — ENUM — NOT NULL
InquiryAnswer
- id — BIGINT — NOT NULL
- inquiryId — BIGINT — NOT NULL
- content — VARCHAR — NOT NULL
- adminUuid — VARCHAR — NOT NULL
MainCategory
- id — INT — NOT NULL
- name — VARCHAR — NOT NULL
Member
- id — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- name — VARCHAR — NOT NULL
- phoneNumber — VARCHAR — NOT NULL
- birthdate — DATE — NOT NULL
- gender — ENUM — NOT NULL
- nickname — VARCHAR — NOT NULL
- status — ENUM — NOT NULL
- authority — ENUM — NOT NULL
MemberAgreement
- id — BIGINT — NOT NULL
- agreementUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- checked — BOOLEAN — NOT NULL
Money
- id — BIGINT — NOT NULL
- moneyUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- remainingMoney — BIGINT — NOT NULL
MoneyHistory
- id — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- price — BIGINT — NOT NULL
- isPositive — BOOLEAN — NOT NULL
- type — ENUM — NOT NULL
- remainingMoney — BIGINT — NOT NULL
- detail — VARCHAR
NegotiationHistory
- id — BIGINT — NOT NULL
- saleRequestUuid — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- negotiatedPrice — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- memberRole — ENUM — NOT NULL
Notice
- id — BIGINT — NOT NULL
- title — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- adminUuid — VARCHAR — NOT NULL
- Field — VARCHAR(255)
OwnedPiece
- id — BIGINT — NOT NULL
- owndedPieceUuid — VARCHAR — NOT NULL
- pieceProductUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- quantity — INT — NOT NULL
- averagePrice — BIGINT — NOT NULL
Payment
- id — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- paymentUuid — VARCHAR — NOT NULL
- paymentCode — VARCHAR — NOT NULL
- depositPrice — BIGINT — NOT NULL
- paymentState — ENUM — NOT NULL
- PGprovider — ENUM — NOT NULL
- failReason — VARCHAR — NOT NULL
- approvedAt — VARCHAR — NOT NULL
- paymentMethod — ENUM — NOT NULL
PieceComment
- id — BIGINT — NOT NULL
- commentUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
PieceSubComment
- id — BIGINT — NOT NULL
- subCommnetUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- commentUuid — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
PieceTradeReservation
- id — BIGINT — NOT NULL
- reservationUuid — VARCHAR — NOT NULL
- pieceProductUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- registeredPrice — BIGINT — NOT NULL
- desiredQuantity — INT — NOT NULL
- remainingQuantity — INT — NOT NULL
- tradeType — ENUM — NOT NULL
- tradeStatus — ENUM — NOT NULL
PieceTransactionHistory
- id — BIGINT — NOT NULL
- historyUuid — VARCHAR — NOT NULL
- pieceProductUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- price — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- tradeType — ENUM — NOT NULL
Product
- id — BIGINT — NOT NULL
- productUuid — VARCHAR — NOT NULL
- name — VARCHAR — NOT NULL
- aiEstimatedPrice — BIGINT — NOT NULL
- purchasePrice — BIGINT — NOT NULL
- productStatus — ENUM — NOT NULL
- storageLocation — VARCHAR — NOT NULL
- thumbnailImageUrl — VARCHAR — NOT NULL
- description — VARCHAR — NOT NULL
ProductCategory
- id — BIGINT — NOT NULL
- mainCategoryId — INT — NOT NULL
- subCategoryId — INT — NOT NULL
- productUuid — VARCHAR — NOT NULL
ProductImage
- id — BIGINT — NOT NULL
- productUuid — VARCHAR — NOT NULL
- imageUrl — VARCHAR — NOT NULL
SaleRequest
- id — BIGINT — NOT NULL
- saleRequestUuid — VARCHAR — NOT NULL
- boardId — VARCHAR — NOT NULL
- productImageUrl — VARCHAR
- desiredPrice — BIGINT — NOT NULL
- mainCategoryId — INT — NOT NULL
- subCategoryId — INT — NOT NULL
- aiEstimatedPrice — BIGINT
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
SubCategory
- id — INT — NOT NULL
- mainCategoryId — INT — NOT NULL
- name — VARCHAR — NOT NULL
SubCommentLike
- id — BIGINT — NOT NULL
- memberUUid — VARCHAR — NOT NULL
- subCommentUuid — VARCHAR — NOT NULL
Untitled
- id — VARCHAR(255) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field11 — VARCHAR(255)
- Field12 — VARCHAR(255)
Untitled2
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
Untitled3
- Key — VARCHAR(255) — NOT NULL
Untitled4
- Key — VARCHAR(255) — NOT NULL
Untitled5
- id — VARCHAR(255) — NOT NULL
- boardCode — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
Untitled6
- Key — VARCHAR(255) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field5 — VARCHAR(255)
WithdrawlHistory
- id — BIGINT — NOT NULL
- withdrawlUuid — VARCHAR — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- bankName — VARCHAR — NOT NULL
- accountNumber — VARCHAR — NOT NULL
- accountHolderName — VARCHAR — NOT NULL
- withdrawlPrice — BIGINT — NOT NULL
- withdrawlState — ENUM — NOT NULL
- failReason — VARCHAR — NOT NULL
liked
- id — BIGINT — NOT NULL
- memberUuid — VARCHAR — NOT NULL
- productUuid — VARCHAR — NOT NULL
notify
- id — BIGINT — NOT NULL
- notifingMemberUuid — VARCHAR — NOT NULL
- badMemberUuid — VARCHAR — NOT NULL
- commentUuid — VARCHAR — NOT NULL
- notifyReason — VARCHAR — NOT NULL
product
- id — BIGINT — NOT NULL
- pieceProductUuid — VARCHAR — NOT NULL
- productUuid — VARCHAR — NOT NULL
- marketPrice — BIGINT — NOT NULL
- totalQuantity — INT — NOT NULL