PortfolioCreditDefaultSwapData

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Table contained 2 rows

Indexes

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

Relationships

Close relationships within degrees of separation

One
Two degrees