KCRT_FG_QC_DEFECT_INFO

This table stores information necessary to uniquely identify a defect in a Quality Center instance. This includes instance (URL of the QC server), Domain, Project, Defect ID, and so on.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

System-generated identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type ID

QC_DEFECT_DOMAIN

NULLABLE

VARCHAR2(128)

Quality Center Domain/Project that contains the defect

QC_DEFECT_PROJECT

NULLABLE

VARCHAR2(64)

Quality Center Domain/Project that contains the defect

QC_DEFECT_ASSIGN_TO_USER

NULLABLE

VARCHAR2(64)

Quality Center's user name of the person assigned to this defect

QC_DEFECT_NO

NULLABLE

NUMBER

Quality Center defect ID

QC_DEFECT_STATUS

NULLABLE

VARCHAR2(500)

Quality Center defect status

QC_DEFECT_ATTACHMENT_URL

NULLABLE

VARCHAR2(200)

A link to the Quality Center defect's attachments

QC_DEFECT_INT_MSG

NULLABLE

VARCHAR2(300)

A message informing of the status of last synchronization (failed / succeeded, errors encountered, and so on)

QC_DEFECT_DOMAIN_ID

NULLABLE

NUMBER

ID of the Quality Center domain

QC_DEFECT_PROJECT_ID

NULLABLE

NUMBER

ID of the Quality Center project

QC_DEFECT_ASSIGN_TO_USER_ID

NULLABLE

VARCHAR2(64)

ID of the Quality Center user (assigned to)

QC_DEFECT_INSTANCE

NULLABLE

VARCHAR2(200)

Quality Center instance where defect is saved

QC_DEFECT_INSTANCE_ID

NULLABLE

NUMBER

ID of the Quality Center instance

QC_DEFECT_ATT_URL_ID

NULLABLE

VARCHAR2(200)

ID of the Defect URL

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_QC_DEFECT_INFO_U1

UNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.