Affinity
Explore the interactive ERD
Table & Field Reference
interaction_email_to
| Column | Type | Keys |
|---|---|---|
interaction_email_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
person_to_id | Unknown | PKFK |
interaction_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
from_id | Unknown | FK |
organization_id | Unknown | FK |
cc | Json | |
date | Unknown | |
direction | Unknown | |
subject | Unknown | |
type | Unknown |
organization_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
entity_id | Unknown | PKFK |
field_id | Unknown | FK |
list_entry_id | Unknown | FK |
created_at | Unknown | |
entity_type | Unknown | |
updated_at | Unknown | |
value | Json | |
value_type | Unknown |
list_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
created_at | Unknown | |
creator_id | Unknown | |
entity_** |
person_with_interaction_email
| Column | Type | Keys |
|---|---|---|
email_id | Unknown | PK |
person_id | Unknown | PKFK |
person_with_interaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
first_name | Unknown | |
last_name | Unknown | |
primary_email | Unknown | |
type | Unknown |
field_dropdown_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
field_id | Unknown | PKFK |
rank | Unknown | |
text | Unknown |
field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | FK |
allows_multiple | Unknown | |
enrichment_source | Unknown | |
name | Unknown | |
track_changes | Unknown | |
value_type | Unknown |
person_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
entity_id | Unknown | PKFK |
field_id | Unknown | FK |
list_entry_id | Unknown | FK |
created_at | Unknown | |
entity_type | Unknown | |
updated_at | Unknown | |
value | Json | |
value_type | Unknown |
organization_with_interaction_domain
| Column | Type | Keys |
|---|---|---|
domain | Unknown | PKFK |
organization_id | Unknown | PKFK |
organization_with_interaction_person_id
| Column | Type | Keys |
|---|---|---|
organization_id | Unknown | PKFK |
person_id | Unknown | PKFK |
organization_with_interaction_list_entry
| Column | Type | Keys |
|---|---|---|
list_entry_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
organization_with_interaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
crunchbase_uuid | Unknown | |
domain | Unknown | |
global | Unknown | |
interaction_first_email_date | Unknown | |
interaction_first_event_date | Unknown | |
interaction_last_chat_message_date | Unknown | |
interaction_last_email_date | Unknown | |
interaction_last_event_date | Unknown | |
interaction_last_interaction_date | Unknown | |
interaction_next_event_date | Unknown | |
name | Unknown |
organization_interaction_person_id
| Column | Type | Keys |
|---|---|---|
type | Unknown | PK |
organization_id | Unknown | PKFK |
person_id | Unknown | PKFK |
interaction_date | Unknown | FK |
relationship_strength
| Column | Type | Keys |
|---|---|---|
external_id | Unknown | PKFK |
internal_id | Unknown | PKFK |
strength | Unknown |
interaction_meeting_attendee
| Column | Type | Keys |
|---|---|---|
attendee_email_id | Unknown | PK |
interaction_meeting_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_meeting_note
| Column | Type | Keys |
|---|---|---|
interaction_meeting_id | Unknown | PKFK |
note_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_meeting_person
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interaction_meeting_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_meeting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
date | Unknown | |
end_time | Unknown | |
manual_creator_id | Unknown | |
start_time | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown |
list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
owner_id | Unknown | FK |
list_size | Unknown | |
name | Unknown | |
public | Unknown | |
type | Unknown |
person_without_interaction_email
| Column | Type | Keys |
|---|---|---|
email_id | Unknown | PK |
person_id | Unknown | PKFK |
person_without_interaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
first_name | Unknown | |
interaction_first_email_date | Unknown | |
interaction_first_event_date | Unknown | |
last_name | Unknown | |
primary_email | Unknown | |
type | Unknown |
organization_without_interaction_domain
| Column | Type | Keys |
|---|---|---|
domain | Unknown | PKFK |
organization_id | Unknown | PKFK |
organization_without_interaction_person_id
| Column | Type | Keys |
|---|---|---|
organization_id | Unknown | PKFK |
person_id | Unknown | PKFK |
organization_without_interaction_list_entry
| Column | Type | Keys |
|---|---|---|
list_entry_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
organization_without_interaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
crunchbase_uuid | Unknown | |
domain | Unknown | |
global | Unknown | |
interaction_first_email_date | Unknown | |
interaction_first_event_date | Unknown | |
name | Unknown |
global_organization_field
| Column | Type | Keys |
|---|---|---|
field_id | Unknown | PKFK |
list_id | Unknown | FK |
reminder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
completer_id | Unknown | FK |
creator_id | Unknown | FK |
organization_id | Unknown | FK |
owner_id | Unknown | FK |
person_id | Unknown | FK |
completed_at | Unknown | |
content | Unknown | |
created_at | Unknown | |
due_date | Unknown | |
opportunity | Json | |
reminder_days | Unknown | |
reset_type | Unknown | |
status | Unknown | |
type | Unknown |
note_person
| Column | Type | Keys |
|---|---|---|
note_id | Unknown | PKFK |
person_id | Unknown | PKFK |
note_organization
| Column | Type | Keys |
|---|---|---|
note_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
note_mentioned_person
| Column | Type | Keys |
|---|---|---|
mentioned_person_id | Unknown | PKFK |
note_id | Unknown | PKFK |
note_opportunity
| Column | Type | Keys |
|---|---|---|
note_id | Unknown | PKFK |
opportunity_id | Unknown | PKFK |
note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
content | Unknown | |
created_at | Unknown | |
creator_id | Unknown | |
interaction_id | Unknown | |
interaction_type | Unknown | |
is_meeting | Unknown | |
parent_id | Unknown | |
type | Unknown | |
updated_at | Unknown |
file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
opportunity_id | Unknown | FK |
organization_id | Unknown | FK |
person_id | Unknown | FK |
uploader_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
size | Unknown |
interaction_chat_person
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
interaction_chat_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_chat_note
| Column | Type | Keys |
|---|---|---|
interaction_chat_id | Unknown | PKFK |
note_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_chat
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
manual_creator_id | Unknown | FK |
organization_id | Unknown | FK |
date | Unknown | |
direction | Unknown | |
type | Unknown |
interaction_call_attendee
| Column | Type | Keys |
|---|---|---|
attendee_email_id | Unknown | PK |
interaction_call_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_call_note
| Column | Type | Keys |
|---|---|---|
interaction_call_id | Unknown | PKFK |
note_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_call_person
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interaction_call_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
interaction_call
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
date | Unknown | |
end_time | Unknown | |
manual_creator_id | Unknown | |
start_time | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown |
opportunity_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
entity_id | Unknown | PKFK |
field_id | Unknown | FK |
list_entry_id | Unknown | FK |
created_at | Unknown | |
entity_type | Unknown | |
updated_at | Unknown | |
value | Json | |
value_type | Unknown |
opportunity_list_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
opportunity_id | Unknown | PKFK |
creator_id | Unknown | FK |
list_id | Unknown | FK |
created_at | Unknown | |
entity_id | Unknown | |
entity_type | Unknown |
opportunity_person
| Column | Type | Keys |
|---|---|---|
opportunity_id | Unknown | PKFK |
person_id | Unknown | PKFK |
opportunity_organization
| Column | Type | Keys |
|---|---|---|
opportunity_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
opportunity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |