The Instrument diagram contains data structures that represent financial instruments and tables that store that information. It stores information that is common to all instruments: the name, trading symbol, issue date, issuer rating, trading currency, and exchange.
Detailed information about each type of instrument represented in the model (that is, stocks, bonds, mutual funds, exchange-traded funds (ETF), and options) is stored in a corresponding table. Thus, stock-related information is stored in the Stock (STOCK) table, bond-related information is stored in the Bond (BOND) table, and so on.
The association table Instrument Exchange (INSTR_EXCHANGE) specifies exchanges where an instrument is traded. The Instrument Rating (INSTR_RATING) table stores information on the ratings assigned to an instrument by rating agencies (for example, Moody's Investor Service, Standard & Poor's Corporation, Fitch Ratings).
Information on market indexes is stored in the Market Index (MARKET_INDEX) table. The Index Composition (INDEX_CMPST) table stores information on an index composition and is used to specify all instruments included in an index. The Instrument Benchmark (INSTR_BENCHMK) table specifies a market index (or indexes) used as a benchmark for a given financial instrument.
The association tables Underlying Index (ULYING_INDEX) and Underlying Instrument (ULYING_INSTR) are used, respectively, to specify an underlying index or an underlying financial instrument for an option.