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