# Claude schema ERD

Table and field reference for the Fivetran Claude connector.

## Table & Field Reference

### enterprise_activity_summary

| Column | Type | Keys |
| --- | --- | --- |
| starting_at | Unknown | PK |
| assigned_seat_count | Unknown |  |
| cowork_daily_active_user_count | Unknown |  |
| cowork_monthly_active_user_count | Unknown |  |
| cowork_weekly_active_user_count | Unknown |  |
| daily_active_user_count | Unknown |  |
| daily_adoption_rate | Unknown |  |
| ending_at | Unknown |  |
| monthly_active_user_count | Unknown |  |
| monthly_adoption_rate | Unknown |  |
| pending_invite_count | Unknown |  |
| weekly_active_user_count | Unknown |  |
| weekly_adoption_rate | Unknown |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| data_residency_allowed_inference_geo | Json |  |
| data_residency_default_inference_geo | Unknown |  |
| data_residency_workspace_geo | Unknown |  |
| display_color | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### compliance_group_member

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| updated_at | Unknown |  |

### claude_code_usage_report_model_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| claude_code_usage_report_fivetran_id | Unknown | PK, FK |
| estimated_cost_amount | Unknown |  |
| estimated_cost_currency | Unknown |  |
| model | Unknown |  |
| tokens_cache_creation | Unknown |  |
| tokens_cache_read | Unknown |  |
| tokens_input | Unknown |  |
| tokens_output | Unknown |  |

### claude_code_usage_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| organization_id | Unknown | FK |
| actor_api_key_name | Unknown |  |
| actor_email_address | Unknown |  |
| actor_type | Unknown |  |
| core_metrics_commits_by_claude_code | Unknown |  |
| core_metrics_lines_of_code_added | Unknown |  |
| core_metrics_lines_of_code_removed | Unknown |  |
| core_metrics_num_sessions | Unknown |  |
| core_metrics_pull_requests_by_claude_code | Unknown |  |
| customer_type | Unknown |  |
| date | Unknown |  |
| subscription_type | Unknown |  |
| terminal_type | Unknown |  |
| tool_actions_accepted | Unknown |  |
| tool_actions_rejected | Unknown |  |

### compliance_organization_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| full_name | Unknown |  |
| organization_role | Unknown |  |

### model

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| display_name | Unknown |  |
| type | Unknown |  |

### compliance_project_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |

### enterprise_user_cost_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| actor_user_id | Unknown | FK |
| amount | Unknown |  |
| context_window | Unknown |  |
| cost_type | Unknown |  |
| currency | Unknown |  |
| data_refreshed_at | Unknown |  |
| ending_date | Unknown |  |
| inference_geo | Unknown |  |
| list_amount | Unknown |  |
| model | Unknown |  |
| organization_id | Unknown |  |
| product | Unknown |  |
| speed | Unknown |  |
| starting_date | Unknown |  |
| token_type | Unknown |  |

### enterprise_chat_project_usage

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| project_id | Unknown | PK |
| created_by_id | Unknown | FK |
| created_at | Unknown |  |
| distinct_conversation_count | Unknown |  |
| distinct_user_count | Unknown |  |
| message_count | Unknown |  |
| project_name | Unknown |  |

### skill_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| skill_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| directory | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |

### message_batch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived_at | Unknown |  |
| cancel_initiated_at | Unknown |  |
| created_at | Unknown |  |
| ended_at | Unknown |  |
| expires_at | Unknown |  |
| processing_status | Unknown |  |
| results_url | Unknown |  |
| type | Unknown |  |

### compliance_project_document_metadata

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| claude_project_id | Unknown | PK, FK |
| compliance_project_attachment_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| filename | Unknown |  |
| md_5 | Unknown |  |
| mime_type | Unknown |  |
| size_bytes | Unknown |  |

### workspace_member

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| type | Unknown |  |
| workspace_role | Unknown |  |

### cost_report_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| cost_report_fivetran_id | Unknown | PK, FK |
| workspace_id | Unknown | FK |
| amount | Unknown |  |
| context_window | Unknown |  |
| cost_type | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| inference_geo | Unknown |  |
| model | Unknown |  |
| service_tier | Unknown |  |
| speed | Unknown |  |
| token_type | Unknown |  |

### cost_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ending_at | Unknown |  |
| starting_at | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| added_at | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| type | Unknown |  |

### enterprise_skill_usage

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| skill_name | Unknown | PK |
| chat_metrics_distinct_conversation_skill_used_count | Unknown |  |
| claude_code_metrics_distinct_session_skill_used_count | Unknown |  |
| cowork_metrics_distinct_session_skill_used_count | Unknown |  |
| distinct_user_count | Unknown |  |
| office_metrics_excel_distinct_session_skill_used_count | Unknown |  |
| office_metrics_outlook_distinct_session_skill_used_count | Unknown |  |
| office_metrics_powerpoint_distinct_session_skill_used_count | Unknown |  |
| office_metrics_word_distinct_session_skill_used_count | Unknown |  |

