Constraints

150 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_PortfolioCreditDefaultSwapData_TradeId
PortfolioCreditDefaultSwapData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioCreditDefaultSwapData_CreditCurveId
PortfolioCreditDefaultSwapData.CreditCurveId
TypesParties.value
Restrict delete
FK_PortfolioCreditDefaultSwapData_SettlesAccrual
PortfolioCreditDefaultSwapData.SettlesAccrual
TypesBool.value
Restrict delete
FK_PortfolioCreditDefaultSwapData_PaysAtDefaultTime
PortfolioCreditDefaultSwapData.PaysAtDefaultTime
TypesBool.value
Restrict delete
FK_PortfolioCreditDefaultSwapData_IssuerId
PortfolioCreditDefaultSwapData.IssuerId
TypesParties.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_KnockOut
PortfolioIndexCreditDefaultSwapOptionData.KnockOut
TypesBool.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_TradeId
PortfolioIndexCreditDefaultSwapOptionData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataLongShort
PortfolioIndexCreditDefaultSwapOptionData.OptionDataLongShort
TypesLongShort.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataSettl
PortfolioIndexCreditDefaultSwapOptionData.OptionDataSettlement
TypesOptionSettlement.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataStyle
PortfolioIndexCreditDefaultSwapOptionData.OptionDataStyle
TypesOptionStyle.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataPremCurr
PortfolioIndexCreditDefaultSwapOptionData.OptionDataPremiumCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataPayOAtExp
PortfolioIndexCreditDefaultSwapOptionData.OptionDataPayOffAtExpiry
TypesBool.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataOptType
PortfolioIndexCreditDefaultSwapOptionData.OptionDataOptionType
TypesOptionType.value
Restrict delete
FK_PortfolioFixedLegCPIRates_LegDataId
PortfolioFixedLegCPIRates.LegDataId
PortfolioLegData.Id
Restrict delete
FK_PortfolioIndexCreditDefaultSwapData_TradeId
PortfolioIndexCreditDefaultSwapData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioIndexCreditDefaultSwapData_PaysAtDefaultTime
PortfolioIndexCreditDefaultSwapData.PaysAtDefaultTime
TypesBool.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapData_CreditCurveId
PortfolioIndexCreditDefaultSwapData.CreditCurveId
TypesParties.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapData_SettlesAccrual
PortfolioIndexCreditDefaultSwapData.SettlesAccrual
TypesBool.value
Restrict delete
FK_PortfolioLegAmortizations_Type
PortfolioLegAmortizations.Type
TypesAmortizationType.value
Restrict delete
FK_PortfolioLegAmortizations_Underflow
PortfolioLegAmortizations.Underflow
TypesBool.value
Restrict delete
FK_PortfolioCashflowDataCashflow_LegDataId
PortfolioCashflowDataCashflow.LegDataId
PortfolioLegData.Id
Restrict delete
FK_MdatFixingData_IndexId
MdatFixingData.IndexId
MdatFixingDataDefinitions.IndexId
Restrict delete
FK_PortfolioSwapData_TradeId
PortfolioSwapData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioLegData_Payer
PortfolioLegData.Payer
TypesBool.value
Restrict delete
FK_PortfolioLegData_FloatingLegIndexName
PortfolioLegData.FloatingLegIndexName
TypesIndexName.value
Restrict delete
FK_PortfolioLegData_FXResetForeignCurrency
PortfolioLegData.FXResetForeignCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioLegData_FloatingLegIsInArrears
PortfolioLegData.FloatingLegIsInArrears
TypesBool.value
Restrict delete
FK_PortfolioLegData_DayCounter
PortfolioLegData.DayCounter
TypesDayCounter.value
Restrict delete
FK_PortfolioLegData_NotionalFinalExchange
PortfolioLegData.NotionalFinalExchange
TypesBool.value
Restrict delete
FK_PortfolioLegData_FloatingLegIsNotResettingXCCY
PortfolioLegData.FloatingLegIsNotResettingXCCY
TypesBool.value
Restrict delete
FK_PortfolioLegData_CPILegInterpolated
PortfolioLegData.CPILegInterpolated
TypesBool.value
Restrict delete
FK_PortfolioLegData_LegType
PortfolioLegData.LegType
TypesLegType.value
Restrict delete
FK_PortfolioLegData_TradeId
PortfolioLegData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioLegData_Currency
PortfolioLegData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioLegData_YYLegIndexName
PortfolioLegData.YYLegIndexName
TypesIndexName.value
Restrict delete
FK_PortfolioLegData_FXResetFXIndex
PortfolioLegData.FXResetFXIndex
TypesIndexName.value
Restrict delete
FK_PortfolioLegData_FloatingLegIsAveraged
PortfolioLegData.FloatingLegIsAveraged
TypesBool.value
Restrict delete
FK_PortfolioLegData_NotionalInitialExchange
PortfolioLegData.NotionalInitialExchange
TypesBool.value
Restrict delete
FK_PortfolioLegData_CPILegSubtractInflationNotional
PortfolioLegData.CPILegSubtractInflationNotional
TypesBool.value
Restrict delete
FK_PortfolioLegData_NotionalAmortizingExchange
PortfolioLegData.NotionalAmortizingExchange
TypesBool.value
Restrict delete
FK_PortfolioLegData_CPILegIndexName
PortfolioLegData.CPILegIndexName
TypesIndexName.value
Restrict delete
FK_PortfolioLegData_FloatingLegNakedOption
PortfolioLegData.FloatingLegNakedOption
TypesBool.value
Restrict delete
FK_PortfolioLegData_YYLegInterpolated
PortfolioLegData.YYLegInterpolated
TypesBool.value
Restrict delete
FK_PortfolioLegData_PaymentConvention
PortfolioLegData.PaymentConvention
TypesBusinessDayConvention.value
Restrict delete
FK_PortfolioCDOData_TradeId
PortfolioCDOData.TradeId
PortfolioTrades.Id
Restrict delete
FK_NettingCSADetails_CSACurrency
NettingCSADetails.CSACurrency
TypesCurrencyCode.value
Restrict delete
FK_NettingCSADetails_Bilateral
NettingCSADetails.Bilateral
TypesCsaType.value
Restrict delete
FK_NettingCSADetails_IndexName
NettingCSADetails.IndexName
TypesIndexName.value
Restrict delete
FK_NettingCSADetails_NettingSetId
NettingCSADetails.NettingSetId
NettingSet.NettingSetId
Restrict delete
FK_NettingCSADetails_IndependentAmountType
NettingCSADetails.IndependentAmountType
TypesIndependentAmountType.value
Restrict delete
FK_PortfolioLegNotionals_LegDataId
PortfolioLegNotionals.LegDataId
PortfolioLegData.Id
Restrict delete
FK_PortfolioFloatingLegGearings_LegDataId
PortfolioFloatingLegGearings.LegDataId
PortfolioLegData.Id
Restrict delete
FK_PortfolioCommodityOptionData_OptionDataOptionType
PortfolioCommodityOptionData.OptionDataOptionType
TypesOptionType.value
Restrict delete
FK_PortfolioCommodityOptionData_TradeId
PortfolioCommodityOptionData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioCommodityOptionData_Currency
PortfolioCommodityOptionData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioCommodityOptionData_OptionDataLongShort
PortfolioCommodityOptionData.OptionDataLongShort
TypesLongShort.value
Restrict delete
FK_PortfolioCommodityOptionData_OptionDataPremiumCurrency
PortfolioCommodityOptionData.OptionDataPremiumCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioCommodityOptionData_Name
PortfolioCommodityOptionData.Name
TypesEquityCurves.value
Restrict delete
FK_PortfolioCommodityOptionData_OptionDataStyle
PortfolioCommodityOptionData.OptionDataStyle
TypesOptionStyle.value
Restrict delete
FK_PortfolioCommodityOptionData_OptionDataSettlement
PortfolioCommodityOptionData.OptionDataSettlement
TypesOptionSettlement.value
Restrict delete
FK_PortfolioCommodityOptionData_OptionDataPayOffAtExpiry
PortfolioCommodityOptionData.OptionDataPayOffAtExpiry
TypesBool.value
Restrict delete
FK_PortfolioFxForwardData_SoldCurrency
PortfolioFxForwardData.SoldCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioFxForwardData_BoughtCurrency
PortfolioFxForwardData.BoughtCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioFxForwardData_TradeId
PortfolioFxForwardData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioTrades_EnvelopeNettingSetId
PortfolioTrades.EnvelopeNettingSetId
NettingSet.NettingSetId
Restrict delete
FK_PortfolioTrades_TradeType
PortfolioTrades.TradeType
TypesOreTradeType.value
Restrict delete
FK_PortfolioTrades_EnvelopeCounterParty
PortfolioTrades.EnvelopeCounterParty
TypesParties.value
Restrict delete
FK_PortfolioFloorRates_TradeId
PortfolioFloorRates.TradeId
PortfolioTrades.Id
Restrict delete
FK_MdatFixingDataDefinitions_ForeignCurrency
MdatFixingDataDefinitions.ForeignCurrency
TypesCurrencyCode.value
Restrict delete
FK_MdatFixingDataDefinitions_Currency
MdatFixingDataDefinitions.Currency
TypesCurrencyCode.value
Restrict delete
FK_MdatFixingDataDefinitions_DomesticCurrency
MdatFixingDataDefinitions.DomesticCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioScheduleDataRules_Convention
PortfolioScheduleDataRules.Convention
TypesBusinessDayConvention.value
Restrict delete
FK_PortfolioScheduleDataRules_TermConvention
PortfolioScheduleDataRules.TermConvention
TypesBusinessDayConvention.value
Restrict delete
FK_PortfolioScheduleDataRules_EndOfMonth
PortfolioScheduleDataRules.EndOfMonth
TypesBool.value
Restrict delete
FK_PortfolioScheduleDataRules_RuleName
PortfolioScheduleDataRules.RuleName
TypesDateRule.value
Restrict delete
FK_MdatMarketData_QuoteId
MdatMarketData.QuoteId
MdatMarketDataDefinitions.QuoteId
Restrict delete
FK_PortfolioBondData_IssuerId
PortfolioBondData.IssuerId
TypesParties.value
Restrict delete
FK_PortfolioBondData_SecurityId
PortfolioBondData.SecurityId
TypesSecurityCurves.value
Restrict delete
FK_PortfolioBondData_CreditCurveId
PortfolioBondData.CreditCurveId
TypesParties.value
Restrict delete
FK_PortfolioBondData_TradeId
PortfolioBondData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioFloatingLegFloors_LegDataId
PortfolioFloatingLegFloors.LegDataId
PortfolioLegData.Id
Restrict delete
FK_NettingSet_ActiveCSAFlag
NettingSet.ActiveCSAFlag
TypesBool.value
Restrict delete
FK_NettingSet_Counterparty
NettingSet.Counterparty
TypesParties.value
Restrict delete
FK_PortfolioCapFloorData_TradeId
PortfolioCapFloorData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioOptionExercises_TradeId
PortfolioOptionExercises.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioFloatingLegCaps_LegDataId
PortfolioFloatingLegCaps.LegDataId
PortfolioLegData.Id
Restrict delete
FK_PortfolioTradeActions_TradeId
PortfolioTradeActions.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioTradeActions_Owner
PortfolioTradeActions.Owner
TypesTradeActionOwner.value
Restrict delete
FK_PortfolioTradeActions_Type
PortfolioTradeActions.Type
TypesTradeActionType.value
Restrict delete
FK_PortfolioFloatingLegSpreads_LegDataId
PortfolioFloatingLegSpreads.LegDataId
PortfolioLegData.Id
Restrict delete
FK_PortfolioCommodityForwardData_Name
PortfolioCommodityForwardData.Name
TypesEquityCurves.value
Restrict delete
FK_PortfolioCommodityForwardData_TradeId
PortfolioCommodityForwardData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioCommodityForwardData_Position
PortfolioCommodityForwardData.Position
TypesLongShort.value
Restrict delete
FK_PortfolioCommodityForwardData_Currency
PortfolioCommodityForwardData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioEquityOptionData_OptionDataPayOffAtExpiry
PortfolioEquityOptionData.OptionDataPayOffAtExpiry
TypesBool.value
Restrict delete
FK_PortfolioEquityOptionData_OptionDataOptionType
PortfolioEquityOptionData.OptionDataOptionType
TypesOptionType.value
Restrict delete
FK_PortfolioEquityOptionData_Name
PortfolioEquityOptionData.Name
TypesEquityCurves.value
Restrict delete
FK_PortfolioEquityOptionData_TradeId
PortfolioEquityOptionData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioEquityOptionData_Currency
PortfolioEquityOptionData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioEquityOptionData_OptionDataLongShort
PortfolioEquityOptionData.OptionDataLongShort
TypesLongShort.value
Restrict delete
FK_PortfolioEquityOptionData_OptionDataSettlement
PortfolioEquityOptionData.OptionDataSettlement
TypesOptionSettlement.value
Restrict delete
FK_PortfolioEquityOptionData_OptionDataStyle
PortfolioEquityOptionData.OptionDataStyle
TypesOptionStyle.value
Restrict delete
FK_PortfolioEquityOptionData_OptionDataPremiumCurrency
PortfolioEquityOptionData.OptionDataPremiumCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioCapRates_TradeId
PortfolioCapRates.TradeId
PortfolioTrades.Id
Restrict delete
FK_NettingEligibleCollateralsCurrencies_Currency
NettingEligibleCollateralsCurrencies.Currency
TypesCurrencyCode.value
Restrict delete
FK_NettingEligibleCollateralsCurrencies_NettingSetId
NettingEligibleCollateralsCurrencies.NettingSetId
NettingSet.NettingSetId
Restrict delete
FK_PortfolioBaskets_CreditCurveId
PortfolioBaskets.CreditCurveId
TypesParties.value
Restrict delete
FK_PortfolioBaskets_TradeId
PortfolioBaskets.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioBaskets_Currency
PortfolioBaskets.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioBaskets_IssuerId
PortfolioBaskets.IssuerId
TypesParties.value
Restrict delete
FK_PortfolioCPICapFloorData_CapFloor
PortfolioCPICapFloorData.CapFloor
TypesCapFloor.value
Restrict delete
FK_PortfolioCPICapFloorData_IndexName
PortfolioCPICapFloorData.IndexName
TypesIndexName.value
Restrict delete
FK_PortfolioCPICapFloorData_TradeId
PortfolioCPICapFloorData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioCPICapFloorData_PayConvention
PortfolioCPICapFloorData.PayConvention
TypesBusinessDayConvention.value
Restrict delete
FK_PortfolioCPICapFloorData_FixConvention
PortfolioCPICapFloorData.FixConvention
TypesBusinessDayConvention.value
Restrict delete
FK_PortfolioCPICapFloorData_LongShort
PortfolioCPICapFloorData.LongShort
TypesLongShort.value
Restrict delete
FK_PortfolioCPICapFloorData_Currency
PortfolioCPICapFloorData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioSwaptionData_OptionDataSettlement
PortfolioSwaptionData.OptionDataSettlement
TypesOptionSettlement.value
Restrict delete
FK_PortfolioSwaptionData_OptionDataPayOffAtExpiry
PortfolioSwaptionData.OptionDataPayOffAtExpiry
TypesBool.value
Restrict delete
FK_PortfolioSwaptionData_OptionDataPremiumCurrency
PortfolioSwaptionData.OptionDataPremiumCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioSwaptionData_OptionDataStyle
PortfolioSwaptionData.OptionDataStyle
TypesOptionStyle.value
Restrict delete
FK_PortfolioSwaptionData_TradeId
PortfolioSwaptionData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioSwaptionData_OptionDataLongShort
PortfolioSwaptionData.OptionDataLongShort
TypesLongShort.value
Restrict delete
FK_PortfolioSwaptionData_OptionDataOptionType
PortfolioSwaptionData.OptionDataOptionType
TypesOptionType.value
Restrict delete
FK_MdatMarketDataDefinitions_TargetCurrency
MdatMarketDataDefinitions.TargetCurrency
TypesCurrencyCode.value
Restrict delete
FK_MdatMarketDataDefinitions_FlatCurrency
MdatMarketDataDefinitions.FlatCurrency
TypesCurrencyCode.value
Restrict delete
FK_MdatMarketDataDefinitions_Currency
MdatMarketDataDefinitions.Currency
TypesCurrencyCode.value
Restrict delete
FK_MdatMarketDataDefinitions_UnitCurrency
MdatMarketDataDefinitions.UnitCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioFxOptionData_OptionDataPayOffAtExpiry
PortfolioFxOptionData.OptionDataPayOffAtExpiry
TypesBool.value
Restrict delete
FK_PortfolioFxOptionData_OptionDataLongShort
PortfolioFxOptionData.OptionDataLongShort
TypesLongShort.value
Restrict delete
FK_PortfolioFxOptionData_OptionDataOptionType
PortfolioFxOptionData.OptionDataOptionType
TypesOptionType.value
Restrict delete
FK_PortfolioFxOptionData_TradeId
PortfolioFxOptionData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioFxOptionData_OptionDataSettlement
PortfolioFxOptionData.OptionDataSettlement
TypesOptionSettlement.value
Restrict delete
FK_PortfolioFxOptionData_SoldCurrency
PortfolioFxOptionData.SoldCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioFxOptionData_BoughtCurrency
PortfolioFxOptionData.BoughtCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioFxOptionData_OptionDataStyle
PortfolioFxOptionData.OptionDataStyle
TypesOptionStyle.value
Restrict delete
FK_PortfolioFxOptionData_OptionDataPremiumCurrency
PortfolioFxOptionData.OptionDataPremiumCurrency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioEquityForwardData_Name
PortfolioEquityForwardData.Name
TypesEquityCurves.value
Restrict delete
FK_PortfolioEquityForwardData_TradeId
PortfolioEquityForwardData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioEquityForwardData_Currency
PortfolioEquityForwardData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioEquityForwardData_LongShort
PortfolioEquityForwardData.LongShort
TypesLongShort.value
Restrict delete
FK_OreConfigurations_ConfigurationType
OreConfigurations.ConfigurationType
TypesConfigurationTypes.value
Restrict delete
FK_PortfolioForwardRateAgreementData_TradeId
PortfolioForwardRateAgreementData.TradeId
PortfolioTrades.Id
Restrict delete
FK_PortfolioForwardRateAgreementData_Currency
PortfolioForwardRateAgreementData.Currency
TypesCurrencyCode.value
Restrict delete
FK_PortfolioForwardRateAgreementData_IndexName
PortfolioForwardRateAgreementData.IndexName
TypesIndexName.value
Restrict delete
FK_PortfolioForwardRateAgreementData_LongShort
PortfolioForwardRateAgreementData.LongShort
TypesLongShort.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionSwapData_PaysAtDefTime
PortfolioIndexCreditDefaultSwapOptionSwapData.PaysAtDefaultTime
TypesBool.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionSwapData_CreditCurveId
PortfolioIndexCreditDefaultSwapOptionSwapData.CreditCurveId
TypesParties.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionSwapData_SettlesAccrual
PortfolioIndexCreditDefaultSwapOptionSwapData.SettlesAccrual
TypesBool.value
Restrict delete
FK_PortfolioIndexCreditDefaultSwapOptionSwapData_TradeId
PortfolioIndexCreditDefaultSwapOptionSwapData.TradeId
PortfolioIndexCreditDefaultSwapOptionData.TradeId
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected