auction_bids

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
auction_id INT 10 null
auctions.id auction_bids_ibfk_1 R
user_id INT 10 null
users.id auction_bids_ibfk_2 R
amount DECIMAL 12,2 null
bid_at DATETIME 23 null
created_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null
updated_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_auction_bids_auction_id Performance Asc auction_id
idx_auction_bids_user_id Performance Asc user_id
uniq_auction_auction_id_user_id_bid_at Must be unique Asc/Asc/Asc auction_id + user_id + bid_at

Relationships

Close relationships within degrees of separation