Schemas deconstructed from dataprovider SQL (Webi/Deski).
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 |
ID |
int |
ID of the schema (globally unique) |
ISCATALOG |
bit |
Is the schema type a catalog? |
META_CONNECTION_ID |
int |
Foreign key to META_CONNECTIONS.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 |
SCHEMATYPE |
int |
Schema Type |
See also