crowd.dev
Explore the interactive ERD
Table & Field Reference
task_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
task_id | Unknown | FK |
task_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
task_id | Unknown | FK |
avatar_url | Unknown | |
email | Unknown | |
full_name | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
segment_id | Unknown | FK |
tenant_id | Unknown | FK |
activity | Json | |
body | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
deleted_at | Unknown | |
due_date | Unknown | |
import_hash | Unknown | |
name | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Unknown | |
updated_by_id | Unknown |
member_attribute_setting_option
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_attribute_setting_id | Unknown | PKFK |
option | Unknown |
member_attribute_setting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
can_delete | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
label | Unknown | |
name | Unknown | |
show | Unknown | |
type | Unknown | |
updated_at | Instant | |
updated_by_id | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tenant_id | Unknown | FK |
created_at | Unknown | |
created_by_id | Unknown | |
deleted_at | Unknown | |
import_hash | Unknown | |
name | Unknown | |
updated_at | Instant | |
updated_by_id | Unknown |
conversation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conversation_starter_id | Unknown | FK |
segment_id | Unknown | FK |
tenant_id | Unknown | FK |
channel | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
last_active | Unknown | |
platform | Unknown | |
published | Unknown | |
slug | Unknown | |
title | Unknown | |
updated_at | Instant | |
updated_by_id | Unknown |
member_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
email | Unknown |
member_enriched_by
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
enriched_by | Unknown |
member_organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
member_id | Unknown | PKFK |
member_segment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
description | Unknown | |
grandparent_name | Unknown | |
grandparent_slug | Unknown | |
name | Unknown | |
parent_name | Unknown | |
parent_slug | Unknown | |
slug | Unknown | |
source_id | Unknown | |
source_parent_id | Unknown | |
status | Unknown | |
url | Unknown |
member_active_on
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
active_on | Unknown |
member_identity
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
identities | Unknown |
member_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
member_id | Unknown | PKFK |
member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_activity_id | Unknown | FK |
active_days_count | Unknown | |
affiliation | Json | |
avatar_url_default | Unknown | |
avatar_url_discord | Unknown | |
avatar_url_enrichment | Unknown | |
avatar_url_github | Unknown | |
average_sentiment | Unknown | |
bio_default | Unknown | |
bio_enrichment | Unknown | |
bio_github | Unknown | |
contribution | Json | |
country_default | Unknown | |
country_enrichment | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
deleted_at | Unknown | |
display_name | Unknown | |
import_hash | Unknown | |
is_hireable_default | Unknown | |
is_hireable_github | Unknown | |
is_organization_default | Unknown | |
is_organization_linkedin | Unknown | |
is_team_member_default | Unknown | |
joined_at | Unknown | |
karma_default | Unknown | |
karma_hacker_news | Unknown | |
last_active | Unknown | |
last_enriched | Unknown | |
location_default | Unknown | |
location_enrichment | Unknown | |
location_github | Unknown | |
manually_created | Unknown | |
no_merge | Json | |
note | Json | |
number_of_open_source_contribution | Unknown | |
reach_github | Unknown | |
reach_total | Unknown | |
reach_twitter | Unknown | |
score | Unknown | |
seniority_level_default | Unknown | |
seniority_level_enrichment | Unknown | |
source_id_default | Unknown | |
source_id_discord | Unknown | |
source_id_hacker_news | Unknown | |
task | Json | |
tenant_id | Unknown | |
to_merge | Json | |
updated_at | Unknown | |
updated_by_id | Unknown | |
url_default | Unknown | |
url_github | Unknown | |
url_linkedin | Unknown | |
url_twitter | Unknown | |
website_url_default | Unknown | |
website_url_github | Unknown | |
years_of_experience_default | Unknown | |
years_of_experience_enrichment | Unknown | |
custom_** |
member_username
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
table_name | String | |
username | Unknown |
member_education
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
campus | Unknown | |
end_date | Unknown | |
specialization | Unknown | |
start_date | Unknown | |
table_name | String |
member_expertise
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
expertise | Unknown | |
table_name | String |
member_attribute_programming_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
programming_language | Unknown | |
table_name | String |
member_work_experience
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
company | Unknown | |
end_date | Unknown | |
location | Unknown | |
start_date | Unknown | |
table_name | String | |
title | Unknown |
member_skill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
member_id | Unknown | PKFK |
skill | Unknown | |
table_name | String |
organization_active_on
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
active_on | Unknown |
organization_identity
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
organization_id | Unknown | FK |
created_at | Unknown | |
integration_id | Unknown | |
name | Unknown | |
platform | Unknown | |
source_id | Unknown | |
updated_at | Unknown | |
url | Unknown |
organization_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
email | Unknown |
organization_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
phone_number | Unknown |
organization_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
tags | Unknown |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tenant_id | Unknown | FK |
activity_count | Unknown | |
address | Json | |
affiliated_profile | Unknown | |
all_subsidiaries | Unknown | |
alternative_domain | Unknown | |
alternative_name | Unknown | |
attribute | Json | |
average_employee_tenure | Unknown | |
average_tenure_by_level | Unknown | |
average_tenure_by_role | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
crunchbase_handle | Unknown | |
deleted_at | Unknown | |
description | Unknown | |
direct_subsidiary | Unknown | |
display_name | Unknown | |
employee | Unknown | |
employee_churn_rate | Unknown | |
employee_count_by_country | Unknown | |
employee_count_by_month | Unknown | |
employee_count_by_month_by_level | Unknown | |
employee_count_by_month_by_role | Unknown | |
employee_growth_rate | Unknown | |
founded | Unknown | |
geo_location | Json | |
gics_sector | Unknown | |
github_handle | Unknown | |
gross_additions_by_month | Unknown | |
gross_departures_by_month | Unknown | |
headline | Unknown | |
immediate_parent | Unknown | |
import_hash | Json | |
industry | Unknown | |
is_team_organization | Unknown | |
joined_at | Unknown | |
last_active | Unknown | |
last_enriched_at | Unknown | |
linkedin_handle | Unknown | |
linkedin_url | Unknown | |
location | Unknown | |
manually_created | Unknown | |
naics | Unknown | |
profile | Unknown | |
revenue_range_max | Unknown | |
revenue_range_min | Unknown | |
segment_id | Unknown | |
size | Unknown | |
ticker | Unknown | |
twitter_bio | Unknown | |
twitter_follower | Unknown | |
twitter_following | Unknown | |
twitter_handle | Unknown | |
twitter_location | Unknown | |
type | Unknown | |
ultimate_parent | Unknown | |
updated_at | Unknown | |
updated_by_id | Unknown | |
weak_identity | Json | |
website | Unknown |
member_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
note_id | Unknown | FK |
note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tenant_id | Unknown | FK |
body | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
deleted_at | Unknown | |
import_hash | Unknown | |
updated_at | Unknown | |
updated_by_id | Unknown |
activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conversation_id | Unknown | FK |
member_id | Unknown | FK |
organization_id | Unknown | FK |
parent_id | Unknown | FK |
segment_id | Unknown | FK |
tenant_id | Unknown | FK |
body | Unknown | |
channel | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
deleted_at | Unknown | |
display_channel | Unknown | |
display_default | Unknown | |
display_formatter | Json | |
display_short | Unknown | |
import_hash | Unknown | |
is_contribution | Unknown | |
object_member | Unknown | |
object_member_id | Unknown | |
object_member_username | Unknown | |
platform | Unknown | |
score | Unknown | |
sentiment_label | Unknown | |
sentiment_mixed | Unknown | |
sentiment_negative | Unknown | |
sentiment_neutral | Unknown | |
sentiment_positive | Unknown | |
sentiment_sentiment | Unknown | |
source_id | Unknown | |
source_parent_id | Unknown | |
task | Json | |
timestamps | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown | |
updated_by_id | Unknown | |
url | Unknown | |
username | Unknown | |
attribute_** |