Constraints

Cascade on delete

FK_sms_shift_sms_site_site_id

sms_shift.site_id

Cascade on delete

FK_groups_groups_parent_id

groups.parent_id

groups.id

Cascade on delete

FK_groups_tenants_tenant_id

groups.tenant_id

Cascade on delete

FK_domains_elements_tenants_tenant_id

domains_elements.tenant_id

Cascade on delete

FK_domains_elements_domains_domain_id

domains_elements.domain_id

domains.id

Cascade on delete

FK_domains_elements_elements_element_id

domains_elements.element_id

Cascade on delete

FK_features_versions_tenants_tenant_id

features_versions.tenant_id

Cascade on delete

FK_features_versions_features_feature_id

features_versions.feature_id

Cascade on delete

FK_layers_groups_maps_map_id

layers_groups.map_id

maps.id

Cascade on delete

FK_layers_groups_tenants_tenant_id

layers_groups.tenant_id

Cascade on delete

FK_layers_groups_layers_groups_parent_id

layers_groups.parent_id

layers_groups.id

Cascade on delete

FK_sms_kpi_sites_machines_tenants_tenant_id

sms_kpi_sites_machines.tenant_id

Cascade on delete

FK_sms_state_tenants_tenant_id

sms_state.tenant_id

Cascade on delete

FK_sms_scraper_parameters_sms_machine_machine_id

sms_scraper_parameters.machine_id

Cascade on delete

FK_sms_scraper_parameters_tenants_tenant_id

sms_scraper_parameters.tenant_id

Cascade on delete

FK_sms_other_parameters_sms_machine_machine_id

sms_other_parameters.machine_id

Cascade on delete

FK_sms_other_parameters_tenants_tenant_id

sms_other_parameters.tenant_id

Cascade on delete

FK_constraints_tenants_tenant_id

constraints.tenant_id

Cascade on delete

FK_constraints_schemas_schema_id

constraints.schema_id

schemas.id

Cascade on delete

FK_sms_loader_parameters_sms_machine_machine_id

sms_loader_parameters.machine_id

Cascade on delete

FK_sms_loader_parameters_tenants_tenant_id

sms_loader_parameters.tenant_id

Cascade on delete

FK_baselayers_maps_map_id

baselayers.map_id

maps.id

Cascade on delete

FK_baselayers_basemaps_basemap_id

baselayers.basemap_id

Cascade on delete

FK_baselayers_tenants_tenant_id

baselayers.tenant_id

Cascade on delete

FK_sms_shift_day_sms_shift_shift_id

sms_shift_day.shift_id

sms_shift.id

Cascade on delete

FK_sms_shift_day_tenants_tenant_id

sms_shift_day.tenant_id

Cascade on delete

FK_sms_truck_cycle_tenants_tenant_id

sms_truck_cycle.tenant_id

Cascade on delete

FK_sms_truck_cycle_sms_shift_day_shift_day_id

sms_truck_cycle.shift_day_id

Null on delete

FK_sms_truck_cycle_sms_zone_dump_zone_id

sms_truck_cycle.dump_zone_id

Null on delete

FK_sms_truck_cycle_sms_truck_daily_zone_dump_daily_zone_id

sms_truck_cycle.dump_daily_zone_id

Null on delete

FK_sms_truck_cycle_sms_machine_loader_id

sms_truck_cycle.loader_id

Null on delete

FK_sms_truck_cycle_sms_truck_parameters_truck_parameter_id

sms_truck_cycle.truck_parameter_id

sms_truck_parameters.id

Null on delete

FK_sms_truck_cycle_sms_loader_parameters_loader_parameter_id

sms_truck_cycle.loader_parameter_id

sms_loader_parameters.id

Null on delete

FK_sms_truck_cycle_sms_truck_daily_zone_load_daily_zone_id

sms_truck_cycle.load_daily_zone_id

Null on delete

FK_sms_truck_cycle_sms_zone_load_zone_id

sms_truck_cycle.load_zone_id

Null on delete

FK_sms_truck_cycle_features_feature_id

sms_truck_cycle.feature_id

Null on delete

FK_sms_truck_cycle_sms_machine_truck_id

