Following are brief descriptions for the CA Harvest SCM database tables. All supported database management systems in CA Harvest SCM use the same schema layout; however, the column types use database-specific mapping.
Note: Detailed descriptions of the database tables are available at Technical Support at http://ca.com/support.
Stores the definition of CA Harvest SCM actions that are auditable.
Stores all the paths under an item to facilitate recursive searches.
Stores the object user information including active and deleted users.
Stores the definition of an approve process.
Stores the history of an approve process.
Stores the definition of an approve process requirement.
Stores the information for associated packages.
Stores the actual auditable actions recorded by the audit system.
Stores the description field for the auditable action recorded by the audit system.
Stores the resource information for the first level (or top-most) ancestor resource associated with an audit log event.
Stores the resource information for the second level (or second top-most) ancestor resource associated with an audit log event.
Stores the resource information for the third level (or third top-most) ancestor resource associated with an audit log event.
Stores the resource information for the fourth level (or fourth top-most) ancestor resource associated with an audit log event.
Stores the information for branches.
Stores the definition of a check-in process.
Stores the definition of a check-out process.
Stores the information for a comment form.
Stores the definition of a concurrent merge process.
Stores conversion information.
Stores the definition of a create package process.
Stores the definition of a cross-project merge process.
Stores an example of a custom form.
Stores the definition of a delete package process.
Stores the definition of a delete version process.
Stores the definition of a demote process.
Stores the active project objects. If users delete a project, it will be removed from this table. However, the project object information will be stored in the harAllEnvirs table.
Note: In earlier releases of CA Harvest SCM, a project was referred to as an environment. In the database tables, the word environment may remain; it is equivalent to the current name project.
Controls CA Harvest SCM project security.
Stores an example of a custom form.
Stores the identify of the resource type of an auditable action which is the resource or parent resource on which action is executed.
Stores the file extension information.
Stores the definition of an object information form.
Stores the definition of an attachment data form.
Stores the definition of a history form.
Stores form type templates.
Stores the name of form types and corresponding table names.
Stores the definition of security for a CA Harvest SCM form.
Stores the definition of form types.
Stores the definition of CA Harvest SCM object attributes.
Identifies which valid audit events are allowed to be logged at run-time, if auditing is enabled for the CA Harvest SCM server.
Stores the definition of an interactive merge process.
Stores the definition of security for a CA Harvest SCM item.
Stores the definition of an object of an item.
Stores the definition of an object of an item.
Stores the definition of a linked process.
Stores the definition of a list difference process.
Stores the definition of a list version process.
Stores the definition of a move item process.
Stores the definition of a move path process.
Stores the definition of a move package process.
Stores an example of a custom form.
Stores the definition of a notify process.
Stores the definition of notification requirements.
Contains a list of the tables that use sequences and the corresponding name of the sequence they use.
Stores an example of a custom form.
Stores the definition of a package.
Stores the definition of the related package group.
Tracks the unique names of generated packages.
Stores package status attributes used for resetting package status. HARPACKAGESTATUS stores additional information about packages whose status is not Idle or Archived. This helps the CA Harvest SCM server decide when it is safe to reset the status of a package (to Idle).
Stores the previously used passwords for the given 'UserObjId'.
Stores the password policy settings for both global and user's overrides.
Stores the full repository path to every version of an item path.
Stores information used for reporting and for providing history information on a review request. This information is recorded for user consumption. It is not displayed by any CA Harvest SCM component, but can be used to produce reports or provide an audit trail of information concerning peer reviews.
Stores information used for reporting and for providing history information on a package. HARPKGHISTORY records associated with a particular package are not deleted when the package is deleted from its associated state. This means that the size of this table will always increase and will not decrease when packages are deleted.
Stores the definition of the packages in CMEW.
Stores the relationship between packages and package groups.
Stores the definition for problem report forms.
Stores the definition of a promote process.
Stores the information for the Q and A (Questions and Answers) forms.
Stores the definition of a remove item process.
Stores the definition of a remove path process.
Stores the definition of a rename item process.
Stores the definition of a rename path process.
Stores a list of repositories available in each view.
Stores repository objects.
Stores the definition of security for a CA Harvest SCM repository.
Stores the definition of the CA Harvest SCM audit resource types.
Stores the parent-child relationships of CA Harvest SCM audit resource types to one another.
Stores the ancestral relationships of CA Harvest SCM audit resource types to one another.
Created and used only in CA Harvest SCM with Microsoft SQL Server implementation. It contains a list of the tables that require sequence numbers, and the corresponding value of the current sequence.
Stores the definition of a take snapshot process.
Stores state information.
Stores the definition of security for a CA Harvest SCM state.
Stores the definition of each process state.
Stores the definition of security for a CA Harvest SCM process.
Stores the definition of a switch package process.
Stores the identification of release versions.
Stores the definition of a testing form.
Stores the definition of a User-defined Process.
Maintains USD target computer names. It is updated periodically by an HServer based on an HBroker.arg parameter that specifies at what interval the information is to be resynchronized.
Maintains USD software deployment information on a platform by platform basis.
Maintains USD target group names. This information is also synchronized on an interval basis.
Maintains common USD package maintenance and deployment history.
Maintains common USD package information.
Maintains USD package names. This information is synchronized on an interval basis.
Maintains USD package information on an operating system basis.
Stores the definition of users.
Stores the information for user contacts.
Stores the user data for all active users.
Stores the object user group information.
Stores the relationship between users and user groups.
Stores the BLOB data of each version.
Stores the result data of a list differences process.
Stores all version activities that occur in a view, such as check-in, promote, and demote.
Stores the version object.
Stores historic values that exist for the version at the time of the switch package operation (that is, at EXECDTIME).
Stores the view object.
Stores the definition of the custom report queries that are used to generate the SCM Project Dashboard Reports.
|
Copyright © 2013 CA.
All rights reserved.
|
|