Deleting entities rules

When deleting Account

• Also delete link Account_To_AccountServicePointChannel.

• Also delete AccountServicePointChannel.

• Also delete link Account_To_Address.

• Also delete Address.

• Also delete link Account_To_Contact.

• Also delete Contact.

• Also delete link Account_To_ServiceProvider.

• Also delete link Customer_To_Account.

When deleting AccountServicePointChannel

• Also delete link Account_To_AccountServicePointChannel.

• Also delete link AccountServicePointChannel_To_ServicePointChannel.

When deleting Address

• Also delete link Account_To_Address.

• Also delete link Contact_To_Address.

• Also delete link Customer_To_Address.

• Also delete link Meter_To_Address.

• Also delete link Premise_To_Address.

• Also delete link ServicePoint_To_Address.

When deleting BillDeterminant

• Also delete link BillDeterminant_To_ServiceProvider.

• Also delete link TimeOfUseDefinition_To_BillDeterminant.

When deleting Charge

• Also delete link RateSchedule_To_Charge.

When deleting Collector

• Also delete link Collector_To_GISCoordinate.

• Also delete GISCoordinate.

• Also delete link RecordingDevice_To_Collector.

• Also delete link Repeater_To_Collector.

When deleting Contact

• Also delete link Account_To_Contact.

• Also delete link Contact_To_Address.

• Also delete Address.

• Also delete link Contact_To_ContactNotification.

• Also delete ContactNotification.

• Also delete link Customer_To_Contact.

• Also delete link Meter_To_Contact.

• Also delete link Premise_To_Contact.

• Also delete link ServicePoint_To_Contact.

When deleting ContactNotification

• Also delete link Contact_To_ContactNotification.

When deleting Customer:

• Also delete link Customer_To_Account.

• Also delete link Customer_To_Address.

• Also delete Address.

• Also delete link Customer_To_Contact.

• Also delete Contact.

• Also delete link Customer_To_MyMeterListGroup.

• Also delete MyMeterListGroup if nothing else links to it.

• Also delete link Customer_To_NodeGroup.

• Also delete NodeGroup if nothing else links to it.

When deleting ExternalSystemRecorderMap

• Also delete link ExternalSystemRecorderMap_To_IntervalChannel.

• Also delete link ExternalSystemRecorderMap_To_RegisterChannel.

When deleting Formula

• Also delete link Formula_To_FormulaTerminationCondition.

• Also delete FormulaTerminationCondition.

• Also delete link FormulaChannel_To_Formula.

When deleting FormulaChannel

• Also delete link FormulaChannel_To_Formula.

• Also delete link FormulaChannel_To_NamedFormula.

• Also delete link ServicePointChannel_To_FormulaChannel.

When deleting FormulaConstant

• Also delete link ServicePoint_To_FormulaConstant.

• Also delete link ServicePointChannel_To_FormulaConstant.

When deleting FormulaTerminationCondition

• Also delete link Formula_To_FormulaTerminationCondition.

• Also delete link NamedFormula_To_FormulaTerminationCondition.

When deleting GISCoordinate

• Also delete link Collector_To_GISCoordinate.

• Also delete link Meter_To_GISCoordinate.

• Also delete link Premise_To_GISCoordinate.

• Also delete link RecordingDevice_To_GISCoordinate.

• Also delete link Repeater_To_GISCoordinate.

• Also delete link ServicePoint_To_GISCoordinate.

• Also delete link Transformer_To_GISCoordinate.

When deleting ImportedChannel

• Also delete link ServicePointChannel_To_ImportedChannel.

When deleting IntervalChannel

• Also delete link ExternalSystemRecorderMap_To_IntervalChannel.

• Also delete link IntervalChannel_To_RecordingDevice.

• Also delete link Meter_To_IntervalChannel.

• Also delete link ServicePointChannel_To_IntervalChannel.

When deleting IntervalChargeAmount

• Also delete link ServicePointChannel_To_IntervalChargeAmount.

When deleting Meter

• Also delete link Meter_To_Address.

• Also delete Address.

• Also delete link Meter_To_Contact.

• Also delete Contact.

• Also delete link Meter_To_GISCoordinate.

• Also delete GISCoordinate.

• Also delete link Meter_To_IntervalChannel.

• Also delete IntervalChannel.

• Also delete link Meter_To_MeterCollectionSystem.

• Also delete MeterCollectionSystem.

• Also delete link Meter_To_RegisterChannel.

• Also delete RegisterChannel.

When deleting MeterCollectionSystem

• Also delete link Meter_To_MeterCollectionSystem.

When deleting MV90PortableReader

• Also delete link Route_To_MV90PortableReader.

When deleting MV90RecordingDevice

• Also delete link RecordingDevice_To_MV90RecordingDevice.

When deleting MyMeterListGroup

• Also delete link Customer_To_MyMeterListGroup.

• Also delete link NodeGroup_To_MyMeterListGroup.

• Also delete NodeGroup if nothing else links to it.

• Also delete link ServicePoint_To_MyMeterListGroup.

