expanded

INTEGER

factory

STRING 30

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

label

STRING 80 NOT_NULL

last_mod_by

UUID

ca_contact::uuid

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

last_mod_dt

LOCAL_TIME

Indicates the timestamp of when this record was last modified.

obj_persid

STRING 60

Persistent ID (SystemObjectName:id)

parent

INTEGER

usq::id

persid

STRING 30

Persistent ID (SystemObjectName:id)

query

STRING 30

Cr_Stored_Queries::code

query_set

INTEGER

query_type

INTEGER

sequence

INTEGER NOT_NULL