raffles

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
raffle_entries.raffle_id raffle_entries_ibfk_1 R
raffle_winners.raffle_id raffle_winners_ibfk_1 R
product_id INT 10 null
live_id INT 10 null
start_time DATETIME 23 null
end_time DATETIME 23 null
winner_count INT 10 null
status enum('PENDING', 'ACTIVE', 'ENDED', 'CANCELLED') 9 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

Relationships

Close relationships within degrees of separation