The claude.ai connector-equivalent ERD What a solo founder on a claude.ai 20x subscription can durably track for one organization — tables named after the real fivetran claude-compliance/claude-platform connector entities and the Cowork SDK's own on-disk shapes (bridge-state.json), never invented names. The dark callout ledgers every table that would need an Admin, Usage, Compliance, or Enterprise-Analytics API — scoped honestly, not faked.
Coworkers × claude.ai 20x — connector-equivalent ERD (fivetran claude-compliance/claude-platform shapes, org c38224f8)
IDENTITY
CHAT
USAGE REPORTS
COWORK VM
SKILLS
organization
uuid
name
is_primary
allowlist_enabled
allowlist_last_updated
captured_at
← claude-compliance.organization + claude-platform.org
organization_user
id
organization_uuid
email
full_name
organization_role
captured_at
← claude-compliance.organization_user (also covers cla
device
account_uuid
registration
registered_at_epoch_ms
captured_at
← ant-device-registry.json
project
id
organization_uuid
user_id
name
created_at
updated_at
is_private
captured_at
← claude-compliance.project — local equivalent: ~/.cla
chat
id
organization_uuid
project_uuid
user_id
created_at
updated_at
deleted_at
name
model
cwd
git_branch
client_version
message_count
captured_at
← claude-compliance.chat — local equivalent: one Claud
chat_message
id
chat_id
parent_message_id
created_at
role
request_id
is_sidechain
captured_at
← claude-compliance.chat_message source: transcript li
chat_message_content
index
chat_id
chat_message_id
type
text_chars
text_md5
{chat_message_id, index}
← claude-compliance.chat_message_content — PRIVACY DIV
chat_message_usage
chat_message_id
chat_id
model
uncached_input_tokens
cache_read_input_tokens
cache_creation_ephemeral_1h_input_tokens
cache_creation_ephemeral_5m_input_tokens
output_tokens
server_tool_use_web_search_requests
service_tier
← claude-platform.message_usage_report_result — same c
model
id
display_name
type
first_seen_at
last_seen_at
← claude-platform.model — source: distinct message.mod
claude_code_usage_report
report_id
date
organization_uuid
actor_email_address
subscription_type
core_metrics_num_sessions
← claude-platform.claude_code_usage_report — derived p
claude_code_usage_report_model_breakdown
index
report_id
model
tokens_input
tokens_output
tokens_cache_creation
tokens_cache_read
estimated_cost_amount
estimated_cost_currency
{report_id, model}
← claude-platform.claude_code_usage_report_model_break
cowork_vm_session
bridge_key
organization_uuid
account_uuid
enabled
user_consented
environment_id
remote_session_id
local_session_id
processed_message_uuid_count
pending_processed_ack_count
captured_at
← ~/Library/Application Support/Claude/bridge-state.js
cowork_vm_session_processed_message
index
bridge_key
message_uuid
{bridge_key, index}
cowork_vm
sdk_version
install_path
captured_at
← ~/Library/Application Support/Claude/claude-code-vm/
cowork_vm_toggle
name
enabled
source_file
captured_at
← developer_settings.json (allowDevTools) + siblings a
cowork_vm_log
file_name
size_bytes
modified_at
captured_at
← ~/Library/Logs/Claude/cowork_vm_*.log + coworkd.log
connector_installed
id
source_path
captured_at
← ~/Library/Application Support/Claude/Claude Extensio
skill
id
display_title
latest_version
source
type
captured_at
← claude-platform.skill — local equivalent: the repo's
NOT AVAILABLE ON A 20x SUBSCRIPTION
needs admin_api
api_key
invite
workspace → project
workspace_member → organization_user
needs batches_api
message_batch
message_batch_result
needs compliance_api
activity → fact_audit_event (mart layer)
activity_additional_array_field
activity_additional_field
artifact_metadata
chat_file_metadata
chat_generated_file_metadata
chat_message_artifact
chat_message_file
chat_message_generated_file
compliance_role
compliance_role_permission
group_member
group_role
groups
needs enterprise_analytics_api
enterprise_activity_summary → claude_code_usage_report
enterprise_chat_project_usage → project
enterprise_connector_usage → connector_installed
enterprise_skill_usage → skill
enterprise_user_activity → claude_code_usage_report
enterprise_user_actor → organization_user
enterprise_user_cost_report
enterprise_user_usage_report → chat_message_usage
needs files_api
file
needs skills_api
skill_version → skill.latest_version
needs usage_cost_api
cost_report → claude_code_usage_report_model_breakdown (tokens; cost NULL)
cost_report_result → claude_code_usage_report_model_breakdown
Generated from connector_schema.sql by uv run telemetry-erd connector-erd (cwc-data-engineering, session-telemetry-erd skill). Real sync of the same schema landed 22 chats / 10,917 messages / 6,835 per-message usage rows on 2026-07-05.