return_requests

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
refunds.return_requestsId refunds_return_requestsId_fkey N
return_messages.request_id return_messages_request_id_fkey R
order_id INT 10 null
orders.id return_requests_order_id_fkey R
reason TEXT 65535 null
status enum('PENDING', 'APPROVED', 'REJECTED', 'COMPLETED', 'CANCELLED') 9 null
requested_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
return_requests_order_id_fkey Performance Asc order_id

Relationships

Close relationships within degrees of separation