Setup

This section provides information on tables and views that store QAComplete settings, such as security settings, project settings, and escalation rules. It contains definitions of projects, security groups, user profiles, and escalation rules for each project.

Critical tables and views:

• Projects table – Stores project settings.

• Projects view – Contains detailed information on created projects.

• Persons table – Stores created users.

• Persons view – Contains detailed information on users.

• PersonAddresses table – Stores user addresses.

• PersonAddresses view – Contains information on user addresses.

• SecurityGroups table – Stores the security groups registered in QAComplete.

• SecurityGroups view – Contains information on security groups created in QAComplete.

• PersonSecurityGroups table – Stores users belonging to security groups.

• PersonSecurityGroups view – Contains detailed information on users belonging to security groups in different projects.

• SecurityGroupPrivs table – Stores privilege settings of security groups.

• SecurityGroupPrivs view – Contains information on security group privileges.

• EscalationRules table – Stores escalation rules.

• EscalationRules view – Contains detailed information on escalation rules.

• EscalationRuleActions table – Stores actions used by escalation rules.

• EscalationRuleActions view – Contains detailed information on escalation rule actions.

See Also

Data Dictionary Reference