payments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
auction_auto_payments.payment_id auction_auto_payments_ibfk_2 R
payment_logs.payment_id payment_logs_payment_id_fkey R
order_id INT 10 null
orders.id payments_ibfk_1 R
amount DECIMAL 12,2 null
method enum('STRIPE', 'GMO', 'DG') 6 null
status enum('PENDING', 'SUCCESS', 'FAILED', 'REFUNDED') 8 null
stripe_charge_id VARCHAR 255 √ 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_payments_order_id Performance Asc order_id

Relationships

Close relationships within degrees of separation