PortfolioSwaptionData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioSwaptionData_TradeId R
OptionDataLongShort varchar 5 √ null
TypesLongShort.value FK_PortfolioSwaptionData_OptionDataLongShort R
OptionDataOptionType varchar 10 √ null
TypesOptionType.value FK_PortfolioSwaptionData_OptionDataOptionType R
OptionDataStyle varchar 10 √ null
TypesOptionStyle.value FK_PortfolioSwaptionData_OptionDataStyle R
OptionDataSettlement varchar 10 √ null
TypesOptionSettlement.value FK_PortfolioSwaptionData_OptionDataSettlement R
OptionDataPayOffAtExpiry varchar 5 √ null
TypesBool.value FK_PortfolioSwaptionData_OptionDataPayOffAtExpiry R
OptionDataPremiumAmount decimal 20,3 √ null
OptionDataPremiumCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioSwaptionData_OptionDataPremiumCurrency R
OptionDataPremiumPayDate date 6 √ null

Table contained 32 rows

Indexes

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

Relationships

Close relationships within degrees of separation