sms_truck_cycle.truck_id

Restrict delete

FK_jobs_tasks_jobs_tasks_parent_id

jobs_tasks.parent_id

jobs_tasks.id

Cascade on delete

FK_jobs_tasks_tenants_tenant_id

jobs_tasks.tenant_id

Cascade on delete

FK_jobs_tasks_jobs_job_id

jobs_tasks.job_id

jobs.id

Cascade on delete

FK_sms_fixed_zone_algo_result_sms_shift_day_shift_day_id

sms_fixed_zone_algo_result.shift_day_id

Null on delete

FK_sms_fixed_zone_algo_result_sms_zone_zone_id

sms_fixed_zone_algo_result.zone_id

Null on delete

FK_sms_fixed_zone_algo_result_tenants_tenant_id

sms_fixed_zone_algo_result.tenant_id

Cascade on delete

FK_sms_fixed_zone_algo_result_sms_machine_machine_id

sms_fixed_zone_algo_result.machine_id

Restrict delete

FK_sms_fixed_zone_algo_machine_parameters_sms_machine_machine_~

sms_fixed_zone_algo_machine_parameters.machine_id

Cascade on delete

FK_sms_fixed_zone_algo_machine_parameters_tenants_tenant_id

sms_fixed_zone_algo_machine_parameters.tenant_id

Cascade on delete

FK_sms_loader_move_sms_zone_zone_id

sms_loader_move.zone_id

Null on delete

FK_sms_loader_move_tenants_tenant_id

sms_loader_move.tenant_id

Cascade on delete

FK_sms_loader_move_sms_loader_daily_zone_end_daily_zone_id

sms_loader_move.end_daily_zone_id

sms_loader_daily_zone.id

Null on delete

FK_sms_loader_move_sms_loader_daily_zone_start_daily_zone_id

sms_loader_move.start_daily_zone_id

sms_loader_daily_zone.id

Null on delete

FK_sms_loader_move_sms_shift_day_shift_day_id

sms_loader_move.shift_day_id

Null on delete

FK_sms_loader_move_features_feature_id

sms_loader_move.feature_id

Null on delete

FK_sms_loader_move_sms_loader_parameters_loader_parameter_id

sms_loader_move.loader_parameter_id

sms_loader_parameters.id

Null on delete

FK_sms_loader_move_sms_machine_loader_id

sms_loader_move.loader_id

Restrict delete

FK_layers_elements_element_id

layers.element_id

Null on delete

FK_layers_maps_map_id

layers.map_id

maps.id

Cascade on delete

FK_layers_tenants_tenant_id

layers.tenant_id

Cascade on delete

FK_layers_basemaps_basemap_id

layers.basemap_id

Null on delete

FK_layers_layers_groups_group_id

layers.group_id

layers_groups.id

Null on delete

FK_maps_groups_group_id

maps.group_id

groups.id

Null on delete

FK_maps_basemaps_basemap_id

maps.basemap_id

Null on delete

FK_maps_tenants_tenant_id

maps.tenant_id

Cascade on delete

FK_roles_components_roles_role_id

roles_components.role_id

roles.id

Cascade on delete

FK_roles_components_tenants_tenant_id

roles_components.tenant_id

Cascade on delete

FK_roles_tenants_tenant_id

roles.tenant_id

Cascade on delete

FK_features_locks_features_feature_id

features_locks.feature_id

Cascade on delete

FK_features_locks_tenants_tenant_id

features_locks.tenant_id

Cascade on delete

FK_features_locks_users_created_by

features_locks.created_by

users.id

Cascade on delete

FK_sms_truck_daily_zone_features_feature_id

sms_truck_daily_zone.feature_id

Null on delete

FK_sms_truck_daily_zone_tenants_tenant_id

sms_truck_daily_zone.tenant_id

Cascade on delete

FK_sms_truck_daily_zone_sms_zone_zone_id

sms_truck_daily_zone.zone_id

Null on delete

FK_sms_zone_features_feature_id

sms_zone.feature_id

Null on delete

FK_sms_zone_sms_zone_parent_id

sms_zone.parent_id

Cascade on delete

