auction

Tables (4)

artworks

  • id — auto increment — Primary key — NOT NULL
  • name — varchar(255)
  • owned_by — Foreign key → buyers.id — NOT NULL

auctions

  • id — auto increment — Primary key — NOT NULL
  • end_time — timestamp
  • status — default ACTIVE
  • artwork_id — not null — Foreign key → artworks.id — NOT NULL

biddings

  • timestamp — tiemstamp — Primary key — NOT NULL
  • buyer_id — Foreign key → buyers.id — NOT NULL
  • auction_id — Foreign key → auctions.id — NOT NULL
  • request_price — integer

buyers

  • id — auto increment — Primary key — NOT NULL
  • balance — integer