# Claude Compliance schema ERD

Table and field reference for the Fivetran Claude Compliance connector.

## Table & Field Reference

### project_document

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

### project_document_metadata

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

### organization_user

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

### 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 |  |

### group_role

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

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| source_type | Unknown |  |
| updated_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 |  |

### organization

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

### project_attachment

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

### compliance_role

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

### group_member

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

### activity_additional_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_type | Unknown |  |
| field_name | Unknown |  |
| field_value | Unknown |  |

### activity_additional_array_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| activity_id | Unknown | PK, FK |
| activity_type | Unknown |  |
| array_field_name | Unknown |  |
| field_name | Unknown |  |
| field_value | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | FK |
| actor_api_key_id | Unknown |  |
| 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 |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### 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 |  |

### chat_message_content

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| chat_id | Unknown | PK, FK |
| chat_message_id | Unknown | PK, FK |
| input | Unknown |  |
| integration_name | Unknown |  |
| is_error | Unknown |  |
| mcp_server_url | Unknown |  |
| name | Unknown |  |
| text | Unknown |  |
| thinking_redacted | Unknown |  |
| tool_result_content | Json |  |
| tool_result_tool_use_id | Unknown |  |
| tool_use_id | Unknown |  |
| truncated | Unknown |  |
| type | Unknown |  |

### chat_message_file

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

### chat_message_generated_file

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

### chat_message_artifact

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

### chat_message

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

## Relationships

- project_document(user_id) → organization_user(id)
- project_document(project_id) → project_attachment(project_id)
- project_document(project_attachment_id) → project_attachment(id)
- project_document_metadata(claude_project_id) → project(id)
- project_document_metadata(user_id) → organization_user(id)
- project_document_metadata(project_attachment_id) → project_attachment(id)
- organization_user(organization_uuid) → organization(uuid)
- project(user_id) → organization_user(id)
- project(organization_uuid) → organization(uuid)
- group_role(role_id) → compliance_role(id)
- group_role(groups_id) → groups(id)
- compliance_role_permission(compliance_role_id) → compliance_role(id)
- compliance_role_permission(organization_uuid) → compliance_role(organization_uuid)
- project_attachment(project_id) → project(id)
- compliance_role(organization_uuid) → organization(uuid)
- group_member(user_id) → organization_user(id)
- group_member(group_id) → groups(id)
- activity_additional_field(activity_id) → activity(id)
- activity_additional_array_field(activity_id) → activity(id)
- activity(organization_uuid) → organization(uuid)
- chat(user_id) → organization_user(id)
- chat(project_id) → project(id)
- chat(organization_uuid) → organization(uuid)
- chat_message_content(chat_message_id) → chat_message(id)
- chat_message_content(chat_id) → chat_message(chat_id)
- chat_message_file(chat_message_id) → chat_message(id)
- chat_message_file(chat_id) → chat_message(chat_id)
- chat_message_generated_file(chat_message_id) → chat_message(id)
- chat_message_generated_file(chat_id) → chat_message(chat_id)
- chat_message_artifact(chat_message_id) → chat_message(id)
- chat_message_artifact(chat_id) → chat_message(chat_id)
- chat_message(chat_id) → chat(id)