FK_sms_zone_tenants_tenant_id

sms_zone.tenant_id

Cascade on delete

FK_sms_zone_sms_site_site_id

sms_zone.site_id

Null on delete

FK_sms_truck_move_tenants_tenant_id

sms_truck_move.tenant_id

Cascade on delete

FK_sms_truck_move_sms_zone_zone_id

sms_truck_move.zone_id

Null on delete

FK_sms_truck_move_sms_machine_truck_id

sms_truck_move.truck_id

Restrict delete

FK_sms_truck_move_sms_truck_daily_zone_end_daily_zone_id

sms_truck_move.end_daily_zone_id

Null on delete

FK_sms_truck_move_sms_truck_daily_zone_start_daily_zone_id

sms_truck_move.start_daily_zone_id

Null on delete

FK_sms_truck_move_sms_machine_loader_id

sms_truck_move.loader_id

Null on delete

FK_sms_truck_move_features_feature_id

sms_truck_move.feature_id

Null on delete

FK_sms_truck_move_sms_truck_parameters_truck_parameter_id

sms_truck_move.truck_parameter_id

sms_truck_parameters.id

Null on delete

FK_sms_truck_move_sms_shift_day_shift_day_id

sms_truck_move.shift_day_id

Null on delete

FK_users_tenants_tenant_id

users.tenant_id

Cascade on delete

FK_users_roles_role_id

users.role_id

roles.id

Restrict delete

FK_attributes_tenants_tenant_id

attributes.tenant_id

Cascade on delete

FK_attributes_constraints_constraint_id

attributes.constraint_id

constraints.id

Null on delete

FK_attributes_elements_element_id

attributes.element_id

Cascade on delete

FK_sms_machine_site_association_tenants_tenant_id

sms_machine_site_association.tenant_id

Cascade on delete

FK_sms_machine_site_association_sms_machine_machine_id

sms_machine_site_association.machine_id

Cascade on delete

FK_sms_machine_site_association_sms_site_site_id

sms_machine_site_association.site_id

Cascade on delete

FK_schemas_tenants_tenant_id

schemas.tenant_id

Cascade on delete

FK_sms_mobile_events_tenants_tenant_id

sms_mobile_events.tenant_id

Cascade on delete

FK_sms_site_tenants_tenant_id

sms_site.tenant_id

Cascade on delete

FK_sms_teltonika_gps_data_sms_teltonika_tracker_serial_number_~

sms_teltonika_gps_data.serial_number

sms_teltonika_gps_data.tenant_id

sms_teltonika_tracker.serial_number

sms_teltonika_tracker.tenant_id

Cascade on delete

FK_sms_teltonika_gps_data_tenants_tenant_id

sms_teltonika_gps_data.tenant_id

Cascade on delete

FK_constraints_members_tenants_tenant_id

constraints_members.tenant_id

Cascade on delete

FK_constraints_members_constraints_constraint_id

constraints_members.constraint_id

constraints.id

Cascade on delete

FK_elements_schemas_schema_id

elements.schema_id

schemas.id

Cascade on delete

FK_elements_tenants_tenant_id

elements.tenant_id

Cascade on delete

FK_elements_elements_parent_id

elements.parent_id

Cascade on delete

FK_sms_machine_teltonika_tracker_sms_teltonika_tracker_tracker~

sms_machine_teltonika_tracker.tracker_serial

sms_machine_teltonika_tracker.tenant_id

sms_teltonika_tracker.serial_number

sms_teltonika_tracker.tenant_id

Cascade on delete

FK_sms_machine_teltonika_tracker_tenants_tenant_id

sms_machine_teltonika_tracker.tenant_id

Cascade on delete

FK_sms_machine_teltonika_tracker_sms_machine_machine_id

sms_machine_teltonika_tracker.machine_id

Cascade on delete

FK_sms_machine_teltonika_tracker_sms_state_state_tenant_id

sms_machine_teltonika_tracker.state

sms_machine_teltonika_tracker.tenant_id

sms_state.id

sms_state.tenant_id

Restrict delete

FK_sms_teltonika_scraper_gps_data_tenants_tenant_id

sms_teltonika_scraper_gps_data.tenant_id

