# Jama Software schema ERD

Table and field reference for the Fivetran Jama Software connector.

## Table & Field Reference

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| uid | Unknown |  |

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| parent_item_id | Unknown | FK |
| parent_project_id | Unknown | FK |
| project_id | Unknown | FK |
| attachment_id | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| document_key | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| global_id | Unknown |  |
| item_type | Unknown |  |
| last_activity_date | Unknown |  |
| last_locked_date | Unknown |  |
| locked | Unknown |  |
| locked_by | Unknown |  |
| mime_type | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### test_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attachment_id | Unknown | FK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| parent_item_id | Unknown | FK |
| parent_project_id | Unknown | FK |
| project_id | Unknown | FK |
| created_date | Unknown |  |
| description | Unknown |  |
| document_key | Unknown |  |
| global_id | Unknown |  |
| item_type | Unknown |  |
| last_activity_date | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| parent_item_id | Unknown | FK |
| parent_project_id | Unknown | FK |
| project_id | Unknown | FK |
| child_item_type | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| document_key | Unknown |  |
| global_id | Unknown |  |
| global_sort_order | Unknown |  |
| item_type | Unknown |  |
| last_activity_date | Unknown |  |
| last_locked_date | Unknown |  |
| locked | Unknown |  |
| locked_by | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| sequence | Unknown |  |
| sort_order | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| item_id | Unknown | FK |
| modified_by | Unknown | FK |
| project_id | Unknown | FK |
| body_text | Unknown |  |
| comment_type | Unknown |  |
| created_date | Unknown |  |
| deleted | Unknown |  |
| in_reply_to | Unknown |  |
| status | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| path_id | Unknown | PK |
| name | Unknown |  |
| path | Unknown |  |

### item_type_widget

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| item_type_id | Unknown | PK, FK |
| name | Unknown |  |
| synchronize | Unknown |  |

### item_type_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| item_type_id | Unknown | PK, FK |
| parent_item_type_id | Unknown | FK |
| picklist_id | Unknown | FK |
| control_style | Unknown |  |
| field_type | Unknown |  |
| infotip | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| pick_list_id | Unknown |  |
| read_only | Unknown |  |
| read_only_allow_overwrite | Unknown |  |
| required | Unknown |  |
| synchronize | Unknown |  |
| text_type | Unknown |  |
| trigger_suspect | Unknown |  |

### item_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| display | Unknown |  |
| display_plural | Unknown |  |
| image | Unknown |  |
| is_system | Unknown |  |
| type_key | Unknown |  |

### relationship_set_mapped_project

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| relationship_set_id | Unknown | PK, FK |
| active | Unknown |  |
| name | Unknown |  |

### relationship_set_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| relationship_set_id | Unknown | PK, FK |
| from_item_type_id | Unknown | FK |
| relationship_type_id | Unknown | FK |
| to_item_type_id | Unknown | FK |
| for_coverage | Unknown |  |

### relationship_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_exclusive | Unknown |  |
| name | Unknown |  |

### picklist

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |
| picklist_type | Unknown |  |

### test_run_baselined_applied_category_snapshot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| test_run_id | Unknown | PK, FK |
| category_path_sequence | Unknown |  |
| item_version_number_applied | Unknown |  |

### test_run_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| test_run_id | Unknown | PK, FK |
| groups | Unknown |  |

### test_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| item_type_id | Unknown | FK |
| modified_by | Unknown | FK |
| project_id | Unknown | FK |
| created_date | Unknown |  |
| document_key | Unknown |  |
| fields_key | Unknown |  |
| global_id | Unknown |  |
| last_activity_date | Unknown |  |
| modified_date | Unknown |  |
| sort_order_from_test_group | Unknown |  |
| test_case_version_number | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| parent_id | Unknown | FK |
| project_manager_id | Unknown | FK |
| created_date | Unknown |  |
| description | Unknown |  |
| is_folder | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| project_group | Unknown |  |
| project_key | Unknown |  |
| status_id | Unknown |  |
| text_1 | Unknown |  |

### picklist_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| picklist_id | Unknown | FK |
| active | Unknown |  |
| archived | Unknown |  |
| color | Unknown |  |
| defaults | Unknown |  |
| description | Unknown |  |
| info_tip | Unknown |  |
| name | Unknown |  |
| sort_order | Unknown |  |
| value | Unknown |  |

