best-offer
Tables (4)
Untitled (users)
- Key (id) — BIGINT — Primary key — NOT NULL — auto increment
- Field (email) — VARCHAR(255) — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (nickname) — VARCHAR(100) — NOT NULL
- Field (role) — VARCHAR(20) — NOT NULL — ROLE_USER, ROLE_ADMIN
- Field (status) — VARCHAR(20) — NOT NULL — ACTIVE, INACTIVE, BANNED
- Field (created_date) — DATETIME — NOT NULL
- Field (modified_date) — DATETIME — NOT NULL
Untitled (auctions)
- Key (id) — BIGINT — Primary key — NOT NULL — auto increment
- Field (title) — VARCHAR(255) — NOT NULL
- Field (description) — TEXT — NOT NULL
- Field (start_price) — BIGINT — NOT NULL
- Field (current_price) — BIGINT — NOT NULL
- Field (end_time) — DATETIME — NOT NULL
- Field (status) — VARCHAR(20) — NOT NULL — ON_SALE, COMPLETED, DELETED
- Field (created_date) — DATETIME — NOT NULL
- Key (seller_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (highest_bidder_id) — BIGINT — Foreign key → Untitled.Key
Untitled (bids)
- Key (id) — BIGINT — Primary key — NOT NULL — auto increment
- Field (bid_price) — BIGINT — NOT NULL
- Field (bid_time) — DATETIME — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Key (auction_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — auto increment
- Key (bidder_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — auto increment
Untitled (trades)
- Key (id) — BIGINT — Primary key — NOT NULL — auto increment
- Field (auction_id) — BIGINT — NOT NULL
- Field (final_price) — BIGINT — NOT NULL
- Field (payment_status) — VARCHAR(20) — NOT NULL — UNPAID, PAID, CANCELED
- Field (shipping_status) — VARCHAR(20) — NOT NULL — PREPARING, SHIPPED, DELIVERED
- Field (created_date) — DATETIME — NOT NULL
- Key (seller_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (buyer_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL