Table UNV_JOINS

Universe Joins (traditional).

Column Name	Data Type	Description
CARDINALITY	nvarchar	Cardinality of the join
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
CREATED	datetime	The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME
FIRSTCOLUMN	nvarchar	First column
FIRSTTABLE	nvarchar	First table
FIRSTTABLEID	int	First Table ID
ID	int	Primary key
ISSHORTCUT	bit	Is join a shortcut join?
JOINEXPRESSION	nvarchar	Join expression
JOINID	int	Join ID used by the context
OUTERJOIN	nvarchar	Is it an outer join?
SECONDCOLUMN	nvarchar	Second column
SECONDTABLE	nvarchar	Second table
SECONDTABLEID	int	Second table ID
UNIVERSECUID	varchar	Univrese CUID
UNIVERSEMUID	varchar	Universe + CMS Server
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	Time object updated in the CMS