Previous Topic: Issue_Category TableNext Topic: Issue_Status Table


Issue_Property Table

Property value pairs for an object.

Field

Data Type

Reference

Remarks

description

nvarchar(240)

 

Specifies the textual description of this property.

error_msg

STRING 240

 

Specifies the error message produced if validation fails.

id

INTEGER

 

Primary key of this table, it is also a unique, numeric ID.

label

nvarchar(80)

 

Specifies the label value for this Issue property.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

owning_iss

nvarchar(30)

Issue

Foreign key to the persistent_id field of the iss table, this is also the Issue.

owning_macro

BOP_REF_STR NOT_NULL

Spell_Macro

Specifies the Spell_Macro for validation.

required

INTEGER

Boolean_Table::
enum

Identifies the Required flag, as follows:
0—Not required
1—Required

sample

nvarchar(240)

 

The sample value for this property.

sequence

INTEGER

 

Used to order the properties for an Issue.

value_ description

STRING 240

 

Text description of the value.

validation_rule

BOP_REF_STR NOT_NULL

Property_Validation_Rule

Identifies the valid value rule.

validation_type

BOP_REF_STR NOT_NULL

Property_Validation_Type

Identifies the type of validation rule.

value

nvarchar(240)

 

Identifies the value of the property.