Table Index

NameValueType


Represents MAGE Class NameValueType
A tuple designed to store data, keyed by a name and type.

Columns

Column MySQL Type Oracle Type Nullable Description
WID BIGINT NUMBER No Warehouse identifier for this entity
DataSetWID BIGINT NUMBER No Reference to the data set from which the entity came from
Name VARCHAR VARCHAR2(255) Yes MAGE attribute NameValueType.name
The name of the key.
Value VARCHAR VARCHAR2(255) Yes MAGE attribute NameValueType.value
The value of the name.
Type_ VARCHAR VARCHAR2(255) Yes MAGE attribute NameValueType.type
The type of the key.
NameValueType_PropertySets BIGINT NUMBER Yes Represents 1..n association between NameValueType and NameValueType
Allows nested specification of name/value pairs
OtherWID BIGINT NUMBER Yes WID of the object this NameValueType describes

Referenced By

Table Column
NameValueType NameValueType_PropertySets

Other Constraints

None.

Indexes

Name Columns
NameValueType1 DataSetWID
NameValueType2 Name
NameValueType3 Value
NameValueType4 Type_
NameValueType5 NameValueType_PropertySets
NameValueType6 OtherWID