Attio
Explore the interactive ERD
Table & Field Reference
list_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PK |
target_id | Unknown | PKFK |
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 | PKFK |
target_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
celebration_enabled | Unknown | |
is_archived | Unknown | |
target_time_in_status | Unknown | |
title | Unknown |
record_value
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
record_id | Unknown | PKFK |
record_object_id | Unknown | PKFK |
record_workspace_id | Unknown | PKFK |
value | Unknown |
record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
object_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
created_at | Unknown |
object
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
api_slug | Unknown | |
created_at | Unknown | |
plural_noun | Unknown | |
singular_noun | Unknown |
object_attribute_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_id | Unknown | PKFK |
target_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
is_archived | Unknown | |
title | Unknown |
object_attribute_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_id | Unknown | PKFK |
target_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
target_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
is_archived | Unknown | |
title | Unknown |
list_workspace_member_access
| Column | Type | Keys |
|---|---|---|
list_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
workspace_member_id | Unknown | PKFK |
level | Unknown |
list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
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 | PKFK |
list_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
value | Unknown |
entries
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
created_at | Unknown | |
parent_object | Unknown | |
parent_record_id | Unknown |