Wrike

Explore the interactive ERD

Table & Field Reference

booking_effort_responsible_daily_allocation

Column	Type	Keys
`date`	Unknown	PK
`booking_effort_responsible_allocation_booking_id`	String	PKFK
`booking_effort_responsible_allocation_index`	Unknown	PKFK
`effort_minutes`	Unknown

booking_effort_responsible_allocation

Column	Type	Keys
`index`	Unknown	PK
`booking_id`	String	PKFK
`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	PKFK
`dependency_id`	Unknown

space_task_super_parent_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`super_parent_id`	Unknown

space_task_sub_task_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`sub_task_id`	Unknown

space_task_super_task_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`space_super_task_id`	Unknown

space_task_parent_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`parent_id`	Unknown

space_task_responsible_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`responsible_id`	Unknown

space_task_responsible_placeholder_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`responsible_placeholder_id`	Unknown

space_task_author_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`author_id`	Unknown

space_task_follower_id

Column	Type	Keys
`index`	Unknown	PK
`space_task_id`	Unknown	PKFK
`follower_id`	Unknown

space_task_custom_field

Column	Type	Keys
`id`	Unknown	PK
`space_task_id`	Unknown	PKFK
`value`	Unknown

space_task

Column	Type	Keys
`id`	Unknown	PKFK
`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	PKFK
`space_id`	String	PKFK
`access_role_id`	String	FK
`is_manager`	Boolean

space_project_workflow

Column	Type	Keys
`space_id`	String	PKFK
`workflow_id`	String	PKFK

space_task_workflow

Column	Type	Keys
`space_id`	String	PKFK
`workflow_id`	String	PKFK

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	PKFK
`actual_cost`	Unknown
`actual_fees`	Unknown
`budget`	Unknown
`currency`	Unknown
`planned_cost`	Unknown
`planned_fees`	Unknown

contact_member

Column	Type	Keys
`contact_id`	String	PKFK
`member_id`	String	PKFK

contact_profile

Column	Type	Keys
`account_id`	String	PKFK
`contact_id`	String	PKFK
`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	PKFK
`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	PKFK
`dependency_id`	Unknown

folder_task_super_parent_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`super_parent_id`	Unknown

folder_task_sub_task_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`sub_task_id`	Unknown

folder_task_super_task_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`folder_super_task_id`	Unknown

folder_task_parent_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`parent_id`	Unknown

folder_task_responsible_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`responsible_id`	Unknown

folder_task_responsible_placeholder_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`responsible_placeholder_id`	Unknown

folder_task_author_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`author_id`	Unknown

folder_task_follower_id

Column	Type	Keys
`index`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`follower_id`	Unknown

folder_task_custom_field

Column	Type	Keys
`id`	Unknown	PK
`folder_task_id`	Unknown	PKFK
`value`	Unknown

folder_task

Column	Type	Keys
`id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`owner_id`	String	PKFK

folder_project_child

Column	Type	Keys
`child_id`	String	PKFK
`folder_project_id`	String	PKFK

folder_project_share

Column	Type	Keys
`folder_project_id`	String	PKFK
`shared_id`	String	PKFK

folder_project_parent

Column	Type	Keys
`folder_project_id`	String	PKFK
`parent_id`	String	PKFK

folder_project_super_parent

Column	Type	Keys
`folder_project_id`	String	PKFK
`super_parent_id`	String	PKFK

folder_project_custom_field

Column	Type	Keys
`custom_column_id`	Unknown	PKFK
`folder_project_id`	String	PKFK
`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	PKFK
`work_schedule_id`	String	PKFK

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	PKFK

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	PKFK
`share_id`	String	PKFK

custom_field_contact

Column	Type	Keys
`contact_id`	String	PKFK
`custom_field_id`	String	PKFK

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	PKFK
`attachment_id`	String	PKFK

approval_decision

Column	Type	Keys
`approval_id`	String	PKFK
`approver_id`	String	PKFK
`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	PKFK
`parent_id`	String	PKFK

child_group

Column	Type	Keys
`child_id`	String	PKFK
`group_id`	String	PKFK

member_group

Column	Type	Keys
`group_id`	String	PKFK
`member_id`	String	PKFK

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	PKFK
`custom_field_id`	Unknown	PKFK

account_workday

Column	Type	Keys
`workday`	String	PK
`account_id`	String	PKFK

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_`