If you have a foreign key on a volatile table, would the foreign key still be stored to the database?
Otherwise, would having foreign keys on a volatile table interfere with any of the features in DataMiner?
Hi Micah
If your table has the volatile option, it means that nothing will be stored in the database. Additionally, this option should only be used in the following cases:
- The table is not used for the DCF interface
- The table is not used for DVEs
- The save option is not enabled
- No foreign keys are used in the table
- Trending is not enabled on the table
- Alarm monitoring is not enabled on the table
In general, make sure to only use it on tables that are only displayed in the UI or used in a QAction, but are not used in any other way. Please see more info here.
It is not advised to use the volatile option in tables that are alarmed or trended because typically primary keys and foreign keys need to be maintained to preserve alarming and trending capabilities. This ensures that when an element with an alarm is restarted, the existing alarms are preserved in the alarm tree.
Regards