Data Tables
Overview
Data Tables are a mechanism for you to store and organize large volumes of data for reference from plugins. These can be referenced from any plugin and can be versioned based on effective dates using the Versioned Resource Selection feature.
Configuration
The structure of each table is established in configuration by declaring the name of the table along with the number and type of each column. A typical declaration looks like this:
{
// At the top level of the configuration
"tables": {
"personalAutoRates": {
"selectionTimeBasis": "termStartTime",
"columns": [
{
"name": "state",
"dataType": "string"
},
{
"name": "baseRate",
"dataType": "decimal"
},
{
"name": "taxRate",
"dataType": "decimal"
},
{
"name": "rateCode",
"dataType": "string"
}
]
}
}
}
This declaration declares a table with the static name personalAutoRates
, with three columns: a key column called state
and three value columns called baseRate
, taxRate
, and rateCode
.
Limitations
Tables support up to one million rows each.