Uploads
The uploads table contains data about legacy uploads in the organization. This table us currently unused and is only present for historical purposes.
This table can be used to determine which legacy uploads exist, as well as metadata about the legacy upload such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| name | The name of the legacy upload in the user interface. | VARCHAR | Yes |
| created_by_id | The numerical identifier of the user who created this legacy upload. Relates to the id column in the users table. |
INT4 | Yes |
| status | The status of this legacy upload. One of COMPLETE, CANCELLED, or FAILED. |
VARACHAR | Yes |
| counts | A JSON representation of counts of uploaded entities. | JSONB | Yes |
| result | A JSON representation of error results from the upload. | JSONB | Yes |
| bucket | A field used only for internal backend purposes. | VARCHAR | Yes |
| key | A field used only for internal backend purposes. | VARCHAR | Yes |
| campaign_id | The numerical identifier of the campaign this legacy upload was assigned to. Relates to the id column in the campaigns table. |
INT8 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| mappings | A JSON representation of the data mappings for this legacy upload. | JSONB | Yes |
| upload_type | The type of legacy upload. One of entity, connection, tag, or entity_delete. |
VARCHAR | Yes |
| processing_options | A JSON representation of extra legacy upload processing options. | JSONB | Yes |
| identification_field | The field used to match entities on the legacy upload. | VARCHAR | Yes |
| entity_type_id | The numerical identifier of the entity type this legacy upload used to upload entities. Relates to the id column in the entity_types table. |
INT4 | Yes |
| visibility_status | The visibility status of this legacy upload. One of active or archived. |
VARCHAR | Yes |