ORE
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
PortfolioIndexCreditDefaultSwapData
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
TradeId
varchar
180
null
PortfolioTrades
.Id
FK_PortfolioIndexCreditDefaultSwapData_TradeId
R
CreditCurveId
varchar
30
null
TypesParties
.value
FK_PortfolioIndexCreditDefaultSwapData_CreditCurveId
R
SettlesAccrual
varchar
5
√
null
TypesBool
.value
FK_PortfolioIndexCreditDefaultSwapData_SettlesAccrual
R
PaysAtDefaultTime
varchar
5
√
null
TypesBool
.value
FK_PortfolioIndexCreditDefaultSwapData_PaysAtDefaultTime
R
ProtectionStart
date
6
√
null
UpfrontDate
date
6
√
null
UpfrontFee
decimal
20,3
√
null
Showing 1 to 7 of 7 entries
Table contained
0
rows
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
PK_PortfolioIndexCreditDefaultSwapData
Primary key
Asc
TradeId
Showing 1 to 1 of 1 entries
Relationships
Close relationships within degrees of separation
One
Two degrees