...
- UUID (char(24) )
- Code (varchar)
- Version ( integer - to be used for optimistic locking)
- TradeName (varchar)
- LocationsUUID (fk tblLocations)
- Not limited to one level
- Address (varchar)
- Phone (varchar)
- Fax (varchar)
- Email (varchar)
- ContactName (varchar)
- LegalFormUUID (fk dictionnary:legalForm )
- ActivityCodeUUID (fk dictionnary:activity)
- AccountancyAccount (varchar)
- PaymentReference (varchar)
- DateValidFrom (date)
- DateValidTo (date)
- Active (bool)
- Json_ext (json)
- DateCreated (date)
- DateUpdated (date)
- UserUpdated UUID UserUpdatedUUID (fk users)UserCreated
- UUID UserCreatedUUID (fk users)
PolicyHolderInsuree
- UUID (char(24) )
- Version ( integer - to be used for optimistic locking)
- PolicyHolderUUID (fk policyHolder)
- InsureeUUID (fk Insuree)
- ContributionPlanBundleUUID (fk_contributionPlanBundle)
- LastPolicyUUID (fk Policy)
- Json_ext (json)
- DateCreated (date)
- DateUpdateDateUpdated (date)
- UserUpdateUUIDUserUpdatedUUID (fk users)
- UserCreateUUID UserCreatedUUID (fk users)
PolicyHolderContributionPlan
- UUID (char(24) )
- Version (integer - to be used for optimistic locking)
- ContributionPlanBundleUUID (fk_contributionPlanBundle)
- PolicyHolderUUID (fk policyHolder)
- Json_ext (json)
- DateCreated (date)
- DateUpdateDateUpdated (date)
- UserUpdateUUIDUserUpdatedUUID (fk users)
- UserCreateUUID UserCreatedUUID (fk users)
- Active (bool)
- DateValidFrom (date)
- DateValidTo (date)
...
- UUID (char(24) )
- UserUUID (fk_contributionPlanBundle)
- PolicyHolderUUID (fk policyHolder)
- Json_ext (json)
- DateCreated (date)
- DateUpdateDateUpdated (date)
- UserUpdateUUIDUserUpdatedUUID (fk users)
- UserCreateUUID UserCreatedUUID (fk users)
- Active (bool)
- DateValidFrom (date)
- DateValidTo (date)
...