Constraints

75 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

rel_pipe_point_owner

pipe_point.fk_owner

organisation.obj_id

Null on delete

rel_od_pipe_point_fk_dataprovider

pipe_point.fk_provider

organisation.obj_id

Restrict delete

rel_od_pipe_point_fk_dataowner

pipe_point.fk_dataowner

organisation.obj_id

Restrict delete

fkey_vl_pipe_point_elevation_determination

pipe_point.elevation_determination

pipe_point_elevation_determination.code

Restrict delete

fkey_vl_pipe_point_horizontal_positioning

pipe_point.horizontal_positioning

pipe_point_horizontal_positioning.code

Restrict delete

fkey_vl_pipe_point_normal_material

pipe_point_normal.material

pipe_point_normal_material.code

Restrict delete

fkey_vl_pipe_point_normal_armature_setting

pipe_point_normal.armature_setting

pipe_point_normal_armature_setting.code

Restrict delete

fkey_vl_pipe_point_normal_kind

pipe_point_normal.kind

pipe_point_normal_kind.code

Restrict delete

oorel_od_pipe_point_normal_pipe_point

pipe_point_normal.obj_id

pipe_point.obj_id

Cascade on delete

rel_od_sia405cc_cable_point_fk_dataowner

sia405cc_cable_point.fk_dataowner

organisation.obj_id

Restrict delete

rel_od_sia405cc_cable_point_fk_dataprovider

sia405cc_cable_point.fk_provider

organisation.obj_id

Restrict delete

fkey_vl_sia405cc_cable_point_elevation_determination

sia405cc_cable_point.elevation_determination

sia405cc_cable_point_elevation_determination.code

Restrict delete

rel_sia405cc_cable_point_owner

sia405cc_cable_point.fk_owner

organisation.obj_id

Null on delete

fkey_vl_sia405cc_cable_point_status

sia405cc_cable_point.status

sia405cc_cable_point_status.code

Restrict delete

fkey_vl_sia405cc_cable_point_horizontal_positioning

sia405cc_cable_point.horizontal_positioning

sia405cc_cable_point_horizontal_positioning.code

Restrict delete

fkey_vl_sia405cc_cable_point_kind

sia405cc_cable_point.kind

sia405cc_cable_point_kind.code

Restrict delete

rel_trench_point_owner

trench_point.fk_owner

organisation.obj_id

Null on delete

fkey_vl_trench_point_elevation_determination

trench_point.elevation_determination

trench_point_elevation_determination.code

Restrict delete

rel_od_trench_point_fk_dataowner

trench_point.fk_dataowner

organisation.obj_id

Restrict delete

rel_od_trench_point_fk_dataprovider

trench_point.fk_provider

organisation.obj_id

Restrict delete

fkey_vl_trench_point_horizontal_positioning

trench_point.horizontal_positioning

trench_point_horizontal_positioning.code

Restrict delete

fkey_vl_trench_point_kind

trench_point.kind

trench_point_kind.code

Restrict delete

rel_structure_owner

structure.fk_owner

organisation.obj_id

Null on delete

fkey_vl_structure_condition

structure.condition

structure_condition.code

Restrict delete

fkey_vl_structure_measuring_system

structure.measuring_system

structure_measuring_system.code

Restrict delete

fkey_vl_structure_drainage_pump

structure.drainage_pump

structure_drainage_pump.code

Restrict delete

fkey_vl_structure_kind

structure_kind.code

Restrict delete

fkey_vl_structure_venting

structure.venting

structure_venting.code

Restrict delete

rel_od_structure_fk_dataprovider

structure.fk_provider

organisation.obj_id

Restrict delete

fkey_vl_structure_horizontal_positioning

structure.horizontal_positioning

structure_horizontal_positioning.code

Restrict delete

fkey_vl_structure_power_connection

structure.power_connection

structure_power_connection.code

Restrict delete

fkey_vl_structure_discharge_type

structure.discharge_type

structure_discharge_type.code

Restrict delete

fkey_vl_structure_grid_type

structure.grid_type

structure_grid_type.code

Restrict delete

rel_structure_construction_company

structure.fk_construction_company

organisation.obj_id

Null on delete

rel_od_structure_fk_dataowner

structure.fk_dataowner

organisation.obj_id

Restrict delete

fkey_vl_structure_status

structure.status

structure_status.code

Restrict delete

fkey_vl_trench_cable_conduits

trench.cable_conduits

trench_cable_conduits.code

Restrict delete

rel_trench_owner

trench.fk_owner

organisation.obj_id

Null on delete

