Database columns of a Universe.
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 |
COLUMNNAME |
nvarchar |
Column Name |
COLUMNTYPE |
nvarchar |
Column Type |
CREATED |
datetime |
The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME |
ID |
int |
Primary Key |
TABLEID |
int |
Table ID (foreign key to UNV_TABLES.TABLEID) |
TABLENAME |
nvarchar |
Table Name |
UNIVERSECUID |
varchar |
Universe CUID |
UNIVERSEMUID |
varchar |
Universe MUID the class belongs to |
UNV_TABLES_ID |
int |
Foreign key to UNV_TABLES.ID |
UNV_UNIVERSES_ID |
int |
Foreign key to UNV_UNIVERSES.ID |
UPDATED |
datetime |
Datetime that this object was updated in the BusinessObjects CMS |
UPDATED_CMS |
datetime |
update time from the CMS |
See also