# Wrike schema ERD

Table and field reference for the Fivetran Wrike connector.

## Table & Field Reference

### booking_effort_responsible_daily_allocation

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| booking_effort_responsible_allocation_booking_id | String | PK, FK |
| booking_effort_responsible_allocation_index | Unknown | PK, FK |
| effort_minutes | Unknown |  |

### booking_effort_responsible_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_id | String | PK, FK |
| user_id | String | FK |
| placeholder_id | Unknown |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| folder_id | String | FK |
| placeholder_id | String | FK |
| responsible_id | String | FK |
| booking_duration | Double |  |
| booking_finish_date | Unknown |  |
| booking_start_date | Unknown |  |
| booking_work_on_weekends | Boolean |  |
| effort_allocation_mode | Unknown |  |
| effort_allocation_total_effort | Unknown |  |
| title | String |  |

### job_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| is_deleted | Boolean |  |
| short_title | String |  |
| title | String |  |

### access_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| title | String |  |

### space_task_dependency_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| dependency_id | Unknown |  |

### space_task_super_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| super_parent_id | Unknown |  |

### space_task_sub_task_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| sub_task_id | Unknown |  |

### space_task_super_task_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| space_super_task_id | Unknown |  |

### space_task_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| parent_id | Unknown |  |

### space_task_responsible_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| responsible_id | Unknown |  |

### space_task_responsible_placeholder_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| responsible_placeholder_id | Unknown |  |

### space_task_author_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| author_id | Unknown |  |

### space_task_follower_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| follower_id | Unknown |  |

### space_task_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_task_id | Unknown | PK, FK |
| value | Unknown |  |

### space_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| account_id | Unknown | FK |
| custom_item_id | Unknown | FK |
| attachment_count | Unknown |  |
| billing_type | Unknown |  |
| brief_description | Unknown |  |
| completed_date | Unknown |  |
| created_date | Unknown |  |
| date_type | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| duration | Unknown |  |
| effort_allocation_allocated_effort | Unknown |  |
| effort_allocation_daily_allocation_percentage | Unknown |  |
| effort_allocation_mode | Unknown |  |
| effort_allocation_total_effort | Unknown |  |
| followed_by_me | Unknown |  |
| has_attachment | Unknown |  |
| importance | Unknown |  |
| permalink | Unknown |  |
| priority | Unknown |  |
| recurrent | Unknown |  |
| responsible_allocation | Json |  |
| scope | Unknown |  |
| shared_id | Json |  |
| start_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_date | Unknown |  |
| work_on_weekend | Unknown |  |
| custom_** |  |  |

### space_member

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | String | PK, FK |
| space_id | String | PK, FK |
| access_role_id | String | FK |
| is_manager | Boolean |  |

### space_project_workflow

| Column | Type | Keys |
| --- | --- | --- |
| space_id | String | PK, FK |
| workflow_id | String | PK, FK |

### space_task_workflow

| Column | Type | Keys |
| --- | --- | --- |
| space_id | String | PK, FK |
| workflow_id | String | PK, FK |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| default_project_workflow_id | String | FK |
| default_task_workflow_id | String | FK |
| guest_role_id | String | FK |
| access_type | String |  |
| archived | Boolean |  |
| description | String |  |
| title | String |  |

### folder_finance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| actual_cost | Unknown |  |
| actual_fees | Unknown |  |
| budget | Unknown |  |
| currency | Unknown |  |
| planned_cost | Unknown |  |
| planned_fees | Unknown |  |

### contact_member

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | String | PK, FK |
| member_id | String | PK, FK |

### contact_profile

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| contact_id | String | PK, FK |
| admin | Boolean |  |
| email | String |  |
| external | Boolean |  |
| owner | Boolean |  |
| role | String |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_role_id | String | FK |
| work_schedule_id | String | FK |
| company_name | String |  |
| current_bill_rate_source | String |  |
| current_bill_rate_value | Double |  |
| current_cost_rate_source | String |  |
| current_cost_rate_value | Double |  |
| deleted | Boolean |  |
| first_name | String |  |
| last_name | String |  |
| locale | String |  |
| location | String |  |
| me | Boolean |  |
| my_team | Boolean |  |
| phone | String |  |
| timezone | String |  |
| title | String |  |
| type | String |  |
| custom_** |  |  |

### custom_item_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| space_id | String | FK |
| description | String |  |
| related_type | String |  |
| title | String |  |

### timelog_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| hidden | Boolean |  |
| name | String |  |
| orders | Int |  |

### workflow_custom_status

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workflow_id | String | PK, FK |
| groups | String |  |
| hidden | Boolean |  |
| name | String |  |
| standard | Boolean |  |
| standard_name | Boolean |  |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| space_id | String | FK |
| hidden | Boolean |  |
| name | String |  |
| standard | Boolean |  |

### invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| inviter_id | String | FK |
| external | Boolean |  |
| invitation_date | Instant |  |
| resolved_date | Instant |  |
| status | String |  |

### user_schedule_exception

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| contact_id | String | FK |
| exclusion_type | String |  |
| from_date | String |  |
| is_work_days | String |  |
| to_date | String |  |

### folder_task_dependency_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| dependency_id | Unknown |  |

### folder_task_super_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| super_parent_id | Unknown |  |

### folder_task_sub_task_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| sub_task_id | Unknown |  |

### folder_task_super_task_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| folder_super_task_id | Unknown |  |

### folder_task_parent_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| parent_id | Unknown |  |

### folder_task_responsible_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| responsible_id | Unknown |  |

### folder_task_responsible_placeholder_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| responsible_placeholder_id | Unknown |  |

### folder_task_author_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| author_id | Unknown |  |

### folder_task_follower_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| follower_id | Unknown |  |

### folder_task_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_task_id | Unknown | PK, FK |
| value | Unknown |  |

### folder_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| account_id | Unknown | FK |
| custom_item_id | Unknown | FK |
| attachment_count | Unknown |  |
| billing_type | Unknown |  |
| brief_description | Unknown |  |
| completed_date | Unknown |  |
| created_date | Unknown |  |
| date_type | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| duration | Unknown |  |
| effort_allocation_allocated_effort | Unknown |  |
| effort_allocation_daily_allocation_percentage | Unknown |  |
| effort_allocation_mode | Unknown |  |
| effort_allocation_total_effort | Unknown |  |
| finance_actual_cost | Unknown |  |
| finance_actual_fees | Unknown |  |
| finance_currency | Unknown |  |
| finance_planned_cost | Unknown |  |
| finance_planned_fees | Unknown |  |
| followed_by_me | Unknown |  |
| has_attachment | Unknown |  |
| importance | Unknown |  |
| permalink | Unknown |  |
| priority | Unknown |  |
| recurrent | Unknown |  |
| responsible_allocation | Json |  |
| scope | Unknown |  |
| shared_id | Json |  |
| start_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_date | Unknown |  |
| work_on_weekends | Unknown |  |
| custom_** |  |  |

### folder_hourly_rate

| Column | Type | Keys |
| --- | --- | --- |
| rate_subject_id | String | PK |
| folder_project_id | String | PK, FK |
| bill_rate_scope | String |  |
| bill_rate_source | String |  |
| bill_rate_value | Double |  |
| cost_rate_scope | String |  |
| cost_rate_source | String |  |
| cost_rate_value | Double |  |
| rate_subject_type | String |  |

### folder_project_owner

| Column | Type | Keys |
| --- | --- | --- |
| folder_project_id | String | PK, FK |
| owner_id | String | PK, FK |

### folder_project_child

| Column | Type | Keys |
| --- | --- | --- |
| child_id | String | PK, FK |
| folder_project_id | String | PK, FK |

### folder_project_share

| Column | Type | Keys |
| --- | --- | --- |
| folder_project_id | String | PK, FK |
| shared_id | String | PK, FK |

### folder_project_parent

| Column | Type | Keys |
| --- | --- | --- |
| folder_project_id | String | PK, FK |
| parent_id | String | PK, FK |

### folder_project_super_parent

| Column | Type | Keys |
| --- | --- | --- |
| folder_project_id | String | PK, FK |
| super_parent_id | String | PK, FK |

### folder_project_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_column_id | Unknown | PK, FK |
| folder_project_id | String | PK, FK |
| custom_field_value | Unknown |  |

### folder_project

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| custom_item_id | String | FK |
| project_author_id | String | FK |
| project_custom_status_id | String | FK |
| workflow_id | String | FK |
| attachment_count | Unknown |  |
| created_date | Instant |  |
| description | String |  |
| has_attachment | Boolean |  |
| permalink | String |  |
| project_completed_date | Instant |  |
| project_contract_type | String |  |
| project_created_date | Instant |  |
| project_end_date | Unknown |  |
| project_owner_id | Json |  |
| project_start_date | Unknown |  |
| project_status | String |  |
| scope | String |  |
| space | Boolean |  |
| title | String |  |
| updated_date | Instant |  |
| custom_** |  |  |

### workweek_schedule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| work_schedule_id | String | FK |
| capacity_minutes | String |  |
| work_day | Json |  |

### user_work_schedule

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| work_schedule_id | String | PK, FK |

### work_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| schedule_type | String |  |
| title | String |  |

### attachment_review

| Column | Type | Keys |
| --- | --- | --- |
| review_id | String | PK |
| attachment_id | String | PK, FK |

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_id | String | FK |
| comment_id | String | FK |
| current_attachment_id | String | FK |
| folder_id | String | FK |
| task_id | String | FK |
| content_type | String |  |
| created_date | Instant |  |
| name | String |  |
| type | String |  |
| version | Double |  |

