Asana

Explore the interactive ERD

Table & Field Reference

custom_field

Column	Type	Keys
`id`	String	PK
`portfolio_id`	String	FK
`project_id`	String	FK
`workspace_id`	String	FK
`description`	String
`name`	String
`type`	String

task

Column	Type	Keys
`id`	String	PK
`assignee_id`	String	FK
`completed_by_id`	String	FK
`created_by_id`	String	FK
`parent_id`	String	FK
`workspace_id`	String	FK
`actual_time_minutes`	Int
`completed`	Boolean
`completed_at`	Instant
`created_at`	Instant
`due_at`	Instant
`due_on`	Instant
`liked`	Boolean
`modified_at`	Instant
`name`	String
`notes`	String
`num_likes`	Int
`resource_subtype`	String
`start_on`	Instant
`custom_`

project

Column	Type	Keys
`id`	String	PK
`owner_id`	String	FK
`team_id`	String	FK
`workspace_id`	String	FK
`archived`	Boolean
`color`	String
`created_at`	Instant
`current_status`	String
`current_status_color`	String
`due_date`	Instant
`modified_at`	Instant
`name`	String
`notes`	String
`public`	Boolean
`start_on`	Instant
`custom_`

user

Column	Type	Keys
`id`	String	PK
`email`	String
`name`	String

attachment

Column	Type	Keys
`id`	String	PK
`parent_id`	String	FK
`created_at`	Instant
`download_url`	String
`host`	String
`name`	String
`view_url`	String

tag

Column	Type	Keys
`id`	String	PK
`workspace_id`	String	FK
`color`	String
`created_at`	Instant
`message`	String
`name`	String
`notes`	String

portfolio_member

Column	Type	Keys
`portfolio_id`	String	PKFK
`user_id`	String	PKFK

goal_follower

Column	Type	Keys
`goal_id`	String	PKFK
`user_id`	String	PKFK

story

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`target_id`	String	FK
`created_at`	Instant
`hearted`	Boolean
`num_hearts`	Int
`source`	String
`text`	String
`type`	String

section

Column	Type	Keys
`id`	String	PK
`project_id`	String	FK
`created_at`	Instant
`name`	String

task_follower

Column	Type	Keys
`task_id`	String	PKFK
`user_id`	String	PKFK

team

Column	Type	Keys
`id`	String	PK
`organization_id`	String	FK
`name`	String

time_tracking

Column	Type	Keys
`id`	String	PK
`task_id`	String	PKFK
`created_by_id`	String	FK
`created_at`	Instant
`duration_minutes`	Double
`entered_on`	Instant

goal_status

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`goal_id`	String	FK
`created_at`	Instant
`modified_at`	Instant
`status_type`	String
`text`	String
`title`	String

project_task

Column	Type	Keys
`project_id`	String	PKFK
`task_id`	String	PKFK

task_tag

Column	Type	Keys
`tag_id`	String	PKFK
`task_id`	String	PKFK

story_heart

Column	Type	Keys
`story_id`	String	PKFK
`user_id`	String	PKFK

tag_follower

Column	Type	Keys
`tag_id`	String	PKFK
`user_id`	String	PKFK

project_status

Column	Type	Keys
`id`	String	PK
`author_id`	String	FK
`created_by_id`	String	FK
`project_id`	String	FK
`color`	String
`created_at`	Instant
`modified_at`	Instant
`text`	String
`title`	String

goal_relationship

Column	Type	Keys
`id`	String	PK
`goal_id`	String	PKFK
`contribution_weight`	Double
`resource_subtype`	String
`supporting_resource_gid`	String
`supporting_resource_name`	String
`supporting_resource_resource_type`	String

portfolio_item

Column	Type	Keys
`id`	String	PK
`portfolio_id`	String	PKFK
`resource_type`	String

task_dependency

Column	Type	Keys
`dependency_id`	String	PKFK
`task_id`	String	PKFK

goal

Column	Type	Keys
`id`	String	PK
`owner_id`	String	FK
`team_id`	String	FK
`workspace_id`	String	FK
`due_on`	Instant
`liked`	Boolean
`name`	String
`notes`	String
`num_likes`	Int
`start_on`	Instant
`status`	String
`metric_`
`time_period_`

workspace

Column	Type	Keys
`id`	String	PK
`is_organization`	Boolean
`name`	String

organization

Column	Type	Keys
`id`	String	PK
`name`	String

task_section

Column	Type	Keys
`section_id`	String	PKFK
`task_id`	String	PKFK

portfolio

Column	Type	Keys
`id`	String	PK
`created_by_id`	String	FK
`owner_id`	String	FK
`workspace_id`	String	FK
`color`	String
`created_at`	Instant
`due_on`	Instant
`name`	String
`start_on`	Instant
`custom_`