### compliance_project_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| compliance_project_attachment_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| content | Unknown |  |

### compliance_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### message_batch_result

| Column | Type | Keys |
| --- | --- | --- |
| custom_id | Unknown | PK |
| message_batch_id | Unknown | PK, FK |
| error | Json |  |
| message | Json |  |
| result_type | Unknown |  |

### compliance_group_role

| Column | Type | Keys |
| --- | --- | --- |
| compliance_groups_id | Unknown | PK, FK |
| role_id | Unknown | PK, FK |

### compliance_groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| source_type | Unknown |  |
| updated_at | Unknown |  |

### enterprise_connector_usage

| Column | Type | Keys |
| --- | --- | --- |
| connector_name | Unknown | PK |
| date | Unknown | PK |
| chat_metrics_distinct_conversation_connector_used_count | Unknown |  |
| claude_code_metrics_distinct_session_connector_used_count | Unknown |  |
| cowork_metrics_distinct_session_connector_used_count | Unknown |  |
| distinct_user_count | Unknown |  |
| office_metrics_excel_distinct_session_connector_used_count | Unknown |  |
| office_metrics_outlook_distinct_session_connector_used_count | Unknown |  |
| office_metrics_powerpoint_distinct_session_connector_used_count | Unknown |  |
| office_metrics_word_distinct_session_connector_used_count | Unknown |  |

### message_usage_report_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_usage_report_fivetran_id | Unknown | PK, FK |
| api_key_id | Unknown | FK |
| workspace_id | Unknown | FK |
| cache_creation_ephemeral_1_h_input_token | Unknown |  |
| cache_creation_ephemeral_5_m_input_token | Unknown |  |
| cache_read_input_token | Unknown |  |
| context_window | Unknown |  |
| model | Unknown |  |
| output_token | Unknown |  |
| server_tool_use_web_search_request | Unknown |  |
| service_tier | Unknown |  |
| uncached_input_token | Unknown |  |

### message_usage_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ending_at | Unknown |  |
| starting_at | Unknown |  |

### compliance_role_permission

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| compliance_role_id | Unknown | FK |
| organization_uuid | Unknown | FK |
| action | Unknown |  |
| resource_id | Unknown |  |
| resource_type | Unknown |  |

### compliance_organization

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| downloadable | Unknown |  |
| filename | Unknown |  |
| mime_type | Unknown |  |
| size_bytes | Unknown |  |
| type | Unknown |  |

### skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| display_title | Unknown |  |
| latest_version | Unknown |  |
| source | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### enterprise_user_actor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### enterprise_user_usage_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| actor_user_id | Unknown | FK |
| cache_creation_ephemeral_1_h_input_token | Unknown |  |
| cache_creation_ephemeral_5_m_input_token | Unknown |  |
| cache_read_input_token | Unknown |  |
| context_window | Unknown |  |
| data_refreshed_at | Unknown |  |
| ending_date | Unknown |  |
| inference_geo | Unknown |  |
| model | Unknown |  |
| organization_id | Unknown |  |
| output_token | Unknown |  |
| product | Unknown |  |
| request | Unknown |  |
| server_tool_use_web_search_request | Unknown |  |
| speed | Unknown |  |
| starting_date | Unknown |  |
| total_token | Unknown |  |
| uncached_input_token | Unknown |  |

### compliance_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| instruction | Unknown |  |
| is_private | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| updated_at | Unknown |  |