fkey_vl_trench_trench_type

trench.trench_type

trench_trench_type.code

Restrict delete

fkey_vl_trench_status

trench.status

trench_status.code

Restrict delete

fkey_vl_trench_embedding

trench.embedding

trench_embedding.code

Restrict delete

rel_od_trench_fk_dataowner

trench.fk_dataowner

organisation.obj_id

Restrict delete

fkey_vl_trench_control_system

trench.control_system

trench_control_system.code

Restrict delete

rel_od_trench_fk_dataprovider

trench.fk_provider

organisation.obj_id

Restrict delete

fkey_vl_trench_horizontal_positioning

trench.horizontal_positioning

trench_horizontal_positioning.code

Restrict delete

rel_trench_construction_company

trench.fk_construction_company

organisation.obj_id

Null on delete

rel_structure_line_structure

structure_line.fk_structure

structure.obj_id

Cascade on delete

rel_od_organisation_fk_dataowner

organisation.fk_dataowner

organisation.obj_id

Restrict delete

rel_od_organisation_fk_dataprovider

organisation.fk_provider

organisation.obj_id

Restrict delete

fkey_vl_organisation_organisation_type

organisation.organisation_type

organisation_organisation_type.code

Restrict delete

fkey_vl_organisation_status

organisation.status

organisation_status.code

Restrict delete

fkey_vl_sia405cc_cable_horizontal_positioning

sia405cc_cable.horizontal_positioning

sia405cc_cable_horizontal_positioning.code

Restrict delete

fkey_vl_sia405cc_cable_status

sia405cc_cable.status

sia405cc_cable_status.code

Restrict delete

fkey_vl_sia405cc_cable_cable_type

sia405cc_cable.cable_type

sia405cc_cable_cable_type.code

Restrict delete

fkey_vl_sia405cc_cable_elevation_determination

sia405cc_cable.elevation_determination

sia405cc_cable_elevation_determination.code

Restrict delete

fkey_vl_sia405cc_cable_function

sia405cc_cable.function

sia405cc_cable_function.code

Restrict delete

rel_cable_owner

sia405cc_cable.fk_owner

organisation.obj_id

Null on delete

rel_od_sia405cc_cable_fk_dataowner

sia405cc_cable.fk_dataowner

organisation.obj_id

Restrict delete

rel_od_sia405cc_cable_fk_dataprovider

sia405cc_cable.fk_provider

organisation.obj_id

Restrict delete

rel_trench_line_trench

trench_line.fk_trench

trench.obj_id

Cascade on delete

fkey_vl_pipe_section_pipeline_quality

pipe_section.pipeline_quality

pipe_section_pipeline_quality.code

Restrict delete

fkey_vl_pipe_section_coating

pipe_section.coating

pipe_section_coating.code

Restrict delete

fkey_vl_pipe_section_status

pipe_section.status

pipe_section_status.code

Restrict delete

rel_od_pipe_section_fk_dataprovider

pipe_section.fk_provider

organisation.obj_id

Restrict delete

fkey_vl_pipe_section_function

pipe_section.function

pipe_section_function.code

Restrict delete

rel_pipe_section_owner

pipe_section.fk_owner

organisation.obj_id

Null on delete

fkey_vl_pipe_section_fluent

pipe_section.fluent

pipe_section_fluent.code

Restrict delete

rel_od_pipe_section_fk_dataowner

pipe_section.fk_dataowner

organisation.obj_id

Restrict delete

rel_pipe_section_pipeline_company

pipe_section.fk_pipeline_company

organisation.obj_id

Null on delete

fkey_vl_pipe_section_insulation_kind

pipe_section.insulation_kind

pipe_section_insulation_kind.code

Restrict delete

fkey_vl_pipe_section_pipe_type

pipe_section.pipe_type

pipe_section_pipe_type.code

Restrict delete

fkey_vl_pipe_section_horizontal_positioning

pipe_section.horizontal_positioning

pipe_section_horizontal_positioning.code

Restrict delete

fkey_vl_pipe_point_feed_category

pipe_point_feed.category

pipe_point_feed_category.code

Restrict delete

fkey_vl_pipe_point_feed_kind

pipe_point_feed.kind

pipe_point_feed_kind.code

Restrict delete

oorel_od_pipe_point_feed_pipe_point

pipe_point_feed.obj_id

pipe_point.obj_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
pipe_point	pp_remark_length_max_80	((char_length(remark) <= 80))
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))
trench_point	tp_name_number_length_max_40	((char_length(name_number) <= 40))
trench_point	tp_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))
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))
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_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))