Skip to main content

Portfolio Structure

Data Dictionary - Entity Table: Portfolio_Structure#

The hierarchical structure maintained in Portfolio_Structure table allows maintanence of portfolios and sub-portfolios. For example a client can have general portfolio including different asset classes and this portfolio can be divided to sub-portfolios based on each asset class. This allows sub-portfolios to be managed entirely separately including optimization and rebalancing possibly even by differnet portfolio managers and with different strategies.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID,(auto creates)
ParentBIGINT(12)NULL1Id of Portfolio on the Top of hierarchy (parent). One portfolio can be linked to multiple sub-portfolios.
ChildBIGINT(12)NULL2Id of Portfolio on the bottom of the hierarchy (child) - sub-portfolio.
ParentPortfolio(Parent)Portfolio (id)NO ACTIONNO ACTION
ChildPortfolio(Child)Portfolio (id)NO ACTIONNO ACTION
Parent_idxPortfolio_Structure(Parent ASC)VISIBLE.
Child_idxPortfolio_Structure(Child ASC)VISIBLE.