gift_transactions

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
user_id INT 10 null
users.id gift_transactions_ibfk_1 R
live_id INT 10 null
gift_type_id INT 10 null
gift_types.id gift_transactions_ibfk_2 R
amount INT 10 null
sent_at DATETIME 19 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_gift_transactions_gift_type_id Performance Asc gift_type_id
idx_gift_transactions_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation