Tables 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 table (globally unique) |
ISALIAS |
bit |
Is the table an alias? |
META_CONNECTION_ID |
int |
Foreign key to META_CONNECTIONS.ID |
META_SCHEMA_ID |
int |
Foreign key to META_SCHEMAS.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 |
TABLETYPE |
int |
Table type |
See also