...

This module won't have ad-hoc authorities.

Entities

CalculationRules

...

(

...

HistoryBusinessModel)

...

• CalculationClassName(varchar)

• Status (int)

• Description (varchar)

• Version (int)

• Json_ext (json)

• DateCreated(date)

• DateUpdate(date)

• UserUpdateUUID(fk users)

• UserCreateUUID (fk users)

• DateValidFrom (date)

• DateValidTo (date)

• Priority (int)

sub table CalculationRulesDetails

...

(HistoryModel)

• CalculationRulesUUID (varchar)

• Status (int)

• ClassName

• Main (bool)

• Params (Json)

• ClassParams(json)

  • Type

  • rights

  • Relevance

  • conditions

• Json_ext (json)

• DateCreated(date)

• DateUpdate(date)

• UserUpdateUUID(fk users)

• UserCreateUUID (fk users)

Detailed design

Calculations Backend Module

...