rca_custom_attribute
Stores custom attributes for a review instance. It has
multiple records for each record in parent table (rca_review_context).
Custom attributes are stored as key value pair in this table. The
same table is also used to store custom attributes for a review
template.
|
Field name (Key)
|
Field data type
|
Purpose
|
|
id (PRI)
|
varchar(255)
|
The Review, Commenting, and Approval custom
attribute identifier.
|
|
attrKey
|
varchar(255)
|
The attribute key. The value can be any
user-specified name such as RESOURCE_ID.
|
|
attrValue
|
varchar(255)
|
The value of the attribute.
|
|
reviewContext(MUL)
|
varchar(255)
|
The foreign key to review context, as this
table is used to store custom attributes for review instance as
well as review template. This column can be null sometime, if it
is null and reviewTemplate field is populated that means the custom
attribute belongs to review template.
|
|
reviewTemplate(MUL)
|
varchar(255)
|
The foreign key to the review template table.
When the value is null and the reviewContext field is populated,
it indicates that the custom attribute belongs to a review instance.
|
|
attributeNo
|
int(11)
|
The index used to access a list of attributes.
The field is used for internal purposes.
|
