PortfolioCreditDefaultSwapData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioCreditDefaultSwapData_TradeId R
IssuerId varchar 30 null
TypesParties.value FK_PortfolioCreditDefaultSwapData_IssuerId R
CreditCurveId varchar 30 null
TypesParties.value FK_PortfolioCreditDefaultSwapData_CreditCurveId R
SettlesAccrual varchar 5 √ null
TypesBool.value FK_PortfolioCreditDefaultSwapData_SettlesAccrual R
PaysAtDefaultTime varchar 5 √ null
TypesBool.value FK_PortfolioCreditDefaultSwapData_PaysAtDefaultTime R
ProtectionStart date 6 √ null
UpfrontDate date 6 √ null
UpfrontFee decimal 20,3 √ null

Table contained 2 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PortfolioCreditDefaultSwapData Primary key Asc TradeId

Relationships

Close relationships within degrees of separation