When deleting NamedFormula

• Also delete link FormulaChannel_To_NamedFormula.

• Also delete link NamedFormula_To_FormulaTerminationCondition.

• Also delete FormulaTerminationCondition.

When deleting NodeGroup

• Also delete link Customer_To_NodeGroup.

• Also delete link NodeGroup_To_MyMeterListGroup.

• Also delete MyMeterListGroup if nothing else links to it.

• Also delete link Premise_To_NodeGroup.

• Also delete link ServicePoint_To_NodeGroup.

When deleting Premise

• Also delete link Premise_To_Address.

• Also delete Address.

• Also delete link Premise_To_Contact.

• Also delete Contact.

• Also delete link Premise_To_GISCoordinate.

• Also delete GISCoordinate.

• Also delete link Premise_To_NodeGroup.

• Also delete NodeGroup if nothing else links to it.

• Also delete link Premise_To_ServicePoint.

When deleting RateSchedule

• Also delete link RateSchedule_To_Charge.

• Also delete link ServiceProvider_To_RateSchedule.

When deleting RecordingDevice

• Also delete link IntervalChannel_To_RecordingDevice.

• Also delete link RecordingDevice_To_Collector.

• Also delete link RecordingDevice_To_GISCoordinate.

• Also delete GISCoordinate.

• Also delete link RecordingDevice_To_MV90RecordingDevice.

• Also delete MV90RecordingDevice.

• Also delete link RecordingDevice_To_Repeater.

• Also delete link RegisterChannel_To_RecordingDevice.

When deleting RegisterChannel

• Also delete link ExternalSystemRecorderMap_To_RegisterChannel.

• Also delete link Meter_To_RegisterChannel.

• Also delete link RegisterChannel_To_RecordingDevice.

• Also delete link ServicePointChannel_To_RegisterChannel.

When deleting Repeater

• Also delete link RecordingDevice_To_Repeater.

• Also delete link Repeater_To_Collector.

• Also delete link Repeater_To_GISCoordinate.

• Also delete GISCoordinate.

When deleting Route

• Also delete link Route_To_MV90PortableReader.

• Also delete link Route_To_RouteHierarchy.

• Also delete RouteHierarchy.

• Also delete link Route_To_ServicePoint.

When deleting RouteHierarchy

• Also delete link Route_To_RouteHierarchy.

When deleting ServicePoint

• Also delete link Premise_To_ServicePoint.

• Also delete link Route_To_ServicePoint.

• Also delete link ServicePoint_To_Address.

• Also delete Address.

• Also delete link ServicePoint_To_Contact.

• Also delete Contact.

• Also delete link ServicePoint_To_FormulaConstant.

• Also delete FormulaConstant.

• Also delete link ServicePoint_To_GISCoordinate.

• Also delete GISCoordinate.

• Also delete link ServicePoint_To_MyMeterListGroup.

• Also delete MyMeterListGroup if nothing else links to it.

• Also delete link ServicePoint_To_NodeGroup.

• Also delete NodeGroup if nothing else links to it.

• Also delete link ServicePoint_To_ServicePointChannel.

• Also delete ServicePointChannel.

• Also delete link ServicePoint_To_Transformer.

When deleting ServicePointChannel

• Also delete link AccountServicePointChannel_To_ServicePointChannel.

• Also delete link ServicePoint_To_ServicePointChannel.

• Also delete link ServicePointChannel_To_FormulaChannel.

• Also delete FormulaChannel.

• Also delete link ServicePointChannel_To_FormulaConstant.

• Also delete FormulaConstant.

• Also delete link ServicePointChannel_To_ImportedChannel.

• Also delete ImportedChannel.

• Also delete link ServicePointChannel_To_IntervalChannel.

• Also delete link ServicePointChannel_To_IntervalChargeAmount.

• Also delete link ServicePointChannel_To_RegisterChannel.

• Also delete link ServicePointChannel_To_ServicePointChannelSet.

• Also delete ServicePointChannelSet.

• Also delete link ServicePointChannel_To_TimeOfUseSeasonBlock.

When deleting ServicePointChannelSet

• Also delete link ServicePointChannel_To_ServicePointChannelSet.

When deleting ServiceProvider

• Also delete link Account_To_ServiceProvider.

• Also delete link BillDeterminant_To_ServiceProvider.

• Also delete link ServiceProvider_To_RateSchedule.

When deleting TimeOfUseDefinition

• Also delete link TimeOfUseDefinition_To_BillDeterminant.

• Also delete link TimeOfUseDefinition_To_TimeOfUseSeasonBlock.

• Also delete TimeOfUseSeasonBlock.

When deleting TimeOfUseSeasonBlock

• Also delete link ServicePointChannel_To_TimeOfUseSeasonBlock.

• Also delete link TimeOfUseDefinition_To_TimeOfUseSeasonBlock.

When deleting Transformer

• Also delete link ServicePoint_To_Transformer.

• Also delete link Transformer_To_GISCoordinate.

• Also delete GISCoordinate.