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