Constraints

28 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_SERVICE_RIGHTS_RIGHT
Service_Rights.Right_Id
Right.Right_Id
Restrict delete
FK_SERVICE_RIGHTS_SERVICE
Service_Rights.Service_Id
Service.Service_Id
Restrict delete
FK_RIGHTS_RIGHT
Rights.Right_Id
Right.Right_Id
Restrict delete
FK_RIGHTS_PHASE
Rights.Phase_Id
Phase.Phase_Id
Restrict delete
FK_ENVIRONMENT_ZONE
Environment.Zone_Id
Zone.Zone_Id
Restrict delete
FK_ENVIRONMENT_APPLICATION_INFO
Environment.Application_Info_Id
Application_Info.Application_Info_Id
Restrict delete
FK_ENVIRONMENT_INFRASTRUCTURE_SERVICES_INFRASTRUCTURE_SERVICE
Environment_Infrastructure_Services.Infrastructure_Service_Id
Infrastructure_Service.Infrastructure_Service_Id
Restrict delete
FK_ENVIRONMENT_INFRASTRUCTURE_SERVICES_ENVIRONMENT
Environment_Infrastructure_Services.Environment_Id
Environment.Environment_Id
Restrict delete
FK_ZONE_PROPERTIES_ZONE
Zone_Properties.Zone_Id
Zone.Zone_Id
Restrict delete
FK_ZONE_PROPERTIES_PROPERTY
Zone_Properties.Property_Id
Property.Property_Id
Restrict delete
FK_JOB_PHASES_PHASE
Job_Phases.Phase_Id
Phase.Phase_Id
Restrict delete
FK_JOB_PHASES_JOB
Job_Phases.Job_Id
Job.Job_Id
Restrict delete
FK_ENVIRONMENT_REGISTER_ZONE
Environment_Register.Zone_Id
Zone.Zone_Id
Restrict delete
FK_PHASE_STATES_RIGHTS_PHASE
Phase_States_Rights.Phase_Id
Phase.Phase_Id
Restrict delete
FK_PHASE_STATES_RIGHTS_RIGHT
Phase_States_Rights.Right_Id
Right.Right_Id
Restrict delete
FK_ENVIRONMENT_REGISTER_INFRASTRUCTURE_SERVICES_ENVIRONMENT_REGISTER
Environment_Register_Infrastructure_Services.Environment_Register_Id
Environment_Register.Environment_Register_Id
Restrict delete
FK_ENVIRONMENT_REGISTER_INFRASTRUCTURE_SERVICES_INFRASTRUCTURE_SERVICE
Environment_Register_Infrastructure_Services.Infrastructure_Service_Id
Infrastructure_Service.Infrastructure_Service_Id
Restrict delete
FK_APPLICATION_ENVIRONMENT_REGISTERS_ENVIRONMENT_REGISTER
Application_Environment_Registers.Environment_Register_Id
Environment_Register.Environment_Register_Id
Restrict delete
FK_APPLICATION_ENVIRONMENT_REGISTERS_APPLICATION_REGISTER
Application_Environment_Registers.Application_Register_Id
Application_Register.Application_Register_Id
Restrict delete
FK_PHASE_STATE_PHASE
Phase_State.Phase_Id
Phase.Phase_Id
Restrict delete
FK_PROVISIONED_ZONE_SERVICES_PROVISIONED_ZONE
Provisioned_Zone_Services.Provisioned_Zone_Id
Provisioned_Zone.Provisioned_Zone_Id
Restrict delete
FK_PROVISIONED_ZONE_SERVICES_SERVICE
Provisioned_Zone_Services.Service_Id
Service.Service_Id
Restrict delete
FK_APPLICATION_INFO_PRODUCT_IDENTITY_APPLICATION_PRODUCT_ID
Application_Info.Application_Product_Id
Product_Identity.Product_Identity_Id
Restrict delete
FK_APPLICATION_INFO_PRODUCT_IDENTITY_ADAPTER_PRODUCT_ID
Application_Info.Adapter_Product_Id
Product_Identity.Product_Identity_Id
Restrict delete
FK_ENVIRONMENT_REGISTER_PROVISIONED_ZONES_PROVISIONED_ZONE
Environment_Register_Provisioned_Zones.Provisioned_Zone_Id
Provisioned_Zone.Provisioned_Zone_Id
Restrict delete
FK_ENVIRONMENT_REGISTER_PROVISIONED_ZONES_ENVIRONMENT_REGISTER
Environment_Register_Provisioned_Zones.Environment_Register_Id
Environment_Register.Environment_Register_Id
Restrict delete
FK_ENVIRONMENT_PROVISIONED_ZONES_PROVISIONED_ZONE
Environment_Provisioned_Zones.Provisioned_Zone_Id
Provisioned_Zone.Provisioned_Zone_Id
Restrict delete
FK_ENVIRONMENT_PROVISIONED_ZONES_ENVIRONMENT
Environment_Provisioned_Zones.Environment_Id
Environment.Environment_Id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected