| 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 |
| Table | Column |
|---|---|
| NameValueType | NameValueType_PropertySets |
| Name | Columns |
|---|---|
| NameValueType1 | DataSetWID |
| NameValueType2 | Name |
| NameValueType3 | Value |
| NameValueType4 | Type_ |
| NameValueType5 | NameValueType_PropertySets |
| NameValueType6 | OtherWID |