Database model - Atoti Hub

The common layer defines a set of shared database tables that represent standard financial entities such as trades, counterparties, books, and instruments. Solutions build on these tables by adding their own domain-specific tables and joining them to the common ones. Understanding the common data model is a prerequisite before reading the database model documentation for any specific solution.

What tables are shared across solutions?

The following tables are defined by the common layer and may be used by any solution.

Table	Key fields	Description
`TradeAttributes`	`AsOfDate`, `TradeId`	Descriptive attributes for each trade, such as trader, sales, and organizational references.
`CounterpartyAttributes`	`AsOfDate`, `CounterpartyId`	Counterparty classification data including name, rating, and geography. Optional; availability depends on the solution.
`OrganizationAttributes`	`AsOfDate`, `OrganizationUnitId`	Organizational hierarchy entries. Optional; availability depends on the solution.
`BookAttributes`	`AsOfDate`, `BookId`	Book hierarchy entries. Optional; availability depends on the solution.
`BookStructure`	`AsOfDate`, `StructureLeafId`	Parent-child structure supporting the Books dimension hierarchy.
`CounterpartyStructure`	`AsOfDate`, `StructureLeafId`	Parent-child structure supporting the Counterparties dimension hierarchy.
`OrganizationStructure`	`AsOfDate`, `StructureLeafId`	Parent-child structure supporting the Organization dimension hierarchy.
`InstrumentAttributes`	`AsOfDate`, `InstrumentId`	Instrument reference data including identifiers, asset class, and option fields.
`Bucketing`	`AsOfDate`, `Underlying`, `BucketingMatrix`, `Tenor`, `TargetTenor`	Bucketing definitions mapping tenors to target tenors with an associated factor.
`VectorExpansion`	none (no key)	Vector expansion support used for scenario-based calculations.
`FxRateMarketData`	`AsOfDate`, `MarketDataSet`, `BaseCcy`, `CounterCcy`	FX rates for currency conversion. Provided by the market-data library.

For the complete field-level reference of every table, see Tables.

​What tables are shared across solutions?

​Related pages

What tables are shared across solutions?

Related pages