115 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| FK_DuplicateEntity_DuplicateEntityStatus |
|
|
Restrict delete | ||
| FK_AddressMarketBoundary_MarketBoundary |
|
|
Restrict delete | ||
| FK_AddressMarketBoundary_Address |
|
|
Restrict delete | ||
| FK_CompanyType_TierType |
|
|
Restrict delete | ||
| FK_InvestmentEvent_InvestmentEventStatus |
|
|
Restrict delete | ||
| FK_InvestmentEvent_InvestmentEvent |
|
|
Restrict delete | ||
| FK_InvestmentEvent_SizeUnit |
|
|
Restrict delete | ||
| FK_InvestmentEvent_CurrencyType |
|
|
Restrict delete | ||
| FK_InvestmentEvent_InvestmentOwnershipType |
|
|
Restrict delete | ||
| FK_InvestmentEvent_InvestmentEventType |
|
|
Restrict delete | ||
| FK_SchemeAttributeType_SchemeAttributeTypeCategory |
|
|
Restrict delete | ||
| FK_InvestmentEventStatus_TierType |
|
|
Restrict delete | ||
| FK_DevelopmentDeveloper_Company |
|
|
Restrict delete | ||
| FK_DevelopmentDeveloper_Development |
|
|
Restrict delete | ||
| FK_PortfolioCompany_Company |
|
|
Restrict delete | ||
| FK_PortfolioCompany_PortfolioCompanyRole |
|
|
Restrict delete | ||
| FK_PortfolioCompany_Portfolio |
|
|
Restrict delete | ||
| FK_PortfolioCompany_CompanyFund |
|
|
Restrict delete | ||
| FK_Country_TierType |
|
|
Restrict delete | ||
| FK_ExternalType_ExternalTypeCategory |
|
|
Restrict delete | ||
| FK_JobExecution_JobType |
|
|
Restrict delete | ||
| FK_Scaler_Currency |
|
|
Restrict delete | ||
| FK_Scaler_ScalerType |
|
|
Restrict delete | ||
| FK_Scaler_BuildingType |
|
|
Restrict delete | ||
| FK_Scaler_Country |
|
|
Restrict delete | ||
| FK_CurrencyConversion_CurrencyType |
|
|
Restrict delete | ||
| FK_PortfolioMarketSector_BuildingType |
|
|
Restrict delete | ||
| FK_PortfolioMarketSector_SizeUnit |
|
|
Restrict delete | ||
| FK_PortfolioMarketSector_Country |
|
|
Restrict delete | ||
| FK_PortfolioMarketSector_Portfolio |
|
|
Restrict delete | ||
| FK_PortfolioMarketSector_Market |
|
|
Restrict delete | ||
| FK_StatisticField_SizeUnit |
|
|
Restrict delete | ||
| FK_StatisticField_StatisticFieldGroup |
|
|
Restrict delete | ||
| FK_Market_TierType |
|
|
Restrict delete | ||
| FK_SchemeAttribute_Scheme |
|
|
Restrict delete | ||
| FK_SchemeAttribute_SchemeAttributeType |
|
|
Restrict delete | ||
| FK_SchemeAttribute_SchemeAttributeListItem |
|
|
Restrict delete | ||
| FK_DevelopmentUse_Development |
|
|
Restrict delete | ||
| FK_DevelopmentUse_BuildingUse |
|
|
Restrict delete | ||
| FK_DevelopmentUse_SizeUnit |
|
|
Restrict delete | ||
| FK_CompanyFund_Company |
|
|
Restrict delete | ||
| FK_CompanyFund_CurrencyType |
|
|
Restrict delete | ||
| FK_InvestmentEventType_TierType |
|
|
Restrict delete | ||
| FK_Company_Company |
|
|
Restrict delete | ||
| FK_Company_Country |
|
|
Restrict delete | ||
| FK_Company_Address |
|
|
Restrict delete | ||
| FK_Company_CompanyType |
|
|
Restrict delete | ||
| FK_PortfolioScheme_Scheme |
|
|
Restrict delete | ||
| FK_PortfolioScheme_Portfolio |
|
|
Restrict delete | ||
| FK_InvestmentScheme_Scheme |
|
|
Restrict delete | ||
| FK_InvestmentScheme_InvestmentEvent |
|
|
Restrict delete | ||
| FK_SizeUnit_CurrencyType |
|
|
Restrict delete | ||
| FK_InvestmentOwnershipType_TierType |
|
|
Restrict delete | ||
| FK_Address_GoogleLocationType |
|
|
Restrict delete | ||
| FK_Address_Country |
|
|
Restrict delete | ||
| FK_Address_Address |
|
|
Restrict delete | ||
| FK_OccupierEventStatus_TierType |
|
|
Restrict delete | ||
| FK_Statistic_StatisticField |
|
|
Restrict delete | ||
| FK_Statistic_Scheme |
|
|
Restrict delete | ||
| FK_Statistic_SizeUnit |
|
|
Restrict delete | ||
| FK_InvestmentCompany_CompanyFund |
|
|
Restrict delete | ||
| FK_InvestmentCompany_Company |
|
|
Restrict delete | ||
| FK_InvestmentCompany_InvestmentEvent |
|
|
Restrict delete | ||
| FK_InvestmentCompany_InvestmentCompanyRole |
|
|
Restrict delete | ||
| FK_AdminBoundary_TierType |
|
|
Restrict delete | ||
| FK_AdminBoundary_AdminType |
|
|
Restrict delete | ||
| FK_AdminBoundary_Country |
|
|
Restrict delete | ||
| FK_DevelopmentType_TierType |
|
|
Restrict delete | ||
| FK_OccupierCompany_OccupierCompanyRole |
|
|
Restrict delete | ||
| FK_OccupierCompany_Company |
|
|
Restrict delete | ||
| FK_OccupierCompany_OccupierEvent |
|
|
Restrict delete | ||
| FK_SchemeCompany_SchemeCompanyRole |
|
|
Restrict delete | ||
| FK_SchemeCompany_Scheme |
|
|
Restrict delete | ||
| FK_SchemeCompany_Company |
|
|
Restrict delete | ||
| FK_ExternalLink_Type |
|
|
Restrict delete | ||
| FK_Scheme_Address |
|
|
Restrict delete | ||
| FK_Scheme_BuildingType |
|
|
Restrict delete | ||
| FK_Scheme_Scheme |
|
|
Restrict delete | ||
| FK_CurrencyType_Country |
|
|
Restrict delete | ||
| FK_MarketBoundary_Market |
|
|
Restrict delete | ||
| FK_MarketBoundary_MarketType |
|
|
Restrict delete | ||
| FK_Portfolio_InvestmentEventType |
|
|
Restrict delete | ||
| FK_Portfolio_BuildingType |
|
|
Restrict delete | ||
| FK_Portfolio_CurrencyType |
|
|
Restrict delete | ||
| FK_Portfolio_InvestmentOwnershipType |
|
|
Restrict delete | ||
| FK_Portfolio_InvestmentEventStatus |
|
|
Restrict delete | ||
| FK_Portfolio_SizeUnit |
|
|
Restrict delete | ||
| FK_SchemeMarketBoundary_MarketBoundary |
|
|
Restrict delete | ||
| FK_SchemeMarketBoundary_Scheme |
|
|
Restrict delete | ||
| FK_DevelopmentStatus_TierType |
|
|
Restrict delete | ||
| FK_BuildingUse_TierType |
|
|
Restrict delete | ||
| FK_BuildingUseToType_BuildingType |
|
|
Restrict delete | ||
| FK_BuildingUseToType_BuildingUse |
|
|
Restrict delete | ||
| FK_BuildingType_MarketType |
|
|
Restrict delete | ||
| FK_BuildingType_TierType |
|
|
Restrict delete | ||
| FK_SchemeAttributeListItem_SchemeAttributeType |
|
|
Restrict delete | ||
| FK_Development_DevelopmentOccupancyComp |
|
|
Restrict delete | ||
| FK_Development_DevelopmentOccupancy |
|
|
Restrict delete | ||
| FK_Development_Scheme |
|
|
Restrict delete | ||
| FK_Development_DevelopmentStatus |
|
|
Restrict delete | ||
| FK_Development_SizeUnitComp |
|
|
Restrict delete | ||
| FK_Development_SizeUnit |
|
|
Restrict delete | ||
| FK_Development_DevelopmentType |
|
|
Restrict delete | ||
| FK_TagLink_Tag |
|
|
Restrict delete | ||
| FK_Tag_TagCategory |
|
|
Restrict delete | ||
| FK_AddressAdminBoundary_Address |
|
|
Restrict delete | ||
| FK_AddressAdminBoundary_AdminBoundary |
|
|
Restrict delete | ||
| FK_OccupierEvent_OccupierEventType |
|
|
Restrict delete | ||
| FK_OccupierEvent_Scheme |
|
|
Restrict delete | ||
| FK_OccupierEvent_SizeUnit |
|
|
Restrict delete | ||
| FK_OccupierEvent_BuildingUse |
|
|
Restrict delete | ||
| FK_OccupierEvent_OccupierEvent |
|
|
Restrict delete | ||
| FK_OccupierEvent_OccupierEventStatus |
|
|
Restrict delete | ||
| FK_OccupierEvent_SizeUnitRent |
|
|
Restrict delete | ||
| FK_OccupierEventType_TierType |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|