claude_code_daily_user_metrics_breakdowns

Detailed daily usage metrics breakdown for Claude Code AI coding assistant users.

id

Primary key

Unique identifier for the row.

daily_user_metric_id

Foreign key

Foreign key reference to claude_code_daily_user_metrics table.

organization_id

Foreign key

Organization UUID identifier.

terminal_type

string

Terminal/IDE type used by the user (e.g., vscode, cursor, intellij, iTerm.app).

num_sessions

number

Number of Claude Code sessions started by the user on this date.

lines_of_code_added

number

Number of lines of code added by the user through Claude Code.

lines_of_code_removed

number

Number of lines of code removed by the user through Claude Code.

commits_by_claude_code

number

Number of Git commits created using Claude Code.

pull_requests_by_claude_code

number

Number of pull requests created using Claude Code.

edit_tool_accepted

number

Number of edit tool suggestions accepted by the user.

edit_tool_rejected

number

Number of edit tool suggestions rejected by the user.

multi_edit_tool_accepted

number

Number of multi-edit tool suggestions accepted by the user.

multi_edit_tool_rejected

number

Number of multi-edit tool suggestions rejected by the user.

write_tool_accepted

number

Number of write tool suggestions accepted by the user.

write_tool_rejected

number

Number of write tool suggestions rejected by the user.

notebook_edit_tool_accepted

number

Number of notebook edit tool suggestions accepted by the user.

notebook_edit_tool_rejected

number

Number of notebook edit tool suggestions rejected by the user.