Constraints

25 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fkey_vl_status
frame.fk_status
vl_status.id
Restrict delete
fkey_vl_frame_type
frame.fk_frame_type
vl_frame_type.id
Restrict delete
fkey_od_provider
frame.fk_provider
vl_provider.id
Restrict delete
fkey_od_azimut
frame.fk_azimut
azimut.id
Restrict delete
fkey_vl_frame_fixing_type
frame.fk_frame_fixing_type
vl_frame_fixing_type.id
Restrict delete
fk_document
dms_rel_document.fk_document
dms_document.id
Restrict delete
fkey_vl_status
support.fk_status
vl_status.id
Restrict delete
fkey_vl_support_type
support.fk_support_type
vl_support_type.id
Restrict delete
fkey_od_provider
support.fk_provider
vl_provider.id
Restrict delete
fkey_od_owner
support.fk_owner
vl_owner.id
Restrict delete
fkey_vl_support_base_type
support.fk_support_base_type
vl_support_base_type.id
Restrict delete
fkey_vl_status
sign.fk_status
vl_status.id
Restrict delete
fkey_vl_coating
sign.fk_coating
vl_coating.id
Restrict delete
fkey_od_provider
sign.fk_provider
vl_provider.id
Restrict delete
fkey_vl_sign_type
sign.fk_sign_type
vl_sign_type.id
Restrict delete
fkey_vl_durability
sign.fk_durability
vl_durability.id
Restrict delete
fkey_vl_official_sign
sign.fk_official_sign
vl_official_sign.id
Restrict delete
fkey_od_sign
sign.fk_parent
sign.id
Null on delete
fkey_vl_lighting
sign.fk_lighting
vl_lighting.id
Restrict delete
fkey_vl_marker_type
sign.fk_marker_type
vl_marker_type.id
Restrict delete
fkey_vl_mirror_shape
sign.fk_mirror_shape
vl_mirror_shape.id
Restrict delete
fkey_vl_user_sign
sign.fk_user_sign
vl_user_sign.id
Restrict delete
fkey_od_frame
sign.fk_frame
frame.id
Restrict delete
fkey_od_owner
sign.fk_owner
vl_owner.id
Restrict delete
fkey_od_support
azimut.fk_support
support.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
vl_user_sign directional (((directional_sign IS FALSE) OR ((img_de_right IS NOT NULL) AND (img_fr_right IS NOT NULL) AND (img_it_right IS NOT NULL) AND (img_ro_right IS NOT NULL))))
vl_official_sign directional (((directional_sign IS FALSE) OR ((img_de_right IS NOT NULL) AND (img_fr_right IS NOT NULL) AND (img_it_right IS NOT NULL) AND (img_ro_right IS NOT NULL))))