Roles: 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 |- !name |varchar(255) |Name of the ...") |
No edit summary |
||
| 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 | |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://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. | Back to [http://wikis.lib.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
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.
Back to Database Tables Main page.