System Domain

There are a number of tables in the system that have no clear domain as they can be used across the system.

There is a technical debt ticket in the backlog to reactor each of these tables adding a “System” prefix to the table name.

The following tables are defined in the entity domain:

• FinanceCalendar - Really this is an analytics dimension table that provides data to aid in the presentation of data in fiscal and non-fiscal period groups

• UK_BankHolidays - Used within the system to compute the next UK banking day when setting invoice dates

• ExchangeRate - Used as a cache mechanism for exchange rates. Ideally this would be removed from the database in favour of a redis cache within the infrastructure. Actual exchange rates are stamped on relevant booking and finance records are runtime.

• Brand - Used to store colours, fonts and logos for brands that are then applied to white-labe and Hub sites for certain Partners and ParnerChannels

• SystemHierarchy - Initially developed in support of store performant hierarchical data within the DB will be superseded by the use use of recursive Common Table Expressions (CTE) within MySQL V8