Role-Based Access Control (RBAC)

ER-Model

Non-Identifying Relationships 是指子表的資料必須不依賴於母表的資料而存在.母表的primary key欄位不為子表primary key的一部分. 簡單來說差別在於 Non-Identifying 的 FK 可為 NULL.

Reference

• https://mysql.tutorials24x7.com/blog/guide-to-design-database-for-rbac-in-mysql
• https://iter01.com/549277.html
• https://www.jianshu.com/p/1d20fd8c3029