# Coda schema ERD

Table and field reference for the Fivetran Coda connector.

## Table & Field Reference

### analytic_pack_metric

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| analytic_pack_id | Long | PK, FK |
| doc_actively_using | Int |  |
| doc_actively_using_30_day | Int |  |
| doc_actively_using_7_day | Int |  |
| doc_actively_using_90_day | Int |  |
| doc_actively_using_all_time | Int |  |
| doc_installs | Int |  |
| num_action_invocations | Int |  |
| num_formula_invocations | Int |  |
| num_metadata_invocations | Int |  |
| num_sync_invocations | Int |  |
| revenue_usd | String |  |
| workspace_installs | Int |  |
| workspaces_actively_trialing | Int |  |
| workspaces_actively_trialing_30_day | Int |  |
| workspaces_actively_trialing_7_day | Int |  |
| workspaces_actively_trialing_90_day | Int |  |
| workspaces_actively_trialing_all_time | Int |  |
| workspaces_actively_using | Int |  |
| workspaces_actively_using_30_day | Int |  |
| workspaces_actively_using_7_day | Int |  |
| workspaces_actively_using_90_day | Int |  |
| workspaces_actively_using_all_time | Int |  |
| workspaces_newly_subscribed | Int |  |
| workspaces_with_active_subscriptions | Int |  |
| workspaces_with_successful_trials | Int |  |

### analytic_pack

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| logo_url | String |  |
| name | String |  |

### columns

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tables_doc_id | String | PK, FK |
| tables_id | Unknown | PK, FK |
| calculated | Boolean |  |
| default_value | Unknown |  |
| display | Boolean |  |
| href | String |  |
| name | String |  |
| type | String |  |
| format_** |  |  |

### analytic_page_metric

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| analytic_page_page_id | String | PK, FK |
| doc_id | String | PK, FK |
| average_seconds_viewed | Unknown |  |
| median_seconds_viewed | Unknown |  |
| sessions | Unknown |  |
| tabs | Unknown |  |
| users | Unknown |  |
| views | Unknown |  |

### analytic_page

| Column | Type | Keys |
| --- | --- | --- |
| doc_id | String | PK, FK |
| page_id | String | PK, FK |

### permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| doc_id | String | PK, FK |
| access | Unknown |  |
| principal_email | Unknown |  |
| principal_type | Unknown |  |

### control

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| doc_id | String | PK, FK |
| parent_id | Unknown | FK |
| href | String |  |
| name | String |  |
| type | String |  |

### tables

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| doc_id | String | PK, FK |
| browser_link | Unknown |  |
| href | Unknown |  |
| name | Unknown |  |
| parent_browser_link | Unknown |  |
| parent_href | Unknown |  |
| parent_id | Unknown |  |
| parent_name | Unknown |  |
| table_type | Unknown |  |

### analytic_doc_metric

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| doc_id | String | PK, FK |
| ai_credits | Int |  |
| ai_credits_assistant | Int |  |
| ai_credits_block | Int |  |
| ai_credits_chat | Int |  |
| ai_credits_column | Int |  |
| ai_credits_reviewer | Int |  |
| copies | Int |  |
| likes | Int |  |
| sessions_desktop | Int |  |
| sessions_mobile | Int |  |
| sessions_other | Int |  |
| total_sessions | Int |  |
| views | Int |  |

### analytic_doc

| Column | Type | Keys |
| --- | --- | --- |
| doc_id | String | PK, FK |

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| browser_link | String |  |
| can_edit | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| icon_browser_link | Unknown |  |
| icon_name | Unknown |  |
| icon_type | Unknown |  |
| name | String |  |
| type | String |  |

### formula

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| doc_id | String | PK, FK |
| parent_id | Unknown | FK |
| href | String |  |
| name | String |  |
| type | String |  |

### doc

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| folder_id | String | FK |
| browser_link | String |  |
| created_at | Instant |  |
| href | String |  |
| icon_browser_link | Unknown |  |
| icon_name | Unknown |  |
| icon_type | Unknown |  |
| name | String |  |
| owner | String |  |
| owner_name | String |  |
| published_browser_link | String |  |
| published_description | String |  |
| published_discoverable | Boolean |  |
| published_earn_credit | Boolean |  |
| published_image_link | String |  |
| published_mode | String |  |
| source_doc_browser_link | Unknown |  |
| source_doc_href | Unknown |  |
| source_doc_id | Unknown |  |
| source_doc_type | Unknown |  |
| type | String |  |
| updated_at | Instant |  |
| workspace_browser_link | String |  |
| workspace_id | String |  |
| workspace_name | String |  |
| workspace_organization_id | String |  |
| workspace_type | String |  |

### page_content

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_doc_id | String | PK, FK |
| page_id | String | PK, FK |
| item_contentcontent | Unknown |  |
| item_contentformat | Unknown |  |
| item_contentline_level | Unknown |  |
| item_contentstyle | Unknown |  |
| type | Unknown |  |

