PortfolioIndexCreditDefaultSwapOptionData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioIndexCreditDefaultSwapOptionData_TradeId R
KnockOut varchar 5 √ null
TypesBool.value FK_PortfolioIndexCreditDefaultSwapOptionData_KnockOut R
OptionDataLongShort varchar 5 √ null
TypesLongShort.value FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataLongShort R
OptionDataOptionType varchar 10 √ null
TypesOptionType.value FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataOptType R
OptionDataStyle varchar 10 √ null
TypesOptionStyle.value FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataStyle R
OptionDataSettlement varchar 10 √ null
TypesOptionSettlement.value FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataSettl R
OptionDataPayOffAtExpiry varchar 5 √ null
TypesBool.value FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataPayOAtExp R
OptionDataPremiumAmount decimal 20,3 √ null
OptionDataPremiumCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioIndexCreditDefaultSwapOptionData_OptionDataPremCurr R
OptionDataPremiumPayDate date 6 √ null

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation