Teams: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) | |- !name |varchar(255) |Name of the team |- !parent_id |int(11) |ID of assignment that thi...") |
No edit summary |
||
| Line 18: | Line 18: | ||
|Type of the team | |Type of the team | ||
|- | |||
!comments_for_advertisement | |||
|text | |||
|text for comments | |||
|- | |||
!advertise_for_partner | |||
|tinyint(1) | |||
|Boolean variable to store whether it has to be advertized by partner*** | |||
|- | |||
!submitted_hyperlinks | |||
|text | |||
|List of submitted hyperlinks | |||
|- | |||
!directory_num | |||
|int(11) | |||
|directory number where details are stored | |||
|- | |||
!grade_for_submission | |||
|int(11) | |||
|Stores the grade of submission | |||
|- | |||
!comment_for_submission | |||
|text | |||
|Stores the comments for the submission | |||
|} | |} | ||
== E/R diagram of tables referencing users table == | |||
The following image shows the tables referencing teams table | |||
[[File:teams_export.png]] | |||
== E/R diagram of tables users table is referencing to == | |||
The teams table is not referenced by any other tables | |||
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Revision as of 22:37, 24 April 2018
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | |
| name | varchar(255) | Name of the team |
| parent_id | int(11) | ID of assignment that this team is participating in |
| type | varchar(255) | Type of the team |
| comments_for_advertisement | text | text for comments |
| advertise_for_partner | tinyint(1) | Boolean variable to store whether it has to be advertized by partner*** |
| submitted_hyperlinks | text | List of submitted hyperlinks |
| directory_num | int(11) | directory number where details are stored |
| grade_for_submission | int(11) | Stores the grade of submission |
| comment_for_submission | text | Stores the comments for the submission |
E/R diagram of tables referencing users table
The following image shows the tables referencing teams table
E/R diagram of tables users table is referencing to
The teams table is not referenced by any other tables
Back to Database Tables Main page.