4rows
6 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
route_id | TEXT | yes | PK | — |
revision | INTEGER | no | — | configurations.revision |
shipper_id | INTEGER | no | — | — |
partner_id | TEXT | no | — | partners.partner_id |
valid_from | TEXT | no | — | — |
valid_until | TEXT | yes | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_routes_1route_idData preview
Sample records
| route_id | revision | shipper_id | partner_id | valid_from | valid_until |
|---|---|---|---|---|---|
| ambiguous-a | 17 | 92 | united-package | 2018-04-01T00:00:00Z | NULL |
| ambiguous-b | 17 | 92 | united-package | 2018-04-01T00:00:00Z | NULL |
| disabled | 17 | 93 | disabled-partner | 2018-04-01T00:00:00Z | NULL |
| route-17-2 | 17 | 2 | united-package | 2018-04-01T00:00:00Z | 2018-05-19T00:00:00Z |
Interactive explorer