Roles permissions: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 24: | Line 24: | ||
== E/R diagram for Child Tables == | == E/R diagram for Child Tables == | ||
No Tables were referred by the | No Tables were referred by the Roles Permissions Table as Foreign Key Relationship. | ||
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Latest revision as of 23:50, 24 April 2018
The Roles Permissions table gives information regarding the permissions given to each of the user roles.
Roles Permissions Variable Documentation
| Name | Datatype | Description ! |
|---|---|---|
| id | int(11) | Primary key of the entry in table, auto increments by default |
| role_id | int(11) | Identifies particular role; foreign key into ROLES table |
| permission_id | int(11) | Identifies respective permissions; FK into ROLES table |
E/R diagram for Parents Tables
No Tables were referred by the Roles Permissions Table as Foreign Key Relationship.
E/R diagram for Child Tables
No Tables were referred by the Roles Permissions Table as Foreign Key Relationship.
Back to Database Tables Main page.