Skip to main content

Instrument Type Hierachy

Data Dictionary - Entity Table: Instrument_Type_Hierachy#

This table provides the hierarchy of instrument types ,e.g. Equites -> Common stock. This hierarchy can help for operational processes, by providing the link between different attributes and different instrument types. The attributes applicable to one parent node should be applicable to all child nodes.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExamplesComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
Parent_Instrument_TypeBIGINT(12)NULL1Id for the top node of hierarchy (parent) of Instrument types. Recommended is to store only the direct relationships between parent node and child node.
Child_Instrument_TypeBIGINT(12)NULL3Id for the underlying node in the hierarchy (child) of Instrument types. More than one child node can be associated with parent node.
Instrument_Type_Parent(Parent_Instrument_Type)InstrumentType (id)NO ACTIONNO ACTION
Instrument_Type_Child(Child_Instrument_Type)Instrument_Type (id)NO ACTIONNO ACTION
Child_idxInstrument_Type_Hierachy(Child_Instrument_Type ASC)VISIBLE.
Parent_idxInstrument_Type_Hierachy(Parent_Instrument_Type ASC)VISIBLE.