Roles: 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 |- !name |varchar(255) |Name of the ...")
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
The Roles table gives information regarding different user roles.
== Roles Variable Documentation ==
{| class="wikitable"  
{| class="wikitable"  
!Name !!Datatype !!Description
!Name !!Datatype !!Description
Line 12: Line 15:
!parent_id   
!parent_id   
|int(11)   
|int(11)   
|The role that is created by this particular user; By default, students may not ne parents of any role.
|The role that is created by this particular user; By default, students may not be parents of any role.
|-  
|-  
!description   
!description   
Line 34: Line 37:
|Time stamp of the date updated.
|Time stamp of the date updated.
|}  
|}  
== E/R diagram for Parents Tables ==
No Tables were referred by the Roles Table as Foreign Key Relationship.
== E/R diagram for Child Tables ==
No Tables were referred by the Roles 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 22:03, 25 April 2018

The Roles table gives information regarding different user roles.

Roles Variable Documentation

Name Datatype Description
id int(11) Primary key of the entry in table, auto increments by default
name varchar(255) Name of the role detailed
parent_id int(11) The role that is created by this particular user; By default, students may not be parents of any role.
description varchar(255) The description associated with the nature of the role
default_page_id int(11) NULL at the moment, the default page_id that is displayed to the user, depending on the role
cache text Cache storage information
created_at datetime Time stamp of the date created
updated_at datetime Time stamp of the date updated.

E/R diagram for Parents Tables

No Tables were referred by the Roles Table as Foreign Key Relationship.


E/R diagram for Child Tables

No Tables were referred by the Roles Table as Foreign Key Relationship.


Back to Database Tables Main page.