...
- 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 dictionnaryconfigEnum:legalForm )
- ActivityCodeUUID (fk dictionnaryconfigEnum:activity)
- AccountancyAccount (varchar)
- PaymentReference (varchar)
- DateValidFrom (date)
- DateValidTo (date)
- Active (bool)
- Json_ext (json)
- DateCreated (date)
- DateUpdated (date)
- UserUpdatedUUID (fk users)
- UserCreatedUUID (fk users)
...
- UUID (char(24) )
- UserUUID (fk_contributionPlanBundleuser)
- PolicyHolderUUID (fk policyHolder)
- Json_ext (json)
- DateCreated (date)
- DateUpdated (date)
- UserUpdatedUUID (fk users)
- UserCreatedUUID (fk users)
- Active (bool)
- DateValidFrom (date)
- DateValidTo (date)
...