...
Code (varchar 32)*
TradeName (varchar 256)*
LocationsUUID LocationsID (fk tblLocations)
Not limited to one level
Address (json 1024)
Phone (varchar 16)
Fax (varchar 16)
Email (varchar 256)
ContactName (json)
LegalForm (configEnum:legalForm)
ActivityCode (configEnum:activity)
AccountancyAccount (varchar 64)
?bankAccount (json)( validation: (^.+$))
PaymentReference (varchar 128)
...
Version (integer - to be used for optimistic locking)
PolicyHolderUUID (fk policyHolder)*
InsureeUUID InsureeID (fk Insuree)*
ContributionPlanBundleUUID (fk_contributionPlanBundle)
LastPolicyUUID (fk Policy)
...
It should be possible to sort the result per column in ASC or DESC order
PolicyHolder PHCPB create
All fields could be changed but the PH which is define by the parent page
CPB
DateValidFrom
DateValidTo
PolicyHolder PHCPB replace
All fields could be changed but the PH which is define by the parent page
CPB
DateValidFrom
DateValidTo
PolicyHolder PHCPB edit
Only dateValidTo can be changed
...