Tables


SchemaSpy Analysis of ORE.dbo

Generated on Fr Jun 12 22:02 MESZ 2020

XML Representation
Insertion Order Deletion Order
TABLES 82
VIEWS 2
COLUMNS 515
Constraints 150

Database Properties

Database Type: Microsoft SQL Server - 13.00.4259

Tables

Table / View Children Parents Columns Rows Type Comments
MdatCovarianceData 0 0 3 0 Table
MdatFixingData 0 1 3 0 Table
MdatFixingDataDefinitions 0 3 11 0 Table
MdatMarketData 0 1 3 75 Table
MdatMarketDataDefinitions 0 4 37 75 Table
NettingCSADetails 0 5 15 58 Table
NettingEligibleCollateralsCurrencies 0 2 2 58 Table
NettingSet 0 2 4 58 Table
NettingSetSelection 0 0 2 0 View
OreConfigurations 0 1 4 63 Table
PortfolioBaskets 0 4 6 0 Table
PortfolioBondData 0 4 8 11 Table
PortfolioCapFloorData 0 1 2 4 Table
PortfolioCapRates 0 1 4 0 Table
PortfolioCashflowDataCashflow 0 1 4 0 Table
PortfolioCDOData 0 1 6 0 Table
PortfolioCommodityForwardData 0 4 7 4 Table
PortfolioCommodityOptionData 0 9 13 2 Table
PortfolioCPICapFloorData 0 7 15 4 Table
PortfolioCreditDefaultSwapData 0 5 8 2 Table
PortfolioEquityForwardData 0 4 7 5 Table
PortfolioEquityOptionData 0 9 13 11 Table
PortfolioFixedLegCPIRates 0 1 4 62 Table
PortfolioFloatingLegCaps 0 1 4 0 Table
PortfolioFloatingLegFloors 0 1 4 1 Table
PortfolioFloatingLegGearings 0 1 4 0 Table
PortfolioFloatingLegSpreads 0 1 4 67 Table
PortfolioFloorRates 0 1 4 0 Table
PortfolioForwardRateAgreementData 0 4 8 1 Table
PortfolioFxForwardData 0 3 6 4 Table
PortfolioFxOptionData 0 9 13 5 Table
PortfolioIndexCreditDefaultSwapData 0 4 7 0 Table
PortfolioIndexCreditDefaultSwapOptionData 0 8 10 0 Table
PortfolioIndexCreditDefaultSwapOptionSwapData 0 4 7 0 Table
PortfolioLegAmortizations 0 2 8 7 Table
PortfolioLegData 0 21 29 136 Table
PortfolioLegNotionals 0 1 4 135 Table
PortfolioOptionExercises 0 1 4 63 Table
PortfolioScheduleDataDates 0 0 5 0 Table
PortfolioScheduleDataRules 0 4 13 138 Table
PortfolioSelection 0 0 2 0 View
PortfolioSwapData 0 1 1 0 Table
PortfolioSwaptionData 0 7 9 32 Table
PortfolioTradeActions 0 3 4 3 Table
PortfolioTradeGroupingIds 0 0 2 113 Table
PortfolioTrades 0 3 5 113 Table
ResultsColVA 0 0 10 0 Table
ResultsCrossGamma 0 0 9 0 Table
ResultsCube 0 0 10 0 Table
ResultsCurves 0 0 6 0 Table
ResultsDimEvolution 0 0 9 0 Table
ResultsDimRegression 0 0 11 0 Table
ResultsExposureNettingSet 0 0 11 0 Table
ResultsExposureTrade 0 0 12 0 Table
ResultsFlows 0 0 17 0 Table
ResultsNPV 0 0 14 0 Table
ResultsScenario 0 0 8 0 Table
ResultsSensitivity 0 0 8 0 Table
ResultsStresstest 0 0 7 0 Table
ResultsXVA 0 0 21 0 Table
TypesAmortizationType 0 0 1 4 Table
TypesBool 0 0 1 8 Table
TypesBusinessDayConvention 0 0 1 19 Table
TypesCalendar 0 0 1 29 Table
TypesCapFloor 0 0 1 2 Table
TypesConfigurationTypes 0 0 1 8 Table
TypesCsaType 0 0 1 3 Table
TypesCurrencyCode 0 0 1 65 Table
TypesCurrencyPair 0 0 1 4033 Table
TypesDateRule 0 0 1 9 Table
TypesDayCounter 0 0 1 37 Table
TypesEquityCurves 0 0 1 4 Table
TypesIndependentAmountType 0 0 1 1 Table
TypesIndexName 0 0 1 1158 Table
TypesLegType 0 0 1 9 Table
TypesLongShort 0 0 1 2 Table
TypesOptionSettlement 0 0 1 2 Table
TypesOptionStyle 0 0 1 3 Table
TypesOptionType 0 0 1 2 Table
TypesOreTradeType 0 0 1 17 Table
TypesParties 0 0 1 6 Table
TypesSecurityCurves 0 0 1 1 Table
TypesTradeActionOwner 0 0 1 3 Table
TypesTradeActionType 0 0 1 3 Table