Previous Topic: wspcol TableNext Topic: Objects and Attributes


wsptbl Table

There are one to three rows in this table for every table created or updated by WSP. The columns table+name+status form a unique key. See also comments in wsp.maj for interpretation of integer codes.

Field

Data Type

Reference

Remarks

description

STRING 300

 

Identifies the description of the table.

common_name

STRING 40

 

Specifies the name for the identification column.

dbms_name

STRING 40

 

Specifies the DBMS schema name.

display_group

STRING 40

 

Identifies the Grouping to display.

display_name

STRING 80

 

Specifies the user-readable name.

function_group

STRING 40

 

Identifies the Security function group.

id

INTEGER UNIQUE NOT_NULL KEY

 

Specifies the numeric ID, which is also unique to the table.

is_local

INTEGER

 

Identifies whether the table is local (1 = local table).

is_wsp

INTEGER

 

Identifies whether the table is created by WSP (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

 

Identifies the timestamp for when this record was last modified.

methods

STRING 500

 

Identifies Spell methods.

persid

STRING 30

 

Identifies the Persistent ID: (SystemObjectName:id)

rel_attr

STRING 40

 

Specifies the Foreign key column.

schema_name

STRING 40

 

Specifies the USD schema name.

sort_by

STRING 150

 

Specifies the Default sort sequence.

status

INTEGER NOT_NULL

 

Identifies the Modification status.

table_name

STRING 40 NOT_NULL

 

Specifies the Table Majic name.

triggers

STRING 500

 

Identifies any Triggers for the table.