### placeholder

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| job_role_id | String | FK |
| deleted | Boolean |  |
| short_title | String |  |
| title | String |  |

### custom_field_share

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | String | PK, FK |
| share_id | String | PK, FK |

### custom_field_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | String | PK, FK |
| custom_field_id | String | PK, FK |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| space_id | String | FK |
| setting_aggregation | String |  |
| setting_allow_other_values | Boolean |  |
| setting_allow_time | Boolean |  |
| setting_currency | String |  |
| setting_decimal_places | Double |  |
| setting_inheritance_type | String |  |
| setting_read_only | Boolean |  |
| setting_timezone | String |  |
| setting_use_thousands_separator | Boolean |  |
| setting_values | Json |  |
| title | String |  |
| type | String |  |

### approval_attachment

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | String | PK, FK |
| attachment_id | String | PK, FK |

### approval_decision

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | String | PK, FK |
| approver_id | String | PK, FK |
| comment | String |  |
| status | String |  |
| updated_date | Instant |  |

### approval

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_id | String | FK |
| finisher_id | String | FK |
| folder_id | String | FK |
| task_id | String | FK |
| auto_finish_on_approve | Boolean |  |
| auto_finish_on_reject | Boolean |  |
| description | String |  |
| due_date | Unknown |  |
| finished | Boolean |  |
| review_id | String |  |
| status | String |  |
| title | String |  |
| type | String |  |
| updated_date | Instant |  |

### parent_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK, FK |
| parent_id | String | PK, FK |

### child_group

| Column | Type | Keys |
| --- | --- | --- |
| child_id | String | PK, FK |
| group_id | String | PK, FK |

### member_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK, FK |
| member_id | String | PK, FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| my_team | Boolean |  |
| title | String |  |
| custom_** |  |  |

### timelog

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category_id | String | FK |
| task_id | String | FK |
| user_id | String | FK |
| billing_type | String |  |
| created_date | Instant |  |
| finance_actual_cost | Double |  |
| finance_actual_fees | Double |  |
| finance_currency | String |  |
| hours | Double |  |
| tracked_date | Unknown |  |
| updated_date | Instant |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_id | String | FK |
| folder_id | String | FK |
| task_id | String | FK |
| created_date | Instant |  |
| direction | String |  |
| email_subject | String |  |
| external_requester_first_name | String |  |
| external_requester_id | String |  |
| external_requester_last_name | String |  |
| text | String |  |
| type | String |  |
| updated_date | Instant |  |

### account_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| custom_field_id | Unknown | PK, FK |

### account_workday

| Column | Type | Keys |
| --- | --- | --- |
| workday | String | PK |
| account_id | String | PK, FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| recycle_bin_id | String | FK |
| root_folder_id | String | FK |
| created_date | Instant |  |
| date_format | String |  |
| first_day_of_week | String |  |
| joined_date | Instant |  |
| name | String |  |
| subscription_paid | Boolean |  |
| subscription_suspended | Boolean |  |
| subscription_type | String |  |
| subscription_user_limit | Double |  |
| custom_** |  |  |

## Relationships