### api_key

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | FK |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_type | Unknown |  |
| name | Unknown |  |
| partial_key_hint | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### enterprise_user_activity

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| user_id | Unknown | PK, FK |
| chat_metrics_connectors_used_count | Unknown |  |
| chat_metrics_distinct_artifacts_created_count | Unknown |  |
| chat_metrics_distinct_conversation_count | Unknown |  |
| chat_metrics_distinct_files_uploaded_count | Unknown |  |
| chat_metrics_distinct_projects_created_count | Unknown |  |
| chat_metrics_distinct_projects_used_count | Unknown |  |
| chat_metrics_distinct_shared_artifacts_viewed_count | Unknown |  |
| chat_metrics_distinct_skills_used_count | Unknown |  |
| chat_metrics_message_count | Unknown |  |
| chat_metrics_shared_conversations_viewed_count | Unknown |  |
| chat_metrics_thinking_message_count | Unknown |  |
| claude_code_metrics_core_metrics_commit_count | Unknown |  |
| claude_code_metrics_core_metrics_distinct_session_count | Unknown |  |
| claude_code_metrics_core_metrics_lines_of_code_added_count | Unknown |  |
| claude_code_metrics_core_metrics_lines_of_code_removed_count | Unknown |  |
| claude_code_metrics_core_metrics_pull_request_count | Unknown |  |
| claude_code_metrics_tool_actions_edit_tool_accepted_count | Unknown |  |
| claude_code_metrics_tool_actions_edit_tool_rejected_count | Unknown |  |
| claude_code_metrics_tool_actions_multi_edit_tool_accepted_count | Unknown |  |
| claude_code_metrics_tool_actions_multi_edit_tool_rejected_count | Unknown |  |
| claude_code_metrics_tool_actions_notebook_edit_tool_accepted_count | Unknown |  |
| claude_code_metrics_tool_actions_notebook_edit_tool_rejected_count | Unknown |  |
| claude_code_metrics_tool_actions_write_tool_accepted_count | Unknown |  |
| claude_code_metrics_tool_actions_write_tool_rejected_count | Unknown |  |
| cowork_metrics_action_count | Unknown |  |
| cowork_metrics_connectors_used_count | Unknown |  |
| cowork_metrics_dispatch_turn_count | Unknown |  |
| cowork_metrics_distinct_connectors_used_count | Unknown |  |
| cowork_metrics_distinct_session_count | Unknown |  |
| cowork_metrics_distinct_skills_used_count | Unknown |  |
| cowork_metrics_message_count | Unknown |  |
| cowork_metrics_skills_used_count | Unknown |  |
| design_metrics_distinct_projects_created_count | Unknown |  |
| design_metrics_distinct_projects_used_count | Unknown |  |
| design_metrics_distinct_session_count | Unknown |  |
| design_metrics_message_count | Unknown |  |
| dimension | Unknown |  |
| distinct_user_count | Unknown |  |
| office_metrics_excel_connectors_used_count | Unknown |  |
| office_metrics_excel_distinct_connectors_used_count | Unknown |  |
| office_metrics_excel_distinct_session_count | Unknown |  |
| office_metrics_excel_distinct_skills_used_count | Unknown |  |
| office_metrics_excel_message_count | Unknown |  |
| office_metrics_excel_skills_used_count | Unknown |  |
| office_metrics_outlook_connectors_used_count | Unknown |  |
| office_metrics_outlook_distinct_connectors_used_count | Unknown |  |
| office_metrics_outlook_distinct_session_count | Unknown |  |
| office_metrics_outlook_distinct_skills_used_count | Unknown |  |
| office_metrics_outlook_message_count | Unknown |  |
| office_metrics_outlook_skills_used_count | Unknown |  |
| office_metrics_powerpoint_connectors_used_count | Unknown |  |
| office_metrics_powerpoint_distinct_connectors_used_count | Unknown |  |
| office_metrics_powerpoint_distinct_session_count | Unknown |  |
| office_metrics_powerpoint_distinct_skills_used_count | Unknown |  |
| office_metrics_powerpoint_message_count | Unknown |  |
| office_metrics_powerpoint_skills_used_count | Unknown |  |
| office_metrics_word_connectors_used_count | Unknown |  |
| office_metrics_word_distinct_connectors_used_count | Unknown |  |
| office_metrics_word_distinct_session_count | Unknown |  |
| office_metrics_word_distinct_skills_used_count | Unknown |  |
| office_metrics_word_message_count | Unknown |  |
| office_metrics_word_skills_used_count | Unknown |  |
| web_search_count | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| type | Unknown |  |

### invite

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| expires_at | Unknown |  |
| invited_at | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### compliance_activity_additional_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| compliance_activity_id | Unknown | PK, FK |
| compliance_activity_type | Unknown |  |
| field_name | Unknown |  |
| field_value | Unknown |  |

### compliance_activity_additional_array_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| compliance_activity_id | Unknown | PK, FK |
| array_field_name | Unknown |  |
| compliance_activity_type | Unknown |  |
| field_name | Unknown |  |
| field_value | Unknown |  |

### compliance_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actor_api_key_id | Unknown | FK |
| organization_id | Unknown | FK |
| organization_uuid | Unknown | FK |
| actor_email_address | Unknown |  |
| actor_ip_address | Unknown |  |
| actor_type | Unknown |  |
| actor_unauthenticated_email_address | Unknown |  |
| actor_user_agent | Unknown |  |
| actor_user_id | Unknown |  |
| created_at | Instant |  |
| type | Unknown |  |

### compliance_chat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | FK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| href | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| updated_at | Instant |  |

### compliance_chat_message_content

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| chat_id | Unknown | PK, FK |
| compliance_chat_message_id | Unknown | PK, FK |
| text | Unknown |  |
| type | Unknown |  |

