# Standard Metrics schema ERD

Table and field reference for the Fivetran Standard Metrics connector.

## 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 | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |
| value_color | Unknown |  |

### custom_column_select

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |
| value_color | Unknown |  |
| value_id | Unknown |  |

### custom_column_text

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### financing_event_co_investor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| financing_event_id | Unknown | PK, FK |
| is_lead | Unknown |  |
| name | Unknown |  |

### financing_event

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

## Relationships

- note(author_id) → users(id)
- note(company_id) → company(id)
- share_class(financing_id) → financing_event(id)
- share_class(company_id) → company(id)
- document(company_id) → company(id)
- information_request(company_id) → company(id)
- custom_column_multi_select(id) → custom_column_option(id)
- custom_column_multi_select(company_id) → company(id)
- custom_column_select(id) → custom_column_option(id)
- custom_column_select(company_id) → company(id)
- custom_column_text(id) → custom_column_option(id)
- custom_column_text(company_id) → company(id)
- financing_event_co_investor(financing_event_id) → financing_event(id)
- financing_event_co_investor(company_id) → financing_event(company_id)
- financing_event(company_id) → company(id)
- security(share_class_id) → share_class(id)
- security(fund_id) → fund(id)
- security(company_id) → company(id)
- security(financing_event) → financing_event(id)
- metrics(category_id) → metrics_option(category_id)
- metrics(company_id) → company(id)
- custom_column_option_option(custom_column_option_id) → custom_column_option(id)
- transaction(share_class_id) → share_class(id)
- transaction(security_id) → security(id)
- transaction(financing_id) → financing_event(id)
- transaction(company_id) → company(id)
- budget(company_slug) → company(slug)
- budget(company_id) → company(id)