Columns deconstructed from known SQL statements of Webi, Deski reports.
Column Name |
Data Type |
Description |
|---|---|---|
CMSID |
varchar |
The actualy name of the CMS host machine without the port number, if used. В This is used in conjunction with OBJECTID or CUID to uniquely identify an object across environments |
COLUMNTYPE |
int |
Column Type |
DATATYPE |
int |
Data type |
ID |
int |
ID of the column (globally unique) |
META_TABLE_ID |
int |
Foreign key to the Table holding this column (META_TABLES.ID) |
NAME |
varchar |
The name of the object, in many cases the equivalent of SI_ID in the CMS/Query Builder when referring to a base CMS object type (USERS, SEMANTICLAYER etc.) |
SCHEMAOBJECTTYPE |
varchar |
Schema object type |
See also