Previous Topic: Property_Template TableNext Topic: Property_Validation_Type Table


Property_Validation_Rule Table

Property validation rule.

Field

Data Type

Reference

Remarks

id

INTEGER UNIQUE NOT_NULL KEY

 

Specifies the primary key of this table.

persid

BOP_REF_STR

 

 

del

INTEGER NOT_NULL

 

0—Present

1—Not present

sym

STRING 30 UNIQUE NOT_NULL S_KEY

 

Specifies the name of the validation rule.

description

STRING 240

 

 

validation_type

BOP_REF_STR

Property_Validation_ Type

Specifies the type of validation rule.

error_msg

STRING 240

 

Specifies the error message produced if validation fails.

owning_macro

BOP_REF_STR

Spell_Macro

Specifies the spell_Macro for validation.

label

LABEL_SYM NOT_NULL

 

Specifies the helper to pre-populate property template.

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp indicating when this record was last modified.

last_mod_by

UUID

ca_contact

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