...

• UUID (char(24) )

• Version (optimistic locking)

• PolicyHolderUUID (fk policyHolder)

• AmountNotified (float)

  • Upon Automatic creation

• AmountRectified (float)

  • Manual update from the policy holder

• AmountDue (float)

  • Value approved by the Scheme admins

• PaymentDateDue (date)

• Status (fk:dictionaryConfigEnum:ContractStatus)

• PayementReference(string)

• Json_ext (json)

• DateCreated(date)

• DateUpdate(date)

• UserUpdateUUID(fk users)

• UserCreateUUID (fk users)

• ContractFrom (date)

• ContractTo (date)

...

• UUID (char(24) )

• Version ( integer - to be used for optimistic locking)

• ContributionPlanUUID (fk_contributionPlan)

• PolicyUUID (fk_policy)

• ContractDetailsUUID 

• Json_ext (json)

  • ContributionPlan parameters

• DateCreated(date)

• DateUpdate(date)

• UserUpdateUUID(fk users)

• UserCreateUUID (fk users)

Details design

Details design

Back end module

Mutations

Permissions

Services

Front end

search page

card