← All tables and views

Shipping table

assignments

Native table in the Shipping sample database.

1rows

5 columns

Schema from the provider contract
ColumnTypeNullableKeyReferences
assignment_idTEXTyesPK—
attempt_idTEXTno—attempts.attempt_id
partner_idTEXTno—partners.partner_id
accepted_atTEXTno——
deduplication_keyTEXTno——

Keys and unique indexes

Physical SQLite metadata

Primary key is declared above.

Additional unique keys

sqlite_autoindex_assignments_2deduplication_key
2 unique indexes inspected
sqlite_autoindex_assignments_1assignment_id
sqlite_autoindex_assignments_2deduplication_key

Data preview

Sample records

1 rows available
assignment_idattempt_idpartner_idaccepted_atdeduplication_key
assignment-11038attempt-11038-1united-package2018-04-30T09:00:04Zrequest-11038:assignment

Interactive explorer

Explore assignments

Powered by DataTug