Table: orders
updated_at (ascending)
Total: 29 records
Loading relationships diagram...
| Column | Value |
|---|
| Column | Type | Nullable | Default | Primary Key |
|---|---|---|---|---|
| id | integer | No | NULL |
Yes |
| customer_id | integer | No | NULL |
No |
| order_number | string | Yes | NULL |
No |
| order_date | datetime | Yes | NULL |
No |
| status | string | Yes | NULL |
No |
| total_amount | decimal | Yes | NULL |
No |
| created_at | datetime | No | NULL |
No |
| updated_at | datetime | No | NULL |
No |
| shipping_address_id | integer | Yes | NULL |
No |
| billing_address_id | integer | Yes | NULL |
No |
| Name | Columns | Unique |
|---|---|---|
| index_orders_on_billing_address_id | billing_address_id | No |
| index_orders_on_customer_id | customer_id | No |
| index_orders_on_order_number | order_number | Yes |
| index_orders_on_shipping_address_id | shipping_address_id | No |