The Relationship Specification has a detailed description of where the documentation is?

erd

#1

On update and On delete, what’s the effect? Where can I find the relevant documentation?


#2

Hi Donie,

It is foreign key’s on update/delete option:


#3

Hi Kit.So

What’s Cascade , Set null , Set default, Restrict, No action?

What is the impact after the selection?


#4

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