[configuration] Create Mapping Type Option

[skarya22]

• Create the ability to map values to other values in the configuration module
• For example, LORIS visit names to External visit names

• In this example, you can set different key-value pairs of visits on LORIS (left) to visits on an external platform (right) for visit_mappings (example in screenshot)
• The mappings should be set-up in a new table, such as ConfigMappings, ConfigMaps, ConfigPairs (TBD) which would include columns for an ID, ConfigTableID and Value. The Config.Value is the left side, and ConfigMappings.Value is the right side of the mapping.
• Add mapping as a DataType in ConfigSettings
• If you want a list of multiple mappings (such as the visits example) you would use allowMultiple=1 in ConfigSettings, and enter multiple rows in Config.

[ridz1208]

The mappings should be set-up in a new table, such as ConfigMappings, ConfigMaps, ConfigPairs (TBD) which would include columns for an ID, ConfigTableID and Value. The Config.Value is the left side, and ConfigMappings.Value is the right side of the mapping.

really? we prefer this to simply creating a new table which host the whole mapping like value 1 col and value 2 col? seems messy to store the values in diff tables..

[skarya22]

The mappings should be set-up in a new table, such as ConfigMappings, ConfigMaps, ConfigPairs (TBD) which would include columns for an ID, ConfigTableID and Value. The Config.Value is the left side, and ConfigMappings.Value is the right side of the mapping.

really? we prefer this to simply creating a new table which host the whole mapping like value 1 col and value 2 col? seems messy to store the values in diff tables..

We can do that, would Config.Value just be blank then?