OBJ_M_UNIVERSES

Name Null ? Type Values
M_UNI_N_ID NOT NULL int10 Primary key, see obj_m_magicid , 'UNIVERSE' row.
M_UNI_N_REPOID NOT NULL int10 ID of the universe domain in which the universe is stored (table OBJ_M_REPOSITORY, row M_REPO_N_ID)
M_UNI_C_FILENAME NOT NULL char(14) Short name of the universe: as stored on the file system when imported, with a .unv extention
M_UNI_C_LONGNAME NOT NULL char(35) Long name of the universe: entered as a universe parameter.
M_UNI_N_REVISION NOT NULL int10 Revision number, increased by each export.
M_UNI_N_LUT NOT NULL int10 Last Update Time: current date during the last export.
M_UNI_N_LOV NOT NULL int10 Number of LOVs associated to the universe (or, alternatively, number of objects of the universe with an associated LOV)
M_UNI_N_HELPSLCID NOT NULL int10 Foreign Key to OBJ_M_UNISLC.M_UNIS_N_ID (which stores a help field for the universe)
M_UNI_N_CNTID NOT NULL int10 Foreign key to OBJ_M_CONNECTION.M_CNTN_N_ID  (which stores a connection on which the universe relies)
M_UNI_N_MAXLINE NOT NULL int10 The value is the maximum number of rows that a query can retrieve from a database. When the query reaches this limit, it stops; however, the end user can still retrieve the partial results.
M_UNI_N_MAXTIME NOT NULL int10 Time such that if the execution exceeds this limit, the query stops; however, the user can retrieve the partial results.
M_UNI_N_WARNTIME NOT NULL int10 This option applies only to RDBMS with cost estimate features based on time. It causes a warning message to appear if the cost estimate exceeds the number of minutes you specify. 
M_UNI_N_ITEMLENGTH NOT NULL int10 Maximum size of a long text object that a user can retrieve from the database
M_UNI_C_FLAGS NOT NULL char(20)

A coded field for the check boxes on the "controls" and "SQL" tabs. Values are Y, N or U. Y is for checked, N for unchecked and U for unused (keep the universe value).

From left to right:

position 1: "SQL" query - Allow use of subquery

position 2: "SQL" query - Allow use of union, intersect and minus

position 3: "SQL" query - Allow complex operators in Query Panel.

position 4: "SQL" multiple paths - Multiple SQL statements for each context.

position 5: "SQL" multiple paths - Allow selection of multiple contexts.

position 6: "SQL" Cartesian Products. Prevent =Y, Warn =N

position 7: "Controls" limit size of result set:

position 8: "Controls" limit size of long text objects to:

position 9: "Controls" limit execution time to:

position 10: "Controls" warn if cost estimate exceeds:

position 11: "SQL" multiple paths - multiple SQL statements for each measure.

position 12-20: reserved.

M_UNI_N_LOCKER NOT NULL int10

0:                Unlocked

UserId:       Locked by user of ID UserID (foreign key to OBJ_M_ACTOR.M_ACTOR_N_ID). The user must be a designer.

M_UNI_N_LAD NOT NULL int10 Last Action Date
M_UNI_N_LAT NOT NULL int10 Last Action Type