Suggestions: 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 |- !assignment_id |int(11) |ID of the...") |
No edit summary |
||
| Line 1: | Line 1: | ||
{| class="wikitable" | == Suggestions Variable Documentation (Reimplementation) == | ||
{| class="wikitable" | |||
!Name !!Datatype !!Description | !Name !!Datatype !!Description | ||
|- | |- | ||
! | !id | ||
|int(11) | |int(11) | ||
|Primary key of the entry in table, auto increments by default | |Primary key of the entry in table, auto increments by default | ||
|- | |||
!assignment_id | |||
|int(11) | |||
|ID of the assignment for which suggestions are published | |||
|- | |||
!title | |||
|varchar(255) | |||
|Stores the title of the suggestion | |||
|- | |||
!description | |||
|text | |||
|Stores the description of the suggestion | |||
|- | |||
!status | |||
|varchar(255) | |||
|Stores the status of the suggestion(Initiated/Approved/Rejected) | |||
|- | |||
!username | |||
|varchar(255) | |||
|Stores the username of the user who provides suggestion (formerly unityID) | |||
|- | |||
!signup_preference | |||
|varchar(255) | |||
|Stores the signup_preference(Y/N) of the user who provides suggestion | |||
|} | |||
|- | == Suggestions Variable Documentation (2023 version) == | ||
{| class="wikitable" | |||
!Name !!Datatype !!Description | |||
|- | |||
!id | |||
|int(11) | |||
|Primary key of the entry in table, auto increments by default | |||
|- | |||
!assignment_id | !assignment_id | ||
|int(11) | |int(11) | ||
|ID of the assignment for which suggestions are published | |ID of the assignment for which suggestions are published | ||
|- | |- | ||
!title | !title | ||
|varchar(255) | |varchar(255) | ||
|Stores the title of the suggestion | |Stores the title of the suggestion | ||
|- | |- | ||
!description | !description | ||
|text | |text | ||
|Stores the description of the suggestion | |Stores the description of the suggestion | ||
|- | |- | ||
!status | !status | ||
|varchar(255) | |varchar(255) | ||
|Stores the status of the suggestion(Initiated/Approved/Rejected) | |Stores the status of the suggestion(Initiated/Approved/Rejected) | ||
|- | |- | ||
!unityID | !unityID | ||
|varchar(255) | |varchar(255) | ||
|Stores the unityID of the user who provides suggestion | |Stores the unityID of the user who provides suggestion | ||
|- | |- | ||
!signup_preference | !signup_preference | ||
|varchar(255) | |varchar(255) | ||
|Stores the signup_preference(Y/N) of the user who provides suggestion | |Stores the signup_preference(Y/N) of the user who provides suggestion | ||
|} | |||
== E/R diagram of tables referencing suggestions table == | |||
== E/R diagram of tables referencing suggestions | |||
The following table doesn't reference to other tables in the database | The following table doesn't reference to other tables in the database | ||
Latest revision as of 03:29, 9 December 2025
Suggestions Variable Documentation (Reimplementation)
| Name | Datatype | Description |
|---|---|---|
| id | int(11) | Primary key of the entry in table, auto increments by default |
| assignment_id | int(11) | ID of the assignment for which suggestions are published |
| title | varchar(255) | Stores the title of the suggestion |
| description | text | Stores the description of the suggestion |
| status | varchar(255) | Stores the status of the suggestion(Initiated/Approved/Rejected) |
| username | varchar(255) | Stores the username of the user who provides suggestion (formerly unityID) |
| signup_preference | varchar(255) | Stores the signup_preference(Y/N) of the user who provides suggestion |
Suggestions Variable Documentation (2023 version)
| Name | Datatype | Description |
|---|---|---|
| id | int(11) | Primary key of the entry in table, auto increments by default |
| assignment_id | int(11) | ID of the assignment for which suggestions are published |
| title | varchar(255) | Stores the title of the suggestion |
| description | text | Stores the description of the suggestion |
| status | varchar(255) | Stores the status of the suggestion(Initiated/Approved/Rejected) |
| unityID | varchar(255) | Stores the unityID of the user who provides suggestion |
| signup_preference | varchar(255) | Stores the signup_preference(Y/N) of the user who provides suggestion |
E/R diagram of tables referencing suggestions table
The following table doesn't reference to other tables in the database
E/R diagram of tables suggestions table is referencing to
The tag_prompts table is not referenced by any other tables
Back to Database Tables Main page.