### row

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tables_doc_id | String | PK, FK |
| tables_id | Unknown | PK, FK |
| browser_link | String |  |
| created_at | Instant |  |
| href | String |  |
| index | Unknown |  |
| name | String |  |
| type | Unknown |  |
| updated_at | Instant |  |
| values | Json |  |

### page_children

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| doc_id | String | PK, FK |
| page_id | String | PK, FK |
| browser_link | Unknown |  |
| href | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### page_author

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| doc_id | String | PK, FK |
| page_id | String | PK, FK |
| additional_type | Unknown |  |
| context | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### page

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| doc_id | String | PK, FK |
| parent_id | Unknown | FK |
| browser_link | String |  |
| content_type | String |  |
| created_at | Instant |  |
| created_by_additional_type | Unknown |  |
| created_by_context | Unknown |  |
| created_by_email | Unknown |  |
| created_by_name | Unknown |  |
| created_by_type | Unknown |  |
| href | String |  |
| icon_browser_link | Unknown |  |
| icon_name | Unknown |  |
| icon_type | Unknown |  |
| image_browser_link | Unknown |  |
| image_height | Unknown |  |
| image_type | Unknown |  |
| image_width | Unknown |  |
| is_effectively_hidden | Unknown |  |
| is_hidden | Unknown |  |
| name | String |  |
| subtitle | Unknown |  |
| type | String |  |
| updated_at | Instant |  |
| updated_by_additional_type | Unknown |  |
| updated_by_context | Unknown |  |
| updated_by_email | Unknown |  |
| updated_by_name | Unknown |  |
| updated_by_type | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |

### analytic_pack_formula_metric

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| analytic_pack_formula_name | String | PK, FK |
| analytic_pack_id | Long | PK, FK |
| doc_actively_using | Unknown |  |
| doc_actively_using_30_day | Unknown |  |
| doc_actively_using_7_day | Unknown |  |
| doc_actively_using_90_day | Unknown |  |
| doc_actively_using_all_time | Unknown |  |
| error_count | Unknown |  |
| formula_invocations | Unknown |  |
| median_latency_ms | Unknown |  |
| median_response_size_bytes | Unknown |  |
| revenue_usd | Unknown |  |
| workspaces_actively_trialing | Unknown |  |
| workspaces_actively_trialing_30_day | Unknown |  |
| workspaces_actively_trialing_7_day | Unknown |  |
| workspaces_actively_trialing_90_day | Unknown |  |
| workspaces_actively_trialing_all_time | Unknown |  |
| workspaces_actively_using | Unknown |  |
| workspaces_actively_using_30_day | Unknown |  |
| workspaces_actively_using_7_day | Unknown |  |
| workspaces_actively_using_90_day | Unknown |  |
| workspaces_actively_using_all_time | Unknown |  |
| workspaces_newly_subscribed | Unknown |  |
| workspaces_with_active_subscriptions | Unknown |  |
| workspaces_with_successful_trials | Unknown |  |

### analytic_pack_formula

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| analytic_pack_id | Long | PK, FK |
| type | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| login_id | Unknown | PK |
| href | String |  |
| name | String |  |
| picture_link | String |  |
| scoped | Boolean |  |
| token_name | String |  |
| type | String |  |
| workspace_browser_link | String |  |
| workspace_id | String |  |
| workspace_name | String |  |
| workspace_organization_id | String |  |
| workspace_type | String |  |

## Relationships

- analytic_pack_metric(analytic_pack_id) → analytic_pack(id)
- columns(tables_doc_id) → tables(doc_id)
- columns(tables_id) → tables(id)
- analytic_page_metric(doc_id) → analytic_page(doc_id)
- analytic_page_metric(analytic_page_page_id) → analytic_page(page_id)
- analytic_page(page_id) → page(id)
- analytic_page(doc_id) → doc(id)
- permission(doc_id) → doc(id)
- control(parent_id) → page(id)
- control(doc_id) → doc(id)
- tables(doc_id) → doc(id)
- analytic_doc_metric(doc_id) → analytic_doc(doc_id)
- analytic_doc(doc_id) → doc(id)
- formula(parent_id) → formula(parent_id)
- formula(doc_id) → doc(id)
- doc(folder_id) → folder(id)
- page_content(page_doc_id) → page(doc_id)
- page_content(page_id) → page(id)
- row(tables_doc_id) → tables(doc_id)
- row(tables_id) → tables(id)
- page_children(doc_id) → page(doc_id)
- page_children(page_id) → page(id)
- page_author(doc_id) → page(doc_id)
- page_author(page_id) → page(id)
- page(parent_id) → page(id)
- page(doc_id) → doc(id)
- analytic_pack_formula_metric(analytic_pack_id) → analytic_pack_formula(analytic_pack_id)
- analytic_pack_formula_metric(analytic_pack_formula_name) → analytic_pack_formula(name)
- analytic_pack_formula(analytic_pack_id) → analytic_pack(id)