# Pivotal Tracker schema ERD

Table and field reference for the Fivetran Pivotal Tracker connector.

## Table & Field Reference

### iteration_story

| Column | Type | Keys |
| --- | --- | --- |
| iteration_number | Unknown | PK, FK |
| iteration_project_id | Unknown | PK, FK |
| story_id | Unknown | PK, FK |

### iteration

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| project_id | Unknown | PK, FK |
| 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 | PK, FK |
| story_id | Unknown | PK, FK |
| 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 | PK, FK |
| story_id | Unknown | PK, FK |

### story_owner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| story_id | Unknown | PK, FK |
| owner_id | Unknown |  |

### story

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- iteration_story(story_id) → story(id)
- iteration_story(iteration_project_id) → iteration(project_id)
- iteration_story(iteration_number) → iteration(number)
- iteration(project_id) → project(id)
- task(story_id) → story(id)
- task(project_id) → story(project_id)
- project(account_id) → account(id)
- project(current_iteration_number) → iteration(number)
- epic(project_id) → project(id)
- epic(label_id) → label(id)
- story_transition(story_id) → story(id)
- story_transition(project_id) → project(id)
- project_integration(project_id) → project(id)
- account_membership(account_id) → account(id)
- release(project_id) → project(id)
- story_label(label_id) → label(id)
- story_label(story_id) → story(id)
- story_owner(story_id) → story(id)
- story(project_id) → project(id)
- project_membership(project_id) → project(id)
- comment(story_id) → story(id)
- comment(project_id) → story(project_id)
- review(story_id) → story(id)
- review(project_id) → story(project_id)
- label(project_id) → project(id)
- activity_change(activity_guid) → activity(guid)
- activity_primary_resource(activity_guid) → activity(guid)
- activity(project_id) → project(id)
- blocker(story_id) → story(id)
- blocker(project_id) → story(project_id)