← developers
Entity-relationship model
Click an entity to expand its attributes — primary keys, foreign keys, classification, and PII/MNPI. Foreign keys draw as connectors between entities. Pick a role to apply attribute-level masking live.
Public — clearance up to public · PII ✗ · MNPI ✗ — Anonymous / external. Public reference facts only.
- PKcounterparty_idstringinternal
- leistringpublic
- legal_namestringpiiconfidential
- country_codestringinternal
- credit_ratingstringconfidential
- internal_risk_scoreintmnpirestricted
- PKcurrency_codestringpublic
- namestringpublic
- minor_unitsintpublic
- PKinstrument_idstringinternal
- isinstringpublic
- cusipstringpublic
- namestringpublic
- asset_classstringpublic
- FKcurrency_codestringpublic
- PKposition_idstringinternal
- book_idstringinternal
- FKinstrument_idstringinternal
- as_of_datedateinternal
- quantitydecimal(18,4)mnpiconfidential
- market_valuedecimal(18,2)mnpiconfidential
- FKcurrency_codestringpublic
- PKtrade_idstringinternal
- trade_datedateinternal
- FKinstrument_idstringinternal
- FKcounterparty_idstringinternal
- sidestringinternal
- quantitydecimal(18,4)mnpiconfidential
- pricedecimal(18,6)mnpiconfidential
- notionaldecimal(18,2)mnpiconfidential
- FKcurrency_codestringpublic
- trader_idstringpiirestricted
Lines are foreign keys (● marks the referenced primary key). Hover an entity to isolate its relationships.