247 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| FK_path_georeference |
|
|
Restrict delete | ||
| FK_command_acknowledge_device |
|
|
Restrict delete | ||
| FK_omnitracsuser_client |
|
|
Restrict delete | ||
| FK_omnitracsuser_user |
|
|
Restrict delete | ||
| FK_alertconf_georeference_alertconf |
|
|
Restrict delete | ||
| FK_alertconf_georeference_georeference |
|
|
Cascade on delete | ||
| FK_mayauser_message_mayauser |
|
|
Restrict delete | ||
| fk_integration_topic |
|
|
Restrict delete | ||
| fk_mayauser |
|
|
Restrict delete | ||
| idunit_inspection_fk |
|
|
Restrict delete | ||
| iddriver_inspection_fk |
|
|
Restrict delete | ||
| fk_event_ecm_iddevice |
|
|
Restrict delete | ||
| FK_Vehicle_unit |
|
|
Restrict delete | ||
| fk_iddevice |
|
|
Restrict delete | ||
| FK_coverage_usergroup_mayausergroup |
|
|
Cascade on delete | ||
| FK_coverage_usergroup_coverage |
|
|
Cascade on delete | ||
| fk_digital_outputport_cfg_peripheral_template_idperipheral_temp |
|
|
Restrict delete | ||
| fk_driverpref_iddriver |
|
|
Restrict delete | ||
| FK_device_peripheral_device |
|
|
Restrict delete | ||
| fk_digital_inputport_cfg_peripheral_template_idperipheral_templ |
|
|
Restrict delete | ||
| fk_idunit_current_ecmevent_parameter_list |
|
|
Restrict delete | ||
| fk_serialcfg_bus |
|
|
Restrict delete | ||
| fk_trailer_unit |
|
|
Restrict delete | ||
| FK_sharedview_unitgroup_sharedview |
|
|
Restrict delete | ||
| FK_sharedview_unitgroup_unitgroup |
|
|
Restrict delete | ||
| fk_peripheral_template |
|
|
Restrict delete | ||
| FK_report_unitgroup_report |
|
|
Restrict delete | ||
| fk_report_unitgroup_idunitgroup |
|
|
Restrict delete | ||
| FK_report_unitgroup_unitgroup |
|
|
Restrict delete | ||
| fk_idunit_unit_driverloginconf |
|
|
Restrict delete | ||
| FK_geozone_georeference |
|
|
Cascade on delete | ||
| FK_coverage_client |
|
|
Restrict delete | ||
| fk_indicator_indicator_icon |
|
|
Restrict delete | ||
| fk_indicator_indicator_type |
|
|
Restrict delete | ||
| fk_indicator_idclient |
|
|
Restrict delete | ||
| FK_externalcontact_alertconf |
|
|
Restrict delete | ||
| FK_externalcontact_report |
|
|
Restrict delete | ||
| FK_role_client |
|
|
Restrict delete | ||
| fk_message_mayauser |
|
|
Restrict delete | ||
| FK_message_device |
|
|
Restrict delete | ||
| message_driver_fk_iddriver |
|
|
Restrict delete | ||
| fk_viewed_by_user |
|
|
Restrict delete | ||
| fk_iddevice |
|
|
Restrict delete | ||
| fk_idunit |
|
|
Restrict delete | ||
| FK_alertconfscalinguser_user |
|
|
Restrict delete | ||
| FK_alertconfscalinguser_alertconf |
|
|
Restrict delete | ||
| fk_command_commandtype |
|
|
Restrict delete | ||
| FK_coverage_unitgroup_unitgroup |
|
|
Cascade on delete | ||
| FK_coverage_unitgroup_coverage |
|
|
Cascade on delete | ||
| fk_alert_recent_iddevice |
|
|
Restrict delete | ||
| connex_request_log_iddevice_fkey |
|
|
Restrict delete | ||
| connex_request_log_idmayauser_fkey |
|
|
Restrict delete | ||
| fk_idsharedvehicle |
|
|
Restrict delete | ||
| fk_idunit |
|
|
Restrict delete | ||
| derate_request_status_iddevice_fkey |
|
|
Restrict delete | ||
| fk_alertconf_toll_toll |
|
|
Restrict delete | ||
| fk_alertconf_toll_alertconf |
|
|
Restrict delete | ||
| route_definition_idcreation_mayauser_fkey |
|
|
Restrict delete | ||
| route_definition_idmodification_mayauser_fkey |
|
|
Restrict delete | ||
| route_definition_idclient_fkey |
|
|
Restrict delete | ||
| fk_mvw_mayauser_device_idmayauser |
|
|
Restrict delete | ||
| fk_mvw_mayauser_device_iddevice |
|
|
Restrict delete | ||
| FK_report_georeference_georeference |
|
|
Restrict delete | ||
| FK_report_georeference_report |
|
|
Restrict delete | ||
| fk_modifiedbyuser |
|
|
Restrict delete | ||
| fk_createdbyuser |
|
|
Restrict delete | ||
| FK_unit_unitgroup_unit |
|
|
Restrict delete | ||
| FK_unit_unitgroup_unitgroup |
|
|
Restrict delete | ||
| FK_driver_client |
|
|
Restrict delete | ||
| fk_alert_alertconf |
|
|
Restrict delete | ||
| fk_mvw_device_alert_device |
|
|
Restrict delete | ||
| fk_ecmerrorcode_history_idunit |
|
|
Restrict delete | ||
| fk_report_georeferencecategory_idgeocategory |
|
|
Restrict delete | ||
| fk_report_georeferencecategory_idreport |
|
|
Restrict delete | ||
| FK_report_georeferencecategory_report |
|
|
Restrict delete | ||
| FK_report_georeferencecategory_georeferencecategory |
|
|
Restrict delete | ||
| fk_customer |
|
|
Restrict delete | ||
| fk_mayauser_report_idreport |
|
|
Restrict delete | ||
| fk_mayauser_report_idmayauser |
|
|
Restrict delete | ||
| FK_georeferencecatgeoreference |
|
|
Restrict delete | ||
| FK_georeference_client |
|
|
Restrict delete | ||
| fk_port_iddevice |
|
|
Restrict delete | ||
| fk_port_porttype |
|
|
Restrict delete | ||
| fk_alert_last_iddevice |
|
|
Restrict delete | ||
| FK_driver_alertconf_driver |
|
|
Restrict delete | ||
| FK_driver_alertconf_alertconf |
|
|
Restrict delete | ||
| fk_macroconf_processor_macroconf |
|
|
Restrict delete | ||
| FK_coverage_command_command |
|
|
Restrict delete | ||
| FK_coverage_command_coverage |
|
|
Restrict delete | ||
| fk_idunit_current_driverlogin |
|
|
Restrict delete | ||
| fk_current_driverlogin_iddriver |
|
|
Restrict delete | ||
| fk_product_feature_idproduct |
|
|
Restrict delete | ||
| fk_product_feature_idfeature |
|
|
Restrict delete | ||
| fk_feature_idfeaturetype |
|
|
Restrict delete | ||
| fk_peripheral_idperipheraltype |
|
|
Restrict delete | ||
| fk_peripheral_idperipheral_template |
|
|
Restrict delete | ||
| fk_idunit_current_ecmevent_parameter |
|
|
Restrict delete | ||
| fk_plainmsg_driver |
|
|
Restrict delete | ||
| fk_feedbacktype |
|
|
Restrict delete | ||
| fk_idmayauser |
|
|
Restrict delete | ||
| fk_idvirform |
|
|
Restrict delete | ||
| fk_inputoutput_iddevice |
|
|
Restrict delete | ||
| FK_customunit_unit |
|
|
Restrict delete | ||
| FK_customunit_client |
|
|
Restrict delete | ||
| fk_ping_request_audit_device |
|
|
Restrict delete | ||
| fk_digital_inputport_cfg_idiconport |
|
|
Restrict delete | ||
| part_config_sub_sub_parent_fkey |
|
|
Cascade on delete | ||
| fk_event_temperature_iddevice |
|
|
Restrict delete | ||
| FK_shipperconf_clientowner |
|
|
Restrict delete | ||
| FK_shipperconf_client |
|
|
Restrict delete | ||
| fk_toll_toll_history |
|
|
Restrict delete | ||
| fk_toll_unit |
|
|
Restrict delete | ||
| fk_ternium_mayauser_idmayauser |
|
|
Restrict delete | ||
| FK_command_modeldevice_command |
|
|
Restrict delete | ||
| FK_command_modeldevice_modeldevice |
|
|
Restrict delete | ||
| FK_report_client |
|
|
Restrict delete | ||
| fk_device_deviceconf_iddevice |
|
|
Restrict delete | ||
| fk_device_deviceconf_iddeviceconf |
|
|
Restrict delete | ||
| inspection_inspection_line_fk |
|
|
Restrict delete | ||
| FK_mayauser_mayausergroup_mayauser |
|
|
Restrict delete | ||
| FK_mayauser_mayausergroup_mayausergroup |
|
|
Restrict delete | ||
| fk_configuration_exec_iddevice |
|
|
Restrict delete | ||
| fk_configuration_exec_iduser |
|
|
Restrict delete | ||
| fk_configuration_exec_idstatus |
|
|
Restrict delete | ||
| fk_privilege_privilegegroup_idprivilege |
|
|
Restrict delete | ||
| fk_privilege_privilegegroup_idprivilegegroup |
|
|
Restrict delete | ||
| FK_sharedview_macros_sharedview |
|
|
Restrict delete | ||
| FK_shipperconf_macros_macro |
|
|
Restrict delete | ||
| fk_device_security_install_device |
|
|
Restrict delete | ||
| commandexec_port_dynamic_idcmdexe_fkey |
|
|
Restrict delete | ||
| fk_incident_iddevice |
|
|
Restrict delete | ||
| fk_geofence_history_unit |
|
|
Restrict delete | ||
| fk_ecmevent_incidence_idecmbus |
|
|
Restrict delete | ||
| fk_ecmevent_incidence_idecmeventtype |
|
|
Restrict delete | ||
| fk_ecmevent_incidence_idunit |
|
|
Restrict delete | ||
| fk_ecmevent_incidence_idecmreason |
|
|
Restrict delete | ||
| fk_ecmevent_incidence_idecmperiodicity |
|
|
Restrict delete | ||
| FK_sharedview_command_sharedview |
|
|
Restrict delete | ||
| FK_sharedview_command_command |
|
|
Restrict delete | ||
| fk_idclient |
|
|
Restrict delete | ||
| fk_idmayauser |
|
|
Restrict delete | ||
| fk_serialcfg_peripheral_template_idperipheral_template |
|
|
Restrict delete | ||
| message_device_seq_iddevice_fkey |
|
|
Restrict delete | ||
| device_derate_template_iddevice_fkey |
|
|
Restrict delete | ||
| device_derate_template_idderate_template_fkey |
|
|
Restrict delete | ||
| FK_role_privilege_role |
|
|
Restrict delete | ||
| FK_role_privilege_privilege |
|
|
Restrict delete | ||
| fk_ecmevent_idecmbus |
|
|
Restrict delete | ||
| fk_ecmevent_idecmreason |
|
|
Restrict delete | ||
| fk_ecmevent_idunit |
|
|
Restrict delete | ||
| fk_ecmevent_idecmeventtype |
|
|
Restrict delete | ||
| FK_mayausergroup_client |
|
|
Restrict delete | ||
| fk_ecmevent_parameter_idecmeventtype |
|
|
Restrict delete | ||
| fk_ecmevent_parameter_idecmperiodicity |
|
|
Restrict delete | ||
| fk_ecmevent_parameter_idecmreason |
|
|
Restrict delete | ||
| fk_ecmevent_parameter_idecmbus |
|
|
Restrict delete | ||
| fk_ecmevent_parameter_idunit |
|
|
Restrict delete | ||
| fk_unitplate_unit |
|
|
Restrict delete | ||
| FK_catgeoreference_client |
|
|
Restrict delete | ||
| FK_unitgroup_client |
|
|
Restrict delete | ||
| fk_preference_ui_setup_map |
|
|
Restrict delete | ||
| fk_georef_georefcat_georeference |
|
|
Restrict delete | ||
| fk_georef_georefcat_georeferencecategory |
|
|
Restrict delete | ||
| FK_unit_report_report |
|
|
Restrict delete | ||
| FK_unit_report_unit |
|
|
Restrict delete | ||
| fk_binarymsg_commandexec |
|
|
Restrict delete | ||
| FK_client_preference |
|
|
Restrict delete | ||
| FK_client_privilegegroup |
|
|
Restrict delete | ||
| FK_client_company |
|
|
Restrict delete | ||
| fk_client_idproduct |
|
|
Restrict delete | ||
| fk_client_idbranch |
|
|
Restrict delete | ||
| fk_iddriver_eventtype |
|
|
Restrict delete | ||
| fk_idunit_driverlogin_history |
|
|
Restrict delete | ||
| FK_landmark_georeference |
|
|
Restrict delete | ||
| fk_client_pos_status_conf_idclient |
|
|
Restrict delete | ||
| fk_client_pos_status_conf_idproduct |
|
|
Restrict delete | ||
| FK_commandexec_user |
|
|
Restrict delete | ||
| FK_commandexec_command |
|
|
Restrict delete | ||
| FK_commandexec_device |
|
|
Restrict delete | ||
| fk_technicalaccount_idproduct |
|
|
Restrict delete | ||
| FK_technicalaccount_client |
|
|
Restrict delete | ||
| FK_coverage_macros_coverage |
|
|
Restrict delete | ||
| FK_coverage_macros_macro |
|
|
Restrict delete | ||
| FK_alertconf_command_command |
|
|
Restrict delete | ||
| FK_alertconf_command_alertconf |
|
|
Restrict delete | ||
| fk_event_device |
|
|
Restrict delete | ||
| fk_idclient |
|
|
Restrict delete | ||
| vir_form_unit_fk_idunit |
|
|
Restrict delete | ||
| vir_form_product_fk_idproduct |
|
|
Restrict delete | ||
| FK_alertconf_user_user |
|
|
Restrict delete | ||
| FK_alertconf_user_alertconf |
|
|
Restrict delete | ||
| FK_template_client |
|
|
Restrict delete | ||
| FK_unit_client |
|
|
Restrict delete | ||
| FK_unit_unittype |
|
|
Restrict delete | ||
| fk_drive_workflow_mayauser |
|
|
Restrict delete | ||
| fk_drive_workflow_viewedbyuser |
|
|
Restrict delete | ||
| fk_afc_device_iddevice |
|
|
Restrict delete | ||
| fk_afcdevice_idclient |
|
|
Restrict delete | ||
| FK_device_modeldevice |
|
|
Restrict delete | ||
| FK_device_technicalaccount |
|
|
Restrict delete | ||
| FK_device_unit |
|
|
Restrict delete | ||
| fk_device_idproduct |
|
|
Restrict delete | ||
| fk_digital_outputport_cfg_idoutputport_action |
|
|
Restrict delete | ||
| fk_digital_outputport_cfg_idiconport |
|
|
Restrict delete | ||
| fk_event_arch_iddevice |
|
|
Restrict delete | ||
| fk_idvirformsection |
|
|
Restrict delete | ||
| FK_mayauser_preference |
|
|
Restrict delete | ||
| FK_mayauser_client |
|
|
Restrict delete | ||
| FK_mayauser_role |
|
|
Restrict delete | ||
| fk_device_profile_client_idclient |
|
|
Restrict delete | ||
| fk_device_profile_client_iddevice_profile |
|
|
Restrict delete | ||
| fk_macroconf_client |
|
|
Restrict delete | ||
| fk_sensor_preference_iddevice |
|
|
Restrict delete | ||
| FK_current_geofence_georeference |
|
|
Restrict delete | ||
| FK_current_geofence_unit |
|
|
Restrict delete | ||
| FK_geofence_georeference |
|
|
Cascade on delete | ||
| fk_ecmevent_errorcode_idecmbus |
|
|
Restrict delete | ||
| fk_ecmevent_errorcode_idecmeventtype |
|
|
Restrict delete | ||
| fk_ecmevent_errorcode_idecmreason |
|
|
Restrict delete | ||
| fk_ecmevent_errorcode_idunit |
|
|
Restrict delete | ||
| fk_ecmevent_errorcode_idecmperiodicity |
|
|
Restrict delete | ||
| fk_maya_user_note |
|
|
Restrict delete | ||
| fk_maya_device_note |
|
|
Restrict delete | ||
| fk_mntalertcfg_alertconf |
|
|
Restrict delete | ||
| fk_client_deviceconf |
|
|
Restrict delete | ||
| fk_client_deviceconf1 |
|
|
Restrict delete | ||
| fk_ecmerrorcode_active_idunit |
|
|
Restrict delete | ||
| fk_ecmerrorcode_active_idecmevent |
|
|
Restrict delete | ||
| fk_idgeoreference |
|
|
Restrict delete | ||
| fk_iddevice |
|
|
Restrict delete | ||
| fk_device_profile_peripheral_iddevice_profile |
|
|
Restrict delete | ||
| fk_device_profile_peripheral_idperipheral_template |
|
|
Restrict delete | ||
| FK_alertconf_unitgroup_alertconf |
|
|
Restrict delete | ||
| FK_alertconf_unitgroup_unitgroup |
|
|
Restrict delete | ||
| fk_driverloginconf_idclient |
|
|
Restrict delete | ||
| fk_ecmevent_rpmspeed_idunit |
|
|
Restrict delete | ||
| fk_ecmevent_rpmspeed_idecmbus |
|
|
Restrict delete | ||
| fk_ecmevent_rpmspeed_idecmperiodicity |
|
|
Restrict delete | ||
| fk_ecmevent_rpmspeed_idecmeventtype |
|
|
Restrict delete | ||
| fk_ecmevent_rpmspeed_idecmreason |
|
|
Restrict delete | ||
| FK_driver_unit_driver |
|
|
Restrict delete | ||
| FK_driver_unit_unit |
|
|
Restrict delete | ||
| fk_macro_macroconf |
|
|
Restrict delete | ||
| fk_client_extra_privilege_idclient |
|
|
Restrict delete | ||
| fk_client_extra_privilege_idprivilege |
|
|
Restrict delete | ||
| fk_device_updaterequest_requeststatus |
|
|
Restrict delete | ||
| fk_deviceconf_idmodeldevice |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| event_ecm | chk_event_ecm_eventcat | ((eventcat = 5)) |
| event0 | ck_event0_part_senddate_range | (((senddate >= '1969-12-31 18:00:00-06'::timestamp with time zone) AND (senddate < '1970-01-01 18:00:00-06'::timestamp with time zone))) |
| get_location_localremote | chk_logging_singlerow | ((logid = 1)) |
| part_config_sub | control_constraint_col_chk | (((sub_constraint_cols @> ARRAY[sub_control]) <> true)) |
| part_config_sub | part_config_sub_automatic_maintenance_check | (check_automatic_maintenance_value(sub_automatic_maintenance)) |
| part_config_sub | part_config_sub_epoch_check | (check_epoch_type(sub_epoch)) |
| part_config_sub | part_config_sub_type_check | (check_partition_type(sub_partition_type)) |
| part_config_sub | positive_premake_check | ((premake > 0)) |
| part_config_sub | retention_schema_not_empty_chk | ((sub_retention_schema <> ''::text)) |
| part_config | control_constraint_col_chk | (((sub_constraint_cols @> ARRAY[sub_control]) <> true)) |
| part_config | part_config_automatic_maintenance_check | (check_automatic_maintenance_value(automatic_maintenance)) |
| part_config | part_config_epoch_check | (check_epoch_type(epoch)) |
| part_config | part_config_type_check | (check_partition_type(partition_type)) |
| part_config | positive_premake_check | ((premake > 0)) |
| part_config | publications_no_empty_set_chk | ((publications <> '{}'::text[])) |
| part_config | retention_schema_not_empty_chk | ((sub_retention_schema <> ''::text)) |
| spatial_ref_sys | spatial_ref_sys_srid_check | (((srid > 0) AND (srid <= 998999))) |