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 difference)
|
Latest revision as of 00:20, 25 April 2018
| 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.