Override Tables¶
When you create an override value for a scenario, process, or operation field in aPriori, the value is not stored in the "_facts" tables (that is, in the field that is normally used for the attribute that has been overridden). Instead, the "_override" tables hold these values because there is more information associated with an override value than just the value itself. The following fields are stored in the scenario_override, process_override, and operation_ override tables:
| Attribute | Attribute Type | Description |
|---|---|---|
| column_name | Varchar(128) | Override name |
| string_value | Varchar(255) | String value stored here if the field is a string |
| numeric_value | Double | Number stored here if the field is a number |
| comments | Varchar(255) | Comment that was entered in aPriori |
| <type>_facts_id 1 | bigint(20) FK | Pointer to the<type>_fact 1 that this field is logically part of |
There are two more tables, operation_override and process_override, that store override values for operation attributes and process attributes respectively.