There are one to three rows in this table for every column created or updated by WSP. The columns table_name+column_name+status form a unique key. See also comments in wsp.maj.
| 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 |
| column_name | nvarchar(40) | not null | Column Magic 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 |
| type | integer | with null | Column type |
| string_len | integer | with null | String len |
| xrel_table | nvarchar(80) | with null | Operand of SRELBRELQREL |
| addl_info | nvarchar(500) | with null | Triggers, QREL stuff, etc. |
| on_new_default | nvarchar(80) | with null | Default value of attribute |
| on_ci_set | nvarchar(80) | with null | Value to set on update |
| is_indexed | integer | with null | 1 = DBMS-indexed column |
| is_cluster | integer | with null | 1 = DBMS cluster index |
| is_descending | integer | with null | 1 = DBMS descending index |
| is_order_by | integer | with null | 1 = DBMS order by index |
| is_unique | integer | with null | 1 = DBMS unique index |
| is_local | integer | with null | 1 = local column |
| is_not_null | integer | with null | 1 = column cannot be null |
| is_required | integer | with null | 1 = column required |
| is_skey | integer | with null | 1 = column is secondary key |
| is_write_new | integer | with null | 1 = read-only after creation |
| 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