# Bynder schema ERD

Table and field reference for the Fivetran Bynder connector.

## Table & Field Reference

### collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cover_large | Unknown |  |
| cover_thumbnail | Unknown |  |
| date_created | LocalDateTime |  |
| date_modified | Unknown |  |
| description | Unknown |  |
| filename | Unknown |  |
| is_embeddable | Unknown |  |
| is_public | Unknown |  |
| name | Unknown |  |
| user_id | Unknown |  |
| user_name | Unknown |  |

### asset_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| additional_id | Unknown |  |
| file_name | Unknown |  |
| name | Unknown |  |
| public_url | Unknown |  |
| type | Unknown |  |

### asset_property_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| property_option | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| archive | Unknown |  |
| copyright | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| date_published | Unknown |  |
| description | Unknown |  |
| extension | Json |  |
| file_size | Unknown |  |
| height | Unknown |  |
| id_hash | Unknown |  |
| is_public | Unknown |  |
| limited | Unknown |  |
| name | Unknown |  |
| orientation | Unknown |  |
| original | Unknown |  |
| property_3_d_ai_generated | Json |  |
| property_access_right | Json |  |
| property_asset_family | Json |  |
| property_asset_type | Json |  |
| property_brand | Json |  |
| property_bu_owner | Json |  |
| property_campaign_program | Json |  |
| property_central_team | Json |  |
| property_content_type | Json |  |
| property_context_of_use | Json |  |
| property_copyright | Unknown |  |
| property_file_type | Json |  |
| property_geographical_areas_authorized | Json |  |
| property_marketing_program_name | Json |  |
| property_selling_type | Json |  |
| property_status | Json |  |
| property_supports_authorized | Json |  |
| thumbnail_mini | Unknown |  |
| thumbnail_thul | Unknown |  |
| thumbnail_webimage | Unknown |  |
| transform_base_url | Unknown |  |
| type | Unknown |  |
| user_created | Unknown |  |
| video_preview_url | Json |  |
| watermarked | Unknown |  |
| width | Unknown |  |

### sub_brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | PK, FK |
| description | Unknown |  |
| image | Unknown |  |
| name | Unknown |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| image | Unknown |  |
| name | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| media_count | Unknown |  |
| tag_name | Unknown |  |

## Relationships

- asset_item(asset_id) → asset(id)
- asset_property_option(asset_id) → asset(id)
- asset(brand_id) → brand(id)
- sub_brand(brand_id) → brand(id)