# Attio schema ERD

Table and field reference for the Fivetran Attio connector.

## Table & Field Reference

### list_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK |
| target_id | Unknown | PK, FK |
| api_slug | Unknown |  |
| config_currency_default_currency_code | Unknown |  |
| config_currency_display_type | Unknown |  |
| config_record_reference_allowed_object_ids | Json |  |
| created_at | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| is_default_value_enabled | Unknown |  |
| is_multiselect | Unknown |  |
| is_required | Unknown |  |
| is_system_attribute | Unknown |  |
| is_unique | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### list_attribute_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_id | Unknown | PK, FK |
| target_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| celebration_enabled | Unknown |  |
| is_archived | Unknown |  |
| target_time_in_status | Unknown |  |
| title | Unknown |  |

### record_value

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| record_id | Unknown | PK, FK |
| record_object_id | Unknown | PK, FK |
| record_workspace_id | Unknown | PK, FK |
| value | Unknown |  |

### record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| object_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| created_at | Unknown |  |

### object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| api_slug | Unknown |  |
| created_at | Unknown |  |
| plural_noun | Unknown |  |
| singular_noun | Unknown |  |

### object_attribute_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_id | Unknown | PK, FK |
| target_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| is_archived | Unknown |  |
| title | Unknown |  |

### object_attribute_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_id | Unknown | PK, FK |
| target_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| celebration_enabled | Unknown |  |
| is_archived | Unknown |  |
| target_time_in_status | Unknown |  |
| title | Unknown |  |

### workspace_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK |
| access_level | Unknown |  |
| avatar_url | Unknown |  |
| created_at | Unknown |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| created_by_actor_id | Unknown | FK |
| content_plaintext | Unknown |  |
| created_at | Unknown |  |
| created_by_actor_type | Unknown |  |
| object | Unknown |  |
| record_id | Unknown |  |
| title | Unknown |  |

### object_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK |
| target_id | Unknown | PK, FK |
| api_slug | Unknown |  |
| config_currency_default_currency_code | Unknown |  |
| config_currency_display_type | Unknown |  |
| config_record_reference_allowed_object_ids | Json |  |
| created_at | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| is_default_value_enabled | Unknown |  |
| is_multiselect | Unknown |  |
| is_required | Unknown |  |
| is_system_attribute | Unknown |  |
| is_unique | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### list_attribute_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute_id | Unknown | PK, FK |
| target_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| is_archived | Unknown |  |
| title | Unknown |  |

### list_workspace_member_access

| Column | Type | Keys |
| --- | --- | --- |
| list_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| workspace_member_id | Unknown | PK, FK |
| level | Unknown |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| created_by_actor_id | Unknown | FK |
| api_slug | Unknown |  |
| created_at | Unknown |  |
| created_by_actor_type | Unknown |  |
| name | Unknown |  |
| parent_object | Json |  |
| workspace_access | Unknown |  |

### entries_value

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| id | Unknown | PK, FK |
| list_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| value | Unknown |  |

### entries

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| created_at | Unknown |  |
| parent_object | Unknown |  |
| parent_record_id | Unknown |  |

## Relationships

- list_attribute(target_id) → list(id)
- list_attribute_status(workspace_id) → workspace_member(workspace_id)
- list_attribute_status(attribute_id) → list_attribute(id)
- list_attribute_status(target_id) → list(id)
- record_value(record_id) → record(id)
- record_value(record_object_id) → record(object_id)
- record_value(record_workspace_id) → record(workspace_id)
- record(workspace_id) → workspace_member(workspace_id)
- record(object_id) → object(id)
- object(workspace_id) → workspace_member(workspace_id)
- object_attribute_option(workspace_id) → workspace_member(workspace_id)
- object_attribute_option(attribute_id) → list_attribute(id)
- object_attribute_option(target_id) → list(id)
- object_attribute_status(workspace_id) → workspace_member(workspace_id)
- object_attribute_status(attribute_id) → object_attribute(id)
- object_attribute_status(target_id) → object(id)
- note(created_by_actor_id) → workspace_member(id)
- note(workspace_id) → workspace_member(workspace_id)
- object_attribute(target_id) → object(id)
- list_attribute_option(workspace_id) → workspace_member(workspace_id)
- list_attribute_option(attribute_id) → object_attribute(id)
- list_attribute_option(target_id) → object(id)
- list_workspace_member_access(workspace_member_id) → workspace_member(id)
- list_workspace_member_access(list_id) → list(id)
- list_workspace_member_access(workspace_id) → list(workspace_id)
- list(created_by_actor_id) → workspace_member(id)
- list(workspace_id) → workspace_member(workspace_id)
- entries_value(id) → entries(id)
- entries_value(list_id) → entries(list_id)
- entries_value(workspace_id) → entries(workspace_id)
- entries(workspace_id) → workspace_member(workspace_id)
- entries(list_id) → list(id)