Skip to main content


Data Dictionary - Entity Table: Price#

This table records the price of an Instrument as of a specific date and time. The information can be taken from third party provider or can be internally calculated based on variety of valuation methodologies.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN2PrimaryKey-ID, Not Null (auto creates)
Instrument_idBIGINT(12)NULL1Instrument ID from the Instrument table for the specific instrument.
Currency_idBIGINT(12)NULL1ID of the currency from Currency table. Currency can be based on the market where the instrument is traded or based on the currency in which we have invested in the instrument.
Quote_type_idBIGINT(12)NULL1Id from Price_Quote table
Instrument_PriceDECIMAL(25,9)NULL58Price of the instrument - can be calculated internally or taken directly from market data provider (for example Bloomberg).
TimestampTIMESTAMP(3)NULL'12/31/2001'Date on which the valuation was performed.
Instrument_price(Instrument)Instrument(id)NO ACTIONNO ACTION
Currency_price(Currency)Currency(id)NO ACTIONNO ACTION
Type_price(Price_quote)Price_Quote(id)NO ACTIONNO ACTION
Instrument_id_idxPrice(Instrument_id ASC)VISIBLE.
Currency_price_idxPrice(Currency_id ASC)VISIBLE.
Type_price_idxPrice(Quote_type_id ASC)VISIBLE.