PortfolioCPICapFloorData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioCPICapFloorData_TradeId R
LongShort varchar 5 null
TypesLongShort.value FK_PortfolioCPICapFloorData_LongShort R
Currency varchar 7 null
TypesCurrencyCode.value FK_PortfolioCPICapFloorData_Currency R
CapFloor varchar 5 null
TypesCapFloor.value FK_PortfolioCPICapFloorData_CapFloor R
Notional decimal 20,3 null
StartDate date 6 null
MaturityDate date 6 null
IndexName varchar 30 null
TypesIndexName.value FK_PortfolioCPICapFloorData_IndexName R
ObservationLag varchar 5 null
BaseCPI decimal 20,3 null
Strike decimal 20,3 null
FixCalendar varchar 20 null
PayCalendar varchar 20 null
FixConvention varchar 20 null
TypesBusinessDayConvention.value FK_PortfolioCPICapFloorData_FixConvention R
PayConvention varchar 20 null
TypesBusinessDayConvention.value FK_PortfolioCPICapFloorData_PayConvention R

Table contained 4 rows

Indexes

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

Relationships

Close relationships within degrees of separation