Previous Topic: Product TableNext Topic: Property_Template Table


Property Table

Property value pairs for an object.

Field

Data Type

Reference

Remarks

description

nvarchar(240)

 

Identifies 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.

label

nvarchar(80)

 

Identifies the label value for this property.

last_mod_by

byte(16)

ca_contact::uuid

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

last_mod_dt

INTEGER

 

Identifies the timestamp of when this record was last modified.

object_id

INTEGER

chg id

Identifies the unique (to the table) numeric ID.

object_type

nvarchar(30)

 

Specifies the short name of the object to which this property belongs.

owning_macro

BOP_REF_STR NOT_NULL

Spell_Macro

Specifies the Spell_Macro for validation.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

property

INTEGER

Property_Template ::id

Foreign key to the id field of the prptpl table, this is the Template.

required

INTEGER

Boolean_Table::enum

Specifies the Required field as follows:
0—Not required
1—Required

sample

nvarchar(240)

 

Indicates the sample value for this property.

sequence

INTEGER

 

Specifies the sequence value for this property.

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)

 

Specifies the value of the property.