raffle_winners

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
raffle_purchases.winner_id raffle_purchases_ibfk_1 R
raffle_id INT 10 null
raffles.id raffle_winners_ibfk_1 R
user_id INT 10 null
users.id raffle_winners_ibfk_2 R
notified_at DATETIME 19 √ null
purchase_deadline 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_raffle_winners_raffle_id Performance Asc raffle_id
idx_raffle_winners_user_id Performance Asc user_id
uniq_raffle_entries_user Must be unique Asc/Asc raffle_id + user_id

Relationships

Close relationships within degrees of separation