Skip to main content


Data Dictionary - Entity Table: Restriction#

This table contains predetermined restriction types and circumstances by which these restrictions should be checked. Limits for different investment strategies can be set based on asset classifications (industry, region, asset class) and specific instruments types (Amazon shares). The group of tables linked to Restrictions can be applied to check if the portfolio fits the predetermined investment strategy or if a proposed transaction will unbalance the portfolio.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID,(auto creates)
NameVARCHAR(45)NULLAmazon; TobaccoName of the restriction
OwnerBIGINT(12)NULL1Related to Business_Partner table. Owner column can determine which user is able to review and change this settings.
Pre_Deal_CheckTINYINTNULL1Determines to check this restriction or not, before conducting the deal (transaction) to assure it will not break restriction threshold
Batch_CheckTINYINTNULL1Determines whether to check this restriction regularly on a batch basis
OverridableTINYINTNULL0Determines whether it could be overridden
RestrictionOwner(Owner)Business_Partner (id)NO ACTIONNO ACTION
Owner_idxRestriction(Owner ASC)VISIBLE.