9rows
8 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
request_id | | yes | — | — |
order_id | | yes | — | — |
route_id | | yes | — | — |
partner_id | | yes | — | — |
valid_from | | yes | — | — |
valid_until | | yes | — | — |
current_config | | yes | — | — |
business_clock | | yes | — | — |
View definition
CREATE VIEW current_routes AS SELECT r.request_id,r.order_id,p.route_id,p.partner_id,p.valid_from,p.valid_until,w.current_config,w.business_clock FROM requests r CROSS JOIN workspace_state w LEFT JOIN routes p ON p.shipper_id=r.shipper_id AND p.revision=w.current_config AND p.valid_from<=w.business_clock AND (p.valid_until IS NULL OR w.business_clock<p.valid_until)Data preview
Sample records
| request_id | order_id | route_id | partner_id | valid_from | valid_until | current_config |
|---|---|---|---|---|---|---|
| request-11038 | 11038 | NULL | NULL | NULL | NULL | 17 |
| request-11045 | 11045 | NULL | NULL | NULL | NULL | 17 |
| request-11062 | 11062 | NULL | NULL | NULL | NULL | 17 |
| request-90001 | 90001 | NULL | NULL | NULL | NULL | 17 |
| request-90002 | 90002 | ambiguous-a | united-package | 2018-04-01T00:00:00Z | NULL | 17 |
| request-90002 | 90002 | ambiguous-b | united-package | 2018-04-01T00:00:00Z | NULL | 17 |
| request-90003 | 90003 | disabled | disabled-partner | 2018-04-01T00:00:00Z | NULL | 17 |
| request-90004 | 90004 | NULL | NULL | NULL | NULL | 17 |