Skip to main content

Restriction Type

Data Dictionary - Entity Table: Restriction_Type#

This table defines the types of restrictions that can be enforced as well as to which Asset Classification Node/Instrument Attribute the Restriction is applicable.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
RestrictionBIGINT(12)NULL23Restriction id
Instrument_Attribute_Definition_IDBIGINT(12)NULL1Instrument Attribute Definition (id)
NodeBIGINT(12)NULL1Asset classification node id
SummableTINYINTNULL0If restriction is summable, it can be aggregated to parent level and rules applied to it. E.g: Energy can be limited to <=10% and two instruments Exxon <=4% and BP <=3%. If Exxon share is 5% - it is violated, BP is 2% and is not violated. When Summable, Exxon + BP is not violated
TypeENUM("Node", "Attribute")NULLNode; AttributeAsset classification node or attribute
Instrument_idVARCHAR(45)NULLAmazonGeneral instrument name
id(Restriction)Restriction (id)NO ACTIONNO ACTION
Instrument_Attribute(Instrument_Attribute)Instrument_Attribute_ Definition (id)NO ACTIONNO ACTION
Node(Node)Asset_Classification_ Node (id)NO ACTIONNO ACTION
id_idxRestriction_Type(Restriction ASC)VISIBLE.
Instrument_Attribute_idxRestriction_Type(Instrument_Attribute ASC)VISIBLE.
Node_idxRestriction_Type (Node ASC)VISIBLE.