PortfolioFxOptionData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioFxOptionData_TradeId R
BoughtCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioFxOptionData_BoughtCurrency R
BoughtAmount decimal 20,3 √ null
SoldCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioFxOptionData_SoldCurrency R
SoldAmount decimal 20,3 √ null
OptionDataLongShort varchar 5 √ null
TypesLongShort.value FK_PortfolioFxOptionData_OptionDataLongShort R
OptionDataOptionType varchar 10 √ null
TypesOptionType.value FK_PortfolioFxOptionData_OptionDataOptionType R
OptionDataStyle varchar 10 √ null
TypesOptionStyle.value FK_PortfolioFxOptionData_OptionDataStyle R
OptionDataSettlement varchar 10 √ null
TypesOptionSettlement.value FK_PortfolioFxOptionData_OptionDataSettlement R
OptionDataPayOffAtExpiry varchar 5 √ null
TypesBool.value FK_PortfolioFxOptionData_OptionDataPayOffAtExpiry R
OptionDataPremiumAmount decimal 20,3 √ null
OptionDataPremiumCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioFxOptionData_OptionDataPremiumCurrency R
OptionDataPremiumPayDate date 6 √ null

Table contained 5 rows

Indexes

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

Relationships

Close relationships within degrees of separation