...
Contract (Contribution Collection)
- UUID (char(24) )
- m 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:dictionary:ContractStatus)
- PayementReference(string)
- Json_ext (json)
- DateCreated(date)
- DateUpdate(date)
- UserUpdateUUID(fk users)
- UserCreateUUID (fk users)
- ContractFrom (date)
- ContractTo (date)
...
Entity ContractDetails (input) - under Contract
- UUID (char(24) )
- ContractUUID (fk Contract)
- PolicyHolderInsureeUUID (fk PolicyHolderInsuree)
- ContributionPlanBundleUUID:Version(fk ContributionPlanBundle)
- Json_ext (json)
- Json_param (json)
- PolicyHolderInsuree parameters
- Json_param_history (json)
- Same as Json_ext but for audits
- DateCreated(date)
- DateUpdate(date)
- UserUpdateUUID(fk users)
- UserCreateUUID (fk users)
...
Entity ContractContributionPlanDetails (output) - under ContractDetails
- UUID (char(24) )
- Version ( integer - to be used for optimistic locking)
- ContributionPlanUUID :Version (fk_contributionPlan)
- PolicyUUID (fk_policy)ContributionUUID:Version (fk premium)
- ContractDetailsUUID
- Json_ext (json)
- ContributionPlan parameters
- DateCreated(date)
- DateUpdate(date)
- UserUpdateUUID(fk users)
- UserCreateUUID (fk users)
...