Cascade on delete

FK_sms_teltonika_scraper_gps_data_sms_machine_scraper_id

sms_teltonika_scraper_gps_data.scraper_id

Cascade on delete

FK_sms_teltonika_scraper_gps_data_sms_machine_dozer_id

sms_teltonika_scraper_gps_data.dozer_id

Null on delete

FK_sms_scraper_cycle_features_feature_id

sms_scraper_cycle.feature_id

Null on delete

FK_sms_scraper_cycle_sms_scraper_parameters_scraper_parameter_~

sms_scraper_cycle.scraper_parameter_id

sms_scraper_parameters.id

Null on delete

FK_sms_scraper_cycle_sms_zone_dump_zone_id

sms_scraper_cycle.dump_zone_id

Null on delete

FK_sms_scraper_cycle_sms_dozer_parameters_dozer_parameter_id

sms_scraper_cycle.dozer_parameter_id

sms_dozer_parameters.id

Null on delete

FK_sms_scraper_cycle_sms_scraper_daily_zone_dump_daily_zone_id

sms_scraper_cycle.dump_daily_zone_id

Null on delete

FK_sms_scraper_cycle_sms_machine_scraper_id

sms_scraper_cycle.scraper_id

Restrict delete

FK_sms_scraper_cycle_sms_zone_load_zone_id

sms_scraper_cycle.load_zone_id

Null on delete

FK_sms_scraper_cycle_tenants_tenant_id

sms_scraper_cycle.tenant_id

Cascade on delete

FK_sms_scraper_cycle_sms_scraper_daily_zone_load_daily_zone_id

sms_scraper_cycle.load_daily_zone_id

Null on delete

FK_sms_scraper_cycle_sms_machine_dozer_id

sms_scraper_cycle.dozer_id

Null on delete

FK_sms_scraper_cycle_sms_shift_day_shift_day_id

sms_scraper_cycle.shift_day_id

Null on delete

FK_attachments_features_feature_id

attachments.feature_id

Cascade on delete

FK_attachments_tenants_tenant_id

attachments.tenant_id

Cascade on delete

FK_sms_machine_features_feature_id

sms_machine.feature_id

Null on delete

FK_sms_machine_sms_machine_type_type_tenant_id

sms_machine.type

sms_machine.tenant_id

sms_machine_type.id

sms_machine_type.tenant_id

Restrict delete

FK_sms_machine_tenants_tenant_id

sms_machine.tenant_id

Cascade on delete

FK_sms_machine_sms_category_category_tenant_id

sms_machine.category

sms_machine.tenant_id

sms_category.id

sms_category.tenant_id

Restrict delete

FK_sms_kpi_sites_tenants_tenant_id

sms_kpi_sites.tenant_id

Cascade on delete

FK_sms_teltonika_tracker_tenants_tenant_id

sms_teltonika_tracker.tenant_id

Cascade on delete

FK_sms_loader_daily_zone_features_feature_id

sms_loader_daily_zone.feature_id

Null on delete

FK_sms_loader_daily_zone_tenants_tenant_id

sms_loader_daily_zone.tenant_id

Cascade on delete

FK_sms_loader_daily_zone_sms_zone_zone_id

sms_loader_daily_zone.zone_id

Null on delete

FK_sms_tgd_computed_info_sms_teltonika_gps_data_id

sms_tgd_computed_info.id

sms_teltonika_gps_data.id

Cascade on delete

FK_sms_tgd_computed_info_sms_shift_day_shift_day_id

sms_tgd_computed_info.shift_day_id

Null on delete

FK_sms_tgd_computed_info_tenants_tenant_id

sms_tgd_computed_info.tenant_id

Cascade on delete

FK_domains_domains_parent_id

domains.parent_id

domains.id

Cascade on delete

FK_domains_tenants_tenant_id

domains.tenant_id

Cascade on delete

FK_domains_schemas_schema_id

domains.schema_id

schemas.id

Cascade on delete

FK_sms_machine_type_tenants_tenant_id

sms_machine_type.tenant_id

Cascade on delete

FK_sms_hiboo_equipment_features_feature_id

