# crowd.dev schema ERD

Table and field reference for the Fivetran crowd.dev connector.

## Table & Field Reference

### task_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| email | Unknown |  |

### member_enriched_by

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| enriched_by | Unknown |  |

### member_organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| member_id | Unknown | PK, FK |

### member_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| member_id | Unknown | PK, FK |
| 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 | PK, FK |
| active_on | Unknown |  |

### member_identity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| identities | Unknown |  |

### member_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| member_id | Unknown | PK, FK |

### 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 | PK, FK |
| table_name | String |  |
| username | Unknown |  |

### member_education

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| campus | Unknown |  |
| end_date | Unknown |  |
| specialization | Unknown |  |
| start_date | Unknown |  |
| table_name | String |  |

### member_expertise

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| expertise | Unknown |  |
| table_name | String |  |

### member_attribute_programming_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| programming_language | Unknown |  |
| table_name | String |  |

### member_work_experience

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| 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 | PK, FK |
| skill | Unknown |  |
| table_name | String |  |

### organization_active_on

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| email | Unknown |  |

### organization_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### organization_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- task_member(id) → member(id)
- task_member(task_id) → task(id)
- task_assignee(task_id) → task(id)
- task(segment_id) → member_segment(id)
- task(tenant_id) → member(tenant_id)
- member_attribute_setting_option(member_attribute_setting_id) → member_attribute_setting(id)
- tags(tenant_id) → member(tenant_id)
- conversation(segment_id) → member_segment(id)
- conversation(conversation_starter_id) → activity(id)
- conversation(tenant_id) → member(tenant_id)
- member_email(member_id) → member(id)
- member_enriched_by(member_id) → member(id)
- member_organization(id) → organization(id)
- member_organization(member_id) → member(id)
- member_segment(member_id) → member(id)
- member_active_on(member_id) → member(id)
- member_identity(member_id) → member(id)
- member_tag(id) → tags(id)
- member_tag(member_id) → member(id)
- member(last_activity_id) → activity(id)
- member_username(member_id) → member(id)
- member_education(member_id) → member(id)
- member_expertise(member_id) → member(id)
- member_attribute_programming_language(member_id) → member(id)
- member_work_experience(member_id) → member(id)
- member_skill(member_id) → member(id)
- organization_active_on(organization_id) → organization(id)
- organization_identity(organization_id) → organization(id)
- organization_email(organization_id) → organization(id)
- organization_phone_number(organization_id) → organization(id)
- organization_tag(organization_id) → organization(id)
- organization(tenant_id) → member(tenant_id)
- member_note(id) → member(id)
- member_note(note_id) → note(id)
- note(tenant_id) → member(tenant_id)
- activity(segment_id) → member_segment(id)
- activity(member_id) → member(id)
- activity(organization_id) → organization(id)
- activity(tenant_id) → member(tenant_id)
- activity(conversation_id) → conversation(id)
- activity(parent_id) → activity(id)