...
Value Tables
The value tables store the actual rows of the lookup table. It is the combination of LookupTable.type and LookupTable.valueType that determines which value type table will be used. The table below contain these details.
type (string) | valueType (string) | Table (class) |
|---|---|---|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
MatrixLookupTableValue
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIXMatrixLookupTableValueThe MatrixLookupTableValue has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.name – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.| Info |
|---|
When the LookupTable.valueType is MATRIX, the name of the key is name – rather than key1. |
MatrixLookupTableValue2Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue2Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX2MatrixLookupTableValue2KeyThe MatrixLookupTableValue2Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..2 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue3Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue3Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX3MatrixLookupTableValue3KeyThe MatrixLookupTableValue3Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..3 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue4Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue4Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX4MatrixLookupTableValue4KeyThe MatrixLookupTableValue4Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..4 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue5Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue5Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX5MatrixLookupTableValue5KeyThe MatrixLookupTableValue5Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..5 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue6Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue6Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX6MatrixLookupTableValue6KeyThe MatrixLookupTableValue6Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..6 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.LookupTableValue
The LookupTableValue table is used for two different types of lookup tables:
If the
LookupTable.typeisSIMPLE,SIMPLE_REAL_KEY,SIMPLE_INT_KEY, orSIMPLE_DATE_KEY, then theLookupTableValuetable is used to store key-value pairs. In this case, theLookupTable.valueTypedefines the type of the value in the key-value pair. The key is determined byLookupTable.type, while the value is determined by theLookupTable.valueType.If the
LookupTable.typeisRANGE, then theLookupTableValuetable is used to store key-value pairs, where the value is a pair of integers. This pair denotes a range. In this case, theLookupTable.valueTypedefines the type of the key in the key-value pair.
| Note |
|---|
The LookupTable.valueType is used for different purposes depending on the LookupTable.type. |
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the LookupTableValue table.
LookupTable.type – SIMPLE | SIMPLE_REAL_KEY | SIMPLE_INT_KEY | SIMPLE_DATE_KEY | RANGELookupTable.valueType – REAL | INT | STRING | DATELookupTableValueThe LookupTableValue has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.name – A primary key that can be used to uniquely identify a row. If LookupTable.type is RANGE, the LookupTable.valueType determines the type of name. Otherwise, the type of name is determined by LookupTable.type.value – If and only if the LookupTable.type is not RANGE, this property is used to store a value. The type of the value is determined by LookupTable.valueType.lowerBound – If and only if the type is RANGE, this property is used to store an integer that denotes the minimum value.upperBound – If and only if the type is RANGE, this property is used to store an integer that denotes the maximum value.JsonLookupTableValue
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the JsonLookupTableValue table.
LookupTable.type – JSONLookupTable.valueType – JSONJsonLookupTableValueThe JsonLookupTableValue has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.name – Primary key(s), whose combination uniquely identifies a single lookup table row.attributeExtension___<fieldName> – arbitrary number of attributeExtension fields, which can be used in the same way as attribute1..30 on matrix tables. The fields with String type do not have limited size.JsonLookupTableValue2Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the JsonLookupTableValue2Key table.
LookupTable.type – JSONLookupTable.valueType – JSON2JsonLookupTableValue2KeyThe JsonLookupTableValue2Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..2 – Primary key(s), whose combination uniquely identifies a single lookup table row.attributeExtension___<fieldName> – arbitrary number of attributeExtension fields, which can be used in the same way as attribute1..30 on matrix tables. The fields with String type do not have limited size.