Suggestions
Jump to navigation
Jump to search
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.