- booking_effort_responsible_daily_allocation(booking_effort_responsible_allocation_index) → booking_effort_responsible_allocation(index)
- booking_effort_responsible_daily_allocation(booking_effort_responsible_allocation_booking_id) → booking_effort_responsible_allocation(booking_id)
- booking_effort_responsible_allocation(user_id) → contact(id)
- booking_effort_responsible_allocation(booking_id) → booking(id)
- booking(folder_id) → folder_project(id)
- booking(placeholder_id) → placeholder(id)
- booking(responsible_id) → contact(id)
- space_task_dependency_id(space_task_id) → space_task(id)
- space_task_super_parent_id(space_task_id) → space_task(id)
- space_task_sub_task_id(space_task_id) → space_task(id)
- space_task_super_task_id(space_task_id) → space_task(id)
- space_task_parent_id(space_task_id) → space_task(id)
- space_task_responsible_id(space_task_id) → space_task(id)
- space_task_responsible_placeholder_id(space_task_id) → space_task(id)
- space_task_author_id(space_task_id) → space_task(id)
- space_task_follower_id(space_task_id) → space_task(id)
- space_task_custom_field(space_task_id) → space_task(id)
- space_task(custom_item_id) → custom_item_type(id)
- space_task(id) → space(id)
- space_task(account_id) → account(id)
- space_member(contact_id) → contact(id)
- space_member(access_role_id) → access_role(id)
- space_member(space_id) → space(id)
- space_project_workflow(workflow_id) → workflow(id)
- space_project_workflow(space_id) → space(id)
- space_task_workflow(workflow_id) → workflow(id)
- space_task_workflow(space_id) → space(id)
- space(guest_role_id) → access_role(id)
- space(default_project_workflow_id) → workflow(id)
- space(default_task_workflow_id) → workflow(id)
- folder_finance(id) → folder_project(id)
- contact_member(member_id) → contact(id)
- contact_member(contact_id) → contact(id)
- contact_profile(account_id) → account(id)
- contact_profile(contact_id) → contact(id)
- contact(job_role_id) → job_role(id)
- contact(work_schedule_id) → work_schedule(id)
- custom_item_type(space_id) → space(id)
- workflow_custom_status(workflow_id) → workflow(id)
- workflow(space_id) → space(id)
- invitation(account_id) → account(id)
- invitation(inviter_id) → contact(id)
- user_schedule_exception(contact_id) → contact(id)
- folder_task_dependency_id(folder_task_id) → folder_task(id)
- folder_task_super_parent_id(folder_task_id) → folder_task(id)
- folder_task_sub_task_id(folder_task_id) → folder_task(id)
- folder_task_super_task_id(folder_task_id) → folder_task(id)
- folder_task_parent_id(folder_task_id) → folder_task(id)
- folder_task_responsible_id(folder_task_id) → folder_task(id)
- folder_task_responsible_placeholder_id(folder_task_id) → folder_task(id)
- folder_task_author_id(folder_task_id) → folder_task(id)
- folder_task_follower_id(folder_task_id) → folder_task(id)
- folder_task_custom_field(folder_task_id) → folder_task(id)
- folder_task(custom_item_id) → custom_item_type(id)
- folder_task(id) → folder_project(id)
- folder_task(account_id) → account(id)
- folder_hourly_rate(folder_project_id) → folder_project(id)
- folder_project_owner(owner_id) → contact(id)
- folder_project_owner(folder_project_id) → folder_project(id)
- folder_project_child(child_id) → folder_project(id)
- folder_project_child(folder_project_id) → folder_project(id)
- folder_project_share(shared_id) → contact(id)
- folder_project_share(folder_project_id) → folder_project(id)
- folder_project_parent(parent_id) → folder_project(id)
- folder_project_parent(folder_project_id) → folder_project(id)
- folder_project_super_parent(super_parent_id) → folder_project(id)
- folder_project_super_parent(folder_project_id) → folder_project(id)
- folder_project_custom_field(custom_column_id) → custom_field(id)
- folder_project_custom_field(folder_project_id) → folder_project(id)
- folder_project(custom_item_id) → custom_item_type(id)
- folder_project(workflow_id) → workflow(id)
- folder_project(account_id) → account(id)
- folder_project(project_custom_status_id) → workflow_custom_status(id)
- folder_project(project_author_id) → contact(id)
- workweek_schedule(work_schedule_id) → work_schedule(id)
- user_work_schedule(user_id) → contact(id)
- user_work_schedule(work_schedule_id) → work_schedule(id)
- attachment_review(attachment_id) → attachment(id)
- attachment(folder_id) → folder_project(id)
- attachment(task_id) → space_task(id)
- attachment(author_id) → contact(id)
- attachment(comment_id) → comment(id)
- attachment(current_attachment_id) → attachment(id)
- placeholder(job_role_id) → job_role(id)
- custom_field_share(share_id) → contact(id)
- custom_field_share(custom_field_id) → custom_field(id)
- custom_field_contact(contact_id) → contact(id)
- custom_field_contact(custom_field_id) → custom_field(id)
- custom_field(account_id) → account(id)
- custom_field(space_id) → space(id)
- approval_attachment(attachment_id) → attachment(id)
- approval_attachment(approval_id) → approval(id)
- approval_decision(approver_id) → contact(id)
- approval_decision(approval_id) → approval(id)
- approval(folder_id) → folder_project(id)
- approval(task_id) → folder_task(id)
- approval(author_id) → contact(id)
- approval(finisher_id) → contact(id)
- parent_group(parent_id) → contact(id)
- parent_group(group_id) → groups(id)
- child_group(child_id) → contact(id)
- child_group(group_id) → groups(id)
- member_group(member_id) → contact(id)
- member_group(group_id) → groups(id)
- groups(account_id) → account(id)
- timelog(user_id) → contact(id)
- timelog(category_id) → timelog_category(id)
- timelog(task_id) → space_task(id)
- comment(folder_id) → folder_project(id)
- comment(task_id) → space_task(id)
- comment(author_id) → contact(id)
- account_custom_field(custom_field_id) → custom_field(id)
- account_custom_field(account_id) → account(id)
- account_workday(account_id) → account(id)
- account(root_folder_id) → folder_project(id)
- account(recycle_bin_id) → folder_project(id)