Pull Requests Requirements

[ ] The PR title includes a brief description of the work done, including the Issue number if applicable.
[ ] The PR includes a video showing the changes for the work done.
[ ] The PR title follows conventional commit label standards.
[ ] The changes confirm to the OpenElis Global x3 Styleguide and design documentation.
[ ] The changes include tests or are validated by existing tests.
[ ] I have read and agree to the Contributing Guidelines of this project.

Summary

been trying to create a provider service test but i have PSQLException blocker, apparently the fields of active and desynchronized which hold a boolean value have been limited with one character as an entry which make true or false to be to long and therefore causing a BatchUpdateException hence rejecting data error:https://pastebin.com/YNFcL2WT
also tried to look into the hibernate/hbm/Provider.hbm.xml but it checks out fine still wondering where the problem might be for these fields to be 1 character
i also notice still in the hibernate/hbm/Provider.hbm.xml the field of PROVIDER_TYPE is also limited to with a lenght of 1 i fear that too can cause errors

Cc. @mozzy11

[Add relevant screenshots here if applicable]

[Add a link to the related issue or mention it here if applicable]

[Add any additional information or notes here]