# Crunchbase schema ERD

Table and field reference for the Fivetran Crunchbase connector.

## Table & Field Reference

### ipo

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| amount_raised_currency | Unknown |  |
| amount_raised_value | Unknown |  |
| amount_raised_value_usd | Unknown |  |
| created_at | Unknown |  |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| permalink | Unknown |  |
| rank | Unknown |  |
| rank_ipo | Unknown |  |
| share_price_currency | Unknown |  |
| share_price_value | Unknown |  |
| share_price_value_usd | Unknown |  |
| shares_outstanding | Unknown |  |
| shares_sold | Unknown |  |
| short_description | Unknown |  |
| stock_exchange_symbol | Unknown |  |
| stock_full_symbol | Unknown |  |
| stock_symbol | Unknown |  |
| updated_at | Instant |  |
| valuation_currency | Unknown |  |
| valuation_value | Unknown |  |
| valuation_value_usd | Unknown |  |
| went_public_on | Unknown |  |

### funding_round

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| funded_organization_id | Unknown | FK |
| announced_on | Unknown |  |
| closed_on_precision | Unknown |  |
| closed_on_value | Unknown |  |
| created_at | Unknown |  |
| entity_def_id | Unknown |  |
| funded_organization_description | Unknown |  |
| funded_organization_funding_stage | Unknown |  |
| funded_organization_funding_total_currency | Unknown |  |
| funded_organization_funding_total_value | Unknown |  |
| funded_organization_funding_total_value_usd | Unknown |  |
| funded_organization_revenue_range | Unknown |  |
| image_id | Unknown |  |
| investment_stage | Unknown |  |
| investment_type | Unknown |  |
| is_equity | Unknown |  |
| money_raised_currency | Unknown |  |
| money_raised_value | Unknown |  |
| money_raised_value_usd | Unknown |  |
| name | Unknown |  |
| num_investor | Unknown |  |
| num_partner | Unknown |  |
| permalink | Unknown |  |
| post_money_valuation_currency | Unknown |  |
| post_money_valuation_value | Unknown |  |
| post_money_valuation_value_usd | Unknown |  |
| pre_money_valuation_currency | Unknown |  |
| pre_money_valuation_value | Unknown |  |
| pre_money_valuation_value_usd | Unknown |  |
| rank | Unknown |  |
| rank_funding_round | Unknown |  |
| short_description | Unknown |  |
| target_money_raised_currency | Unknown |  |
| target_money_raised_value | Unknown |  |
| target_money_raised_value_usd | Unknown |  |
| updated_at | Instant |  |

### funding_round_investor_identifier

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| uuid | Unknown | PK |
| funding_round_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| permalink | Unknown |  |
| role | Unknown |  |
| value | Unknown |  |

### funding_round_identifier

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| uuid | Unknown | PK |
| funding_round_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| location_type | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| person_id | Unknown | FK |
| created_at | Unknown |  |
| employee_featured_order | Unknown |  |
| ended_on_precision | Unknown |  |
| ended_on_value | Unknown |  |
| entity_def_id | Unknown |  |
| is_current | Unknown |  |
| job_type | Unknown |  |
| name | Unknown |  |
| permalink | Unknown |  |
| short_description | Unknown |  |
| started_on_precision | Unknown |  |
| started_on_value | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### aquisition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| acquiree_funding_total_currency | Unknown |  |
| acquiree_funding_total_value | Unknown |  |
| acquiree_funding_total_value_usd | Unknown |  |
| acquiree_identifier_entity_def_id | Unknown |  |
| acquiree_identifier_permalink | Unknown |  |
| acquiree_identifier_role | Unknown |  |
| acquiree_identifier_uuid | Unknown |  |
| acquiree_identifier_value | Unknown |  |
| acquiree_last_funding_type | Unknown |  |
| acquiree_num_funding_rounds | Unknown |  |
| acquiree_revenue_range | Unknown |  |
| acquiree_short_description | Unknown |  |
| acquirer_funding_stage | Unknown |  |
| acquirer_funding_total_currency | Unknown |  |
| acquirer_funding_total_value | Unknown |  |
| acquirer_funding_total_value_usd | Unknown |  |
| acquirer_identifier_entity_def_id | Unknown |  |
| acquirer_identifier_image_id | Unknown |  |
| acquirer_identifier_permalink | Unknown |  |
| acquirer_identifier_role | Unknown |  |
| acquirer_identifier_uuid | Unknown |  |
| acquirer_identifier_value | Unknown |  |
| acquirer_num_funding_rounds | Unknown |  |
| acquirer_revenue_range | Unknown |  |
| acquirer_short_description | Unknown |  |
| acquisition_type | Unknown |  |
| announced_on_precision | Unknown |  |
| announced_on_value | Unknown |  |
| completed_on_precision | Unknown |  |
| completed_on_value | Unknown |  |
| created_at | Unknown |  |
| disposition_of_acquired | Unknown |  |
| entity_def_id | Unknown |  |
| identifier_entity_def_id | Unknown |  |
| identifier_image_id | Unknown |  |
| identifier_value | Unknown |  |
| permalink | Unknown |  |
| price_currency | Unknown |  |
| price_value | Unknown |  |
| price_value_usd | Unknown |  |
| rank | Unknown |  |
| rank_acquisition | Unknown |  |
| short_description | Unknown |  |
| status | Unknown |  |
| terms | Unknown |  |
| updated_at | Unknown |  |

### aquisition_category

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| uuid | Unknown | PK |
| aquisition_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

### aquisition_location

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| uuid | Unknown | PK |
| aquisition_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| location_type | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

### organisation_facet

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| facet | Unknown |  |

### organisation_hub_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| hub_tag | Unknown |  |

### organisation_alias

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| alias | Unknown |  |

### organisation_permalink_alias

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| permalink_alias | Unknown |  |

### organisation_investor_stage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| investor_stage | Unknown |  |

### organisation_investor_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| investor_type | Unknown |  |

### organisation_investor_identifier

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| investor_identifier_uuid | Unknown | FK |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

### organisation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| acquirer_identifier_uuid | Unknown | FK |
| company_type | Unknown |  |
| contact_email | Unknown |  |
| created_at | Unknown |  |
| demo_day | Unknown |  |
| description | Unknown |  |
| entity_def_id | Unknown |  |
| equity_funding_total_currency | Unknown |  |
| equity_funding_total_value | Unknown |  |
| equity_funding_total_value_usd | Unknown |  |
| exited_on_precision | Unknown |  |
| exited_on_value | Unknown |  |
| facebook_value | Unknown |  |
| founded_on_precision | Unknown |  |
| founded_on_value | Unknown |  |
| funding_stage | Unknown |  |
| funding_total_currency | Unknown |  |
| funding_total_value | Unknown |  |
| funding_total_value_usd | Unknown |  |
| funds_total_currency | Unknown |  |
| funds_total_value | Unknown |  |
| funds_total_value_usd | Unknown |  |
| image_id | Unknown |  |
| image_url | Unknown |  |
| ipo_status | Unknown |  |
| last_equity_funding_total_currency | Unknown |  |
| last_equity_funding_total_value | Unknown |  |
| last_equity_funding_total_value_usd | Unknown |  |
| last_funding_at | Unknown |  |
| last_funding_total_currency | Unknown |  |
| last_funding_total_value | Unknown |  |
| last_funding_total_value_usd | Unknown |  |
| last_funding_type | Unknown |  |
| layout_id | Unknown |  |
| legal_name | Unknown |  |
| linkedin_value | Unknown |  |
| listed_stock_symbol | Unknown |  |
| name | Unknown |  |
| num_acquisition | Unknown |  |
| num_alumni | Unknown |  |
| num_article | Unknown |  |
| num_current_advisor_position | Unknown |  |
| num_current_position | Unknown |  |
| num_diversity_spotlight_investment | Unknown |  |
| num_employees_enum | Unknown |  |
| num_enrollments | Unknown |  |
| num_event_appearance | Unknown |  |
| num_exit | Unknown |  |
| num_exits_ipo | Unknown |  |
| num_founder | Unknown |  |
| num_founder_alumni | Unknown |  |
| num_fund | Unknown |  |
| num_funding_round | Unknown |  |
| num_investment | Unknown |  |
| num_investor | Unknown |  |
| num_lead_investment | Unknown |  |
| num_lead_investor | Unknown |  |
| num_past_position | Unknown |  |
| num_portfolio_organization | Unknown |  |
| num_sub_organization | Unknown |  |
| operating_status | Unknown |  |
| owner_identifier_entity_def_id | Unknown |  |
| owner_identifier_image_id | Unknown |  |
| owner_identifier_permalink | Unknown |  |
| owner_identifier_uuid | Unknown |  |
| owner_identifier_value | Unknown |  |
| permalink | Unknown |  |
| phone_number | Unknown |  |
| program_application_deadline | Unknown |  |
| program_duration | Unknown |  |
| program_type | Unknown |  |
| rank | Unknown |  |
| rank_delta_d_30 | Unknown |  |
| rank_delta_d_7 | Unknown |  |
| rank_delta_d_90 | Unknown |  |
| rank_org | Unknown |  |
| rank_principal | Unknown |  |
| revenue_range | Unknown |  |
| school_method | Unknown |  |
| school_program | Unknown |  |
| school_type | Unknown |  |
| short_description | Unknown |  |
| status | Unknown |  |
| stock_exchange_symbol | Unknown |  |
| stock_symbol_entity_def_id | Unknown |  |
| stock_symbol_image_id | Unknown |  |
| stock_symbol_permalink | Unknown |  |
| stock_symbol_uuid | Unknown |  |
| stock_symbol_value | Unknown |  |
| twitter_value | Unknown |  |
| updated_at | Unknown |  |
| valuation_currency | Unknown |  |
| valuation_date | Unknown |  |
| valuation_value | Unknown |  |
| valuation_value_usd | Unknown |  |
| website_url | Unknown |  |
| website_value | Unknown |  |
| went_public_on | Unknown |  |

