See Also

Quality Center Database

See Also Quality Center Database

BUG Table

Description

Information about defects.

Remarks

For table relationships, see the Defect Module Overview.

Columns

  Column Name Description Datatype Length Allow
Nulls
Primary Key  BG_BUG_ID The defect record ID. Integer 4  
  BG_STATUS The current status of the defect.

The values are from the Bug Status custom list. Typical values are: Open, Fixed, Closed, New, Rejected, and Reopen.

VarChar 70
  BG_RESPONSIBLE The name of the developer responsible for fixing the defect. VarChar 60
  BG_PROJECT The name of the project in which the defect was found. 

The values are from the All Projects custom list.

VarChar 70
  BG_SUBJECT The subject in the test plan tree to which the bug is related: ALL_LISTS.AL_ITEM_ID. Integer 4
  BG_SUMMARY A summary of the defect. VarChar 255
  BG_DESCRIPTION A description of the defect. LongVarChar 16
  BG_DEV_COMMENTS Comments about the defect, usually by the developer responsible for the defect. LongVarChar 16
  BG_REPRODUCIBLE Indicates whether the tester was able to reproduce the defect. VarChar 1
  BG_SEVERITY The severity level of the defect.

The values are from the Severity custom list.

Typical values are: 1-Low, 2-Medium, 3-High, 4-Very High, 5-Urgent.

VarChar 70
  BG_PRIORITY The priority level of the defect.

The values are from the Priority custom list.

Typical values are: 1-Low, 2-Medium, 3-High, 4-Very High, 5-Urgent.

VarChar 70
  BG_DETECTED_BY The user name of the tester who found the defect. VarChar 60
  BG_DETECTION_DATE The date the defect was found. DBTimeStamp 4
  BG_DETECTION_VERSION The version in which the defect was detected. VarChar 70
  BG_PLANNED_CLOSING_VER The version in which the developer estimates the defect will be closed. VarChar 70
  BG_ESTIMATED_FIX_TIME The number of days the developer estimates will be required to fix the defect. Integer 4
  BG_ACTUAL_FIX_TIME The number of days worked to fix the defect. Integer 4
  BG_CLOSING_DATE The date the defect record was closed. DBTimeStamp 4
  BG_CLOSING_VERSION The version in which the defect record was closed. VarChar 70
  BG_TO_MAIL Indicates whether a defect report should be mailed to users registered to receive such reports. VarChar 1
  BG_ATTACHMENT Indicates whether the defect record has any attachments.

 The value of this field can be either Y or N.

VarChar 1
  BG_USER_01 User-defined field. VarChar 40
  BG_USER_02 User-defined field. VarChar 40
  BG_USER_03 User-defined field. VarChar 40
  BG_USER_04 User-defined field. VarChar 40
  BG_USER_05 User-defined field. VarChar 40
  BG_USER_06 User-defined field. VarChar 40
  BG_USER_07 User-defined field. VarChar 40
  BG_USER_08 User-defined field. VarChar 40
  BG_USER_09 User-defined field. VarChar 40
  BG_USER_10 User-defined field. VarChar 40
  BG_USER_11 User-defined field. VarChar 40
  BG_USER_12 User-defined field. VarChar 40
  BG_USER_13 User-defined field. VarChar 40
  BG_USER_14 User-defined field. VarChar 40
  BG_USER_15 User-defined field. VarChar 40
  BG_USER_16 User-defined field. VarChar 40
  BG_USER_17 User-defined field. VarChar 40
  BG_USER_18 User-defined field. VarChar 40
  BG_USER_19 User-defined field. VarChar 40
  BG_USER_20 User-defined field. VarChar 40
  BG_USER_21 User-defined field. VarChar 40
  BG_USER_22 User-defined field. VarChar 40
  BG_USER_23 User-defined field. VarChar 40
  BG_USER_24 User-defined field. VarChar 40
  BG_USER_HR_01 BG_USER_HR_01 to BG_USER_HR_06 are for backward compatibility. Fields may be removed in future version. Integer 4
  BG_BUG_VER_STAMP A number indicating the revision number of this record. Increments each time a change is made. Integer 4
  BG_HAS_CHANGE For backward compatibility. VarChar 50
  BG_VTS The version time stamp. Indicates the time this record was last changed according to the database server. VarChar 20
  BG_EXTENDED_REFERENCE For internal use.  Do not change data. VarChar 50
  BG_REQUEST_ID The ITG Request ID. This field is used internally by ITG to link ITG requests to defects. Integer 4
  BG_TEXT_SYNC For internal use. Do not change data. VarChar 1
  BG_REQUEST_SERVER The URL of the ITG server. This field is used internally by ITG. VarChar 120
  BG_REQUEST_TYPE The ITG request type. This field is used internally by ITG. VarChar 120
  BG_REQUEST_NOTE The notes added to the linked request in ITG. LongVarChar 16
  BG_CYCLE_ID For backward compatibility. Integer 4
  BG_TEST_REFERENCE For backward compatibility. Integer 4
  BG_CYCLE_REFERENCE For backward compatibility. VarChar 255
  BG_RUN_REFERENCE For backward compatibility. Integer 4
  BG_STEP_REFERENCE For backward compatibility. Integer 4
  BG_DETECTED_IN_REL The RELEASES.REL_ID of the release in which the defect was detected. Integer 4
  BG_DETECTED_IN_RCYC The RELEASE_CYCLES.RCYC_ID of the release cycle in which the defect was detected. Integer 4
  BG_TARGET_REL The RELEASES.REL_ID of the release in which the defect is planned to be fixed. Integer 4
  BG_TARGET_RCYC The RELEASE_CYCLES.RCYC_ID of the release cycle in which the defect is planned to be fixed. Integer 4

Indexes

Index Primary Unique
BG_PRIMARYKEY
BG_COMPOUND_IDX  
BG_TO_MAIL_IDX    

Triggers

Trigger Description
AUTR66132_BUG  

See Also

Quality Center Database



Copyright 2002-2007 Mercury Interactive Corporation.

Documentation comments or suggestions?
Please send feedback to SW-Doc@hp.com