### compliance_chat_message_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chat_id | Unknown | PK, FK |
| compliance_chat_message_id | Unknown | PK, FK |
| created_at | Unknown |  |
| file_name | Unknown |  |
| md_5 | Unknown |  |
| mime_type | Unknown |  |
| size_bytes | Unknown |  |

### compliance_chat_message_generated_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chat_id | Unknown | PK, FK |
| compliance_chat_message_id | Unknown | PK, FK |
| file_name | Unknown |  |
| md_5 | Unknown |  |
| mime_type | Unknown |  |
| size_bytes | Unknown |  |

### compliance_chat_message_artifact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| version_id | Unknown | PK |
| chat_id | Unknown | PK, FK |
| compliance_chat_message_id | Unknown | PK, FK |
| artifact_type | Unknown |  |
| title | Unknown |  |

### compliance_chat_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chat_id | Unknown | PK, FK |
| created_at | Unknown |  |
| role | Unknown |  |
| updated_at | Instant |  |

## Relationships

- compliance_group_member(user_id) → compliance_organization_user(id)
- compliance_group_member(group_id) → compliance_groups(id)
- claude_code_usage_report_model_breakdown(claude_code_usage_report_fivetran_id) → claude_code_usage_report(_fivetran_id)
- claude_code_usage_report(organization_id) → organization(id)
- compliance_organization_user(id) → users(id)
- compliance_organization_user(organization_uuid) → compliance_organization(uuid)
- compliance_project_attachment(project_id) → compliance_project(id)
- enterprise_user_cost_report(actor_user_id) → enterprise_user_actor(id)
- enterprise_chat_project_usage(created_by_id) → enterprise_user_actor(id)
- skill_version(skill_id) → skill(id)
- compliance_project_document_metadata(claude_project_id) → compliance_project(id)
- compliance_project_document_metadata(user_id) → compliance_organization_user(id)
- compliance_project_document_metadata(compliance_project_attachment_id) → compliance_project_attachment(id)
- workspace_member(workspace_id) → workspace(id)
- workspace_member(user_id) → users(id)
- cost_report_result(workspace_id) → workspace(id)
- cost_report_result(cost_report_fivetran_id) → cost_report(_fivetran_id)
- compliance_project_document(user_id) → compliance_organization_user(id)
- compliance_project_document(project_id) → compliance_project_attachment(project_id)
- compliance_project_document(compliance_project_attachment_id) → compliance_project_attachment(id)
- compliance_role(organization_uuid) → compliance_organization(uuid)
- message_batch_result(message_batch_id) → message_batch(id)
- compliance_group_role(role_id) → compliance_role(id)
- compliance_group_role(compliance_groups_id) → compliance_groups(id)
- message_usage_report_result(api_key_id) → api_key(id)
- message_usage_report_result(workspace_id) → workspace(id)
- message_usage_report_result(message_usage_report_fivetran_id) → message_usage_report(_fivetran_id)
- compliance_role_permission(compliance_role_id) → compliance_role(id)
- compliance_role_permission(organization_uuid) → compliance_role(organization_uuid)
- enterprise_user_usage_report(actor_user_id) → enterprise_user_actor(id)
- compliance_project(user_id) → compliance_organization_user(id)
- compliance_project(organization_uuid) → compliance_organization(uuid)
- api_key(workspace_id) → workspace(id)
- enterprise_user_activity(user_id) → enterprise_user_actor(id)
- compliance_activity_additional_field(compliance_activity_id) → compliance_activity(id)
- compliance_activity_additional_array_field(compliance_activity_id) → compliance_activity(id)
- compliance_activity(organization_id) → organization(id)
- compliance_activity(organization_uuid) → compliance_organization(uuid)
- compliance_activity(actor_api_key_id) → api_key(id)
- compliance_chat(user_id) → compliance_organization_user(id)
- compliance_chat(project_id) → compliance_project(id)
- compliance_chat(organization_uuid) → compliance_organization(uuid)
- compliance_chat_message_content(compliance_chat_message_id) → compliance_chat_message(id)
- compliance_chat_message_content(chat_id) → compliance_chat_message(chat_id)
- compliance_chat_message_file(compliance_chat_message_id) → compliance_chat_message(id)
- compliance_chat_message_file(chat_id) → compliance_chat_message(chat_id)
- compliance_chat_message_generated_file(compliance_chat_message_id) → compliance_chat_message(id)
- compliance_chat_message_generated_file(chat_id) → compliance_chat_message(chat_id)
- compliance_chat_message_artifact(compliance_chat_message_id) → compliance_chat_message(id)
- compliance_chat_message_artifact(chat_id) → compliance_chat_message(chat_id)
- compliance_chat_message(chat_id) → compliance_chat(id)