ORE
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
PortfolioFxForwardData
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
TradeId
varchar
180
null
PortfolioTrades
.Id
FK_PortfolioFxForwardData_TradeId
R
ValueDate
date
6
√
null
BoughtCurrency
varchar
7
√
null
TypesCurrencyCode
.value
FK_PortfolioFxForwardData_BoughtCurrency
R
BoughtAmount
decimal
20,3
√
null
SoldCurrency
varchar
7
√
null
TypesCurrencyCode
.value
FK_PortfolioFxForwardData_SoldCurrency
R
SoldAmount
decimal
20,3
√
null
Showing 1 to 6 of 6 entries
Table contained
4
rows
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
PK_PortfolioFxForwardData
Primary key
Asc
TradeId
Showing 1 to 1 of 1 entries
Relationships
Close relationships within degrees of separation
One
Two degrees