90 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| rel_od_sia405cc_cable_point_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_sia405cc_cable_point_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_point_elevation_determination |
|
|
Restrict delete | ||
| rel_sia405cc_cable_point_owner |
|
|
Null on delete | ||
| fkey_vl_sia405cc_cable_point_status |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_point_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_point_kind |
|
|
Restrict delete | ||
| rel_structure_owner |
|
|
Null on delete | ||
| fkey_vl_structure_condition |
|
|
Restrict delete | ||
| fkey_vl_structure_measuring_system |
|
|
Restrict delete | ||
| fkey_vl_structure_drainage_pump |
|
|
Restrict delete | ||
| fkey_vl_structure_kind |
|
|
Restrict delete | ||
| fkey_vl_structure_venting |
|
|
Restrict delete | ||
| rel_od_structure_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_structure_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_structure_power_connection |
|
|
Restrict delete | ||
| fkey_vl_structure_discharge_type |
|
|
Restrict delete | ||
| fkey_vl_structure_grid_type |
|
|
Restrict delete | ||
| rel_structure_construction_company |
|
|
Null on delete | ||
| rel_od_structure_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_structure_status |
|
|
Restrict delete | ||
| rel_structure_line_structure |
|
|
Cascade on delete | ||
| rel_od_organisation_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_organisation_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_organisation_organisation_type |
|
|
Restrict delete | ||
| fkey_vl_organisation_status |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_status |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_cable_type |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_elevation_determination |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_function |
|
|
Restrict delete | ||
| rel_cable_owner |
|
|
Null on delete | ||
| rel_od_sia405cc_cable_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_sia405cc_cable_fk_dataprovider |
|
|
Restrict delete | ||
| rel_pipe_point_owner |
|
|
Null on delete | ||
| rel_od_pipe_point_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_pipe_point_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_elevation_determination |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_normal_material |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_normal_armature_setting |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_normal_kind |
|
|
Restrict delete | ||
| oorel_od_pipe_point_normal_pipe_point |
|
|
Cascade on delete | ||
| rel_trench_point_owner |
|
|
Null on delete | ||
| fkey_vl_trench_point_elevation_determination |
|
|
Restrict delete | ||
| rel_od_trench_point_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_trench_point_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_trench_point_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_trench_point_kind |
|
|
Restrict delete | ||
| fkey_vl_trench_cable_conduits |
|
|
Restrict delete | ||
| rel_trench_owner |
|
|
Null on delete | ||
| fkey_vl_trench_trench_type |
|
|
Restrict delete | ||
| fkey_vl_trench_status |
|
|
Restrict delete | ||
| fkey_vl_trench_embedding |
|
|
Restrict delete | ||
| rel_od_trench_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_trench_control_system |
|
|
Restrict delete | ||
| rel_od_trench_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_trench_horizontal_positioning |
|
|
Restrict delete | ||
| rel_trench_construction_company |
|
|
Null on delete | ||
| fkey_vl_sia405pt_protection_tube_material |
|
|
Restrict delete | ||
| rel_od_sia405pt_protection_tube_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_sia405pt_protection_tube_status |
|
|
Restrict delete | ||
| fkey_vl_sia405pt_protection_tube_horizontal_positioning |
|
|
Restrict delete | ||
| rel_sia405pt_protection_tube_owner |
|
|
Null on delete | ||
| rel_od_sia405pt_protection_tube_fk_pipe_section |
|
|
Restrict delete | ||
| rel_od_sia405pt_protection_tube_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_data_media_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_data_media_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_data_media_kind |
|
|
Restrict delete | ||
| fkey_vl_file_kind |
|
|
Restrict delete | ||
| rel_file_data_media |
|
|
Null on delete | ||
| rel_od_file_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_file_classname |
|
|
Restrict delete | ||
| rel_od_file_fk_dataprovider |
|
|
Restrict delete | ||
| rel_trench_line_trench |
|
|
Cascade on delete | ||
| fkey_vl_pipe_section_pipeline_quality |
|
|
Restrict delete | ||
| fkey_vl_pipe_section_coating |
|
|
Restrict delete | ||
| fkey_vl_pipe_section_status |
|
|
Restrict delete | ||
| rel_od_pipe_section_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_pipe_section_function |
|
|
Restrict delete | ||
| rel_pipe_section_owner |
|
|
Null on delete | ||
| fkey_vl_pipe_section_fluent |
|
|
Restrict delete | ||
| rel_od_pipe_section_fk_dataowner |
|
|
Restrict delete | ||
| rel_pipe_section_pipeline_company |
|
|
Null on delete | ||
| fkey_vl_pipe_section_insulation_kind |
|
|
Restrict delete | ||
| fkey_vl_pipe_section_pipe_type |
|
|
Restrict delete | ||
| fkey_vl_pipe_section_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_feed_category |
|
|
Restrict delete | ||
| fkey_vl_pipe_point_feed_kind |
|
|
Restrict delete | ||
| oorel_od_pipe_point_feed_pipe_point |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| sia405cc_cable_point | _condition_length_max_40 | ((char_length(condition) <= 40)) |
| sia405cc_cable_point | _name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| sia405cc_cable_point | _remark_length_max_80 | ((char_length(remark) <= 80)) |
| structure | st_documentation_length_max_40 | ((char_length(documentation) <= 40)) |
| structure | st_mandate_length_max_40 | ((char_length(mandate) <= 40)) |
| structure | st_name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| structure | st_network_area_length_max_40 | ((char_length(network_area) <= 40)) |
| structure | st_pps_length_max_40 | ((char_length(pps) <= 40)) |
| structure | st_remark_length_max_80 | ((char_length(remark) <= 80)) |
| structure | st_schema_indication_length_max_40 | ((char_length(schema_indication) <= 40)) |
| organisation | og_identifier_length_max_255 | ((char_length(identifier) <= 255)) |
| organisation | og_identifier_short_length_max_12 | ((char_length(identifier_short) <= 12)) |
| organisation | og_remark_length_max_255 | ((char_length(remark) <= 255)) |
| organisation | og_uid_length_max_12 | ((char_length(uid) <= 12)) |
| sia405cc_cable | _condition_length_max_40 | ((char_length(condition) <= 40)) |
| sia405cc_cable | _name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| sia405cc_cable | _remark_length_max_80 | ((char_length(remark) <= 80)) |
| pipe_point | pp_remark_length_max_80 | ((char_length(remark) <= 80)) |
| trench_point | tp_name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| trench_point | tp_remark_length_max_80 | ((char_length(remark) <= 80)) |
| trench | tr_construction_company_length_max_40 | ((char_length(construction_company) <= 40)) |
| trench | tr_documentation_length_max_40 | ((char_length(documentation) <= 40)) |
| trench | tr_mandate_length_max_40 | ((char_length(mandate) <= 40)) |
| trench | tr_name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| trench | tr_remark_length_max_80 | ((char_length(remark) <= 80)) |
| sia405pt_protection_tube | _condition_length_max_30 | ((char_length(condition) <= 30)) |
| sia405pt_protection_tube | _name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| sia405pt_protection_tube | _nominal_diameter_length_max_10 | ((char_length(nominal_diameter) <= 10)) |
| sia405pt_protection_tube | _remark_length_max_80 | ((char_length(remark) <= 80)) |
| data_media | vo_identifier_length_max_60 | ((char_length(identifier) <= 60)) |
| data_media | vo_location_length_max_50 | ((char_length(location) <= 50)) |
| data_media | vo_path_length_max_1023 | ((char_length(path) <= 1023)) |
| data_media | vo_remark_length_max_80 | ((char_length(remark) <= 80)) |
| file | fi_identifier_length_max_120 | ((char_length(identifier) <= 120)) |
| file | fi_object_length_max_16 | ((char_length(object) <= 16)) |
| file | fi_path_relative_length_max_200 | ((char_length(path_relative) <= 200)) |
| file | fi_remark_length_max_80 | ((char_length(remark) <= 80)) |
| pipe_section | ps_documentation_length_max_40 | ((char_length(documentation) <= 40)) |
| pipe_section | ps_mandate_length_max_40 | ((char_length(mandate) <= 40)) |
| pipe_section | ps_name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| pipe_section | ps_nominal_diameter_length_max_10 | ((char_length(nominal_diameter) <= 10)) |
| pipe_section | ps_pipe_brand_length_max_40 | ((char_length(pipe_brand) <= 40)) |
| pipe_section | ps_remark_length_max_80 | ((char_length(remark) <= 80)) |