Fivetran documentation

Search the docs

/

Standard Metrics

Explore the interactive ERD

Table & Field Reference

note

Column	Type	Keys
`id`	Unknown	PK
`author_id`	Unknown	FK
`company_id`	Unknown	FK
`author`	Unknown
`created_at`	Unknown
`note`	Json

share_class

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`financing_id`	Unknown	FK
`include_in_fair_value`	Unknown
`name`	Unknown
`price_per_share_converted_value`	Unknown
`price_per_share_currency`	Unknown
`price_per_share_fx_rate`	Unknown
`price_per_share_is_custom_rate`	Unknown
`price_per_share_value`	Unknown
`purchase_type`	Unknown
`type`	Unknown

document

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`file_size`	Unknown
`information_request_id`	Unknown
`name`	Unknown
`parse_state`	Unknown
`parsed_at`	Unknown
`source`	Unknown
`submitted_date`	Unknown
`type`	Unknown
`uploaded_at`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown

information_request

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`due_date`	Unknown
`name`	Unknown
`period`	Unknown
`period_end_date`	Unknown
`period_start_date`	Unknown
`status`	Unknown

custom_column_multi_select

Column	Type	Keys
`value_id`	Unknown	PK
`company_id`	Unknown	PKFK
`id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`value`	Unknown
`value_color`	Unknown

custom_column_select

Column	Type	Keys
`company_id`	Unknown	PKFK
`id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`value`	Unknown
`value_color`	Unknown
`value_id`	Unknown

custom_column_text

Column	Type	Keys
`company_id`	Unknown	PKFK
`id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`value`	Unknown

financing_event_co_investor

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`financing_event_id`	Unknown	PKFK
`is_lead`	Unknown
`name`	Unknown

financing_event

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`closing_date`	LocalDate
`fully_diluted_shares`	Unknown
`is_crypto`	Boolean
`name`	Unknown
`pre_money_valuation_currency`	Unknown
`pre_money_valuation_value`	Unknown
`round_size_currency`	Unknown
`round_size_value`	Unknown

security

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`financing_event`	Unknown	FK
`fund_id`	Unknown	FK
`share_class_id`	Unknown	FK
`financing_id`	Unknown
`investment_amount_converted_value`	Unknown
`investment_amount_currency`	Unknown
`investment_amount_fix_rate`	Unknown
`investment_amount_is_custom_rate`	Unknown
`investment_amount_value`	Unknown
`shares`	Unknown
`type`	Unknown

fund

Column	Type	Keys
`id`	Unknown	PK
`currency`	Unknown
`name`	Unknown
`size`	Unknown
`vintage`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`city`	Unknown
`description`	Unknown
`firm_sector`	Unknown
`fiscal_year_end`	Unknown
`logo_url`	Unknown
`name`	Unknown
`sector`	Unknown
`slug`	Unknown
`status`	Unknown
`website`	Unknown

metrics

Column	Type	Keys
`_fivetran_id`	String	PK
`category_id`	Unknown	FK
`company_id`	Unknown	FK
`budget_id`	Unknown
`cadence`	Unknown
`converted_value`	Unknown
`currency`	Unknown
`date`	Unknown
`detailed_source`	Unknown
`fx_rate`	Unknown
`is_budget_metric`	Unknown
`preferred_currency`	Unknown
`updated_at`	Unknown
`value`	Unknown

custom_column_option_option

Column	Type	Keys
`id`	Unknown	PK
`custom_column_option_id`	Unknown	PKFK
`color`	Unknown
`value`	Unknown

custom_column_option

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`type`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`financing_id`	Unknown	FK
`security_id`	Unknown	FK
`share_class_id`	Unknown	FK
`date`	Unknown
`event`	Unknown
`input_security_id`	Unknown
`output_security_id`	Unknown
`proceed_currency`	Unknown
`proceed_value`	Unknown
`shares`	Unknown

metrics_option

Column	Type	Keys
`category_id`	Unknown	PK
`category_name`	Unknown
`description`	Unknown
`is_archived`	Unknown
`is_point_in_time`	Unknown
`is_standard`	Unknown
`type`	Unknown

budget

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`company_slug`	Unknown	FK
`company`	Unknown
`date`	Unknown
`name`	Unknown