Roles permissions: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| class="wikitable" !Name !!Datatype !!Description ! |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !role_id |int(11) |Identifies p...") |
No edit summary |
||
| Line 1: | Line 1: | ||
The Roles Permissions table gives information regarding the permissions given to each of the user roles. | |||
== Roles Permissions Variable Documentation == | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !!Datatype !!Description ! | !Name !!Datatype !!Description ! | ||
| Line 14: | Line 17: | ||
|Identifies respective permissions; FK into ROLES table | |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 Roels Permissions Table as Foreign Key Relationship. | |||
Back to [http:// | Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Revision as of 23:47, 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 Roels Permissions Table as Foreign Key Relationship.
Back to Database Tables Main page.