Suggestions

From Expertiza_Wiki
Revision as of 00:20, 25 April 2018 by Smishra4 (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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.