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.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| table_name | nvarchar(40) | not null | Table Majic name |
| status | integer | not null | Modification status |
| schema_name | nvarchar(40) | with null | USD schema name |
| dbms_name | nvarchar(40) | with null | DBMS schema name |
| description | nvarchar(300) | with null | Description |
| display_name | nvarchar(80) | with null | Human-readable name |
| display_group | nvarchar(40) | with null | Grouping |
| function_group | nvarchar(40) | with null | Security function group |
| rel_attr | nvarchar(40) | with null | Foreign key column |
| common_name | nvarchar(40) | with null | Display identification col |
| sort_by | nvarchar(150) | with null | Default sort sequence |
| methods | nvarchar(500) | with null | Spell methods |
| triggers | nvarchar(500) | with null | Triggers |
| is_local | integer | with null | 1 = local table |
| is_wsp | integer | with null | 1 = table created by WSP |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the uuid of the contact who last modified this record |
Product Name: Unicenter Service Desk
Table Type: Table