# Salsify schema ERD

Table and field reference for the Fivetran Salsify connector.

## Table & Field Reference

### product_digital_asset

| Column | Type | Keys |
| --- | --- | --- |
| digital_asset_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| profile_asset_id | Unknown |  |
| relation_updated_at | Unknown |  |
| system_id | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### digital_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_height | Unknown |  |
| asset_resource_type | Unknown |  |
| asset_width | Unknown |  |
| bytes | Unknown |  |
| created_at | Unknown |  |
| etag | Unknown |  |
| filename | Unknown |  |
| format | Unknown |  |
| name | Unknown |  |
| source_url | Unknown |  |
| status | Unknown |  |
| system_id | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| widen_file_upload_date | Unknown |  |
| custom_** |  |  |

### record_digital_asset

| Column | Type | Keys |
| --- | --- | --- |
| digital_asset_id | Unknown | PK, FK |
| record_id | Unknown | PK, FK |

### record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| relation_updated_at | Unknown |  |
| system_id | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### record_type

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| created_at | Unknown |  |
| id | Unknown |  |
| localized_name | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_to | Unknown |  |
| attribute_group | Unknown |  |
| created_at | Unknown |  |
| data_type | Unknown |  |
| entity_types | Json |  |
| help_text | Unknown |  |
| hidden_permissions | Unknown |  |
| is_facetable | Unknown |  |
| localizable | Unknown |  |
| manage_permissions | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| read_permissions | Unknown |  |
| required | Unknown |  |
| reviewed_by | Unknown |  |
| scope | Unknown |  |
| system_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| validation | Unknown |  |

### attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_id | Unknown | FK |
| created_at | Unknown |  |
| localized_names | Json |  |
| name | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- product_digital_asset(digital_asset_id) → digital_asset(id)
- product_digital_asset(product_id) → product(id)
- product(parent_id) → product(id)
- record_digital_asset(digital_asset_id) → digital_asset(id)
- record_digital_asset(record_id) → record(id)
- record(parent_id) → record(id)
- attribute_value(attribute_id) → attribute(id)