Fivetran documentation

Search the docs

/

Pivotal Tracker

Explore the interactive ERD

Table & Field Reference

iteration_story

Column	Type	Keys
`iteration_number`	Unknown	PKFK
`iteration_project_id`	Unknown	PKFK
`story_id`	Unknown	PKFK

iteration

Column	Type	Keys
`number`	Unknown	PK
`project_id`	Unknown	PKFK
`finish`	Unknown
`length`	Unknown
`start`	Unknown
`team_strength`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`story_id`	Unknown	FK
`complete`	Unknown
`created_at`	Unknown
`description`	Unknown
`position`	Unknown
`updated_at`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`current_iteration_number`	Unknown	FK
`atom_enabled`	Unknown
`automatic_planning`	Unknown
`bugs_and_chores_are_estimatable`	Unknown
`created_at`	Unknown
`enable_following`	Unknown
`enable_incoming_emails`	Unknown
`enable_tasks`	Unknown
`has_google_domain`	Unknown
`initial_velocity`	Unknown
`iteration_length`	Unknown
`name`	Unknown
`number_of_done_iterations_to_show`	Unknown
`point_scale`	Unknown
`point_scale_is_custom`	Unknown
`profile_content`	Unknown
`project_type`	Unknown
`public`	Unknown
`show_priority_icon`	Unknown
`show_priority_icon_in_all_panels`	Unknown
`show_story_priority`	Unknown
`start_date`	Unknown
`start_time`	Unknown
`time_zone_kind`	Unknown
`time_zone_offsets`	Unknown
`time_zone_olson_name`	Unknown
`updated_at`	Unknown
`velocity_averaged_over`	Unknown
`version`	Unknown
`week_start_day`	Unknown

epic

Column	Type	Keys
`id`	Unknown	PK
`label_id`	Unknown	FK
`project_id`	Unknown	FK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown
`url`	Unknown

story_transition

Column	Type	Keys
`project_id`	Unknown	PKFK
`story_id`	Unknown	PKFK
`occurred_at`	Unknown
`performed_by_id`	Unknown
`project_version`	Unknown
`state`	Unknown

project_integration

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`active`	Unknown
`base_url`	Unknown
`can_import`	Unknown
`created_at`	Unknown
`import_api_url`	Unknown
`is_other`	Unknown
`kind`	Unknown
`name`	Unknown
`story_name`	Unknown
`updated_at`	Unknown

account_membership

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`admin`	Unknown
`created_at`	Unknown
`email`	Unknown
`initial`	Unknown
`name`	Unknown
`owner`	Unknown
`person_id`	Unknown
`project_creator`	Unknown
`updated_at`	Unknown
`username`	Unknown

release

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`accepted_at`	Unknown
`created_at`	Unknown
`current_state`	Unknown
`deadline`	Unknown
`labels`	Json
`name`	Unknown
`updated_at`	Unknown
`url`	Unknown

story_label

Column	Type	Keys
`label_id`	Unknown	PKFK
`story_id`	Unknown	PKFK

story_owner

Column	Type	Keys
`index`	Unknown	PK
`story_id`	Unknown	PKFK
`owner_id`	Unknown

story

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`accepted_at`	Unknown
`created_at`	Unknown
`current_state`	Unknown
`description`	Unknown
`estimate`	Unknown
`name`	Unknown
`owned_by_id`	Unknown
`requested_by_id`	Unknown
`story_priority`	Unknown
`story_type`	Unknown
`updated_at`	Unknown
`url`	Unknown

project_membership

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`created_at`	Unknown
`favorite`	Unknown
`kind`	Unknown
`last_viewed_at`	Unknown
`person_email`	Unknown
`person_id`	Unknown
`person_initial`	Unknown
`person_kind`	Unknown
`person_name`	Unknown
`person_username`	Unknown
`project_color`	Unknown
`role`	Unknown
`updated_at`	Unknown
`wants_comment_notification_email`	Unknown
`will_receive_mention_notification_or_email`	Unknown

comment

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`story_id`	Unknown	FK
`created_at`	Unknown
`person_id`	Unknown
`text`	Unknown
`updated_at`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`plan`	Unknown
`status`	Unknown
`updated_at`	Unknown

review

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`story_id`	Unknown	FK
`created_at`	Unknown
`review_type_id`	Unknown
`status`	Unknown
`updated_at`	Unknown

label

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

activity_change

Column	Type	Keys
`index`	Unknown	PK
`activity_guid`	Unknown	PKFK
`change_type`	Unknown
`id`	Unknown
`name`	Unknown
`new_value`	Json
`original_value`	Json
`story_priority`	Unknown
`story_type`	Unknown

activity_primary_resource

Column	Type	Keys
`index`	Unknown	PK
`activity_guid`	Unknown	PKFK
`id`	Unknown
`kind`	Unknown
`name`	Unknown
`story_priority`	Unknown
`story_type`	Unknown
`url`	Unknown

activity

Column	Type	Keys
`guid`	Unknown	PK
`project_id`	Unknown	FK
`highlight`	Unknown
`message`	Unknown
`occurred_at`	Unknown
`performed_by`	Unknown
`project_version`	Unknown
`secondary_resource`	Json

blocker

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`story_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`person_id`	Unknown
`resolved`	Unknown
`updated_at`	Unknown