# Confluence schema ERD

Table and field reference for the Fivetran Confluence connector.

## Table & Field Reference

### inline_comment_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment_id | Unknown | PK, FK |
| comment_body | Json |  |
| created_at | Instant |  |

### custom_content_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_content_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |
| version_created_at | Unknown |  |
| version_message | Unknown |  |
| version_minor_edit | Unknown |  |
| version_number | Unknown |  |

### blog_post_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | PK, FK |
| blog_post_body | Json |  |
| created_at | Instant |  |
| page_body | Json |  |

### footer_comment_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment_id | Unknown | PK, FK |
| comment_body | Json |  |
| created_at | Instant |  |

### footer_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attachment_id | Unknown | FK |
| blog_post_id | Unknown | FK |
| page_id | Unknown | FK |
| parent_comment_id | Unknown | FK |
| status | Unknown |  |
| title | Unknown |  |
| version_created_at | Instant |  |
| version_number | Unknown |  |

### page_version_detail

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK, FK |
| page_id | Unknown | PK, FK |
| collaborator | Json |  |
| content_type_modifier | Unknown |  |
| created_at | Unknown |  |
| message | Unknown |  |
| minor_edit | Unknown |  |
| next_version | Unknown |  |
| previous_version | Unknown |  |

### space_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | PK, FK |
| name | Unknown |  |
| prefix | Unknown |  |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description_plan | Json |  |
| description_view | Json |  |
| homepage_id | Unknown |  |
| icon_path | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### space_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | PK, FK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| key | Unknown |  |
| version_created_at | Unknown |  |
| version_created_by | Unknown |  |
| version_message | Unknown |  |
| version_number | Unknown |  |

### child_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | PK, FK |
| space_id | Unknown | FK |
| position | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |

### attachment_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attachment_id | Unknown | PK, FK |
| attachment_body | Json |  |
| created_at | Instant |  |

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | FK |
| custom_content_id | Unknown | FK |
| page_id | Unknown | FK |
| _fivetran_file_path | String |  |
| comment | Unknown |  |
| created_at | Unknown |  |
| download_url | Unknown |  |
| file_id | Unknown |  |
| file_size | Unknown |  |
| media_type | Unknown |  |
| media_type_description | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| version_created_at | Instant |  |
| version_number | Unknown |  |
| webui_link | Unknown |  |

### permitted_footer_comment_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| footer_comment_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### page_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | PK, FK |
| created_at | Instant |  |
| page_body | Json |  |

### permitted_blog_post_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| blog_post_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### custom_content_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_id | Unknown | PK, FK |
| created_at | Instant |  |
| custom_body | Json |  |

### permitted_space_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| space_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### blog_post_content_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |
| version_created_at | Unknown |  |
| version_message | Unknown |  |
| version_minor_edit | Unknown |  |
| version_number | Unknown |  |

### permitted_inline_comment_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| inline_comment_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### custom_content_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_content_id | Unknown | PK, FK |
| name | Unknown |  |
| prefix | Unknown |  |

### attachment_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attachment_id | Unknown | PK, FK |
| name | Unknown |  |
| prefix | Unknown |  |

### blog_post_version_detail

| Column | Type | Keys |
| --- | --- | --- |
| blog_post_id | Unknown | PK, FK |
| number | Unknown | PK, FK |
| collaborator | Json |  |
| content_type_modifier | Unknown |  |
| created_at | Unknown |  |
| message | Unknown |  |
| minor_edit | Unknown |  |
| next_version | Unknown |  |
| previous_version | Unknown |  |

### attachment_version_detail

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Unknown | PK, FK |
| number | Unknown | PK, FK |
| collaborator | Json |  |
| content_type_modifier | Unknown |  |
| created_at | Unknown |  |
| message | Unknown |  |
| minor_edit | Unknown |  |
| next_version | Unknown |  |
| previous_version | Unknown |  |

### permitted_attachment_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| attachment_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### page_content_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | PK, FK |
| key | Unknown |  |
| version_created_at | Unknown |  |
| version_message | Unknown |  |
| version_minor_edit | Unknown |  |
| version_number | Unknown |  |

### footer_comment_version_detail

| Column | Type | Keys |
| --- | --- | --- |
| comment_id | Unknown | PK, FK |
| number | Unknown | PK, FK |
| collaborator | Json |  |
| content_type_modifier | Unknown |  |
| created_at | Unknown |  |
| message | Unknown |  |
| minor_edit | Unknown |  |
| next_version | Unknown |  |
| previous_version | Unknown |  |

### child_custom_content

| Column | Type | Keys |
| --- | --- | --- |
| custom_content_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| space_id | Unknown | FK |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### blog_post_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | PK, FK |
| name | Unknown |  |
| prefix | Unknown |  |

### blog_post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | FK |
| created_at | Instant |  |
| status | Unknown |  |
| title | Unknown |  |
| version_created_at | Instant |  |
| version_number | Unknown |  |

### label

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

### page_like

| Column | Type | Keys |
| --- | --- | --- |
| user_account_id | Unknown | PK |
| page_id | Unknown | PK, FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | FK |
| page_id | Unknown | FK |
| space_id | Unknown | FK |
| assigned_to | Unknown |  |
| atlas_doc_format | Json |  |
| completed_at | Unknown |  |
| completed_by | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| due_at | Unknown |  |
| local_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### custom_content_version_detail

