| field | type | obs |
|---|---|---|
| retail_id | number | PK, autoincrement |
| created_at | time | autogenerated |
| updated_at | time | autogenerated |
| name | varchar | - |
| varchar | - | |
| cpf | number | - |
| tel | number | - |
| pix | varchar | - |
| pickup_address | varchar | - |
| field | type | obs |
|---|---|---|
| courier_id | number | PK, autoincrement |
| created_at | time | autogenerated |
| updated_at | time | autogenerated |
| name | varchar | - |
| varchar | - | |
| cpf | number | - |
| tel | number | - |
| pix | varchar | - |
| vehicle_plate | varchar | - |
| vehicle_model | varchar | - |
| field | type | obs |
|---|---|---|
| delivery_id | number | autoincrement |
| created_at | time | autogenerated |
| updated_at | time | autogenerated |
| request_retail | number | from retail_table |
| called_courier | number | from courie_table |
| pickup_address | varchar | - |
| delivery_address | varchar | - |
| value_tax | number | - |
| delivery_status | number | - |
| payment_status | number | - |