Database constraints

👨‍💻 Development Help
1

Hi,
I am a new developer starting to work with SuiteCRM. I was reading the developer documentation and if I have understood correctly, vardefs are the objects used to specify the database structure (each one corresponds to a database table). I was wondering how can database constraints be specified or if these need to be programmed directly at the database level.
Thank you,

Javier

2

Hi Javier, welcome to the Community! :tada:

SuiteCRM handles all database constraints at the application level. Nothing is enforced in the DB layer, everything is enforced in PHP.

And it is not very rigorous on this. Many things are left orphan in the database, there are no cascaded deletes, etc

1 Like