Roles: Difference between revisions
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. | ||
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.