Table UNV_COLUMNS

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

MetaMiner Database Fields

 

© 2013-2015 by Infolytik