| Column | Type | Keys |
| --- | --- | --- |
| custom_id | Unknown | PK, FK |
| number | Unknown | PK, FK |
| collaborator | Json |  |
| content_type_modifier | Unknown |  |
| created_at | Unknown |  |
| message | Unknown |  |
| minor_edit | Unknown |  |
| next_version | Unknown |  |
| previous_version | Unknown |  |

### inline_comment_version_detail

| Column | Type | Keys |
| --- | --- | --- |
| comment_id | Unknown | PK, FK |
| number | Unknown | PK, FK |
| collaborator | Json |  |
| content_type_modifier | Unknown |  |
| created_at | Unknown |  |
| message | Unknown |  |
| minor_edit | Unknown |  |
| next_version | Unknown |  |
| previous_version | Unknown |  |

### permitted_custom_content_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| custom_content_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### permitted_page_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| page_id | Unknown | FK |
| operation | Unknown |  |
| target_type | Unknown |  |

### attachment_content_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attachment_id | Unknown | PK, FK |
| key | Unknown |  |
| version_created_at | Unknown |  |
| version_message | Unknown |  |
| version_minor_edit | Unknown |  |
| version_number | Unknown |  |

### page_ancestor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| type | Unknown |  |

### page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| space_id | Unknown | FK |
| created_at | Instant |  |
| parent_type | Unknown |  |
| position | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| version_created_at | Instant |  |
| version_number | Unknown |  |

### custom_content

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | FK |
| page_id | Unknown | FK |
| space_id | Unknown | FK |
| created_at | Instant |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| version_created_at | Instant |  |
| version_number | Unknown |  |

### space_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | PK, FK |
| operation_key | Unknown |  |
| operation_target_type | Unknown |  |
| principal_id | Unknown |  |
| principal_type | Unknown |  |

### page_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | PK, FK |
| name | Unknown |  |
| prefix | Unknown |  |

### inline_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blog_post_id | Unknown | FK |
| page_id | Unknown | FK |
| parent_comment_id | Unknown | FK |
| resolution_last_modified_at | Unknown |  |
| resolution_last_modifier_id | Unknown |  |
| resolution_status | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| version_created_at | Instant |  |
| version_number | Unknown |  |
| properties_** |  |  |

## Relationships

- inline_comment_version(comment_id) → inline_comment(id)
- custom_content_property(custom_content_id) → custom_content(id)
- blog_post_version(blog_post_id) → blog_post(id)
- footer_comment_version(comment_id) → footer_comment(id)
- footer_comment(page_id) → page(id)
- footer_comment(blog_post_id) → blog_post(id)
- footer_comment(attachment_id) → attachment(id)
- footer_comment(parent_comment_id) → footer_comment(id)
- page_version_detail(number) → page_version(id)
- page_version_detail(page_id) → page_version(page_id)
- space_label(space_id) → space(id)
- space_property(space_id) → space(id)
- child_page(space_id) → space(id)
- child_page(page_id) → page(id)
- attachment_version(attachment_id) → attachment(id)
- attachment(page_id) → page(id)
- attachment(blog_post_id) → blog_post(id)
- attachment(custom_content_id) → custom_content(id)
- permitted_footer_comment_operation(footer_comment_id) → footer_comment(id)
- page_version(page_id) → page(id)
- permitted_blog_post_operation(blog_post_id) → blog_post(id)
- custom_content_version(custom_id) → custom_content(id)
- permitted_space_operation(space_id) → space(id)
- blog_post_content_property(blog_post_id) → blog_post(id)
- permitted_inline_comment_operation(inline_comment_id) → inline_comment(id)
- custom_content_label(custom_content_id) → custom_content(id)
- attachment_label(attachment_id) → attachment(id)
- blog_post_version_detail(number) → blog_post_version(id)
- blog_post_version_detail(blog_post_id) → blog_post_version(blog_post_id)
- attachment_version_detail(number) → attachment_version(id)
- attachment_version_detail(attachment_id) → attachment_version(attachment_id)
- permitted_attachment_operation(attachment_id) → attachment(id)
- page_content_property(page_id) → page(id)
- footer_comment_version_detail(number) → footer_comment_version(id)
- footer_comment_version_detail(comment_id) → footer_comment_version(comment_id)
- child_custom_content(id) → custom_content(id)
- child_custom_content(space_id) → space(id)
- child_custom_content(custom_content_id) → custom_content(id)
- blog_post_label(blog_post_id) → blog_post(id)
- blog_post(space_id) → space(id)
- page_like(page_id) → page(id)
- task(page_id) → page(id)
- task(space_id) → space(id)
- task(blog_post_id) → blog_post(id)
- custom_content_version_detail(number) → custom_content_version(id)
- custom_content_version_detail(custom_id) → custom_content_version(custom_id)
- inline_comment_version_detail(number) → inline_comment_version(id)
- inline_comment_version_detail(comment_id) → inline_comment_version(comment_id)
- permitted_custom_content_operation(custom_content_id) → custom_content(id)
- permitted_page_operation(page_id) → page(id)
- attachment_content_property(attachment_id) → attachment(id)
- page_ancestor(page_id) → page(id)
- page(space_id) → space(id)
- page(parent_id) → page(id)
- custom_content(page_id) → page(id)
- custom_content(space_id) → space(id)
- custom_content(blog_post_id) → blog_post(id)
- space_permission(space_id) → space(id)
- page_label(page_id) → page(id)
- inline_comment(page_id) → page(id)
- inline_comment(blog_post_id) → blog_post(id)
- inline_comment(parent_comment_id) → inline_comment(id)