Constraints

69 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_bc846ebf232d562b

space_meta.object_id

Cascade on delete

fk_d7edf8b2232d562b

evaluationmethodconfiguration_meta.object_id

evaluation_method_configuration.id

Cascade on delete

fk_9977a8521dfa7c8f

entity_revision_revision_data.revision_id

entity_revision.id

Cascade on delete

fk_9977a852b4906f58

entity_revision_revision_data.revision_data_id

entity_revision_data.id

Cascade on delete

fk_3bae0aa73414710b

event.agent_id

Cascade on delete

fk_3bae0aa7166d1f9c

event.project_id

Null on delete

fk_3bae0aa7bddfbe89

event.subsite_id

Null on delete

fk_330cb54c9a34590f

evaluation_method_configuration.opportunity_id

Cascade on delete

fk_a5506736140e9f00

event_occurrence_cancellation.event_occurrence_id

event_occurrence.id

Cascade on delete

fk_2bb06d08232d562b

opportunity_meta.object_id

Cascade on delete

fk_62a8a7a7bddfbe89

registration.subsite_id

Null on delete

fk_62a8a7a73414710b

registration.agent_id

Cascade on delete

fk_62a8a7a79a34590f

registration.opportunity_id

Cascade on delete

fk_b0f67b6f3414710b

subsite.agent_id

Restrict delete

fk_2fb3d0ee727aca70

project.parent_id

Cascade on delete

fk_2fb3d0eebddfbe89

project.subsite_id

Null on delete

fk_2fb3d0ee3414710b

project.agent_id

Cascade on delete

fk_350dd4bea76ed395

event_attendance.user_id

usr.id

Cascade on delete

fk_350dd4be71f7e88b

event_attendance.event_id

Cascade on delete

fk_350dd4be140e9f00

event_attendance.event_occurrence_id

event_occurrence.id

Cascade on delete

fk_350dd4be23575340

event_attendance.space_id

Cascade on delete

fk_60c85cb19a34590f

registration_field_configuration.opportunity_id

Cascade on delete

fk_1a0e9a30232d562b

space_relation.object_id

registration.id

Cascade on delete

fk_1a0e9a3023575340

space_relation.space_id

Cascade on delete

fk_fab3fc16c47d5262

chat_message.chat_thread_id

Cascade on delete

fk_fab3fc16727aca70

chat_message.parent_id

chat_message.id

Cascade on delete

fk_fab3fc16a76ed395

chat_message.user_id

usr.id

Cascade on delete

fk_7a69aed6232d562b

agent_meta.object_id

Cascade on delete

fk_3d853098a76ed395

pcache.user_id

usr.id

Cascade on delete

fk_487af6517e3c61f9

seal_relation.owner_id

Cascade on delete

fk_487af65154778145

seal_relation.seal_id

Cascade on delete

fk_487af6513414710b

seal_relation.agent_id

Cascade on delete

fk_cf97a98ca76ed395

entity_revision.user_id

usr.id

Cascade on delete

fk_2e186c5c833d8f43

registration_evaluation.registration_id

registration.id

Cascade on delete

fk_2e186c5ca76ed395

registration_evaluation.user_id

usr.id

Cascade on delete

fk_268b9c9dbddfbe89

agent.subsite_id

Null on delete

fk_268b9c9da76ed395

agent.user_id

usr.id

Cascade on delete

fk_268b9c9d727aca70

agent.parent_id

Null on delete

fk_57698a6abddfbe89

role.subsite_id

Cascade on delete

fk_57698a6ac69d3fb

role.usr_id

usr.id

Cascade on delete

fk_2972c13abddfbe89

space.subsite_id

Null on delete

fk_2972c13a3414710b

space.agent_id

Cascade on delete

fk_2972c13a727aca70

space.parent_id

Cascade on delete

fk_e61358dc23575340

event_occurrence.space_id

Cascade on delete

fk_e61358dc71f7e88b

event_occurrence.event_id

Cascade on delete

fk_ee63dc2d232d562b

project_meta.object_id

Cascade on delete

fk_780702f5232d562b

subsite_meta.object_id

Cascade on delete

fk_eddf39fde2c35fc

term_relation.term_id

Cascade on delete

fk_54585edd3414710b

agent_relation.agent_id

Cascade on delete

fk_22781144bddfbe89

user_app.subsite_id

Cascade on delete

fk_22781144a76ed395

user_app.user_id

usr.id

Cascade on delete

fk_2e30ae303414710b

seal.agent_id

Cascade on delete

fk_2e30ae30bddfbe89

seal.subsite_id

Cascade on delete

fk_8c9f3610727aca70

file.parent_id

Cascade on delete

fk_a92e5e22232d562b

seal_meta.object_id

Cascade on delete

fk_18cc03e9232d562b

registration_meta.object_id

registration.id

Cascade on delete

fk_d7bae7f3aeb2ed7

procuration.attorney_user_id

usr.id

Cascade on delete

fk_d7bae7fc69d3fb

procuration.usr_id

usr.id

Cascade on delete

fk_209c792e9a34590f

registration_file_configuration.opportunity_id

Cascade on delete

fk_ad7358fc232d562b

user_meta.object_id

usr.id

Cascade on delete

fk_bf5476ca427eb8a5

notification.request_id

Cascade on delete

fk_bf5476caa76ed395

notification.user_id

usr.id

Cascade on delete

fk_3b978f9fba78f12a

request.requester_user_id

usr.id

Cascade on delete

fk_1762498cccfa12b8

usr.profile_id

Null on delete

fk_6fce5f0f232d562b

notification_meta.object_id

notification.id

Cascade on delete

fk_388eccb140e9f00

event_occurrence_recurrence.event_occurrence_id

event_occurrence.id

Cascade on delete

fk_8389c3d7727aca70

opportunity.parent_id

Cascade on delete

fk_8389c3d73414710b

opportunity.agent_id

Cascade on delete

fk_c839589e232d562b

event_meta.object_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
geo_division	enforce_dims_geom	((st_ndims(geom) = 2))
geo_division	enforce_geotype_geom	(((geometrytype(geom) = 'MULTIPOLYGON'::text) OR (geometrytype(geom) = 'POLYGON'::text) OR (geom IS NULL)))
geo_division	enforce_srid_geom	((st_srid(geom) = 4326))
spatial_ref_sys	spatial_ref_sys_srid_check	(((srid > 0) AND (srid <= 998999)))
event_occurrence	positive_separation	((separation > 0))