### release

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| active | Unknown |  |
| archived | Unknown |  |
| date | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| item_count | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### base_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| origin_item_id | Unknown | FK |
| origin_project_id | Unknown | FK |
| origin_release_id | Unknown | FK |
| origin_test_cycle_id | Unknown | FK |
| origin_test_plan_id | Unknown | FK |
| baseline_key | Unknown |  |
| baseline_pick_list_option | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| filter | Unknown |  |
| name | Unknown |  |
| origin_simple_filter | Unknown |  |
| signed | Unknown |  |
| source | Unknown |  |
| source_key | Unknown |  |
| source_name | Unknown |  |
| type | Unknown |  |

### test_plan_baselined_applied_category_snapshot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| test_plan_id | Unknown | PK, FK |
| category_path_sequence | Unknown |  |
| item_version_number_applied | Unknown |  |

### test_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| item_type_id | Unknown | FK |
| modified_by | Unknown | FK |
| archived | Unknown |  |
| created_date | Unknown |  |
| document_key | Unknown |  |
| fields_key | Unknown |  |
| global_id | Unknown |  |
| last_activity_date | Unknown |  |
| modified_date | Unknown |  |

### relationship_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_default | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| from_item | Unknown | FK |
| relationship_type | Unknown | FK |
| to_item | Unknown | FK |
| suspect | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| authentication_id | Unknown |  |
| authentication_name | Unknown |  |
| custom_data | Json |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| license_type | Unknown |  |
| location | Unknown |  |
| phone | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| uid | Unknown |  |
| username | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| item_type_id | Unknown | FK |
| user_id | Unknown | FK |
| action | Unknown |  |
| date | Unknown |  |
| details | Unknown |  |
| event_type | Unknown |  |
| object_type | Unknown |  |
| user_comment | Unknown |  |
| user_name | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |

## Relationships

- user_group(project_id) → project(id)
- attachment(created_by) → users(id)
- attachment(project_id) → project(id)
- attachment(modified_by) → users(id)
- attachment(parent_project_id) → project(id)
- attachment(parent_item_id) → item(id)
- test_cycle(created_by) → users(id)
- test_cycle(project_id) → project(id)
- test_cycle(modified_by) → users(id)
- test_cycle(attachment_id) → attachment(id)
- test_cycle(parent_project_id) → project(id)
- test_cycle(parent_item_id) → item(id)
- item(created_by) → users(id)
- item(project_id) → project(id)
- item(modified_by) → users(id)
- item(parent_item_id) → item(id)
- item(parent_project_id) → project(id)
- comment(created_by) → users(id)
- comment(item_id) → item(id)
- comment(project_id) → project(id)
- comment(modified_by) → users(id)
- item_type_widget(item_type_id) → item_type(id)
- item_type_field(parent_item_type_id) → item_type(id)
- item_type_field(picklist_id) → picklist(id)
- item_type_field(item_type_id) → item_type(id)
- relationship_set_mapped_project(project_id) → project(id)
- relationship_set_mapped_project(relationship_set_id) → relationship_set(id)
- relationship_set_rule(from_item_type_id) → item_type(id)
- relationship_set_rule(to_item_type_id) → item_type(id)
- relationship_set_rule(relationship_type_id) → relationship_type(id)
- relationship_set_rule(relationship_set_id) → relationship_set(id)
- test_run_baselined_applied_category_snapshot(test_run_id) → test_run(id)
- test_run_group(test_run_id) → test_run(id)
- test_run(created_by) → users(id)
- test_run(project_id) → project(id)
- test_run(modified_by) → users(id)
- test_run(item_type_id) → item_type(id)
- project(parent_id) → project(id)
- project(created_by) → users(id)
- project(modified_by) → users(id)
- project(project_manager_id) → users(id)
- picklist_option(picklist_id) → picklist(id)
- release(project_id) → project(id)
- base_line(created_by) → users(id)
- base_line(origin_item_id) → item(id)
- base_line(origin_test_cycle_id) → test_cycle(id)
- base_line(origin_release_id) → release(id)
- base_line(origin_test_plan_id) → test_plan(id)
- base_line(origin_project_id) → project(id)
- base_line(project_id) → project(id)
- test_plan_baselined_applied_category_snapshot(test_plan_id) → test_plan(id)
- test_plan(created_by) → users(id)
- test_plan(modified_by) → users(id)
- test_plan(item_type_id) → item_type(id)
- test_plan(project_id) → project(id)
- relationship(from_item) → item(id)
- relationship(to_item) → item(id)
- relationship(relationship_type) → relationship_type(id)
- relationship(project_id) → project(id)
- activity(user_id) → users(id)
- activity(item_id) → item(id)
- activity(item_type_id) → item_type(id)
- activity(project_id) → project(id)
- tags(project_id) → project(id)