← All tables and views

Shipping table

attempts

Native table in the Shipping sample database.

8rows

6 columns

Schema from the provider contract
ColumnTypeNullableKeyReferences
attempt_idTEXTyesPK—
request_idTEXTno—requests.request_id
attempt_noINTEGERno——
config_revisionINTEGERno—configurations.revision
started_atTEXTno——
stateTEXTno——

Keys and unique indexes

Physical SQLite metadata

Primary key is declared above.

Additional unique keys

sqlite_autoindex_attempts_2request_id + attempt_no
2 unique indexes inspected
sqlite_autoindex_attempts_1attempt_id
sqlite_autoindex_attempts_2request_id + attempt_no

Data preview

Sample records

8 rows available
attempt_idrequest_idattempt_noconfig_revisionstarted_atstate
attempt-11038-1request-110381172018-04-30T09:00:00Zaccepted
attempt-11045-1request-110451172018-05-20T09:00:00Zblocked
attempt-11062-1request-110621172018-05-20T09:00:00Zblocked
attempt-90001-1request-900011172018-05-20T09:00:00Zblocked
attempt-90002-1request-900021172018-05-20T09:00:00Zblocked
attempt-90003-1request-900031172018-05-20T09:00:00Zblocked
attempt-90004-1request-900041172018-05-20T09:00:00Zblocked
attempt-90005-1request-900051172018-05-20T09:00:00Zblocked

Interactive explorer

Explore attempts

Powered by DataTug