Roles permissions: Difference between revisions

From Expertiza_Wiki
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...")
 
 
(One intermediate revision by the same user not shown)
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 Roles Permissions Table as Foreign Key Relationship.




Back to [http://wikis.lib.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.