Name | Note |
ACTNTGT | Contains a list of target users for automation rule actions. This table has a many-to-one relationship with the TRGACTN table. |
ATTACHINFO | 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. |
ATTACHMT | 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. |
ATTARCHIVE | Contains file attachment archive information. Each table row represents one file attachment. |
AUDITLOG | 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. |
CHARTS | Contains live chart report information. Each table row represents one live chart report. |
CHARTSET | Contains live chart report attributes. |
CSDOCVAL | 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. |
CSRDEVTVL | 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. |
CSREQVAL | 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. |
CSREVTVL | 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. |
CSTDEVTVAL | 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. |
CSTTCEVTVAL | 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. |
CSTTREVTVAL | 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. |
CUSTMMAP | Contains field level mappings for creating-type-from-type. |
CUSTMVAL | 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. |
CUSTTCVAL | 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. |
CUSTTRVAL | 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. |
DASHBOARDLIVECHARTWIDGET | Contains dashboard chart widget information. |
DASHBOARDSTATICWIDGET | Reserved for future use. |
DASHBOARDSTATUSWIDGET | Contains dashboard burn down or burn up widget information. |
DASHBOARDTILEWIDGET | Contains dashboard count widget information. |
DASHBOARDVIEW | Contains dashboard information. |
DASHBOARDVIEWORDER | Contains the order to display dashboards in for a specified user. |
DASHBOARDVIEWWIDGET | Contains information about the widgets included in a dashboard. |
DASHBOARDWIDGET | Contains basic information included in all dashboard widgets. |
DASHRECACT | Contains dashboard recent activity |
DEFECTEVTS | 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. |
DEFECTS | 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. |
DEFLOG | 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. |
DFLOGASC | Associates defect historical log and audit log information. |
DISPNAME | Contains text strings used in the interface. This table contains the Rename Field Label values. |
DOCCHNGS | Contains the original values for fields that were changed after a document snapshot was created. The document itself always stores the current value. |
DOCEVTS | 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. |
DOCEXPORTFAVORITES | Relates users to favorited Word export templates. |
DOCEXPORTGRP | Relates security groups to Word export templates they can use. |
DOCEXPORTTEMPLATE | Contains Word export templates. |
DOCLOG | 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. |
DOCSNPST | Contains document snapshot information. Each table row represents one document snapshot. |
DOCTREE | Contains the requirement relationship tree for the current version of the document. |
DOCUMENT | Contains requirement document information. Each table row represents one requirement document. |
DRAFTFIELD | Contains draft version/inactive custom fields. Each table row represents one draft custom field. |
EMAIL | Contains tracked email information. Each table row represents one email. This table has a one-to-one relationship with the EMAILASSOC table. |
EMAILASSOC | Contains information about records tracked emails are associated with. Each table row represents an email association with one entity. |
EMAILRECP | Contains email recipient information. This table has a many-to-one relationship with the EMAIL table. |
EMAILTMP | Contains email template information. |
EVENTS | Contains event definition information. Each table row represents one event definition. This table has a many-to-one relationship with the FLDDFNTN table. |
EXTERNPROVIDER | Contains information that enables integration with external source control providers, such as Git |
EXTERN_ITEM_ASSOC_ITEM | Contains external item associations, such as for JIRA issues. |
EXTERN_ITEM_ASSOC_PROVIDER | Contains external item association providers, such as JIRA. |
FIELDCALC | Contains calculated custom field details. Each table row represents one calculated custom field. |
FIELDREL | Contains the definition of field relationships setup for this database. Each table row represents one field relationship. |
FIELDSTYLES | Contains field value style settings. May be associated with multiple fields. |
FIELDSTYLESASSOC | 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. |
FILTDISP | 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. |
FILTER | 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. |
FLDCOMP | Contains the components pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDCUSTM | 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. |
FLDDFNTN | 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. |
FLDDISPO | Contains the disposition pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDPRIOR | Contains the priority pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDPROD | Contains the product pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDPULIST | 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. |
FLDRDTL | Contains the additional folder details for the folder table. |
FLDREPRO | Contains the reproduced pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDRITEM | Contains folder item information. Each table row represents one folder item. This table has a many-toone relationship with the FOLDER table. |
FLDRLOG | 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. |
FLDRPRIO | Contains requirement importance pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDRTYP | Contains folder type information. Each table row represents one type value. |
FLDSEVER | Contains the severity pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDTOTP | Contains test object type pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDTRSET | Contains test run set pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDTYPE | Contains the type pop-up menu values. Each row in this table represents one pop-up menu item. |
FLDVERSN | Contains the version pop-up menu values. Each row in this table represents one pop-up menu item. |
FOLDER | 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. |
FRLOGASC | Associates folder historical log and audit log information. |
HYPRLNK | 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. |
INPUTMAP | Contains input mapping rule for a formula based calculated custom field. |
LINKDFNTN | Contains a list of user-defined link definitions. |
LINKHISTRY | Contains history of changes made to links. |
LINKITEM | Contains the information for a single item within a link in the LINK table. |
LINKS | Contains a list of link items that have been added to a link. |
LINKWRKFLW | Contains the options that describe the workflow behaviors for items in the LINKDFNTN table. |
LISTWND | Contains list window information. |
LISTWNDTAB | Contains list window tab information. Each table row represents one tab. This table has a many-to-one relationship with the LISTWND table. |
OBJCTGEN | Contains create-type-from-type mappings. |
OUTPUTMAP | Contains ouput mapping for a calculated pop-up custom field. |
OWNERLCK | Contains TestTrack internal information. |
PARENTCHILDASSOC | Associates a parent record with a child record. |
RDBMSOPTNS | 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. |
RDLOGASC | Associates requirement document historical log and audit log information. |
REPORTBY | 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. |
REQCHNGS | Contains the original values for fields that were changed after a requirement version was created. The requirement itself always stores the current value. |
REQEVTS | 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. |
REQLOG | 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. |
REQMNT | Contains requirement information. Each table row represents either one requirement. |
REQVRSN | Contains requirement version information. Each table row represents one requirement version. |
RPCHRT | Contains report chart information. |
RPCUSTOM | Contains custom report information. Each table row represents one custom report. |
RPDETL | Contains detail report information. Each table row represents one detail report. |
RPDIST | Contains distribution report information. Each table row represents one distribution report. |
RPEXTERN | Contains external report information. Each table row represents one external report. |
RPFRMT | 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. |
RPIDS | Contains a row for each report defined in the database, regardless of report type. |
RPLIST | Contains list report information. Each table row represents one list report. |
RPTREND | Contains trend report information. Each table row represents one trend report. |
RQLOGASC | Associates requirement historical log and audit log information. |
SCCFILE | 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. |
SCCPROJ | Contains SCC project information. |
SCMCHGLST | Contains source control changelist information. |
SHRWUSRGRP | Contains settings for sharing filters with security groups. |
SNPSTTRE | Contains the requirement relationship tree for a snapshot of the document. |
SPELLCHK | Contains the spell check options for a specified user. Each row contains the options for one specific user. |
STATES | Contains information about states that an entity can transition into. |
STEPDATA | Contains test run step details. |
SUBCMDSC | Contains user group subtype command security settings. |
SUBFLDDF | Contains default values and required field settings for fields by subtype. |
SUBFLDSC | Contains user group subtype field level security settings. |
SUBTYPE | Contains requirement type information. Each table row represents one type value. |
SYSCONF | Contains test configuration information. Each table row represents one system test configuration. |
TABFILTER | Stores the temporary filters settings that are applied to any given tab when the user logs out. |
TABFLTRDSP | Store the restrictions used by the temporary filters that are applied to any given tab when the user logs out. |
TABMAPVALUE | Contains table lookup mapping values for calculated pop-up custom field. |
TABULARMAP | Contains table lookup mapping for calculated pop-up custom field. |
TACTMOD | Contains information for the modify automation rule action. This table has a many-to-one relationship with the TRGACTN table. |
TASK | Contains workbook task information. Each table row represents one task defined in the workbook. |
TASKBOARD | Contains the list of task boards configured for each project. |
TASKBOARDCOLUMN | Contains the list of columns configured for a task board. |
TASKBOARDENTITYOPTNS | Contains card color information for each item type in the task board. |
TASKBOARDTYPEENTITY | Contains information about item types and requirement types that can be swimlanes when grouping by relationship. |
TCEVTS | 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. |
TCLOG | 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. |
TCLOGASC | Associates test case historical log and audit log information. |
TESTCASE | 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. |
TESTRUN | 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. |
TILECOLORMAP | Contains all color settings for home page widgets. |
TRACEREPORT | Contains custom traceability report information. Each table row represents one custom traceability report. |
TRANSITION | 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. |
TREVTS | 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. |
TRGACTN | Contains user notification and automation rule action information. This table has a many-to-one relationship with the TRIGGERS table. |
TRIGGERS | Contains automation rule information. This table has a many-to-many relationship with the STATES and FILTERS tables. |
TRIGLOG | 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. |
TRIGSCHD | Contains schedule information for escalation rules. |
TRLOG | 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. |
TRLOGASC | Associates test run historical log and audit log information. |
TTDBOPTN | Contains database options. Works like a Windows INI file and each entry has a name/value pair. |
TTPROJECTS | Contains the list of TestTrack projects that reside in the RDBMS database. |
USERGRP | Contains user group information. Each table row represents one user group. |
USERS | Contains user and customer information. Each table row represents either one user or one customer. |
USERSET | 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. |
USERSETENT | Contains shortcut menu settings for a specified user. |
VIEWCOLINFO | 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. |
VIEWINFO | Contains user-defined view information. Each table row represents one view. This table has a one-to-many relationship with the VIEWCOLINFO table. |