PortfolioCommodityOptionData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioCommodityOptionData_TradeId R
Name varchar 20 √ null
TypesEquityCurves.value FK_PortfolioCommodityOptionData_Name R
Currency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioCommodityOptionData_Currency R
Strike decimal 20,3 √ null
Quantity decimal 20,3 √ null
OptionDataLongShort varchar 5 √ null
TypesLongShort.value FK_PortfolioCommodityOptionData_OptionDataLongShort R
OptionDataOptionType varchar 10 √ null
TypesOptionType.value FK_PortfolioCommodityOptionData_OptionDataOptionType R
OptionDataStyle varchar 10 √ null
TypesOptionStyle.value FK_PortfolioCommodityOptionData_OptionDataStyle R
OptionDataSettlement varchar 10 √ null
TypesOptionSettlement.value FK_PortfolioCommodityOptionData_OptionDataSettlement R
OptionDataPayOffAtExpiry varchar 5 √ null
TypesBool.value FK_PortfolioCommodityOptionData_OptionDataPayOffAtExpiry R
OptionDataPremiumAmount decimal 20,3 √ null
OptionDataPremiumCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioCommodityOptionData_OptionDataPremiumCurrency R
OptionDataPremiumPayDate date 6 √ null

Table contained 2 rows

Indexes

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

Relationships

Close relationships within degrees of separation