### organisation_identifier

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| uuid | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| location_type | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

### investment_investor_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| investment_id | Unknown | PK, FK |
| investor_type | Unknown |  |

### investment_investor_stage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| investment_id | Unknown | PK, FK |
| investor_stage | Unknown |  |

### investment_partner_identifier

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| investment_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| image_id | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

### investment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| funding_round_id | Unknown | FK |
| organization_id | Unknown | FK |
| announced_on | Unknown |  |
| created_at | Unknown |  |
| entity_def_id | Unknown |  |
| funding_round_investment_type | Unknown |  |
| funding_round_money_raised_currency | Unknown |  |
| funding_round_money_raised_value | Unknown |  |
| funding_round_money_raised_value_usd | Unknown |  |
| investor_identifier_entity_def_id | Unknown |  |
| investor_identifier_image_id | Unknown |  |
| investor_identifier_permalink | Unknown |  |
| investor_identifier_uuid | Unknown |  |
| investor_identifier_value | Unknown |  |
| is_lead_investor | Unknown |  |
| name | Unknown |  |
| permalink | Unknown |  |
| updated_at | Unknown |  |

### people_permalink_alias

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| permalink_alias | Unknown |  |

### people_alias

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| alias | Unknown |  |

### people_facet

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| facet | Unknown |  |

### people_investor_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| investor_type | Unknown |  |

### people_investor_stage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| investor_stage | Unknown |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| primary_organization_id | Unknown | FK |
| born_on | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| entity_def_id | Unknown |  |
| facebook_value | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| image_id | Unknown |  |
| image_url | Unknown |  |
| last_name | Unknown |  |
| layout_id | Unknown |  |
| linkedin_value | Unknown |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| num_article | Unknown |  |
| num_current_advisor_job | Unknown |  |
| num_current_job | Unknown |  |
| num_diversity_spotlight_investment | Unknown |  |
| num_event_appearance | Unknown |  |
| num_exit | Unknown |  |
| num_exits_acquisition | Unknown |  |
| num_exits_ipo | Unknown |  |
| num_founded_organization | Unknown |  |
| num_investment | Unknown |  |
| num_job | Unknown |  |
| num_lead_investment | Unknown |  |
| num_partner_investment | Unknown |  |
| num_past_advisor_job | Unknown |  |
| num_past_job | Unknown |  |
| num_portfolio_organization | Unknown |  |
| permalink | Unknown |  |
| primary_job_title | Unknown |  |
| rank | Unknown |  |
| rank_delta_d_30 | Unknown |  |
| rank_delta_d_7 | Unknown |  |
| rank_delta_d_90 | Unknown |  |
| rank_person | Unknown |  |
| rank_principal | Unknown |  |
| short_description | Unknown |  |
| started_on_precision | Unknown |  |
| started_on_value | Unknown |  |
| twitter_value | Unknown |  |
| updated_at | Unknown |  |
| website_url | Unknown |  |
| website_value | Unknown |  |

### people_loaction_identifier

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| uuid | Unknown | PK |
| people_id | Unknown | PK, FK |
| entity_def_id | Unknown |  |
| location_type | Unknown |  |
| permalink | Unknown |  |
| value | Unknown |  |

## Relationships

- ipo(organization_id) → organisation(id)
- funding_round(funded_organization_id) → organisation(id)
- funding_round_investor_identifier(funding_round_id) → funding_round(id)
- funding_round_identifier(funding_round_id) → funding_round(id)
- job(organization_id) → organisation(id)
- job(person_id) → people(id)
- aquisition_category(aquisition_id) → aquisition(id)
- aquisition_location(aquisition_id) → aquisition(id)
- organisation_facet(organisation_id) → organisation(id)
- organisation_hub_tag(organisation_id) → organisation(id)
- organisation_alias(organisation_id) → organisation(id)
- organisation_permalink_alias(organisation_id) → organisation(id)
- organisation_investor_stage(organisation_id) → organisation(id)
- organisation_investor_type(organisation_id) → organisation(id)
- organisation_investor_identifier(investor_identifier_uuid) → investment(id)
- organisation_investor_identifier(organisation_id) → organisation(id)
- organisation(acquirer_identifier_uuid) → aquisition(id)
- organisation_identifier(organisation_id) → organisation(id)
- investment_investor_type(investment_id) → investment(id)
- investment_investor_stage(investment_id) → investment(id)
- investment_partner_identifier(investment_id) → investment(id)
- investment(organization_id) → organisation(id)
- investment(funding_round_id) → funding_round(id)
- people_permalink_alias(people_id) → people(id)
- people_alias(people_id) → people(id)
- people_facet(people_id) → people(id)
- people_investor_type(people_id) → people(id)
- people_investor_stage(people_id) → people(id)
- people(primary_organization_id) → organisation(id)
- people_loaction_identifier(people_id) → people(id)