PortfolioEquityOptionData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioEquityOptionData_TradeId R
Name varchar 20 √ null
TypesEquityCurves.value FK_PortfolioEquityOptionData_Name R
Currency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioEquityOptionData_Currency R
Strike decimal 20,3 √ null
Quantity decimal 20,3 √ null
OptionDataLongShort varchar 5 √ null
TypesLongShort.value FK_PortfolioEquityOptionData_OptionDataLongShort R
OptionDataOptionType varchar 10 √ null
TypesOptionType.value FK_PortfolioEquityOptionData_OptionDataOptionType R
OptionDataStyle varchar 10 √ null
TypesOptionStyle.value FK_PortfolioEquityOptionData_OptionDataStyle R
OptionDataSettlement varchar 10 √ null
TypesOptionSettlement.value FK_PortfolioEquityOptionData_OptionDataSettlement R
OptionDataPayOffAtExpiry varchar 5 √ null
TypesBool.value FK_PortfolioEquityOptionData_OptionDataPayOffAtExpiry R
OptionDataPremiumAmount decimal 20,3 √ null
OptionDataPremiumCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioEquityOptionData_OptionDataPremiumCurrency R
OptionDataPremiumPayDate date 6 √ null

Table contained 11 rows

Indexes

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

Relationships

Close relationships within degrees of separation