On update and On delete, what’s the effect? Where can I find the relevant documentation?
You can refer to database documentation, e.g. MySQL:
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html#foreign-keys-referential-actions
You can refer to database documentation, e.g. MySQL:
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html#foreign-keys-referential-actions