Roles: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 49: Line 49:


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