Table: ACTNTGT
Note | Contains a list of target users for automation rule actions. This table has a many-to-one relationship with the TRGACTN table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
ACTIONID | No | NUMERIC(10) | Yes | Link to a record ID in TRGACTN table |
TARGET | No | NUMERIC(5) | No | Target for automation rule action; includes the following values: 0 (action not set) 1 (Entered by user) 2 (assigned users) 3 (Found by users) 4 (Modified by users) 5 (last user to enter event) 6 (user) 7 (security group) 8 (current user) 9 (unassigned) |
TGTOPT | No | NUMERIC(10) | No | If target is a user, links to user ID in USERS table. If target is last user to enter an event, contains the event ID. If target is Found by or Modified by users, contains user; includes the following values: 0 (first user) 1 (last user) 2 (all users) Otherwise, contains 0. |
Table: ATTACHINFO
Note | Contains additional information on attachments to test cases and test runs. Each table row represents one file attached to the given record. This table has one-to-one relationship with ATTACHMT table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
ATTACHTYPE | No | NUMERIC(10) | Yes | Attachment type: 0 (Regular attachment), 1 (Script), 2 (Run Result) |
ATTACHID | No | NUMERIC(10) | Yes | Record ID in ATTACHMT table |
TYPE | No | NUMERIC(2) | Yes | Indicates Attachment table type (tableID_Attachments or tableID_SCCFiles) |
OWNERTYPE | No | NUMERIC(10) | Yes | Entity Type to which attachment belongs to |
OWNERID | No | NUMERIC(10) | Yes | Entity record ID to which attachment belongs to |
SCRPTORDER | No | NUMERIC(10) | No | This field is valid only if attachment type is script. Indicates order script is displayed in scripts tab and executed. |
SCRPTSTAT | No | VARCHAR(1020) | No | This field is valid only if attachment type is script. Indicates status of the script. |
Table: ATTACHMT
Note | Contains file attachment information. Each table row represents one file attached to the given record. This table has a many-to-one relationship with the REPORTBY table. Each row has a reported by record ID that matches a record ID in the REPORTBY table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
ENTITYTYPE | No | NUMERIC(10) | No | The table attachment is linked to. (Defect, Defect event, Test case, Test case event, Test run, or Test run event) |
ATTTYPE | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Macintosh binary file), 2 (other file type) |
ENTITYRID | No | NUMERIC(10) | No | Links to a REPORTBY table or DEFECTEVTS table record ID in case of Defects, otherwise links to Entity record ID. |
FILENAME | No | VARCHAR(800) | No | Original file name, before it was attached to an entity. |
MACTYPE | No | NUMERIC(10) | No | Macintosh type (valid for Macintosh only) |
MACCREATOR | No | NUMERIC(10) | No | Macintosh creator (valid for Macintosh only) |
DATECREATE | No | DATETIME | No | File creation date |
DATEMODIFY | No | DATETIME | No | File modification date |
FILESIZE | No | NUMERIC(10) | No | File size |
ARCHVFILE | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
COMPRESSED | No | NUMERIC(1) | No | Reserved for future use |
ATTACHINDB | No | NUMERIC(1) | No | Flag indicates if archive file contents are stored in database (valid for RDBMS only) |
FIELDID | No | NUMERIC(10) | No | Contains field id of field containing image for WYSIWYG inline images. |
IMGWIDTH | No | NUMERIC(5) | No | Width of original image added as inline WYSIWYG image. |
IMGHEIGHT | No | NUMERIC(5) | No | Height of original image added as inline WYSIWYG image. |
SUBTYPEID | No | NUMERIC(10) | No | SubType ID |
Table: ATTARCHIVE
Note | Contains file attachment archive information. Each table row represents one file attachment. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
ARCHVFILE | No | VARCHAR(96) | No | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
FILEDATA | No | IMAGE | No | Binary attachment data |
Table: AUDITLOG
Note | Contains the changes made to defect, test case or test run records. Each row records changes made to an entity and information regarding who, when, and how changes were made. Change information is stored in such a way that, if the user information is modified or deleted at a later date, the audit log table represents the information as it was when the changes were made. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
DATETIME | No | DATETIME | Yes | Date and time change was made; changed item identified by ENTITYTYPE and ENTITYID |
LOGINNAME | No | VARCHAR(356) | Yes | User login name |
FULLNAME | No | VARCHAR(260) | Yes | Full name (last, first) of user making the changes |
ENTITYTYPE | No | NUMERIC(10) | Yes | Entity to which the changes are linked to, defects, test cases or test runs |
ENTITYID | No | NUMERIC(10) | Yes | Link to the record ID in the table specified by ENTITYTYPE |
AUTOREASON | No | VARCHAR(1020) | Yes | Description of how item was changed (e.g., renumbered, changed via bulk field changes) |
ENTITYIDEN | No | VARCHAR(1020) | No | Description of changed item |
MANREASON | No | VARCHAR(1020) | No | Reason, entered by user, describing why changes were made; identified by ENTITYTYPE and ENTITYID |
MODSOURCE | No | VARCHAR(1020) | No | Description of source of changes (e.g, Web, SOAP, XML) |
MODTYPE | No | VARCHAR(1020) | No | Description of how source changes were made (e.g. Edit Window, List window, bulk field changes) |
CHANGES | No | TEXT | No | XML-formatted text documents changes |
HASH | No | VARCHAR(1020) | No | An MD5 hash of the LOGINNAME and DATETIME; verifies that data for this row has not been modified |
SIGCAPTURED | No | NUMERIC(1) | No | Indicates if electronic signatured is captured for this change. |
Table: CHARTS
Note | Contains live chart report information. Each table row represents one live chart report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
REPORTID | No | NUMERIC(10) | No | Record ID that uniquely identifies a report. |
NAME | No | VARCHAR(128) | No | Name field. |
TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
ACCESSSTAT | No | NUMERIC(2) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
ENTITYMASK | No | NUMERIC(10) | No | A bitmask of the entity types that the chart supports. |
DFCTFLTRID | No | NUMERIC(10) | No | Issue filter the chart uses. |
TSTCFLTRID | No | NUMERIC(10) | No | Test case filter the chart uses. |
TSTRFLTRID | No | NUMERIC(10) | No | Test run filter the chart uses. |
RQMTFLTRID | No | NUMERIC(10) | No | Requirement filter the chart uses. |
RDMTFLTRID | No | NUMERIC(10) | No | Requirement document filter the chart uses. |
XML | No | TEXT | No | XML text containing additional parameters. (Stored as XML to allow for future expansion). |
Table: CHARTSET
Note | Contains live chart report attributes. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
CHARTID | No | NUMERIC(10) | No | Links to a record ID in CHARTS table. |
USERID | No | NUMERIC(10) | No | Links to a record ID in USERS table. |
FILTERID | No | NUMERIC(10) | No | Filter the chart uses. |
ISINTFILT | No | NUMERIC(1) | No | Indicates if filter is interactive. |
SHWENTTYPE | No | NUMERIC(10) | No | Indicates entity type of the chart settings. |
ISRECUR | No | NUMERIC(1) | No | Indicates if folder recursive option is selected |
FOLDRECID | No | NUMERIC(10) | No | Links to a record ID in FOLDER table. |
FOLDOWNID | No | NUMERIC(10) | No | Indicates folder owner ID |
ZORDER | No | NUMERIC(5) | No | Indicates Z order of the window. |
WIDTH | No | NUMERIC(5) | No | Width of live chart window in pixels |
HEIGHT | No | NUMERIC(5) | No | Height of live chart window in pixels |
XPOS | No | NUMERIC(10) | No | X position of the live chart window in the MDI client area. |
YPOS | No | NUMERIC(10) | No | Y position of the live chart window in the MDI client area. |
ISMAX | No | NUMERIC(1) | No | Indicates if live chart window was maximized when client was closed. |
SHWTITLE | No | NUMERIC(1) | No | Indicates if chart title should be visible. |
SHWLGND | No | NUMERIC(1) | No | Indicates if chart legend should be visible. |
SHWXAXIS | No | NUMERIC(1) | No | Indicates if chart X axis should be visible. |
SHWYAXLT | No | NUMERIC(1) | No | Indicates if chart left Y axis should be visible. |
SHWYAXRT | No | NUMERIC(1) | No | Indicates if chart right Y axis should be visible. |
SHWXAXLBL | No | NUMERIC(1) | No | Indicates if chart X axis labels should be visible. |
SHWYLTLBL | No | NUMERIC(1) | No | Indicates if chart left Y axis labels should be visible. |
SHWYRTLBL | No | NUMERIC(1) | No | Indicates if chart right Y axis labels should be visible. |
SHWDATLBL | No | NUMERIC(1) | No | Indicates if chart data labels should be visible. |
Table: CSDOCVAL
Note | Contains information related to custom fields on a requirement document. Each table row represents one custom field value associated with a single document. This table has a many-to-one relationship with the DOCUMENT table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCUMENT table |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CSRDEVTVL
Note | Contains custom field values for requirement document events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the DOCEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
IDEVENT | No | NUMERIC(10) | No | Links to a record ID in DOCEVTS table |
Table: CSREQVAL
Note | Contains information related to custom fields on a requirement. Each table row represents one custom field value associated with a single requirement. This table has a many-to-one relationship with the REQMNT table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CSREVTVL
Note | Contains custom field values for requirement events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the REQEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
IDEVENT | No | NUMERIC(10) | No | Links to a record ID in REQEVTS table |
Table: CSTDEVTVAL
Note | Contains custom field values for defect events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the DEFECTEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
IDDEFEVT | No | NUMERIC(10) | No | Links to a record ID in DEFECTEVTS table |
Table: CSTTCEVTVAL
Note | Contains custom field values for test case events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the TCEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
IDDEFEVT | No | NUMERIC(10) | No | Links to a record ID in TCEVTS table |
Table: CSTTREVTVAL
Note | Contains custom field values for test run events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the TREVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
IDDEFEVT | No | NUMERIC(10) | No | Links to a record ID in TREVTS table |
Table: CUSTMMAP
Note | Contains field level mappings for creating-type-from-type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
SRCFLDID | No | NUMERIC(10) | No | Field ID for the source field. |
DSTNFLDID | No | NUMERIC(10) | No | Field ID for the destination field. |
PREPNDTEXT | No | TEXT | No | Prepend text. |
APPNDTEXT | No | TEXT | No | Append text. |
ORDERNUM | No | NUMERIC(5) | No | Order number of mapping rule within mapping rule dialog. |
PARENTACTIONID | No | NUMERIC(10) | Yes | Refers to the parent row in OBJCTGEN. |
Table: CUSTMVAL
Note | Contains information related to custom fields on a defect. Each table row represents one custom field value associated with a single defect. This table has a many-to-one relationship with the DEFECTS table and the FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in DEFECTS table |
CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, links to a record ID. |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CUSTTCVAL
Note | Contains information related to custom fields on a test case. Each table row represents one custom field value associated with a single test case. This table has a many-to-one relationship with the TESTCASE table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTCASE table |
CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CVVRSTATE | No | NUMERIC(5) | No | Type of coverage variable: 0 (Unknown) 1 (Required) 2 (Excluded) 3 (Generated) 4 (Additional) 5 (All Coverage) |
HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CUSTTRVAL
Note | Contains information related to custom fields on a test run. Each table row represents one custom field value associated with a single test run. This table has a many-to-one relationship with the TESTRUN table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTRUN table |
CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
CVVRSTATE | No | NUMERIC(5) | No | Type of coverage variable: 0 (Unknown) 1 (Required) 2 (Excluded) 3 (Generated) 4 (Additional) 5 (All Coverage) |
HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: DASHBOARDLIVECHARTWIDGET
Note | Contains dashboard chart widget information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
XML | No | TEXT | No | XML that contains all chart settings. |
Table: DASHBOARDSTATICWIDGET
Note | Reserved for future use. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Reserved for future use. |
CONTENT | No | TEXT | No | Reserved for future use. |
Table: DASHBOARDSTATUSWIDGET
Note | Contains dashboard burn down or burn up widget information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
RECURSIVE | No | NUMERIC(1) | Yes | Indicates if folder recursive option is selected. |
OVERRIDEPLANNING | No | NUMERIC(1) | Yes | Indicates if widget uses own planning information instead of folder release planning information. |
STARTDATE | No | DATETIME | No | Widget planning period start date. |
ENDDATE | No | DATETIME | No | Widget planning period end date. |
INCLUDEWEEKENDS | No | NUMERIC(1) | No | Indicates if planning information includes weekends. |
BURNDOWN | No | NUMERIC(1) | Yes | Indicates if the widget type is burn down. 0 indicates the widget type is burn up. |
FOLDERID | No | NUMERIC(10) | No | Folder that contains items to include in widget data. |
DATATOCHART | No | NUMERIC(10) | No | Time tracking fields; includes the following values: 0 (Hours) 1 (Story Points for burn down widget or Story Points Done for burn up widget) 2 (Story Points Accepted for burn up widget) |
UNITS | No | NUMERIC(10) | No | Units to display; includes the following values: 0 (Days) 1 (Weeks) 2 (Months) |
ENABLEDTYPES | No | NUMERIC(10) | No | Bit flags that indicate item types included in the widget: 0x01 (Defects) 0x02 (Test Cases) 0x04 (Test Runs) 0x08 (Requirements) 0x10 (Requirement Documents) |
Table: DASHBOARDTILEWIDGET
Note | Contains dashboard count widget information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
FILTERENTITYTYPE | No | NUMERIC(10) | Yes | Item type included in the widget. |
FILTERID | No | NUMERIC(10) | Yes | Filter the widget uses. |
HASGRADIENT | No | NUMERIC(1) | Yes | Indicates if the widget uses a gradient. |
Table: DASHBOARDVIEW
Note | Contains dashboard information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
NAME | No | VARCHAR(256) | Yes | Dashboard name. |
DESCRIPTION | No | VARCHAR(1020) | No | Dashboard description. |
LAYOUT | No | NUMERIC(10) | Yes | Dashboard layout; includes the following values: 1 (One column) 2 (Two equal-sized columns) 3 (Two columns with a larger left column) 4 (Two columns with a larger right column) 5 (Three equal-sized columns) |
HASHEADER | No | NUMERIC(1) | Yes | Indicates if the dashboard includes a header area above the columns. |
Table: DASHBOARDVIEWORDER
Note | Contains the order to display dashboards in for a specified user. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
VIEWID | Yes | NUMERIC(10) | Yes | Dashboard ID. |
USERID | Yes | NUMERIC(10) | Yes | Link to a record ID in USERS table. |
ORDERNUM | No | NUMERIC(10) | Yes | Order number of the dashboard on the Dashboards window or page. |
ISACTIVE | No | NUMERIC(1) | Yes | Indicates if the dashboard is the active dashboard when the Dashboards window or page opens. |
ISVISIBLE | No | NUMERIC(1) | Yes | Indicates if the dashboard is shown in a tab on the Dashboards window or page. |
Table: DASHBOARDVIEWWIDGET
Note | Contains information about the widgets included in a dashboard. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
WIDGETID | Yes | NUMERIC(10) | Yes | Widget ID. |
VIEWID | Yes | NUMERIC(10) | Yes | Dashboard ID. |
LOCATION | Yes | NUMERIC(10) | Yes | Dashboard column that includes the widget. 0 indicates the widget is in the dashboard header area. |
ORDERNUM | Yes | NUMERIC(10) | Yes | Order number of the widget in the specified dashboard column. |
Table: DASHBOARDWIDGET
Note | Contains basic information included in all dashboard widgets. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
TITLE | No | VARCHAR(512) | Yes | Widget name. |
DESCRIPTION | No | VARCHAR(1020) | No | Widget description. |
WIDGETTYPE | No | NUMERIC(10) | Yes | fromIdentifies the table to retrieve widget settings from; includes the following values: 1 (DASHBOARDCOUNTWIDGET) 4 (DASHBOARDLIVECHARTWIDGET) 5 or 6 (DASHBOARDSTATUSWIDGET) |
Table: DASHRECACT
Note | Contains dashboard recent activity |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
DATELOG | No | DATETIME | Yes | Date/time the activity occurred. |
CHANGETYPE | No | NUMERIC(10) | Yes | Activity type: 0 (Unknown) 1 (Item added) 2 (Item edited) 3 (Workflow event) 4 (Items merged) |
USERID | No | NUMERIC(10) | No | User who performed the action. |
ENTITYID | No | NUMERIC(10) | No | Item the activity was performed on. |
ENTITYTYPE | No | NUMERIC(10) | No | Item type the activity was performed on. |
EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table. |
EVTUSERID | No | NUMERIC(10) | No | User in the workflow event By field. |
EVTDATE | No | DATETIME | No | Date in the workflow event Date field. |
TIMESPENT | No | NUMERIC(20, 2) | No | Time in the workflow event Hours field. |
RSLTSTATE | No | NUMERIC(10) | No | Resulting state for the workflow event. |
ASGNDUSERS | No | VARCHAR(4000) | No | Users the item was assigned to. |
EVTMARKSUSPECT | No | NUMERIC(1) | No | Indicates if the item was marked as suspect. |
NOTES | No | TEXT | No | Workflow event notes. |
Table: DEFECTEVTS
Note | Contains event information for each event recorded with a defect. Each table row represents a single defect event. This table has a many-to-one relationship with the DEFECTS table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table |
ORDERNUM | No | NUMERIC(5) | No | Identifies order the defect event was created relative to other defect events; an internal counter for a specific defect |
PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in DEFECTS table |
EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in DEFECTEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multiuser assignment, field contains the value -1 |
IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by TestTrack, it has a record ID of -2 |
DATEEVENT | No | DATETIME | No | Defect event date |
NOTES | No | TEXT | No | Notes field |
TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1 |
RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting defect state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values: 0 (created by user) 1 (created by multi-user assignment) 2 (created by auto assignment) 3 (created by auto escalation) |
CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases: - Escalation rule record id - Trigger rule record id - User record id of user that performed an action generating a system comment event |
DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values: 1 (event results in new assignment) 2 (event has no effect on assignment) 3 (event clears assignment) |
OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override |
OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field |
SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
Table: DEFECTS
Note | Contains defect information. Each table row represents one defect. Additional information associated with a defect is found in the DEFECTEVTS table. This table has a one-to-one relationship with the STATES, FLDTYPE, FLDPROD, FLDDISPO, FLDPRIOR, FLDCOMP and FLDSEVER tables. This table has a many-to-many relationship with the USERS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
DATECREATE | No | DATETIME | No | Date/time (in GMT) defect was added to the database |
IDCREATEBY | No | NUMERIC(10) | No | User who added the defect, Links to a record ID in USERS table |
DATEMODIFY | No | DATETIME | No | Date/time (in GMT) defect was last modified |
IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the defect, Links to a record ID in USERS table |
DEFECTNUM | No | NUMERIC(10) | No | Defect number, value is zero if number not yet assigned |
SUMMARY | No | VARCHAR(1020) | No | Summary field |
STATUS | No | NUMERIC(10) | No | Defect state, links to a record ID in STATES table |
INITSTATUS | No | NUMERIC(10) | No | Initial defect state |
IDTYPE | No | NUMERIC(10) | No | Type field, links to a record ID in FLDTYPE table |
IDPRODUCT | No | NUMERIC(10) | No | Product field, links to a record ID in FLDPROD table |
REFERENCE | No | VARCHAR(1020) | No | Reference field |
IDENTERBY | No | NUMERIC(10) | No | Entered by field, links to a record ID in USERS table |
IDDISPOSIT | No | NUMERIC(10) | No | Disposition field, links to a record ID in FLDDISPO table |
IDPRIORITY | No | NUMERIC(10) | No | Priority field, links to a record ID in FLDPRIOR table |
IDCOMPON | No | NUMERIC(10) | No | Component field, links to a record ID in FLDCOMP table |
IDSEVERITY | No | NUMERIC(10) | No | Severity field, links to a record ID in FLDSEVER table |
DATEENTER | No | DATETIME | No | Date entered field (in GMT) |
ADDLOCAT | No | NUMERIC(5) | No | Method used to add defect; includes the following values: 0 (unknown) 1 (Add defect window) 2 (SoloSubmit) 3 (SoloBug file) 4 (Email import) 5 (Text file import) 6 (TestTrack user duplicated a defect) If a defect was created during a conversion from a TestTrack 1.8.x or Workgroup database, value is set to "unknown" |
WORKAROUND | No | TEXT | No | Workaround field |
IDTICKET | No | NUMERIC(10) | No | Reserved for future functionality |
NOTIFY | No | VARCHAR(4000) | No | List of users/customers notified when defect changes, links to the USERS table |
CURASGTO | No | TEXT | No | Stores names of users defect is currently assigned to for external reporting tools. |
Table: DEFLOG
Note | Contains historical log information about changes made to defect records. Each row in this table represents a log entry in one of the defect records. Each row has a defect record ID that matches a record ID in the DEFECTS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table |
DATELOG | No | DATETIME | No | Date/time the change occurred |
NOTES | No | VARCHAR(4000) | No | Description of the change |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in DEFECTS table |
Table: DFLOGASC
Note | Associates defect historical log and audit log information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
AUDITID | No | NUMERIC(10) | Yes | Links to a record ID in AUDITLOG table |
HISTID | No | NUMERIC(10) | Yes | Links to a record ID in DEFLOG table |
Table: DISPNAME
Note | Contains text strings used in the interface. This table contains the Rename Field Label values. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
DISPLAY | No | VARCHAR(1020) | No | Text string used in the user interface display |
Table: DOCCHNGS
Note | Contains the original values for fields that were changed after a document snapshot was created. The document itself always stores the current value. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCSNPST table |
IDFIELD | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table indentifying the field. |
HASVALUE | No | NUMERIC(1) | No | Flag indicating if OrigValue field represents original value. If false the original value was NULL. |
ORIGVALUE | No | TEXT | No | Contains the original value for the field stored as the string value. |
Table: DOCEVTS
Note | Contains event information for each event recorded with a document. Each table row represents a single document event. This table has a many-to-one relationship with the DOCUMENT table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table |
ORDERNUM | No | NUMERIC(5) | No | Identifies order the document event was created relative to other document events; an internal counter for a specific document. |
PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in DOCUMENT table |
EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in DOCEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multiuser assignment, field contains the value -1 |
IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by TestTrack, it has a record ID of -2 |
DATEEVENT | No | DATETIME | No | Document event date |
NOTES | No | TEXT | No | Notes field |
TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1 |
RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting document state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values: 0 (created by user) 1 (created by multi-user assignment) 2 (created by auto assignment) 3 (created by auto escalation) |
CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases: - Escalation rule record id - Trigger rule record id - User record id of user that performed an action generating a system comment event |
DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values: 1 (event results in new assignment) 2 (event has no effect on assignment) 3 (event clears assignment) |
OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override |
OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field |
SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
VERSION | No | NUMERIC(10) | No | Contains the version number of the document that was current when the event was entered. |
Table: DOCEXPORTFAVORITES
Note | Relates users to favorited Word export templates. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TemplateID | Yes | NUMERIC(10) | Yes | Template record ID. |
UserID | Yes | NUMERIC(10) | Yes | User record ID. |
Table: DOCEXPORTGRP
Note | Relates security groups to Word export templates they can use. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TemplateID | Yes | NUMERIC(10) | Yes | Template record ID. |
UserGroupID | Yes | NUMERIC(10) | Yes | Security group record ID. |
Table: DOCEXPORTTEMPLATE
Note | Contains Word export templates. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
TemplateName | No | NVARCHAR(128) | Yes | Template name. |
TemplateDesc | No | NVARCHAR(1000) | No | Template description. |
TemplateType | No | NUMERIC(10) | Yes | Template type; includes the following values: 0: Microsoft Word |
IsDraft | No | NUMERIC(1) | No | Indicates if the template is marked as a draft. |
DocTemplateName | No | NVARCHAR(512) | No | Template file name. |
EntityMask | No | NUMERIC(10) | No | Item types at the top level of the template file; includes the following bit values: 0x01 = Issue 0x02 = Test case 0x04 = Test run 0x08 = Requirement 0x10 = Document 0x20 = Folder |
ContainsString | No | NVARCHAR(512) | No | Item types the template file supports. |
CreatedUserID | No | NUMERIC(10) | No | Record ID of user who created the template. |
CreatedDate | No | DATETIME | No | Date/time the template was created. |
LastModUserID | No | NUMERIC(10) | No | Record ID of the last user who uploaded a new version of the template file. |
LastModDate | No | DATETIME | No | Date/time a new version of the template file was last uploaded. |
OrigDocTemplate | No | VARBINARY(max) | No | Buffer that contains the original uploaded template file. |
DocumentStructure | No | VARBINARY(max) | No | Buffer JSON representation of the XML data structure parsed from OrigDocTemplate. |
Table: DOCLOG
Note | Contains historical log information about changes made to requirement document records. Each row in this table represents a log entry in one of the document records. Each row has a document record ID that matches a record ID in the DOCUMENT table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table |
DATELOG | No | DATETIME | No | Date/time the change occurred |
NOTES | No | VARCHAR(4000) | No | Description of the change |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCUMENT table |
Table: DOCSNPST
Note | Contains document snapshot information. Each table row represents one document snapshot. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
IDDOCUMENT | No | NUMERIC(10) | No | Links to a record ID in DOCUMENT table |
DATECREATE | No | DATETIME | No | Date/time (in GMT) snapshot was added to the database |
IDCREATEBY | No | NUMERIC(10) | No | User who added the snapshot. Links to a record ID in USERS table |
VERSION | No | NUMERIC(10) | No | Snapshot version number |
LABEL | No | VARCHAR(128) | No | Snapshot label |
COMMNT | No | TEXT | No | Snapshot comment |
Table: DOCTREE
Note | Contains the requirement relationship tree for the current version of the document. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDDOCUMENT | Yes | NUMERIC(10) | Yes | Links to a record ID in DOCUMENT table |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCTREE table; Field contains the record ID of the parent node in the tree. If the node is at the top level ParnetID contains 0. |
IDREQMNT | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
SIBORDER | No | NUMERIC(10) | No | Contains the order of this node in relation to its siblings in the parent node. |
ISSUSPECT | No | NUMERIC(1) | No | Flag indicating if the node is marked as suspect. |
Table: DOCUMENT
Note | Contains requirement document information. Each table row represents one requirement document. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
DATECREATE | No | DATETIME | No | Date/time (in GMT) document was added to the database |
IDCREATEBY | No | NUMERIC(10) | No | User who added the document. Links to a record ID in USERS table |
DATEMODIFY | No | DATETIME | No | Date/time (in GMT) document was last modified |
IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the document. Links to a record ID in USERS table |
DOCNUM | No | NUMERIC(10) | No | Document number, value is zero if number not yet assigned |
NAME | No | VARCHAR(1020) | No | Document name. |
IDSTATUS | No | NUMERIC(10) | No | Current document state, links to a record ID in STATES table |
ADDLOCAT | No | NUMERIC(5) | No | Method used to add requirement document, includes the following values: 0 (unknown) 1 (Add requirement document window) 4 (Email import) 5 (Text file import) 6 (TestTrack user duplicated a requirement document) 13 (Microsoft Word import) |
VERSION | No | NUMERIC(10) | No | Current document version number. |
DESCRPTN | No | TEXT | No | Document description |
PGWIDTH | No | NUMERIC(10, 3) | No | Current page width for multi-line text fields in specification window. |
LEFTMARGIN | No | NUMERIC(10, 3) | No | Current left margin indent in specification window. |
UNITTYPE | No | NUMERIC(2) | No | Units that the page width and left margin are specified in. 0 - Pixels 1 - Inches 2 - Centimeters |
NOTIFY | No | TEXT | No | List of users/customers notified when document changes, links to the USERS table |
CURASGTO | No | TEXT | No | Stores names of users document is currently assigned to for external reporting tools. |
INITSTATUS | No | NUMERIC(10) | No | Initial document state. |
Table: DRAFTFIELD
Note | Contains draft version/inactive custom fields. Each table row represents one draft custom field. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Table this field is linked to. |
SOURCEFIELD | No | NUMERIC(10) | Yes | Links to a record ID FLDDFNTN table. |
XML | No | TEXT | No | Draft field data. |
Table: EMAIL
Note | Contains tracked email information. Each table row represents one email. This table has a one-to-one relationship with the EMAILASSOC table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ISORPHAN | No | NUMERIC(1) | No | Flag indicates if email is associated with an entity |
SUBJECT | No | VARCHAR(1020) | No | Email subject |
BODY | No | TEXT | No | Email message body |
DATESENT | No | DATETIME | No | Date/time email was sent |
DATERECD | No | DATETIME | No | Date/time email was received |
THDMSGID | No | VARCHAR(1020) | No | Email message ID in thread |
DIRECTION | No | NUMERIC(5) | No | Indicates if email was sent or received; includes the following values: 0 (outgoing) 1 (incoming) |
ISHTML | No | NUMERIC(1) | No | Indicates if the email is in HTML format |
Table: EMAILASSOC
Note | Contains information about records tracked emails are associated with. Each table row represents an email association with one entity. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the email is associated with |
ENTITYRID | No | NUMERIC(10) | No | Link to a record ID in corresponding entity table |
EMAILID | No | NUMERIC(10) | No | Link to a record ID in EMAIL table |
PARENTID | No | NUMERIC(10) | No | Parent email ID |
Table: EMAILRECP
Note | Contains email recipient information. This table has a many-to-one relationship with the EMAIL table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
EMAILID | No | NUMERIC(10) | No | Link to a record ID in EMAIL table |
TYPE | No | NUMERIC(1) | No | Recipient type; includes the following values: 1 (From) 2 (To) 3 (Cc) 4 (Bcc) |
USERID | No | NUMERIC(10) | No | Link to a record ID in USERS table |
ADDRESS | No | VARCHAR(252) | No | Recipient email address |
Table: EMAILTMP
Note | Contains email template information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
EMAILDESC | No | VARCHAR(1020) | No | Description of when email template is used |
SUBJECT | No | VARCHAR(1020) | No | Email template subject field |
TEMPLATE | No | TEXT | No | Email template message body |
NAME | No | VARCHAR(128) | No | Email template name |
MULTIPLE | No | NUMERIC(1) | No | Flag indicates if multiple recipients can be specified; if set to N, multiple emails with a single recipient will be sent |
MAILGROUPS | No | VARCHAR(4000) | No | Specifies which security groups can be sent the message, links to the USERGRP table |
HTML | No | NUMERIC(1) | No | Flag indicates if the email is sent in HTML format |
ALLOWALL | No | NUMERIC(1) | No | Flag indicates that all groups can receive this email |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the template is associated to |
Table: EVENTS
Note | Contains event definition information. Each table row represents one event definition. This table has a many-to-one relationship with the FLDDFNTN table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type to which event is linked to |
NAME | No | VARCHAR(128) | No | Event name |
EVENTDESC | No | VARCHAR(1020) | No | Event description |
ACTIVE | No | NUMERIC(1) | No | Flat indicates if the event is active in the workflow |
EVENTORDER | No | NUMERIC(10) | No | Identifies order events are displayed on workflow configuration screens |
INFORM | No | NUMERIC(1) | No | Flag indicates if event is informational only or affects current state of the entity |
ALLOWATTCH | No | NUMERIC(1) | No | Flag indicates if files can be attached to the event |
TIMETRK | No | NUMERIC(1) | No | Flag indicates if time tracking is enabled for the event |
TIMETRKOPT | No | NUMERIC(2) | No | Value indicates how time tracking operates; includes the following values: 1 (display sum of event hours) 2 (display last event hours) |
ASSIGNEFF | No | NUMERIC(2) | No | Stores assignment value of event; includes the following values: 1 (event results in new assignment) 2 (event has no effect on assignment) 3 (event clears assignment) |
RSLTSTATES | No | VARCHAR(4000) | No | Specifies valid states for event, links to STATES table |
QKLINKICON | No | VARCHAR(1020) | No | Specifies file name used as a graphic on the TestTrack Web list window for creating this type of event |
EVENTICON | No | IMAGE | No | Binary data for the toolbar icon displayed on the TestTrack Windows client |
INCEVTICON | No | NUMERIC(1) | No | Flag indicates if icon be displayed on the Windows toolbar |
EVTICONNM | No | VARCHAR(1020) | No | Name of file used for event icon |
EVTINCREL | No | NUMERIC(1) | No | Flag indicates if event notes should be included with release notes |
ALLOWMUAS | No | NUMERIC(1) | No | Flag indicates if multiple user assignment is allowed |
REQESIGS | No | NUMERIC(1) | No | Flag indicates electronic signature is required to complete this event |
HIDEDLG | No | NUMERIC(1) | No | Flag indicates to hide dialog if there are no fields to be shown. Currently it is implemented only for test runs. |
EVVSRWMOD | No | NUMERIC(1) | No | Flag indicates if event notes should be included with the requirement document review mode; applies to requirements only. |
DNLNKSUSP | No | NUMERIC(1) | No | Flag indicates if the event should include the "Mark dependent items as suspect" option. |
Table: EXTERNPROVIDER
Note | Contains information that enables integration with external source control providers, such as Git |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
PROVIDERTYPE | No | NUMERIC(10) | No | Defines the provider type: 1 - SCM Provider |
PROVSUBTYPE | No | NUMERIC(10) | Yes | Defines the provider type sub type: 0 - Other 1 - Surround SCM 2 - Git 3 - GitHub |
APIKEY | No | VARCHAR(256) | No | Contains the provider key which uniquely identifies the provider when it connects to the project |
NAME | No | VARCHAR(1024) | Yes | Contains the provider name. This field is required and must be unique. |
ACTIVE | No | NUMERIC(1) | Yes | Indicates if the provider is active. |
SERVERADDR | No | VARCHAR(2048) | No | Surround SCM Server Path |
SERVERPORT | No | NUMERIC(10) | No | Surround SCM Server port |
COMMITURL | No | VARCHAR(4000) | No | Commit viewer URL path string. |
FILEURL | No | VARCHAR(4000) | No | File viewer URL path string. |
REPOURL | No | VARCHAR(4000) | No | GitHub repository URL path string. |
PROVIDERCGIURL | No | VARCHAR(4000) | No | The URL of the external provider CGI. |
Table: EXTERN_ITEM_ASSOC_ITEM
Note | Contains external item associations, such as for JIRA issues. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ProviderID | No | NUMERIC(10) | Yes | Record ID that identifies the external association provider row for the external item. |
ItemID | No | NUMERIC(10) | Yes | Record ID that identifies the TestTrack item associated with the external item. |
ItemType | No | NUMERIC(10) | Yes | TestTrack item type associated with the external item. |
CreatedDate | No | DATETIME | No | Date/time the association was created. |
ProviderData | No | VARBINARY(max) | No | External data from the provider that identifies the specific external item. |
Table: EXTERN_ITEM_ASSOC_PROVIDER
Note | Contains external item association providers, such as JIRA. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
Location | No | NVARCHAR(512) | Yes | URL or other location for the provider. |
Enabled | No | NUMERIC(10) | Yes | Indicates if the provider is enabled in TestTrack. |
ProviderData | No | VARBINARY(max) | No | JSON identification data given from the provider to TestTrack. |
ConfigData | No | VARBINARY(max) | No | JSON data representing the provider configuration in the TestTrack project. |
Table: FIELDCALC
Note | Contains calculated custom field details. Each table row represents one calculated custom field. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
IDFIELD1 | No | NUMERIC(10) | No | For time span calculated fields, this will store the Field ID of the first time field. |
IDFIELD2 | No | NUMERIC(10) | No | For time span calculated fields, this will store the Field ID of the second time field |
UNIT | No | NUMERIC(2) | No | For time span calculated fields, this will store the unit to use for the difference |
ROUNDING | No | NUMERIC(2) | No | For time span calculated fields, this will store the rounding behavior |
FIELDCALCTYPE | No | NUMERIC(2) | No | Field calculation type. (kCalcType_NotSet = 0, kCalculationWithFormula, kCalculatedPopup, kCalculatedTimespan, kMappedField) |
INCLWEEKENDS | No | NUMERIC(1) | No | Flag to indicate if weekend is included in calculation. |
LASTERRORDATE | No | DATETIME | No | This will store the last time that this field had an error (on any item). |
LASTLOGDATE | No | DATETIME | No | This will store the last time that an error message was logged for this field. |
FORMULA | No | TEXT | No | This will store the formula for the calculated field. |
Table: FIELDREL
Note | Contains the definition of field relationships setup for this database. Each table row represents one field relationship. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ENTITYTYPE | No | NUMERIC(10) | No | Parent entity type the relationship is linked to. |
CHILDTYPE | No | NUMERIC(10) | No | Child entity type the relationship is linked to. |
IDPARENT | No | NUMERIC(10) | Yes | Identifies parent field in the field relationship. |
IDCHILD | No | NUMERIC(10) | Yes | Identifies child field in the field relationship. |
RULES | No | TEXT | No | List of record IDs for parent and child fields that describe the relationship of the field items. |
Table: FIELDSTYLES
Note | Contains field value style settings. May be associated with multiple fields. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
NAME | No | VARCHAR(1020) | Yes | Style name in style list. |
ORDERNUM | No | NUMERIC(10) | Yes | Order of style in style list. |
BOLD | No | NUMERIC(1) | Yes | Indicates if the style is bold. |
ITALIC | No | NUMERIC(1) | Yes | Indicates if the style is italics. |
UNDERLINE | No | NUMERIC(1) | Yes | Indicates if the style is underlined. |
STRIKEOUT | No | NUMERIC(1) | Yes | Indicates if the style is strikeout. |
COLOR | No | VARCHAR(24) | Yes | Style text color in 6 hex digits. |
BACKGROUNDCOLOR | No | VARCHAR(24) | Yes | Style background color in 6 hex digits. |
HIDETEXT | No | NUMERIC(1) | Yes | Indicates if text is hidden when the style is applied. |
ICON | No | IMAGE | No | Binary data containing the icon image file. |
Table: FIELDSTYLESASSOC
Note | Associates a field and popup value with a style. The field style mapping associates a field style with a workflow state or a pop-up menu item. If the parent type is 1, the parent ID column is interpreted as a workflow state and the child columns are interpreted as states that use the style. If parent type is 2, the parent ID represents the record ID of the pop-up menu. The child IDs represent the pop-up menu items that use the style. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PARENTTYPE | No | NUMERIC(10) | Yes | How to interpret the data in the ParentID and ChildID columns. Valid values are Workflow or PopupItem. |
PARENTID | No | NUMERIC(10) | Yes | If ParentType is Workflow, this is the entity type of the workflow (e.g. tableID_Defects, tableID_TestCases, etc.). If ParentType is PopupItem, this is the record ID of the pop-up list this entry is for. |
CHILDID | No | NUMERIC(10) | Yes | If ParentType is Workflow, this is the workflow state record ID. If ParentType is PopupItem, this is the pop-up item record ID. |
FIELDSTYLEID | No | NUMERIC(10) | Yes | Record ID for field style to apply to the associated item. |
Table: FILTDISP
Note | Contains restriction items in a filter. Each table row represents one displayed line in a filter. This table has a many-to-one relationship with the FILTER table. Each row has a filter record ID that matches a record ID in the FILTER table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
FILTERID | No | NUMERIC(10) | No | Filter record ID. |
FILTORDER | No | NUMERIC(3) | No | Restriction item order, relative to other items. |
BNOT | No | NUMERIC(1) | No | Indicates if Not flag is set. |
OPENPAREN | No | NUMERIC(2) | No | Number of open parentheses that appear before restriction item. |
CLOSEPAREN | No | NUMERIC(2) | No | Number of close parentheses that appear after restriction item. |
FILTERTYPE | No | NUMERIC(2) | No | Operator applied to the next restriction item; includes the following values: 0 (none) 2 (AND operator) 3 (OR operator) |
RESTRICTN | No | TEXT | No | Filter restriction information; field can use information from a filter restriction definition and code them into a string value stored in this field |
PROMPT | No | NUMERIC(1) | No | Indicates if filter is interactive and should prompt user for values when used. |
Table: FILTER
Note | Contains filter information. Each table row represents one filter for the given entity type. Additional information associated with a filter is found in the FILTDISP table, which has a many-to-one relationship to this table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FILTERTYPE | No | NUMERIC(10) | Yes | Filter entity type |
NAME | No | VARCHAR(252) | Yes | Name field |
FILTERDESC | No | VARCHAR(1020) | No | Description field |
IDOWNER | No | NUMERIC(10) | No | Filter owner, links to a record ID in USERS table. |
ACCESSSTAT | No | NUMERIC(1) | Yes | Filter access state; includes the following values: 1 (Shared) 3 (Private) |
Table: FLDCOMP
Note | Contains the components pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Pop-up item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for this pop-up menu item. |
Table: FLDCUSTM
Note | Contains the custom field pop-up menu values. Each row in this table represents one pop-up menu item. This table has a many-to-one relationship with the FLDPULIST table. Each row in this table has a Pop-up list record ID that matches a record ID in the FLDPULIST table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDPULIST | No | NUMERIC(10) | Yes | Links to a record ID in FLDPULIST table. |
FIELDORDER | No | NUMERIC(10) | No | Item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDDFNTN
Note | Contains definitions for fields of all entity type and event fields. Each table row represents a single field. Custom pop-up fields, for both entity and entity events, have many-to-one relationship with the FLDPULIST table that links to pop-up menu items in FLDCUSTM table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ENTITYTYPE | No | NUMERIC(10) | No | Table this field is linked to. |
FIELDID | No | NUMERIC(10) | No | Field ID that uniquely identifies a field in an entity type. |
POSITION | No | NUMERIC(5) | No | For custom fields, order field displays on the custom field tab; for inherent fields, value is -1. |
FIELDCODE | No | VARCHAR(1020) | No | Character string used as a replacement field code for email templates. |
FIELDTYPE | No | NUMERIC(5) | No | Stores value that describes field type; includes the following values: 1 (pop-up menu) 2 (string) 3 (Boolean) 4 (date) 5 (version field) 6 (Component) 7 (Disposition) |
FIELDOPTS | No | NUMERIC(10) | No | Stores value that describes data allowed for this field; includes the following values: 0 (no option specified) 1 (integer values) 2 (floating point values) 3 (include time - only for date fields) 5 (memo field) 6 (Hyperlink) |
FLDFLGOPTS | No | NUMERIC(10) | No | Stores field flag options; includes the following values: 0 (no option specified) 1 (Include Global users or customers) 2 (Include Local users or customers) 4 (Multi-select field) |
ATTFLAG | No | NUMERIC(10) | No | Bit flag indicates which text import/export options are available; the following options can be combined with an OR operator: 0x0001 (field can be imported via text import) 0x0002 (field can be exported via text export) 0x0004 (field defaults to checked on text export dialog) 0x0008 (field defaults to checked on text import dialog) |
SHORTNAME | No | VARCHAR(1020) | No | Field name as displayed with entity or event dialog. |
LONGNAME | No | VARCHAR(1020) | No | Field name as displayed in list windows, filters, and reports. |
WEBCODE | No | VARCHAR(1020) | No | Character string used to parse data read-in from TestTrack Web; data cannot be modified. |
MAXSIZE | No | NUMERIC(10) | No | Maximum field length, only applies to custom fields for entity and entity events; all other fields have value of -1. |
NUMROWS | No | NUMERIC(10) | No | Number of rows for multi-line text fields; minimum value is 2, maximum is 10. |
ACTIVE | No | NUMERIC(1) | No | Flag indicates if the field is being used. |
EDTREQDFLT | No | NUMERIC(1) | No | Flag indicates if required fields and default values can be modified. |
DEFAULTVAL | No | NUMERIC(10) | No | Default value for this field; stored values are based on field type; for string fields, the only value allowed is -4 (blank record ID); for pop-up menus, the allowed values are: 0 (not set record ID) and any valid record ID in corresponding table; for user fields, allowed values are: -2 (current user), 0 (not set record ID); for date fields, allowed values are: 0 (not set record ID), 1 (current date). |
ALLOWDEFLT | No | NUMERIC(1) | No | Flag indicates if the default can be set. |
ENTITYRID | No | NUMERIC(10) | No | Links to record ID of event definition (EVENTS) if definition is for an event field; for entity fields, value is 0. |
REQUIRED | No | NUMERIC(1) | No | Flag indicates if the field is required. |
IDPULIST | No | NUMERIC(10) | No | This is applicable only for pop-up menu items; indicates TableID for inherent fields, Record ID in FLDPULIST for custom pop-up menu items; All other fields have value of 0. |
DEFAULTSTR | No | TEXT | No | Reserved for future use. |
Table: FLDDISPO
Note | Contains the disposition pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Pop-up item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDPRIOR
Note | Contains the priority pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDPROD
Note | Contains the product pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDPULIST
Note | Contains pop-up list names. FLDDFNTN table maps to FLDPULIST record ID for each pop-up menu item. List of actual values for each PU List is stored in FLDCUSTM table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
LISTNAME | No | VARCHAR(128) | No | Pop-up list name. |
Table: FLDRDTL
Note | Contains the additional folder details for the folder table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
FLDRTYPID | No | NUMERIC(10) | No | Foreign key to folder type table. |
FLDRDTLS | No | TEXT | No | Folder WYSIWYG text entered for the folder. |
ALLWEDTDTL | No | NUMERIC(1) | No | Flag indicating if users can edit the folder details field from the list window. |
WEBURL | No | TEXT | No | Folder web URL. |
STARTDATE | No | DATETIME | No | Folder release planning start date. |
ENDDATE | No | DATETIME | No | Folder release planning end date. |
INCLWKENDS | No | NUMERIC(1) | No | Folder release planning include weekends flag. |
NONWKDYS | No | NUMERIC(10) | No | Folder release planning non working days. |
WORKHRS | No | NUMERIC(20, 2) | No | Folder release planning work hours. |
AVAILUSRS | No | NUMERIC(20, 2) | No | Folder release planning available users. |
PTOHRS | No | NUMERIC(20, 2) | No | Folder release planning vacation and holiday hours. |
STORYPTS | No | NUMERIC(10) | No | Folder release planning target stroy points. |
Table: FLDREPRO
Note | Contains the reproduced pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDRITEM
Note | Contains folder item information. Each table row represents one folder item. This table has a many-toone relationship with the FOLDER table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
FOLDERID | No | NUMERIC(10) | No | Link to a record ID in the FOLDER table. |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the item is related to. |
ENTITYID | No | NUMERIC(10) | No | Link to a record ID in the DEFECT, TESTCASE, or TESTRUN table. |
ITEMRANK | No | NUMERIC(10) | No | |
Table: FLDRLOG
Note | Contains historical log information about changes to folders. Each row in this table represents a log entry for a folder. Each row has a folder record ID that matches a record ID in the FOLDER table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table. |
DATELOG | No | DATETIME | No | Date/time the change occurred. |
NOTES | No | VARCHAR(4000) | No | Description of the change. |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in the FOLDER table. |
Table: FLDRPRIO
Note | Contains requirement importance pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDRTYP
Note | Contains folder type information. Each table row represents one type value. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
NAME | No | VARCHAR(128) | No | Folder type name. |
DESCRPTN | No | VARCHAR(1020) | No | Folder type description. |
OPENICON | No | IMAGE | No | Open folder icon image. |
OPNICONNM | No | VARCHAR(1020) | No | Filename of the image file that was selected for the open folder icon image. |
CLOSEDICON | No | IMAGE | No | Closed folder icon image. |
CLSICONNM | No | VARCHAR(1020) | No | Filename of the image file that was selected for the closed folder icon image. |
ISACTIVE | No | NUMERIC(1) | No | Flag indicating if folder type is active. |
ALLOWURL | No | NUMERIC(1) | No | Flag indicating if folder type should support URLs. |
ALLWWYGTXT | No | NUMERIC(1) | No | Flag indicating if folder type should support WYSIWYG text. |
ALLWTMTRK | No | NUMERIC(1) | No | Flag indicating if folder type should support release planning |
ORDERNUM | No | NUMERIC(5) | No | Order number of the folder type within the list. |
BANNERCLR | No | VARCHAR(24) | No | Banner color for the folder type |
DEFAULTTASKBOARD | No | NUMERIC(10) | No | The default Task Board to use for this folder type. |
ENABLETASKBOARD | No | NUMERIC(1) | No | Boolean indicating if task boards are enabled for the folder type. |
Table: FLDSEVER
Note | Contains the severity pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDTOTP
Note | Contains test object type pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDTRSET
Note | Contains test run set pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDTYPE
Note | Contains the type pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDVERSN
Note | Contains the version pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item |
Table: FOLDER
Note | Contains folder information. Each table row represents one folder. Folder item information is in the FLDRITEM table. This table has a one-to-many relationship with the FLDRITEM table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
OWNERID | No | NUMERIC(10) | No | Links to a record ID in USERS table. |
PARENTID | No | NUMERIC(10) | No | Record ID of the parent folder. |
FLDRORDER | No | NUMERIC(5) | No | Folder order, relative to other folders. |
NAME | No | VARCHAR(128) | No | Folder name. |
DESCRPTN | No | VARCHAR(1020) | No | Folder description. |
DATECREATE | No | DATETIME | No | Date/time folder was created. |
IDCREATEBY | No | NUMERIC(10) | No | User who created the folder, links to a record ID in USERS table |
DATEMODIFY | No | DATETIME | No | Date/time folder was last modified. |
IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the folder, links to a record ID in USERS table |
ADDEDFROM | No | NUMERIC(5) | No | How folder was added; includes the following values: 0 (location unknown) 1 (add window) 2 (SoloSubmit page) 3 (SoloBug import) 4 (email import) 5 (text import) 6 (duplicated) 7 (XML import) 8 (SOAP API) 9 (help desk - obsolete) 10 (QA Wizard Pro) 11 (generated test run) 12 (TestTrack Outlook add-in) |
MULTIDESC | No | TEXT | No | Reserved for future use. |
URL | No | TEXT | No | Reserved for future use. |
TASKBOARDID | No | NUMERIC(10) | No | Record ID of the task board used when viewing the folder. |
Table: FRLOGASC
Note | Associates folder historical log and audit log information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
AUDITID | No | NUMERIC(10) | Yes | Links to a record ID in AUDITLOG table |
HISTID | No | NUMERIC(10) | Yes | Links to a record ID in DOCLOG table |
Table: HYPRLNK
Note | Contains email notification hyperlink information. Each row contains the information for one hyperlink sent to a user. The table contains the information needed to match a hyperlink to the user who was sent the hyperlink and the record it links to. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
DTCREATED | No | DATETIME | Yes | Date/time hyperlink created. |
USERID | No | NUMERIC(10) | No | Link to USERS table for person who is to view defect (i.e., person email notification was sent to) |
NMTIMESUSD | No | NUMERIC(10) | No | Number of times user has accessed hyperlink. |
DTLASTLOGN | No | DATETIME | No | Date/time user last accessed hyperlink. |
OTHER | No | VARCHAR(40) | Yes | Security information, verifies authenticity of hyperlink request |
DEFECTID | No | NUMERIC(10) | No | Link to DEFECTS table for the defect to be viewed. |
Table: INPUTMAP
Note | Contains input mapping rule for a formula based calculated custom field. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDFIELDCALC | No | NUMERIC(10) | Yes | Links to a record ID in FIELDCALC table. |
IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
IDPUVALUE | No | NUMERIC(10) | Yes | Popup list ID value. |
VALUE | No | VARCHAR(1020) | No | Input map value. |
Table: LINKDFNTN
Note | Contains a list of user-defined link definitions. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
LINKORDER | No | NUMERIC(10) | No | Order of row in list of link definitions. |
LINKNAME | No | VARCHAR(128) | No | Unique name for link definition. |
LINKCOMMNT | No | VARCHAR(1020) | No | Comment associated with link definition. |
LINKPARENT | No | NUMERIC(1) | No | Flag indicates if link definition requires a parent. |
LINKACTIVE | No | NUMERIC(1) | No | Flag indicates if link definition is active. |
LINKENTS | No | VARCHAR(255) | No | Indicates allowed entities for this link. |
COMNTREQD | No | NUMERIC(1) | No | Flag indicating if link comment is required when creating a new link using this definition. |
ALLWDPRNTS | No | VARCHAR(255) | No | List of table ids allowed to be parent in link using this definition. |
ALLWDCHLD | No | VARCHAR(255) | No | List of table ids allowed to be children or peers in link using this definition. |
MAXITEMS | No | NUMERIC(10) | No | Number of items allowed to be linked together using this definition. |
ALLWSUSPCT | No | NUMERIC(1) | No | Flag indicating if children or peers in link using this definition should be marked as suspect when suspect event is added to parent. |
Table: LINKHISTRY
Note | Contains history of changes made to links. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
LINKID | No | NUMERIC(10) | Yes | Links to parent record in LINKS table. |
HISTORDER | No | NUMERIC(10) | No | Order that events appear in link's history. |
HISTDATE | No | DATETIME | No | Date link was changed. |
FIRSTNAME | No | VARCHAR(128) | No | First name of user who made change. |
LASTNAME | No | VARCHAR(128) | No | Last name of user who made change. |
HISTINFO | No | VARCHAR(1020) | No | Detailed description of change. |
Table: LINKITEM
Note | Contains the information for a single item within a link in the LINK table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
LINKID | No | NUMERIC(10) | Yes | Links to parent record in LINKS table. |
ITEMORDER | No | NUMERIC(10) | No | Item order in peer/child list; value of 0 indicates parent item in link. |
ENTITYTYPE | No | NUMERIC(10) | No | Table link item is associated with; |
ENTITYID | No | NUMERIC(10) | No | Record ID of defect item is linked to. |
ITEMSTATUS | No | NUMERIC(5) | No | Reserved for future use. |
SUSPSTAT | No | NUMERIC(10) | No | Indicates suspect status of linked items. 0 (Not suspect) 1 (Suspect status caused by workflow) 2 (Suspect status was set manually) |
SUSPBY | No | NUMERIC(10) | No | RecordID of user who made link suspect. |
SUSPDATE | No | DATETIME | No | Date & time when link was made suspect. |
SUSPNOTES | No | VARCHAR(1020) | No | Notes entered by user when link was made suspect. |
SRCTYPE | No | NUMERIC(10) | No | Table ID of the item in the link that made this link suspect. |
SRCID | No | NUMERIC(10) | No | Record ID of the item in the link that made this link suspect. |
DATEADDED | No | DATETIME | No | Indicates date/time item was added to the link. |
Table: LINKS
Note | Contains a list of link items that have been added to a link. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
LINKDEFID | No | NUMERIC(10) | Yes | Link to LINKDFNTN table, identifies link type. |
LINKSTATUS | No | NUMERIC(5) | No | Reserved for future use. |
LINKCOMMNT | No | VARCHAR(1020) | No | Comment entered by user when link was created. |
Table: LINKWRKFLW
Note | Contains the options that describe the workflow behaviors for items in the LINKDFNTN table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies parent project for row. |
LINKDEFID | Yes | NUMERIC(10) | Yes | Link to LINKDFNTN table, identifies link type. |
LINKRLTN | No | NUMERIC(5) | No | The enumerated relationship type of this behavior: 1 - Parent 2 - Child 3 - Peer |
LINKOPTION | No | NUMERIC(5) | No | The enumerated option for the workflow behavior: 1 - Prevent parent from closing if children are open 2 - Prevent child from re-opening if parent is closed 3 - Prevent child from closing if parent is open 4 - Prevent parent from re-opening if children are closed 5 - Close peers in order 6 - Re-open peers in reverse order |
Table: LISTWND
Note | Contains list window information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
USERID | No | NUMERIC(10) | No | Link to a record ID in USERS table. |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type of the list window. |
WIDTH | No | NUMERIC(5) | No | List window width in pixels. |
HEIGHT | No | NUMERIC(5) | No | List window height in pixels. |
XPOS | No | NUMERIC(10) | No | X position of the list window in the MDI client area. |
YPOS | No | NUMERIC(10) | No | Y position of the list window in the MDI client area. |
ISOPEN | No | NUMERIC(1) | No | Indicates if window was open when client was closed. |
ZORDER | No | NUMERIC(5) | No | Z order of the window. |
CLIENTW | No | NUMERIC(5) | No | Width of the MDI client area the window was displayed in (for applying width correction). |
CLIENTH | No | NUMERIC(5) | No | Height of the MDI client area the window was displayed in (for applying height correction). |
Table: LISTWNDTAB
Note | Contains list window tab information. Each table row represents one tab. This table has a many-to-one relationship with the LISTWND table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
LISTWNDID | No | NUMERIC(10) | No | Link to a record ID in LISTWND table. |
NAME | No | VARCHAR(512) | No | Tab name. |
PRISORT | No | NUMERIC(10) | No | Primary sort field ID. |
SECSORT | No | NUMERIC(10) | No | Secondary sort field ID. |
PRISRTORDR | No | NUMERIC(1) | No | Primary sort column order. |
SECSRTORDR | No | NUMERIC(1) | No | Secondary sort column order. |
FILTERID | No | NUMERIC(10) | No | Filter the list window uses. |
QUICKLINKS | No | NUMERIC(10) | No | Indicates if TestTrack Web quick link icons are displayed. |
EVENTS | No | VARCHAR(4000) | No | List of selected TestTrack Web event quick link icons. |
TABORDER | No | NUMERIC(5) | No | Tab order, relative to other tabs. |
ACTIVE | No | NUMERIC(1) | No | Indicates if the tab is selected. |
Table: OBJCTGEN
Note | Contains create-type-from-type mappings. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
SRCENTITYTYPE | No | NUMERIC(10) | No | The source entity type of the object generation action. |
SRCSUBTYPEID | No | NUMERIC(10) | No | The source subtype of the object generation action. |
DSTENTITYTYPE | No | NUMERIC(10) | No | The destination entity type of the object generation action. |
DSTSUBTYPEID | No | NUMERIC(10) | No | The destination subtype of the object generation action. |
ADDTOFOLDER | No | NUMERIC(1) | No | True if generated items should be added to the same folders as the source item. |
COPYFIELDDATA | No | NUMERIC(1) | No | True if additional field information should be copied, e.g. "Copy description fields from all issue reported by records to the requirement description" |
LINKDEFID | No | NUMERIC(10) | No | The ID of the link definition to use. |
PROMPTTOLINK | No | NUMERIC(1) | No | True if the user is prompted to add the link. |
PARENTINLINK | No | NUMERIC(10) | No | An enumeration indicating which item is made the parent in the link if the link is a parent/child link. Source(0), destination(1), special(2). |
ACTTYPE | No | NUMERIC(10) | No | An enumeration indicating what type of object generation this is, Create(0), Generate(1), or Insert Shared Steps(2). |
ADDTODOCUMENT | No | NUMERIC(1) | No | True if the newly created requirement should be added to a document. |
Table: OUTPUTMAP
Note | Contains ouput mapping for a calculated pop-up custom field. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDFIELDCALC | No | NUMERIC(10) | Yes | Links to a record ID in FIELDCALC table. |
MAPCOND | No | NUMERIC(10) | Yes | An enumerated value corresponding to "Greater Than", "Equal To", etc. (kCondition_Invalid, kCondition_Greater, kCondition_GreaterOrEqual, kCondition_Less, kCondition_LessOrEqual, kCondition_Equal, kCondition_NotEqual, kCondition_DefaultValue) |
MAPPING | No | NUMERIC(10) | Yes | The output value |
MAPORDER | No | NUMERIC(10) | Yes | Order of this mapping rule in the list of output mappings |
MAPVALUE | No | VARCHAR(80) | No | Numeric portion of the condition |
Table: OWNERLCK
Note | Contains TestTrack internal information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
DBVERSION | No | VARCHAR(40) | No | Database version number, specifies database table format. |
Table: PARENTCHILDASSOC
Note | Associates a parent record with a child record. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ASSOCTYPE | No | NUMERIC(10) | Yes | How data in the ParentID and ChildID columns is interpreted. Can only be 1 initially. 1 - Indicates PARENTID in SCCFILE.idRecord and a CHILDID in USERS.idRecord, which associates a source control file record with multiple AuthorIDs (TestTrack user IDs). 2 - Indicates PARENTID in TASKBOARD.idRecord and a CHILDID in SUBTYPES.idRecord. 3 - Indicates PARENTID in TASKBOARDCOLUMN.idRecord and a CHILDID in STATES.idRecord. |
PARENTID | No | NUMERIC(10) | Yes | RecordID of an SCCFILE if AssocType is 1. |
CHILDID | No | NUMERIC(10) | Yes | AuthorID (TestTrack user ID) for the SCCFILE parent if AssocType is 1. |
Table: RDBMSOPTNS
Note | Contains the options and settings used when connecting to this RDBMS database. Works like a Windows INI file and each entry has a name/value pair. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
OPTDESC | No | VARCHAR(128) | No | Option name. |
OPTVALUE | No | VARCHAR(1020) | No | Option value. |
Table: RDLOGASC
Note | Associates requirement document historical log and audit log information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
AUDITID | No | NUMERIC(10) | Yes | Links to a record ID in AUDITLOG table |
HISTID | No | NUMERIC(10) | Yes | Links to a record ID in DOCLOG table |
Table: REPORTBY
Note | Contains defect reported by information. Each table row represents one report of a defect. This table has a many-to-one relationship with the DEFECTS table because TestTrack allows multiple reports of a single defect. Each row in this table has a defect record ID that matches a record ID in the DEFECTS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDFOUNDBY | No | NUMERIC(10) | No | Found by field, links to a record ID in USERS table. |
DATEFOUND | No | DATETIME | No | Found by date field. |
ORDERNUM | No | NUMERIC(5) | No | Identifies reported by record order, relative to other reported by records; internal counter for a specific defect. |
VERSNFOUND | No | VARCHAR(128) | No | Version found in field. This field stores the text of the item if selected from the FLDVERSN table. |
DESCRPTN | No | TEXT | No | Description field. |
IDREPROD | No | NUMERIC(10) | No | Reproduced field, links to a record ID in FLDREPRO table. |
REPROSTEPS | No | TEXT | No | Steps to reproduce field. |
TSTCONTYPE | No | NUMERIC(5) | No | Computer configuration field type; includes the following values: 1 (User's Test Configuration) 2 (Standard Test Configuration) |
IDCONFIG | No | NUMERIC(10) | No | Standard computer configuration field, links to a record ID in SYSCONF table |
OTHERHWSW | No | TEXT | No | Other hardware and software field. |
CONTACT | No | VARCHAR(252) | No | User contact information, either phone number or email address. |
IDDEFREC | No | NUMERIC(10) | No | Links to a record ID in DEFECTS table. |
Table: REQCHNGS
Note | Contains the original values for fields that were changed after a requirement version was created. The requirement itself always stores the current value. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in REQVRSN table |
IDFIELD | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table indentifying the field. |
HASVALUE | No | NUMERIC(1) | No | Flag indicating if OrigValue field represents original value. If false the original value was NULL. |
ORIGVALUE | No | TEXT | No | Contains the original value for the field stored as the string value. |
Table: REQEVTS
Note | Contains event information for each event recorded with a requirement. Each table row represents a single requirement event. This table has a many-to-one relationship with the REQMNT table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table |
ORDERNUM | No | NUMERIC(5) | No | Identifies order the requirement event was created relative to other requirement events; an internal counter for a specific requirement. |
PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in REQMNT table |
EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in REQEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multiuser assignment, field contains the value -1 |
IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by TestTrack, it has a record ID of -2 |
DATEEVENT | No | DATETIME | No | Requirement event date |
NOTES | No | TEXT | No | Notes field |
TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1 |
RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting defect state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values: 0 (created by user) 1 (created by multi-user assignment) 2 (created by auto assignment) 3 (created by auto escalation) |
CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases: - Escalation rule record id - Trigger rule record id - User record id of user that performed an action generating a system comment event |
DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values: 1 (event results in new assignment) 2 (event has no effect on assignment) 3 (event clears assignment) |
OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override |
OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field |
SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
VERSION | No | NUMERIC(10) | No | Contains the version number of the requirement that was current when the event was entered. |
Table: REQLOG
Note | Contains historical log information about changes made to requirement records. Each row in this table represents a log entry in one of the requirement records. Each row has a requirement record ID that matches a record ID in the REQMNT table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table |
DATELOG | No | DATETIME | No | Date/time the change occurred |
NOTES | No | VARCHAR(4000) | No | Description of the change |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
Table: REQMNT
Note | Contains requirement information. Each table row represents either one requirement. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
DATECREATE | No | DATETIME | No | Date/time (in GMT) requirement was added to the database |
IDCREATEBY | No | NUMERIC(10) | No | User who added the requirement. Links to a record ID in USERS table |
DATEMODIFY | No | DATETIME | No | Date/time (in GMT) requirement was last modified |
IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the requirement. Links to a record ID in USERS table |
DATEENTER | No | DATETIME | No | Date entered field (in GMT) |
IDENTERBY | No | NUMERIC(10) | No | Entered by field, links to a record ID in USERS table |
REQNUM | No | NUMERIC(10) | No | Requirement number, value is zero if number not yet assigned |
TAG | No | VARCHAR(88) | No | Contains the requirement tag number. |
SUMMARY | No | VARCHAR(1020) | No | Summary field |
IDSTATUS | No | NUMERIC(10) | No | Current requirement state, links to a record ID in STATES table |
IDTYPE | No | NUMERIC(10) | No | Requirement type, links to a record ID in SUBTYPE table |
ADDLOCAT | No | NUMERIC(5) | No | Method used to add requirement, includes the following values: 0 (unknown) 1 (Add requirement window) 4 (Email import) 5 (Text file import) 13 (MS Word Import) |
VERSION | No | NUMERIC(10) | No | Current requirement version number. |
IDPRIORITY | No | NUMERIC(10) | No | Importance field, links to a record ID in FLDRPRIO table |
DESCRPTN | No | TEXT | No | Description field. |
NOTIFY | No | TEXT | No | List of users/customers notified when requirement changes, links to the USERS table |
CURASGTO | No | TEXT | No | Stores names of users requirement is currently assigned to for external reporting tools. |
INITSTATUS | No | NUMERIC(10) | No | Initial requirement state. |
Table: REQVRSN
Note | Contains requirement version information. Each table row represents one requirement version. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
IDREQMNT | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
DATECREATE | No | DATETIME | No | Date/time (in GMT) requirement version was added to the database |
IDCREATEBY | No | NUMERIC(10) | No | User who created the requirement version. Links to a record ID in USERS table |
VERSION | No | NUMERIC(10) | No | Contains the version number of the requirement version. |
Table: RPCHRT
Note | Contains report chart information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
CHRTRPTID | No | NUMERIC(10) | Yes | Report chart is associated with. Links to a record ID in RPDETL, RPDIST, RPLIST, or RPTREND table. |
CHRTPOS | No | NUMERIC(2) | No | Chart position in the report. |
CHRTTYP | No | NUMERIC(2) | No | Chart type; includes the following values: 0 (Unknown) 1 (Pie) 2 (3DPie) 3 (Bar) 4 (3DBar) 5 (Floating Bar) 6 (3D Floating Bar) 7 (Area) 8 (3DArea) 9 (Line) 10 (3DLine) |
TITLE | No | VARCHAR(4000) | No | Chart title. |
TITLESZ | No | NUMERIC(2) | No | Chart title size; Includes the following values: 0 (Unknown) 1 (Very Small) 2 (Small) 3 (Medium) 4 (Large) 5 (Very Large) |
DATAFLDID | No | NUMERIC(10) | No | Report data type; includes the following values: -1 (Invalid) 0 (Defects) 4 (Customers) 1 (Users) 2 (Security Groups) 3 (Test Configs) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) |
TITLECLR | No | NUMERIC(10) | No | Title font color (RGB format). |
WIDTH | No | NUMERIC(5) | No | Chart width in pixels. |
HEIGHT | No | NUMERIC(5) | No | Chart height in pixels. |
BKGCLR | No | NUMERIC(10) | No | Chart background color (RGB format). |
DATPRVLST | No | VARCHAR(4000) | No | List of field IDs to chart. |
PIELBLS | No | NUMERIC(1) | No | Indicates if labels used on a pie chart. |
PIELBLSZ | No | NUMERIC(2) | No | Size of pie chart labels. |
PIESHWPCTS | No | NUMERIC(1) | No | Indicates if percentage amount is shown on slice of a pie chart. |
PIELBLPOS | No | NUMERIC(5) | No | Pie chart label position in pixels. |
PIELBLCLR | No | NUMERIC(10) | No | Pie chart label color (RGB format). |
BARSHWGRD | No | NUMERIC(1) | No | Indicates if grid is shown on a bar chart. |
BARSHOWX | No | NUMERIC(1) | No | Indicates if x-axis is shown on a bar chart. |
BARSHOWY | No | NUMERIC(1) | No | Indicates if y-axis is shown on a bar chart. |
BARXTTLE | No | VARCHAR(128) | No | Bar chart x-axis title. |
BARXTTLESZ | No | NUMERIC(2) | No | Bar chart x-axis size. |
BARYTTLE | No | VARCHAR(128) | No | Bar chart y-axis title. |
BARYTTLESZ | No | NUMERIC(2) | No | Bar chart y-axis title. |
BARAXSLBLS | No | NUMERIC(1) | No | Indicates if value labels are shown along axis of a graph of a bar chart. |
BARXLBLSZ | No | NUMERIC(2) | No | Bar chart x-axis labels size |
BARXLBLCLR | No | NUMERIC(10) | No | Bar chart x-axis labels color (RGB format). |
BARYLBLSZ | No | NUMERIC(2) | No | Bar chart y-axis labels size. |
BARYLBLCLR | No | NUMERIC(10) | No | Bar chart y-axis labels color (RGB format). |
BARLBLSPC | No | NUMERIC(5) | No | Spacing between bar chart columns. |
BARDNSTY | No | NUMERIC(5) | No | Placing of marks on the y-axis of a bar chart; the higher the percentage, the more dense the marks displayed. |
BARXTTLCLR | No | NUMERIC(10) | No | Bar chart x-axis title color (RGB format). |
BARYTTLCLR | No | NUMERIC(10) | No | Bar chart y-axis title color (RGB format). |
BARGRDCLR | No | NUMERIC(10) | No | Bar chart grid color (RGB format). |
Table: RPCUSTOM
Note | Contains custom report information. Each table row represents one custom report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
NAME | No | VARCHAR(512) | No | Name field. |
TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
ACCESSSTAT | No | NUMERIC(2) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
STYLENAME | No | VARCHAR(1020) | No | Name of the .xslt file from the \StyleSheets\Custom directory. |
STYLEDIR | No | VARCHAR(1020) | No | Directory where the .xslt file referenced in StyleName is located. |
STYLREPTYP | No | NUMERIC(2) | No | Report type; includes the following values: 0 (Unknown), 1 (Detailed), 2 (Distribution), 3 (List), 4 (Trend), 5 (Custom). |
STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values: 0 (Unknown), 1 (Local) - not valid for this type, 2 (Server), 3 (Database) |
STYLDTPRV | No | NUMERIC(10) | No | Indicates report data type for the report; includes the following values: -1 (Invalid) 0 (Defects) 1 (Users) 2 (Security Groups) 3 (Test Configs) 4 (Customers) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) 13 (Test Cases) 14 (Test Runs) 15 (Folders) 16 (All Types) 18 (Documents) 19 (ReqDocuments) |
DATEPRFROM | No | DATETIME | No | Contains the from date if specified in the Options tab. |
DATEPRTO | No | DATETIME | No | Contains the thru date if specified in the Options tab. |
IDFOLDER | No | NUMERIC(10) | No | Folder idRecord for folder specified on the Source tab. |
RECURSIVE | No | NUMERIC(1) | No | Recursive folder checkbox as specified on the Source tab. |
ENTITYMASK | No | NUMERIC(10) | No | A bitmask of the entity types that the chart supports. |
DFCTFLTRID | No | NUMERIC(10) | No | Issue filter the report uses. |
TSTCFLTRID | No | NUMERIC(10) | No | Test case filter the report uses. |
TSTRFLTRID | No | NUMERIC(10) | No | Test run filter the report uses. |
RQMTFLTRID | No | NUMERIC(10) | No | Requirement filter the report uses. |
RDMTFLTRID | No | NUMERIC(10) | No | Requirement document filter the report uses. |
SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
SRTPRORDER | No | NUMERIC(2) | No | Primary sort order. |
SRTSCORDER | No | NUMERIC(2) | No | Secondary sort order. |
OPTIONS | No | TEXT | No | XML text containing additional parameters... - Include Links - Link Defiition list of links to include, list of folder types to include - Show Chart - Show Data (Stored as XML to allow for future expansion). |
Table: RPDETL
Note | Contains detail report information. Each table row represents one detail report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
NAME | No | VARCHAR(512) | No | Name field. |
TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
ACCESSSTAT | No | NUMERIC(1) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
STYLENAME | No | VARCHAR(1020) | No | XSLT document for file name. |
STYLEDIR | No | VARCHAR(1020) | No | Directory where STYLENAME file is located. |
STYLREPTYP | No | NUMERIC(2) | No | Indicates type of report; includes the following values: 0 (Unknown) 1 (Detail) 2 (Distribution) 3 (List) 4 (Trend) |
STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values: 0 (Unknown) 1 (Local) 2 (Server) 3 (Database) |
BRKAFTITEM | No | NUMERIC(1) | No | Insert page break between items flag. |
TYPETOSHOW | No | NUMERIC(2) | No | Indicates report object type; includes the following values: 1 (Defects) 2 (Users) 3 (Security Groups) 4 (Test Configurations) 5 (Customers) |
STYLDTPRV | No | NUMERIC(10) | No | Indicates report data type; includes the following values: -1 (Invalid) 0 (Defects) 4 (Customers) 1 (Users) 2 (Security Groups) 3 (Test Configs) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) |
PRINTALL | No | NUMERIC(1) | No | Include all entities in report or only selected entities (where an entity is defined by the selection in the TYPETOSHOW field). |
SHOWLIST | No | VARCHAR(4000) | No | List of entities to include in report (where an entity is defined by the selection in the TYPETOSHOW field); list has user record IDs that link to the USERS, USERGRP, or SYSCONF table. |
SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
SRTPRORDER | No | NUMERIC(2) | No | Order primary sort column is sorted. |
SRTSCORDER | No | NUMERIC(2) | No | Order secondary sort column is sorted. |
Table: RPDIST
Note | Contains distribution report information. Each table row represents one distribution report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
NAME | No | VARCHAR(512) | No | Name field. |
TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
ACCESSSTAT | No | NUMERIC(1) | No | Report access state; values are: 1 (Shared) and 3 (Private). |
STYLENAME | No | VARCHAR(1020) | No | XSLT document file name. |
STYLEDIR | No | VARCHAR(1020) | No | Directory where STYLENAME file is located. |
STYLREPTYP | No | NUMERIC(2) | No | Indicates type of report; Includes the following values: 0 (Unknown) 1 (Detailed) 2 (Distribution) 3 (List) 4 (Trend) |
STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values: 0 (Unknown) 1 (Local) 2 (Server) 3 (Database) |
STYLDTPRV | No | NUMERIC(10) | No | Indicates report data type for the report; includes the following values: -1 (Invalid) 0 (Defects) 4 (Customers) 1 (Users) 2 (Security Groups) 3 (Test Configs) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) |
REPORTON | No | NUMERIC(2) | No | Report on field option; includes the following values: 1 (Action by user) 2 (Reported by field) 3 (Status by field) |
USERACTION | No | NUMERIC(10) | No | User action selected from pop-up menu, used if REPORTON field is set to “Action by user”'; includes the following values: 1 (Found) 2 (Assigned) 3 (Fixed) 4 (Verified) 5 (Closed) |
REPRTBYFLD | No | NUMERIC(10) | No | Reported by field selected from pop-up menu, used if REPORTON field is set to Reported by field; Includes the following values: 1 (Status) 2 (Type) 3 (Priority) 4 (Product) 5 (Resolution) 6 (Test Configuration) 7 (Component) 8 (Disposition) |
STATSBYFLD | No | NUMERIC(2) | No | Status by field selected from pop-up menu, used if REPORTON field is set to “Status by field”; includes the following values: 1 (Type) 2 (Priority) 3 (Product) 4 (Component) |
DATEPRFROM | No | DATETIME | No | From field in the report options. |
DATEPRTHRU | No | DATETIME | No | Through field in the report options. |
INCTOTALS | No | NUMERIC(1) | No | Include totals field. |
IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
XAXISFLDID | No | NUMERIC(10) | No | X-axis column field ID. |
YAXISFLDID | No | NUMERIC(10) | No | Y-axis column field ID. |
SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
SRTPRORDER | No | NUMERIC(2) | No | Primary column sort order. |
SRTSCORDER | No | NUMERIC(2) | No | Secondary column sort order. |
EXCLCOLS | No | VARCHAR(4000) | No | Reserved for future use. |
RECPERPG | No | NUMERIC(5) | No | Records per printed page. |
HIDEEMPTYR | No | NUMERIC(1) | No | Flag indicates if empty rows are displayed. |
HIDEEMPTYC | No | NUMERIC(1) | No | Flag indicates if empty columns are displayed. |
TYPETOSHOW | No | NUMERIC(2) | No | Indicates report object type; includes the following values:
1 (Defects) 2 (Users) 3 (Security Groups) 4 (Test Configurations) 5 (Customers) |
Table: RPEXTERN
Note | Contains external report information. Each table row represents one external report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
NAME | No | VARCHAR(512) | No | Name field. |
TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
ACCESSSTAT | No | NUMERIC(1) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
ORGNLNAME | No | VARCHAR(128) | No | Original name of external report. |
ADDLINFO | No | TEXT | No | Additional information about the report. |
EXRPTID | No | TEXT | No | External report identifier field. |
SRVCGUID | No | VARCHAR(38) | No | External reporting service identifier field. |
OUTPTYP | No | NUMERIC(10) | No | Output format of the report. |
Table: RPFRMT
Note | Describes the layout of a field type on a report. The field type default uses the values from the XSL file. Each field type has a parent type that is used unless the field has a defined format. In this case, the field's format is used. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID uniquely identifying a row in this table |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
FRMTFNT | No | NUMERIC(2) | No | Font family; includes the following values:
-1 (use XSL value) 1 (serif) 2 (sans serif) 3 (cursive) 4 (monospace) 5 (fantasy) |
CHRTRPTID | No | NUMERIC(10) | No | Specifies report format is associated with (customization can only be applied to list reports); links to a record ID in RPLIST table. |
FNTSZ | No | NUMERIC(5) | No | Font size in pixels. |
FNTWT | No | NUMERIC(2) | No | Font weight or thickness; includes the following values: -1 (use xsl value) 0 (100) 1 (200) 2 (300) 3 (400) 4 (500) 5 (600) 6 (700) 7 (800) 8 (900) |
FNTCLR | No | NUMERIC(10) | No | Font color (RGB format). |
FNTBKGCLR | No | NUMERIC(10) | No | Font background color (RGB format). |
HALIGN | No | NUMERIC(2) | No | Field horizontal alignment; includes the following values: -1 (use xsl value) 0 (left) 1 (center) 2 (right) 3 (justify) |
VALIGN | No | NUMERIC(2) | No | Field vertical alignment; includes the following values: -1 (use xsl value) 0 (top) 1 (middle) 2 (bottom) 3 (baseline) |
WIDTH | No | NUMERIC(5) | No | Field width. |
HEIGHT | No | NUMERIC(5) | No | Field height. |
BRDRSZ | No | NUMERIC(5) | No | Border size. |
TBLBKGCLR | No | NUMERIC(10) | No | Background field color (RGB format). |
FRMTPAD | No | NUMERIC(5) | No | Cell padding. |
FRMTSP | No | NUMERIC(5) | No | Cell spacing. |
FRMTTYPE | No | NUMERIC(5) | No | Field format; includes the following values: -1 (Invalid) 0 (Field) 1000 (Header) 2000 (Detail Table) 3000 (Detail Column Heading) 4000 (Detail Row Heading) 5000 (Detail Data Cells) 6000 (Detail Row Totals) 7000 (Detail Column Totals) 8000 (Footer) |
PRNTTYP | No | NUMERIC(5) | No | Parent field format; includes the following values: -1 (Invalid) 0 (Field) 1000 (Header) 2000 (Detail Table) 3000 (Detail Column Heading) 4000 (Detail Row Heading) 5000 (Detail Data Cells) 6000 (Detail Row Totals) 7000 (Detail Column Totals) 8000 (Footer) |
FRMTFLDID | No | NUMERIC(10) | No | Field ID. |
Table: RPIDS
Note | Contains a row for each report defined in the database, regardless of report type. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TYPE | No | NUMERIC(5) | No | Report type; includes the following values: 1 (Detail) 2 (Distribution) 3 (List) 4 (Trend) |
Table: RPLIST
Note | Contains list report information. Each table row represents one list report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
NAME | No | VARCHAR(512) | No | Report name. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
TITLE | No | VARCHAR(4000) | No | Report title. |
ACCESSSTAT | No | NUMERIC(1) | No | Report access; includes the following values: 1 (Shared) 3 (Private) |
STYLENAME | No | VARCHAR(1020) | No | XSLT document file name. |
STYLEDIR | No | VARCHAR(1020) | No | Directory where the STYLENAME file is located. |
STYLREPTYP | No | NUMERIC(2) | No | Report type; includes the following values: 0 (Unknown) 1 (Detailed) 2 (Distribution) 3 (List) 4 (Trend) |
STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values: 0 (Unknown) 1 (Local) 2 (Server) 3 (Database) |
STYLDTPRV | No | NUMERIC(10) | No | Report data type; includes the following values: -1 (Invalid) 0 (Defects) 4 (Customers) 1 (Users) 2 (Security Groups) 3 (Test Configs) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) |
TYPETOSHOW | No | NUMERIC(2) | No | Report object type; includes the following values: 1 (Defects) 2 (Users) 3 (Security Groups) 4 (Test Configurations) 5 (Customers) |
GRIDLINES | No | NUMERIC(1) | No | Print grid lines. |
SHOWLIST | No | VARCHAR(4000) | No | List of entities to include in the report (where an entity is defined by the selection in the TYPETOSHOW field); list has user record IDs that link to USERS, USERGRP, or SYSCONF table |
SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
SRTPRORDER | No | NUMERIC(2) | No | Order the primary sort column is sorted. |
SRTSCORDER | No | NUMERIC(2) | No | Order the secondary sort column is sorted. |
RECPERPG | No | NUMERIC(5) | No | Records per printed page. |
Table: RPTREND
Note | Contains trend report information. Each table row represents one trend report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
NAME | No | VARCHAR(512) | No | Report name. |
TITLE | No | VARCHAR(4000) | No | Report title. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
ACCESSSTAT | No | NUMERIC(1) | No | Report access state; includes the following values: 1 (Shared) 3 (Private) |
STYLENAME | No | VARCHAR(1020) | No | XSLT document file name |
STYLEDIR | No | VARCHAR(1020) | No | Directory where the STYLENAME file is located. |
STYLREPTYP | No | NUMERIC(2) | No | Report type; includes the following values: 0 (Unknown) 1 (Detailed) 2 (Distribution) 3 (List) 4 (Trend) |
STYLSCOPE | No | NUMERIC(2) | No | Indicates where the report stylesheet is applicable; includes the following values: 0 (Unknown) 1 (Local) 2 (Server) 3 (Database) |
STYLDTPRV | No | NUMERIC(10) | No | Report data type; includes the following values: -1 (Invalid) 0 (Defects) 4 (Customers) 1 (Users) 2 (Security Groups) 3 (Test Configs) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) 13 (Test Cases) 14 (Test Runs) |
DATEPRFROM | No | DATETIME | No | From field (date/time). |
DATEPRTHRU | No | DATETIME | No | Through field (date/time). |
PERDUNITS | No | NUMERIC(2) | No | Period units; includes the following values: 1 (Days) 2 (Weeks) 3 (Months) |
INCTOTALS | No | NUMERIC(1) | No | Include totals field. |
REPORTON | No | NUMERIC(2) | No | Report on field; includes the following values: 1 (Defect status) 2 (Defect action by field) |
DEFEVTREPT | No | NUMERIC(10) | No | Defect action selected in pop-up menu, only used if REPORTON field is set to Defect action by field; includes the following values: 1 (Found) 2 (Fixed) 3 (Verified Passed) 4 (Verified Failed) 5 (Closed) |
SECNDFIELD | No | NUMERIC(10) | No | Status by field selected in pop-up menu, field is used if the REPORTON field is set to Defect action by field; includes the following values: 1 (Type) 2 (Priority) 3 (Resolution) |
IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
INCALLSTS | No | NUMERIC(1) | No | Include all status events for each defect. |
INCTOTOP | No | NUMERIC(1) | No | Show number of events open in each period. |
EXCLCOLS | No | VARCHAR(4000) | No | Reserved for future use. |
RECPERPG | No | NUMERIC(5) | No | Records per printed page. |
HIDEEMPTYC | No | NUMERIC(1) | No | Flag indicates if empty columns are displayed. |
TYPETOSHOW | No | NUMERIC(2) | No | Indicates report object type; includes the following values: 0 (Defects) 4 (Customers) 1 (Users) 2 (Security Groups) 3 (Test Configs) 8 (Defect Filters) 9 (Reports) 10 (Workbook Tasks) 13 (Test Cases) 14 (Test Runs) |
Table: RQLOGASC
Note | Associates requirement historical log and audit log information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
AUDITID | No | NUMERIC(10) | Yes | Links to a record ID in AUDITLOG table |
HISTID | No | NUMERIC(10) | Yes | Links to a record ID in REQLOG table |
Table: SCCFILE
Note | Contains SCC file information. Each table row represents one SCC file that is attached to an entity. This table has a many-to-one relationship with the corresponding entity table. Each row has an entity record ID. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
ENTITYRID | No | NUMERIC(10) | Yes | Links to a record ID in corresponding entity table. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Entity type to which SCC File is linked to. |
FILENAME | No | VARCHAR(1020) | No | File name in SCC system. |
VERSION | No | TEXT | No | Version number of fix in the SCC system. |
DATEFIXED | No | DATETIME | No | Date fix was made. |
CHGLSTID | No | NUMERIC(10) | No | Change list record ID from the SCMCHGLST table. |
PROVIDERID | No | NUMERIC(10) | No | Provider ID from the SCMPROVIDER table if the file was submitted by a configured external source control provider. |
HYPERLINK | No | TEXT | No | Full file URL path to view the file if generated by XML import because the provider was not available. |
AUTHOR | No | TEXT | No | Author who changed file for commit. Text string or user ID if committed by TestTrack user. |
HYPERLINKDETAIL | No | TEXT | No | JSON submitted by the external provider if the provider hook used a set of name/value pairs for field code replacement. |
CHANGETYPE | No | NUMERIC(10) | No | Type of file change associated with the attachment: 0 (Unknown) 1 (File added) 2 (File edited) 3 (File removed) |
ISPENDING | No | NUMERIC(1) | Yes | Indicates if the changelist is in a pending state. |
Table: SCCPROJ
Note | Contains SCC project information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
PROJPATH | No | TEXT | No | Path that is internal to SCC application. |
Table: SCMCHGLST
Note | Contains source control changelist information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
ENTITYRID | No | NUMERIC(10) | Yes | Entity Record ID to which changelist is associated with. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Entity type to which changelist is associated with. |
CHGLSTID | No | NUMERIC(10) | Yes | Changelist ID stored in the source control application. |
COMMITTED | No | NUMERIC(1) | Yes | Flag indicates if changelist is committed. |
MLNENAME | No | TEXT | No | Mainline name. |
NAME | No | TEXT | No | Changelist name. |
PROVIDERID | No | NUMERIC(10) | No | Provider ID from the SCMPROVIDER table if the file was submitted by a configured source control provider. |
BRANCHNAME | No | TEXT | No | Branch the change was committed to. |
ATTACHDATE | No | DATETIME | No | Date and time the changelist was committed to TestTrack from the source control provider. |
HYPERLINK | No | TEXT | No | Full file URL path to view the file if generated by XML import because the provider was not available. |
AUTHOR | No | TEXT | No | Author who changed file for commit. Text string. |
AUTHORID | No | NUMERIC(10) | No | User ID if committed by TestTrack user. |
HYPERLINKDETAIL | No | TEXT | No | JSON submitted by the source control provider if the provider hook used a set of name/value pairs for field code replacement. |
ISPENDING | No | NUMERIC(1) | Yes | Indicates if the changelist is in a pending state. |
Table: SHRWUSRGRP
Note | Contains settings for sharing filters with security groups. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ENTITYID | No | NUMERIC(10) | No | Identifies the item being shared with a security group. Currently only filters and reports are shared. |
USRGROUPID | No | NUMERIC(10) | No | Identifies which security groups are shared with the item. |
ENTITYTYPE | No | NUMERIC(10) | No | Indicates which entity type is being shared by this record. Currently only filters and reports are shared with security groups. |
Table: SNPSTTRE
Note | Contains the requirement relationship tree for a snapshot of the document. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDSNAPSHOT | Yes | NUMERIC(10) | Yes | Links to a record ID in DOCSNPST table |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in SNPSTTRE table; Field contains the record ID of the parent node in the tree. If the node is at the top level ParnetID contains 0. |
IDREQMNT | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
REQVERSION | No | NUMERIC(10) | No | Contains the version number of the requirement that was current when the snapshot was created. |
SIBORDER | No | NUMERIC(10) | No | Contains the order of this node in relation to its siblings in the parent node. |
Table: SPELLCHK
Note | Contains the spell check options for a specified user. Each row contains the options for one specific user. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Link to USERS table; a value of 0x7FFFFFFF is used to store default system options. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
DMTLEX | No | IMAGE | No | Custom dictionary words (user's or system-wide). |
SPELLOPT | No | NUMERIC(10) | No | Bit field used to store different spell check options; values that can be used in this field are: 0x00000001 - Ignore capitalized words 0x00000002 - Ignore words that have mixed case. 0x00000004 - Ignore words in uppercase 0x00000008 - Ignore words with numbers 0x00000100 - Report doubled words 0x00000200 - Ignore case sensitive words 0x00004000 - Make phonetic suggestions 0x00080000 - Make typographic suggestions 0x00400000 - Ignore domain names
Other bit values are used internally by TestTrack; only the bit fields listed above can be modified via ODBC |
LANGCODE | No | NUMERIC(10) | No | Specifies language used when spell checking; there are over 50 allowed values, but typical values are: 24941 - American English 25202 - British English 25441 - Canadian English |
LEXSRCH | No | NUMERIC(10) | No | Search depth used for spell checking; following are used by: 0 - fast but less accurate 1 - moderately fast and accurate 2 - slow but accurate |
Table: STATES
Note | Contains information about states that an entity can transition into. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
ENTITYTYPE | No | NUMERIC(10) | No | The table state is linked to. |
NAME | No | VARCHAR(128) | No | State name. |
STATEDESC | No | VARCHAR(1020) | No | State description. |
ACTIVE | No | NUMERIC(1) | No | Flag indicates if the state is active in the workflow. |
STATEORDER | No | NUMERIC(10) | No | Identifies the order the state displays on the workflow configuration screens. |
ATTRIB | No | NUMERIC(2) | No | Indicates if state is open or closed; includes the following values: 1 (open) 2 (closed) |
ONLYASSIGN | No | NUMERIC(1) | No | Flag indicates if only assigned users can enter event |
MULTIRULE | No | NUMERIC(2) | No | For states which are multi-user assignments, rule determines when state is completed and the corresponding entity moves to new state; includes the following values: 1 (use the first response) 2 (wait for all responses - use highest priority response) 3 (wait for highest priority response) |
CNGENTSTRS | No | NUMERIC(1) | No | Flag indicates if this state can generate test runs; applies to test cases only. |
COMPLSTAT | No | NUMERIC(5) | No | Indicates test run result, passed/failed/other; applies to test runs only. |
LOCKED | No | NUMERIC(2) | No | Indicates if the item is locked in this state. |
CNGENTSTCS | No | NUMERIC(1) | No | Flag indicates if this state can generate test cases; applies to requirements only. |
Table: STEPDATA
Note | Contains test run step details. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
ACTRSLTS | No | TEXT | No | Actual Results. |
ISTCNOTE | No | NUMERIC(1) | No | Flag to indicate if this step is from test case. |
NORDER | No | NUMERIC(10) | No | Order of steps. |
STAMPTIME | No | DATETIME | No | Datetime of steps. |
STEPDATA | No | TEXT | No | Steps |
STEPRSLTS | No | NUMERIC(10) | No | Step results. |
STEPTYPE | No | NUMERIC(10) | No | Step type (eComment = 1, eInsertedTestCase = 2, eStep = 3, eEmptyLine = 4, eCheckBox = 5 etc) |
IDSTAMPUSR | No | NUMERIC(10) | No | UserID |
IDTESTRUN | No | NUMERIC(10) | No | TestRun ID |
ATTCHMNTS | No | TEXT | No | Step data attachments. |
Table: SUBCMDSC
Note | Contains user group subtype command security settings. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
SECGRPID | No | NUMERIC(10) | Yes | Links to idRecord in USERGRP table. |
SUBTYPEID | No | NUMERIC(10) | Yes | Links to idRecord in SUBTYPE table. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Table ID for item type. Currently only requirements are supported. |
COMMDENIED | No | VARCHAR(3500) | No | Command security options. |
Table: SUBFLDDF
Note | Contains default values and required field settings for fields by subtype. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
FLDDEFID | No | NUMERIC(10) | Yes | Links to the idRecord in the FLDDRNTN table. |
SUBTYPEID | No | NUMERIC(10) | Yes | Links to the idRecord in the SUBTYPE table. |
DEFAULTVAL | No | NUMERIC(10) | Yes | Default value for this field; stored values are based on field type; for string fields, the only value allowed is -4 (blank record ID); for pop-up menus, the allowed values are: 0 (not set record ID) and any valid record ID in corresponding table; for user fields, allowed values are: -2 (current user), 0 (not set record ID); for date fields, allowed values are: 0 (not set record ID), 1 (current date). |
REQUIRED | No | NUMERIC(1) | Yes | Flag indicates if the field is required. |
DEFAULTSTR | No | TEXT | No | Reserved for future use. |
Table: SUBFLDSC
Note | Contains user group subtype field level security settings. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
SECGRPID | No | NUMERIC(10) | Yes | Links to idRecord in USERGRP table. |
SUBTYPEID | No | NUMERIC(10) | Yes | Links to idRecord in SUBTYPE table. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Table ID for item type. Currently only requirements are supported. |
FIELDSEC | No | TEXT | No | Field level security options |
Table: SUBTYPE
Note | Contains requirement type information. Each table row represents one type value. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Table this type is linked to. Currently types are only supported for requirements. |
DISPORDER | No | NUMERIC(3) | Yes | Popup display item order, relative to other types in this table. |
NAME | No | VARCHAR(252) | Yes | Type name |
STDESC | No | VARCHAR(1020) | No | Type description |
STICON | No | IMAGE | No | Type icon |
STICONNM | No | VARCHAR(1020) | No | Type icon file name |
STPREFIX | No | VARCHAR(20) | No | Type tag prefix |
STSUFFIX | No | VARCHAR(20) | No | Type tag suffix |
SUMFRMTFNT | No | NUMERIC(2) | No | Reserved for future use |
SUMFNTSZ | No | NUMERIC(5) | No | Reserved for future use |
SUMFNTWT | No | NUMERIC(2) | No | Reserved for future use |
SUMFNTCLR | No | NUMERIC(10) | No | Reserved for future use |
DTLFRMTFNT | No | NUMERIC(2) | No | Reserved for future use |
DTLFNTSZ | No | NUMERIC(5) | No | Reserved for future use |
DTLFNTWT | No | NUMERIC(2) | No | Reserved for future use |
DTLFNTCLR | No | NUMERIC(10) | No | Reserved for future use |
ACTIVE | No | NUMERIC(1) | No | Flag indicating if type is active, can be selected for new items. |
Table: SYSCONF
Note | Contains test configuration information. Each table row represents one system test configuration. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
CONFTYPE | No | NUMERIC(1) | No | System configuration type; includes the following values: 1 (User's Test Configuration) 2 (Standard Test Configuration) |
SYSNAME | No | VARCHAR(128) | No | Name field. |
LOCATION | No | VARCHAR(1020) | No | Reserved for future use. |
COMPMODEL | No | VARCHAR(1020) | No | Computer model field. |
COMPBRAND | No | VARCHAR(1020) | No | Computer brand field. |
CPUTYPE | No | VARCHAR(128) | No | CPU type field. |
CPUSPEED | No | VARCHAR(128) | No | CPU speed field (value specified in MHz). |
HDISKTYPT | No | VARCHAR(1020) | No | Hard disk type field. |
HDISKSIZE | No | VARCHAR(1020) | No | Hard disk size field (value specified in MB). |
RAMSIZE | No | VARCHAR(128) | No | RAM field (value specified in MB) |
ROMSIZE | No | VARCHAR(128) | No | ROM field (value specified in MB). |
OSNAME | No | VARCHAR(252) | No | Operating system field. |
OSVERSION | No | VARCHAR(128) | No | Operating system version field. |
VIDEONAME | No | VARCHAR(252) | No | Video controller field. |
HASMULTMON | No | NUMERIC(1) | No | Has multiple monitors field. |
HASCDROM | No | NUMERIC(1) | No | Has CD-ROM field |
CDROMMODEL | No | VARCHAR(252) | No | CD-ROM model field. |
HASSCANR | No | NUMERIC(1) | No | Has scanner field. |
SCANRMODEL | No | VARCHAR(252) | No | Scanner model field. |
HASMODEM | No | NUMERIC(1) | No | Has modem field. |
MODEMMODEL | No | VARCHAR(252) | No | Modem model field. |
HASPRINT | No | NUMERIC(1) | No | Has printer field |
PRINTMODEL | No | VARCHAR(252) | No | Printer model field |
OTHERHW | No | VARCHAR(1020) | No | Other hardware and software field. |
Table: TABFILTER
Note | Stores the temporary filters settings that are applied to any given tab when the user logs out. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TABID | No | NUMERIC(10) | No | Record ID that uniquely identifies the list window tab this filter was assigned to. |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the filter is associated with. |
NAME | No | VARCHAR(252) | No | Name field |
FILTERTYPE | No | NUMERIC(2) | No | Filter type: 0 - Normal, 1 - Find, 2 - Drilldown |
USERID | No | NUMERIC(10) | Yes | Links to a record ID in USERS table. |
Table: TABFLTRDSP
Note | Store the restrictions used by the temporary filters that are applied to any given tab when the user logs out. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
TABFLTRID | No | NUMERIC(10) | No | Identifies parent TABFILTER record. |
LINEORDER | No | NUMERIC(3) | No | Restriction item order, relative to other items. |
NOTFLAG | No | NUMERIC(1) | No | Indicates if Not flag is set. |
OPENPAREN | No | NUMERIC(2) | No | Number of open parentheses that appear before restriction item. |
CLOSEPAREN | No | NUMERIC(2) | No | Number of open parentheses that appear after restriction item. |
RSTNTYPE | No | NUMERIC(2) | No | Operator applied to the next restriction item; includes the following values: 0 (none) 2 (AND operator) 3 (OR operator) |
RESTRICTN | No | TEXT | No | Filter restriction information; field can use information from a filter restriction definition and code them into a string value stored in this field |
Table: TABMAPVALUE
Note | Contains table lookup mapping values for calculated pop-up custom field. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
IDTABMAP | No | NUMERIC(10) | Yes | Links to a record ID in TABULARMAP table. |
IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
IDPUVALUE | No | NUMERIC(10) | Yes | The input pop-up list value for this mapping |
Table: TABULARMAP
Note | Contains table lookup mapping for calculated pop-up custom field. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
IDPUVALUE | No | NUMERIC(10) | Yes | The output pop-up list value for this mapping |
Table: TACTMOD
Note | Contains information for the modify automation rule action. This table has a many-to-one relationship with the TRGACTN table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
ACTIONID | No | NUMERIC(10) | Yes | Link to a record ID in the TRGACTN table. |
ENTITYID | No | NUMERIC(10) | Yes | Entity type. |
FIELDID | No | NUMERIC(10) | Yes | Field to be modified, links to a record ID in FLDDFNTN table. |
FLDTYPE | No | NUMERIC(5) | No | Field type; includes the following values: 0 (invalid field type) 1 (text) 2 (text without replace) 3 (date) 4 (date/time) 5 (check box) 6 (pop-up menu) 7 (test case steps) |
ACTION | No | NUMERIC(5) | No | Action to modify field; includes the following values: 0 (no action) 1 (set to value) 2 (prepend) 3 (append) 4 (replace) |
VALA | No | TEXT | No | If action is set to value, contains value to set (e.g., if field is pop-up menu, contains record ID of value to set). |
VALB | No | TEXT | No | If action is replace, contains strings to replace VALA with. |
Table: TASK
Note | Contains workbook task information. Each table row represents one task defined in the workbook. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TASKTYPE | No | NUMERIC(2) | Yes | Task type; includes the following values: 0 (Unknown) 1 (ToDo) 2 (Defect) 3 (TestCase) 4 (TestRun) |
TASKSTATUS | No | NUMERIC(2) | No | Task status; includes the following values: 0 (Unknown) 1 (On Hold) 2 (Open) 3 (Done) |
IDPRIORITY | No | NUMERIC(10) | No | Priority field, links to a record ID in FLDPRIOR table. |
SUMMARY | No | VARCHAR(1020) | No | To do summary field. |
VERSIONDUE | No | VARCHAR(128) | No | Need by version field. |
DATEDUE | No | DATETIME | No | Need by date field. |
DATEASSIGN | No | DATETIME | No | Date field. |
IDASGTOUSR | No | NUMERIC(10) | No | User task is assigned to, links to a record ID in USERS table. |
IDASGBYUSR | No | NUMERIC(10) | No | Reserved for future use. |
TASKDESC | No | TEXT | No | Description field. |
Table: TASKBOARD
Note | Contains the list of task boards configured for each project. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
TaskBoardName | No | VARCHAR(512) | Yes | Task board name. |
TaskBoardDesc | No | VARCHAR(1020) | No | Task board description. |
ShowEmptyLanesFolder | No | NUMERIC(1) | Yes | Boolean indicating if swimlanes should be displayed for empty folders when grouping by folder. |
RollUpFieldFolder | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by folder. |
RollUpFieldUser | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by user. |
ShowEmptyLanesType | No | NUMERIC(1) | Yes | Boolean indicating if swimlanes should be displayed for items with no linked children when grouping by relationship. |
RollUpFieldType | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by relationship. |
ShowEmptyLanesDoc | No | NUMERIC(1) | Yes | Boolean indicating if swimlanes should be displayed for empty documents when grouping by document. |
RollUpFieldDoc | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by document. |
ShowAllReqTypes | No | NUMERIC(10) | Yes | Boolean indicating if all requirements types should be displayed when grouping by document. |
Flags | No | NUMERIC(10) | Yes | Indicates the enabled group by options for the task board. |
Table: TASKBOARDCOLUMN
Note | Contains the list of columns configured for a task board. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ParentTaskBoardID | No | NUMERIC(10) | Yes | Record ID for the parent task board the column is in. |
ColumnName | No | VARCHAR(512) | Yes | Task board column name. |
ColumnDescription | No | VARCHAR(1020) | No | Task board column description. |
OrderNum | No | NUMERIC(5) | Yes | Position for this column relative to other columns in the task board. |
WIPLimit | No | NUMERIC(10) | No | Work In Progress (WIP) limit for the column. Can be NULL to indicate no WIP limit is set. |
Table: TASKBOARDENTITYOPTNS
Note | Contains card color information for each item type in the task board. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ParentTaskBoardID | No | NUMERIC(10) | Yes | Record ID for the parent task board. |
EntityType | No | NUMERIC(10) | Yes | Item type ID to use the specified color. |
SubtypeID | No | NUMERIC(10) | Yes | Requirement type ID to use the specified color. |
FieldID | No | NUMERIC(10) | Yes | Field ID to use the field style color from. Reserved for future use. |
DefaultColor | No | VARCHAR(6) | Yes | String representation of the color to use for the item type and requirement type. |
Table: TASKBOARDTYPEENTITY
Note | Contains information about item types and requirement types that can be swimlanes when grouping by relationship. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
ProjectID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
ParentTaskBoardID | No | NUMERIC(10) | Yes | Record ID for the parent task board. |
EntityType | No | NUMERIC(10) | Yes | Item type ID. |
SubtypeID | No | NUMERIC(10) | Yes | Requirement type ID. |
Table: TCEVTS
Note | Contains event information for each event recorded with a test case. Each table row represents a single test case event. This table has a many-to-one relationship with the TESTCASE table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table. |
ORDERNUM | No | NUMERIC(5) | No | Identifies order the test case event was created relative to other test case events; an internal counter for a specific test case. |
PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in TESTCASE table. |
EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in TCEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multi-user assignment, field contains the value -1. |
IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by TestTrack, it has a record ID of -2 |
DATEEVENT | No | DATETIME | No | Test case event date. |
NOTES | No | TEXT | No | Notes field. |
TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1. |
RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting test case state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values: 0 (created by user) 1 (created by multi-user assignment) 2 (created by auto assignment) 3 (created by auto escalation) |
CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases: - Escalation rule record ID - Trigger rule record ID - User record ID of user that performed an action generating a system comment event |
DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values: 1 (event results in new assignment) 2 (event has no effect on assignment) 3 (event clears assignment) |
OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override. |
OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field. |
SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
Table: TCLOG
Note | Contains historical log information about changes made to test case records. Each row in this table represents a log entry in one of the test case records. Each table row has a test case record ID that matches a record ID in the TESTCASE table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table. |
DATELOG | No | DATETIME | No | Date time the change occurred. |
NOTES | No | VARCHAR(4000) | No | Description of the change. |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTCASE table. |
Table: TCLOGASC
Note | Associates test case historical log and audit log information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
AUDITID | No | NUMERIC(10) | Yes | Links to a record ID in AUDITLOG table |
HISTID | No | NUMERIC(10) | Yes | Links to a record ID in TCLOG table |
Table: TESTCASE
Note | Contains test case information. Each table row represents one test case. Additional information associated with a test case is found in the TCEVTS table. This table has a one-to-one relationship with the STATES and FLDTOTP tables. This table has a many-to-many relationship with the USERS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
DATECREATE | No | DATETIME | No | Date/time (in GMT) test case was added to the database. |
IDCREATEBY | No | NUMERIC(10) | No | User who added the test case, links to a record ID in USERS table. |
DATEMODIFY | No | DATETIME | No | Date/time (in GMT) test case was last modified. |
IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the test case, links to a record ID in USERS table. |
TSTCASENUM | No | NUMERIC(10) | No | Test case number, value is zero if number not assigned. |
SUMMARY | No | VARCHAR(1020) | No | Summary field. |
IDTYPE | No | NUMERIC(10) | No | Test object type field, links to a record ID in FLDTOTP table. |
ISAUTOTEST | No | NUMERIC(1) | No | Flag indicates if this is automated test. |
ESTTIME | No | NUMERIC(10) | No | Estimated time of this test case execution. |
STEPS | No | TEXT | No | Test case steps. |
ADDEDFROM | No | NUMERIC(6) | No | Method used to add test case; includes the following values: 0 (unknown) 1 (Add test case window) 5 (Text file import) 6 (TestTrack user duplicated a test case) |
NOTIFY | No | TEXT | No | Currently not in use. |
SAVEGRID | No | NUMERIC(1) | No | Flag indicates to save test runs in grid mode or plain text. |
STATUS | No | NUMERIC(10) | No | Record id of the current state for the test case. |
CURASGTO | No | TEXT | No | Names of the users the test case is currently assigned to. |
SAVEMODE | No | NUMERIC(10) | No | Indicates how test runs should be generated. 0 (Use existing setting) 1 (Text View) 2 (Grid View) 3 (Detail Grid View) |
TESTCASE | No | NUMERIC(10) | No | Initial test case state |
Table: TESTRUN
Note | Contains test run information. Each table row represents one test run. Additional information associated with a test run is found in the TREVTS table. This table has a one-to-one relationship with the STATES, FLDTOTP and FLDTRSET tables. This table has a many-to-many relationship with the USERS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
DATECREATE | No | DATETIME | No | Date/time (in GMT) test run was added to the database. |
IDCREATEBY | No | NUMERIC(10) | No | User who added the test run, links to a record ID in USERS table. |
DATEMODIFY | No | DATETIME | No | Date/time (in GMT) test run was last modified. |
IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the test run, links to a record ID in USERS table. |
TSTCASERID | No | NUMERIC(10) | No | Test case record ID. |
SUMMARY | No | VARCHAR(1020) | No | Summary field. |
IDTYPE | No | NUMERIC(10) | No | Test object type field, links to a record ID in FLDTOTP table. |
ISAUTOTEST | No | NUMERIC(1) | No | Flag indicates if this is automated test. |
ESTTIME | No | NUMERIC(10) | No | Estimated time of this test run execution. |
STEPS | No | TEXT | No | Test case steps. |
ADDEDFROM | No | NUMERIC(6) | No | Method used to add test case; includes the following values: 0 (unknown) 1 (Add test run window) 5 (Text file import) 6 (TestTrack user duplicated a test run) |
TSTRUNNUM | No | NUMERIC(10) | No | Test run number (Auto generated). |
IDTRSET | No | NUMERIC(10) | No | Test run set field, links to a record ID in FLDTRSET table. |
NOTIFY | No | TEXT | No | Currently not in use. |
VIEWGRID | No | NUMERIC(1) | No | Flag indicates to view test runs in grid mode or plain text. |
PRBSTATE | No | TEXT | No | Problem statement for this test run, if any. |
STATUS | No | NUMERIC(10) | No | Record id of the current state for the test run. |
CURASGTO | No | TEXT | No | Names of the users the test run is currently assigned to. |
VIEWMODE | No | NUMERIC(10) | No | Indicates how test runs were generated. 0 (Use existing setting) 1 (Text View) 2 (Grid View) 3 (Detail Grid View) |
INTSTATUS | No | NUMERIC(10) | No | Initial testrun state |
Table: TILECOLORMAP
Note | Contains all color settings for home page widgets. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
TILEID | No | NUMERIC(10) | Yes | Parent widget record ID |
VALUESTART | No | NUMERIC(10) | Yes | Number of items that must pass the widget filter to start using the specified color |
COLOR | No | VARCHAR(24) | Yes | Color to use. Hex string. |
Table: TRACEREPORT
Note | Contains custom traceability report information. Each table row represents one custom traceability report. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
REPORTID | No | NUMERIC(10) | No | Unused |
NAME | No | VARCHAR(512) | No | Name field. |
TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
ACCESSSTAT | No | NUMERIC(2) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
ENTITYMASK | No | NUMERIC(10) | No | A bitmask of the entity types that the traceability report contains across all columns. |
XML | No | TEXT | No | XML text containing additional parameters. (Stored as XML to allow for future expansion). |
Table: TRANSITION
Note | Contains information describing which events can be entered for corresponding entities which are in a given state. If the state is a result of a multi-user assignment, also contained within the table is the priority of the resulting states. This table has a one-to-many relationship with the EVENTS table and the STATES table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ENTITYTYPE | No | NUMERIC(10) | No | Table state is linked to. |
STATERECID | No | NUMERIC(10) | No | Transition rule that apply to the entity in state referenced by this record ID; links to a record ID in STATES table. |
ISDEFAULT | No | NUMERIC(1) | No | Flag indicates if state referenced by STATERECID is default state for new defects/test cases /test runs. |
EVENTIDS | No | VARCHAR(3500) | No | Serialized record IDs linked to EVENTS table; record IDs in this field correspond to events that can be entered when an entity is in the STATERECID state |
RSTLSTPRTY | No | VARCHAR(3500) | No | Serialized record IDs linked to STATES table, field used when current state is a multi-user assignment; lists priority of states that are evaluated to determine resulting state of a multi-user assignment. |
Table: TREVTS
Note | Contains event information for each event recorded with a test run. Each table row represents a single test run event. This table has a many-to-one relationship with the TESTRUN table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table. |
ORDERNUM | No | NUMERIC(5) | No | Identifies order the test run event was created relative to other test run events; an internal counter for a specific testrun. |
PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in TESTRUN table. |
EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in TREVTS table; if event is a response to a multi-user assignment, field is the record ID of theparent event; if event is not a response to a multi-user assignment, field contains the value -1. |
IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by TestTrack, it has a record ID of -2. |
DATEEVENT | No | DATETIME | No | Test run event date. |
NOTES | No | TEXT | No | Notes field. |
TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1. |
RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting test run state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field. |
RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information. |
ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty. |
GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values: 0 (created by user) 1 (created by multi-user assignment) 2 (created by auto assignment) 3 (created by auto escalation) |
CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases: - Escalation rule record id - Trigger rule record id - User record id of user that performed an action generating a system comment event |
DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values: 1 (event results in new assignment) 2 (event has no effect on assignment) 3 (event clears assignment) |
OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override. |
OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field. |
SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
Table: TRGACTN
Note | Contains user notification and automation rule action information. This table has a many-to-one relationship with the TRIGGERS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TRIGGERID | No | NUMERIC(10) | Yes | Link to a record ID in TRIGGERS table. |
TYPE | No | NUMERIC(5) | Yes | Action type; includes the following values: 0 (not set) 1 (enter event) 2 (notification) 3 (modify) 4 (run executable) 5 (prevent) |
ONLYIFASGN | No | NUMERIC(1) | No | If user notification, indicates to only notify currently assigned user. |
ENTIFASGND | No | NUMERIC(1) | No | If enter event action, indicates if event is entered if the record is already assigned. |
OWNCHGS | No | NUMERIC(1) | No | If user notification, indicates if user receives email if they made changes to cause notification to be sent. |
ACTOPTID | No | NUMERIC(10) | Yes | If enter event action, contains event ID; if prevent action, field contains message path; otherwise, field is NULL. |
ACTOPTSTR | No | TEXT | No | If run executable action, contains executable path; if prevent action, contains prevent message. |
TRACKEMAIL | No | NUMERIC(1) | No | Indicates if email is tracked for send email actions. |
Table: TRIGGERS
Note | Contains automation rule information. This table has a many-to-many relationship with the STATES and FILTERS tables. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
CREATEDATE | No | DATETIME | No | Date/time rule was created. |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the rule is associated with. |
ENABLED | No | NUMERIC(1) | No | Indicates if the rule is enabled. |
NAME | No | VARCHAR(400) | No | Trigger name. |
OWNERID | No | NUMERIC(10) | No | If user notification, links to a record ID in USERS table; if automation rule, value is 0. |
RULETYPE | No | NUMERIC(10) | No | Rule type; includes the following values: 0 (not set) 1 (notification) 2 (before save trigger) 3 (after save trigger) 4 (escalation) |
CONDTYPE | No | NUMERIC(10) | No | Type of trigger condition; includes the following values: 0 (not set) 1 (state transition) 2 (item created) 3 (item merged) 4 (item assigned a number) 5 (item renumbered) 6 (item changed) 7 (item event changed) 8 (item assigned) 9 (test run generated) |
TYPEOPT | No | NUMERIC(10) | No | Links to a record ID in STATES table. |
FILTERID | No | NUMERIC(10) | No | Filter the trigger uses. |
TRIGORDER | No | NUMERIC(10) | No | Order of before save trigger rules. |
STOPIFPASS | No | NUMERIC(1) | No | Stops processing of next rule if this rule passes; only applies to before save triggers. |
ISPRESAVE | No | NUMERIC(1) | No | Indicates if rule is before save or after save triggers. |
APPLYONCE | No | NUMERIC(1) | No | Flag indicates to inactivate the rule after it runs once; only applies to escalations. |
RUNONCE | No | NUMERIC(1) | No | Flag indicates to apply the rule once per record; only applies to escalations. |
RUNONIMP | No | NUMERIC(1) | No | Flag indicates to run trigger when performing XML or text import; only applies to triggers. |
LASTEVAL | No | DATETIME | No | Last date/time rule was evaluated; not set if the rule is never evaluated. |
Table: TRIGLOG
Note | Contains historical log information about changes to automation rules. Each table row represents a log entry for a rule. Each table row has a record ID that matches a record ID in the TRIGGERS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TRIGGERID | No | NUMERIC(10) | Yes | Links to a record ID in TRIGGERS table. |
ENTITYID | No | NUMERIC(10) | No | Entity type modified by automation rule. |
RULENAME | No | VARCHAR(400) | No | Rule name that caused message to be generated. |
MSGDATE | No | DATETIME | No | Date/time modification occurred. |
RULETYPE | No | NUMERIC(5) | No | Rule type; includes the following values: 0 (not set) 1 (notification) 2 (before save trigger) 3 (after save trigger) 4 (escalation) |
MSG | No | TEXT | No | Message written to log. |
Table: TRIGSCHD
Note | Contains schedule information for escalation rules. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
TRIGGERID | No | NUMERIC(10) | Yes | Link to a record ID in TRIGGERS table. |
PERIOD | No | NUMERIC(5) | No | Evaluation frequency; includes the following values: 0 (not set) 1 (daily) 2 (weekly) 3 (monthly) 4 (manually) |
USESTRT | No | NUMERIC(1) | No | If evaluation is daily, indicates if hour or start time is used. |
STARTTIME | No | DATETIME | No | Evaluation start date/time. |
HOURFREQ | No | NUMERIC(5) | No | If evaluation is daily on a specific hour, contains the hour frequency. |
DYSOFWK | No | VARCHAR(128) | No | If evaluation is weekly, contains a comma-delimited list of enumerated days of the week to evaluate rule. |
USEDYMNTH | No | NUMERIC(1) | No | If evaluation is monthly, indicates day of month option is selected. |
DYMNTH | No | NUMERIC(5) | No | Day of month to evaluate rules on. |
DAYOPT | No | NUMERIC(5) | No | If evaluation is monthly, day to evaluate in month; includes the following values: 0 (not set) 1 (first) 2 (second) 3 (third) 4 (fourth) 5 (last) |
DYOFWK | No | NUMERIC(5) | No | If evaluation is monthly, contains day of the week to evaluate rule. |
MNTHSOFYR | No | VARCHAR(128) | No | If evaluation is monthly, contains months to evaluate rule. |
Table: TRLOG
Note | Contains historical log information about changes made to test run records. Each row in this table represents a log entry in one of the test run records. Each table row has a test run record ID that matches a record ID in the TESTRUN table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table. |
DATELOG | No | DATETIME | No | Date time the change occurred. |
NOTES | No | VARCHAR(4000) | No | Description of the change. |
PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTRUN table. |
Table: TRLOGASC
Note | Associates test run historical log and audit log information. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
AUDITID | No | NUMERIC(10) | Yes | Links to a record ID in AUDITLOG table |
HISTID | No | NUMERIC(10) | Yes | Links to a record ID in TRLOG table |
Table: TTDBOPTN
Note | Contains database options. Works like a Windows INI file and each entry has a name/value pair. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
OPTDESC | No | VARCHAR(252) | No | Description of option represented in this row. |
OPTVALUE | No | VARCHAR(1020) | No | Value of option represented in this row. |
Table: TTPROJECTS
Note | Contains the list of TestTrack projects that reside in the RDBMS database. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project; all other project-related tables link to this id. |
TTPROJNAME | No | VARCHAR(128) | Yes | Project name, which must be unique within the database. |
TTPROJUUID | No | VARCHAR(152) | Yes | Universally unique project identifier. |
TTSERVUUID | No | VARCHAR(152) | No | Universally unique identifier of TestTrack Server that hosts the project. |
TTPROJVERS | No | VARCHAR(40) | No | Project version number. |
TTSERVDBID | No | NUMERIC(10) | No | Server database ID. |
Table: USERGRP
Note | Contains user group information. Each table row represents one user group. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
NAME | No | VARCHAR(128) | No | Name field |
GROUPDESC | No | VARCHAR(1020) | No | Description field. |
NOTES | No | TEXT | No | Notes field. |
INUSERPOPUP | No | NUMERIC(1) | No | Include users in pop-up menus field. |
INCSTPOPUP | No | NUMERIC(1) | No | Include customers in pop-up menus field. |
IDDEFFLT | No | NUMERIC(10) | No | Filter that restricts issues users in this group can work with. |
IDTCFLT | No | NUMERIC(10) | No | Filter that restricts test cases users in this group can work with. |
IDTRFLT | No | NUMERIC(10) | No | Filter that restricts test runs users in this group can work with. |
IDREQFLT | No | NUMERIC(10) | No | Filter that restricts requirements users in this group can work with. |
IDDOCFLT | No | NUMERIC(10) | No | Filter that restricts requirement documents users in this group can work with. |
ONLYMYDEF | No | NUMERIC(1) | No | Defect security option of "Users can only see and work with the defects they reported". |
ONLYMYTC | No | NUMERIC(1) | No | Test case security option of "Users can only see and work with the test cases they reported". |
ONLYMYTR | No | NUMERIC(1) | No | Test run security option of "Users can only see and work with the test runs they reported". |
ONLYMYREQ | No | NUMERIC(1) | No | Requirement security option of "Users can only see and work with the requirements they reported". |
ONLYMYDOC | No | NUMERIC(1) | No | Requirement document security option of "Users can only see and work with the requirement documents they reported". |
COMMDENIED | No | VARCHAR(3500) | No | Command security options. |
FIELDSEC | No | TEXT | No | Field level security options |
EVTDENIED | No | VARCHAR(3500) | No | Serialized list of record IDs linked to EVENTS table; contains record IDs of events that security group members cannot perform. |
Table: USERS
Note | Contains user and customer information. Each table row represents either one user or one customer. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
ACTIVE | No | NUMERIC(1) | Yes | Flag indicates if a user is active; if false, user is inactive. |
FIRSTNAME | No | VARCHAR(128) | No | First name field. |
IDUSRGROUP | No | NUMERIC(10) | No | User group field, links to a record ID in USERGRP table. |
LASTNAME | No | VARCHAR(128) | No | Last name field. |
LOGINNAME | No | VARCHAR(1424) | Yes | Login name field. As login name is stored as an encrypted string and for local users an empty string of 32 characters is encrypted therefore this field will not be null. |
DATELOGOUT | No | DATETIME | No | Date/time (in GMT) that user last logged out of TestTrack. |
NOTES | No | TEXT | No | Notes field. |
PHONETYPE1 | No | NUMERIC(2) | No | First phone number type field; includes the following values: 1 (Work) 2 (Fax) 3 (Home) 4 (Pager) 5 (Mobile) |
PHONENUM1 | No | VARCHAR(128) | No | First phone number field. |
PHONETYPE2 | No | NUMERIC(2) | No | Second phone number type field; includes the following values: 1 (Work) 2 (Fax) 3 (Home) 4 (Pager) 5 (Mobile) |
PHONENUM2 | No | VARCHAR(128) | No | Second phone number field. |
BETASITE | No | NUMERIC(1) | No | Beta test site field (used only for customers) |
COMPANY | No | VARCHAR(252) | No | Company field (used only for customers) |
ADDRESS | No | VARCHAR(1020) | No | Address field (used only for customers) |
IDTESTCONF | No | NUMERIC(10) | No | Links to a record ID in SYSCONF table where user's system configuration information is stored. |
EMAILTYPE | No | NUMERIC(2) | No | Email type field; includes the following values: 1 (Internet) 2 (MAPI) 3 (Other) |
ISCUSTOMER | No | NUMERIC(1) | Yes | Flag indicates if a user is a customer; if false, this is a user, if true, this is a customer. |
ISGLOBAL | No | NUMERIC(1) | Yes | Flag indicates if user is a global user. |
EMAILADDR | No | VARCHAR(252) | No | Email address field. |
ALLOWSSO | No | NUMERIC(1) | No | Flag indicates single sign-on support. |
INITIALS | No | VARCHAR(32) | No | Middle initials. |
DIVISION | No | VARCHAR(252) | No | User's division within company |
DEPARTMENT | No | VARCHAR(252) | No | User's department within division |
ADDLINFO | No | TEXT | No | Additional info about user, reserved for future use |
Table: USERSET
Note | Contains user settings information. Each user has a set of user settings (also referred to as user options). The record ID has a one-to-one relationship with the USERS table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
NOTFSOUND | No | NUMERIC(1) | No | Play a sound option for assignment notification. |
NOTFDIALOG | No | NUMERIC(1) | No | Display a dialog box option for assignment notification. |
DBLCLKEDIT | No | NUMERIC(1) | No | Double-click on items field. |
NAMEORDER | No | NUMERIC(10) | No | Display names as option; includes the following values: 0 (First Last) 1 (Last First) |
RECPERPAGE | No | NUMERIC(5) | No | Web option to limit number of defects displayed per page on the Work With Defects window. |
ASGNINSTAT | No | NUMERIC(1) | No | Status display option, determines if assignment information is displayed in the status field. |
GRAYCLSDEF | No | NUMERIC(1) | No | Grey out closed defects field. |
WARNFLDREL | No | NUMERIC(1) | No | User option to display warning when field relationship information may be impacted |
AFTDEFADD | No | NUMERIC(2) | No | Action performed after adding a defect; includes the following values: 0 (Set all fields to their default values) 1 (Retain pop-up menu values) 2 (Close the Add Defect window) |
SCCIUNAME | No | VARCHAR(1424) | No | Username for the SCC integration; this username is for this TestTrack user. |
SCCIPWD | No | VARCHAR(2832) | No | Password for the SCC integration; this password is for this TestTrack user. |
PROJNAME | No | VARCHAR(1020) | No | Project name for SCC integration. |
DBPATH | No | VARCHAR(1020) | No | SCC integration connection information. |
WEBTZOPT | No | NUMERIC(1) | No | Determines time zone to use for web interface; includes the following values: are GMT, server's time zone, or specified time zone (see the WebTzOff field). |
WEBTZOFF | No | NUMERIC(6) | No | Specified time zone for web interface. |
DEFLAYOUT | No | NUMERIC(1) | No | Indicates defect view window layout, vertical tab view or single page view. |
AFTTCADD | No | NUMERIC(2) | No | Action performed after adding a test case; includes the following values: 0 (Set all fields to their default values) 1 (Retain pop-up menu values) 2 (Close the Add test case window) |
GRAYCLOSTC | No | NUMERIC(1) | No | Dim, or gray out, closed test cases field. |
GRAYCOMPTR | No | NUMERIC(1) | No | Dim, or gray out, completed test runs field. |
HDDFOVVWTB | No | NUMERIC(1) | No | Indicates if defect Overview tab is displayed or hidden. |
HDTCOVVWTB | No | NUMERIC(1) | No | Indicates if test case Overview tab is displayed or hidden. |
HDTROVVWTB | No | NUMERIC(1) | No | Indicates if test run Overview tab is displayed or hidden. |
ALWSTBBR | No | NUMERIC(1) | No | Indicates if tab bar is displayed or hidden. |
HGHLTCOLOR | No | VARCHAR(24) | No | Highlight color code for type ahead searching. |
HGHLTBOLD | No | NUMERIC(1) | No | Indicates if type ahead search text results are bold |
HGHLTUNDER | No | NUMERIC(1) | No | Indicates if type ahead search results are underlined. |
HGHLITALIC | No | NUMERIC(1) | No | Indicates if type ahead search results are italicized. |
DRDNCOLOR | No | VARCHAR(24) | No | Color code for column filters in list windows. |
OPNSPCDC | No | NUMERIC(1) | No | Open requirement document in specification window field. |
REQEVTINLN | No | NUMERIC(1) | No | |
AFTRQADD | No | NUMERIC(2) | No | Action performed after adding a requirement; includes the following values: 0 (Set all fields to their default values) 1 (Retain pop-up menu values) 2 (Close the Add Requirement window) |
AFTDOCADD | No | NUMERIC(2) | No | Action performed after adding a requirement document; includes the following values: 0 (Set all fields to their default values) 1 (Retain pop-up menu values) 2 (Close the Add Requirement Document window) |
GRAYCLOSRQ | No | NUMERIC(1) | No | Dim, or gray out, closed requirements field. |
GRAYCLOSDC | No | NUMERIC(1) | No | Dim, or gray out, closed requirement documents field. |
HDRQOVVWTB | No | NUMERIC(1) | No | Indicates if defect Overview tab is displayed or hidden on Requirements detail window. |
HDDCOVVWTB | No | NUMERIC(1) | No | Indicates if defect Overview tab is displayed or hidden on Requirement Documents detail window. |
ADDCOLOR | No | VARCHAR(24) | No | Added requirement text color for differences window. |
ADDBOLD | No | NUMERIC(1) | No | Added requirements text displays in bold for differences window. |
ADDUNDER | No | NUMERIC(1) | No | Added requirements text displays underlined for differences window. |
ADDITALIC | No | NUMERIC(1) | No | Added requirements text displays in italic for differences window. |
ADDSTRIKE | No | NUMERIC(1) | No | Added requirements text displays in strikeout for differences window. |
REMVCOLOR | No | VARCHAR(24) | No | Removed requirement text color for differences window. |
REMVBOLD | No | NUMERIC(1) | No | Removed requirements text displays in bold for differences window. |
REMVUNDER | No | NUMERIC(1) | No | Removed requirements text displays underlined for differences window. |
REMVITALIC | No | NUMERIC(1) | No | Removed requirements text displays in italic for differences window. |
REMVSTRIKE | No | NUMERIC(1) | No | Removed requirements text displays in strikeout for differences window. |
Table: USERSETENT
Note | Contains shortcut menu settings for a specified user. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
USERID | No | NUMERIC(10) | Yes | Links to a record ID in USERS table. |
ENTITYTYPE | No | NUMERIC(10) | Yes | Identifies the list window the shortcut menu settings apply to. |
CTXACTENUMS | No | TEXT | No | Actions included in the shortcut menu. |
SHOWWRKFWSUB | No | NUMERIC(1) | Yes | Flag that indicates if workflow events are grouped in a sub-menu. |
ALLOWWRKFWEVTS | No | TEXT | No | Reserved for future use. |
Table: VIEWCOLINFO
Note | Contains user-defined view column information. Each table row represents one column in a view. This table has a many-to-one relationship with the VIEWINFO table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
VIEWID | No | NUMERIC(10) | No | Link to a record ID in VIEWINFO table. |
VIEWTYPE | No | NUMERIC(5) | No | View type; includes the following values: 0 (list window tab) 1 (user-definedview) |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the view is associated with. |
FIELDID | No | NUMERIC(10) | No | Field displayed in column, links to a record in FLDDFNTN table. |
COLORDER | No | NUMERIC(5) | No | Order of column, relative to other columns. |
WIDTH | No | NUMERIC(5) | No | Column width. |
Table: VIEWINFO
Note | Contains user-defined view information. Each table row represents one view. This table has a one-to-many relationship with the VIEWCOLINFO table. |
Columns:
Column name | Primary key | Data type | Not NULL | Note |
PROJECTID | Yes | NUMERIC(10) | Yes | TestTrack project ID, identifies row's parent project. |
IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
USERID | No | NUMERIC(10) | No | Link to a record in USERS table. |
ENTITYTYPE | No | NUMERIC(10) | No | Entity type the view is associated with. |
NAME | No | VARCHAR(512) | No | View name. |
PRISORT | No | NUMERIC(10) | No | Primary sort field ID. |
SECSORT | No | NUMERIC(10) | No | Secondary sort field ID. |
PRISRTORDR | No | NUMERIC(1) | No | Primary sort column order. |
SECSRTORDR | No | NUMERIC(1) | No | Secondary sort column order. |
FILTERID | No | NUMERIC(10) | No | Filter the view uses. |
QUICKLINKS | No | NUMERIC(10) | No | Indicates if TestTrack Web quick link icons are displayed. |
EVENTS | No | VARCHAR(4000) | No | List of selected TestTrack Web event quick link icons. |
|