sms_hiboo_equipment.feature_id

Null on delete

FK_sms_hiboo_equipment_tenants_tenant_id

sms_hiboo_equipment.tenant_id

Cascade on delete

FK_groups_users_tenants_tenant_id

groups_users.tenant_id

Cascade on delete

FK_groups_users_groups_group_id

groups_users.group_id

groups.id

Cascade on delete

FK_groups_users_users_user_id

groups_users.user_id

users.id

Cascade on delete

FK_sms_dozer_parameters_tenants_tenant_id

sms_dozer_parameters.tenant_id

Cascade on delete

FK_sms_dozer_parameters_sms_machine_machine_id

sms_dozer_parameters.machine_id

Cascade on delete

FK_sms_scraper_daily_zone_sms_zone_zone_id

sms_scraper_daily_zone.zone_id

Null on delete

FK_sms_scraper_daily_zone_features_feature_id

sms_scraper_daily_zone.feature_id

Null on delete

FK_sms_scraper_daily_zone_tenants_tenant_id

sms_scraper_daily_zone.tenant_id

Cascade on delete

FK_layers_styles_tenants_tenant_id

layers_styles.tenant_id

Cascade on delete

FK_layers_styles_layers_layer_id

layers_styles.layer_id

layers.id

Cascade on delete

FK_sms_site_parameters_sms_site_site_id

sms_site_parameters.site_id

Cascade on delete

FK_sms_site_parameters_tenants_tenant_id

sms_site_parameters.tenant_id

Cascade on delete

FK_sms_hiboo_daily_data_sms_hiboo_equipment_equipment_id

sms_hiboo_daily_data.equipment_id

sms_hiboo_equipment.id

Cascade on delete

FK_sms_hiboo_daily_data_tenants_tenant_id

sms_hiboo_daily_data.tenant_id

Cascade on delete

FK_features_tenants_tenant_id

features.tenant_id

Cascade on delete

FK_features_elements_element_id

features.element_id

Cascade on delete

FK_features_features_parent_id

features.parent_id

Cascade on delete

FK_sms_zone_attributes_sms_zone_zone_id

sms_zone_attributes.zone_id

Cascade on delete

FK_sms_zone_attributes_tenants_tenant_id

sms_zone_attributes.tenant_id

Cascade on delete

FK_sms_kpi_machines_cycles_tenants_tenant_id

sms_kpi_machines_cycles.tenant_id

Cascade on delete

FK_jobs_tenants_tenant_id

jobs.tenant_id

Cascade on delete

FK_sms_category_tenants_tenant_id

sms_category.tenant_id

Cascade on delete

FK_sms_scraper_move_sms_scraper_daily_zone_end_daily_zone_id

sms_scraper_move.end_daily_zone_id

Null on delete

FK_sms_scraper_move_sms_zone_zone_id

sms_scraper_move.zone_id

Null on delete

FK_sms_scraper_move_tenants_tenant_id

sms_scraper_move.tenant_id

Cascade on delete

FK_sms_scraper_move_sms_machine_scraper_id

sms_scraper_move.scraper_id

Restrict delete

FK_sms_scraper_move_sms_scraper_parameters_scraper_parameter_id

sms_scraper_move.scraper_parameter_id

sms_scraper_parameters.id

Null on delete

FK_sms_scraper_move_sms_shift_day_shift_day_id

sms_scraper_move.shift_day_id

Null on delete

FK_sms_scraper_move_sms_scraper_daily_zone_start_daily_zone_id

sms_scraper_move.start_daily_zone_id

Null on delete

FK_sms_scraper_move_sms_machine_dozer_id

sms_scraper_move.dozer_id

Null on delete

FK_sms_scraper_move_features_feature_id

sms_scraper_move.feature_id

Null on delete

FK_sms_truck_parameters_sms_machine_machine_id

sms_truck_parameters.machine_id

Cascade on delete

FK_sms_truck_parameters_tenants_tenant_id

sms_truck_parameters.tenant_id

Cascade on delete

FK_basemaps_tenants_tenant_id

basemaps.tenant_id

Cascade on delete

FK_basemaps_basemaps_parent_id

basemaps.parent_id