Jama Software
Explore the interactive ERD
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 | PKFK |
name | Unknown | |
synchronize | Unknown |
item_type_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
item_type_id | Unknown | PKFK |
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 | PKFK |
relationship_set_id | Unknown | PKFK |
active | Unknown | |
name | Unknown |
relationship_set_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
relationship_set_id | Unknown | PKFK |
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 | PKFK |
category_path_sequence | Unknown | |
item_version_number_applied | Unknown |
test_run_group
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
test_run_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
category_path_sequence | Unknown | |
item_version_number_applied | Unknown |
test_plan
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown |