description

STRING 300

Description

addl_info

STRING 500

Triggers, QREL stuff, and so on.

column_name

STRING 40 NOT_NULL

Column Majic name

dbms_name

STRING 40

DBMS schema name

display_name

STRING 80

Human-readable name

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

is_cluster

INTEGER

1 = DBMS cluster index

is_descending

INTEGER

1 = DBMS descending index

is_indexed

INTEGER

1 = DBMS-indexed column

is_local

INTEGER

1 = local column

is_not_null

INTEGER

1 = column cannot be null

is_order_by

INTEGER

1 = DBMS order by index

is_required

INTEGER

1 = column required

is_skey

INTEGER

1 = column is secondary key

is_unique

INTEGER

1 = DBMS unique index

is_write_new

INTEGER

1 = read-only after creation

is_wsp

INTEGER

1 = table created by WSP

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.

on_ci_set

STRING 80

Value to set on update

on_new_default

STRING 80

Default value of attribute

persid

STRING 30

Persistent ID (SystemObjectName:id)

schema_name

STRING 40

USD schema name

status

INTEGER NOT_NULL

Modification status

string_len

INTEGER

String len

table_name

STRING 40 NOT_NULL

Table Majic name

type

INTEGER

Column type

xrel_table

STRING 80

Operand of SRELBRELQREL