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. |
|
Copyright © 2013 CA.
All rights reserved.
|
|