Constraints

16 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

syst_owner_owner_states_fk

syst_owners.owner_state_id

syst_enum_items.id

Restrict delete

syst_instance_type_contexts_inst_type_app_fk

syst_instance_type_contexts.instance_type_application_id

syst_instance_type_applications.id

Cascade on delete

syst_instance_type_contexts_application_contexts_fk

syst_instance_type_contexts.application_context_id

syst_application_contexts.id

Cascade on delete

syst_enum_items_enum_fk

syst_enum_items.enum_id

Cascade on delete

syst_enum_items_enum_functional_type_fk

syst_enum_items.functional_type_id

syst_enum_functional_types.id

Restrict delete

syst_enum_functional_types_enum_fk

syst_enum_functional_types.enum_id

Cascade on delete

syst_application_contexts_applications_fk

syst_application_contexts.application_id

syst_applications.id

Cascade on delete

syst_instances_applications_fk

syst_instances.application_id

syst_applications.id

Restrict delete

syst_instances_owners_fk

syst_instances.owner_id

Restrict delete

syst_instances_owning_instance_fk

syst_instances.owning_instance_id

syst_instances.id

Restrict delete

syst_instances_enum_instance_state_fk

syst_instances.instance_state_id

syst_enum_items.id

Restrict delete

syst_instances_enum_instance_type_fk

syst_instances.instance_type_id

syst_enum_items.id

Restrict delete

syst_instance_contexts_instances_fk

syst_instance_contexts.instance_id

syst_instances.id

Cascade on delete

syst_instance_contexts_application_contexts_fk

syst_instance_contexts.application_context_id

syst_application_contexts.id

Cascade on delete

syst_instance_type_applications_applications_fk

syst_instance_type_applications.application_id

syst_applications.id

Cascade on delete

syst_instance_type_applications_instance_types_fk

syst_instance_type_applications.instance_type_id

syst_enum_items.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
syst_instance_type_contexts	syst_instance_type_contexts_default_db_pool_size_chk	((default_db_pool_size >= 0))
syst_instances	syst_instances_self_ownership_chk	(((owning_instance_id IS NULL) OR (owning_instance_id <> id)))
syst_instance_contexts	syst_instance_contexts_db_pool_size_chk	((db_pool_size >= 0))