Claude
Explore the interactive ERD
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 |
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 | PKFK |
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 |
claude_code_usage_report_model_breakdown
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
claude_code_usage_report_fivetran_id | Unknown | PKFK |
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 |
file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
downloadable | Unknown | |
filename | Unknown | |
mime_type | Unknown | |
size_bytes | Unknown | |
type | Unknown |
spend_limit
| Column | Type | Keys |
|---|---|---|
period | Unknown | PK |
user_id | Unknown | PKFK |
actor_user_id | Unknown | FK |
source_user_id | Unknown | FK |
actor_deleted | Unknown | |
amount | Unknown | |
currency | Unknown | |
period_to_date_spend | Unknown | |
source_rbac_group_id | Unknown | |
source_seat_tier | Unknown | |
source_service | Unknown | |
source_type | Unknown | |
spend_limit_id | Unknown |
skill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
display_title | Unknown | |
latest_version | Unknown | |
source | Unknown | |
type | Unknown | |
updated_at | Unknown |
model
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
display_name | Unknown | |
type | 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 |
spend_limit_increase_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
actor_user_id | Unknown | FK |
resolved_by_scoped_api_key_id | Unknown | FK |
resolved_by_user_id | Unknown | FK |
spend_limit_id | Unknown | FK |
actor_deleted | Unknown | |
created_at | Unknown | |
period | Unknown | |
resolved_at | Unknown | |
resolved_by_deleted | Unknown | |
status | Unknown | |
type | Unknown |
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 | PKFK |
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 |
workspace_member
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
type | Unknown | |
workspace_role | Unknown |
cost_report_result
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
cost_report_fivetran_id | Unknown | PKFK |
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 |
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 | PKFK |
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 |
message_batch_result
| Column | Type | Keys |
|---|---|---|
custom_id | Unknown | PK |
message_batch_id | Unknown | PKFK |
error | Json | |
message | Json | |
result_type | Unknown |