Crunchbase

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`entity_def_id`	Unknown
`location_type`	Unknown
`permalink`	Unknown
`value`	Unknown

organisation_facet

Column	Type	Keys
`index`	Unknown	PK
`organisation_id`	Unknown	PKFK
`facet`	Unknown

organisation_hub_tag

Column	Type	Keys
`index`	Unknown	PK
`organisation_id`	Unknown	PKFK
`hub_tag`	Unknown

organisation_alias

Column	Type	Keys
`index`	Unknown	PK
`organisation_id`	Unknown	PKFK
`alias`	Unknown

organisation_permalink_alias

Column	Type	Keys
`index`	Unknown	PK
`organisation_id`	Unknown	PKFK
`permalink_alias`	Unknown

organisation_investor_stage

Column	Type	Keys
`index`	Unknown	PK
`organisation_id`	Unknown	PKFK
`investor_stage`	Unknown

organisation_investor_type

Column	Type	Keys
`index`	Unknown	PK
`organisation_id`	Unknown	PKFK
`investor_type`	Unknown

organisation_investor_identifier

Column	Type	Keys
`uuid`	Unknown	PK
`organisation_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`investor_type`	Unknown

investment_investor_stage

Column	Type	Keys
`index`	Unknown	PK
`investment_id`	Unknown	PKFK
`investor_stage`	Unknown

investment_partner_identifier

Column	Type	Keys
`uuid`	Unknown	PK
`investment_id`	Unknown	PKFK
`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	PKFK
`permalink_alias`	Unknown

people_alias

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`alias`	Unknown

people_facet

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`facet`	Unknown

people_investor_type

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`investor_type`	Unknown

people_investor_stage

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`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	PKFK
`entity_def_id`	Unknown
`location_type`	Unknown
`permalink`	Unknown
`value`	Unknown