Teams: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{| class="wikitable" | == Teams Variable Documentation (Reimplementation) == | ||
!Field Name !!Type !! | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |||
!id | |||
|int(11) | |||
| | |||
|- | |||
!name | |||
|varchar(255) | |||
|Name of the team | |||
|- | |||
!parent_id | |||
|int(11) | |||
|ID of assignment or course that this team is participating in | |||
|- | |||
!type | |||
|varchar(255) | |||
|Type of the team, either AssignmentTeam or CourseTeam | |||
|- | |||
!submitted_hyperlinks | |||
|text | |||
|List of submitted hyperlinks | |||
|- | |||
!directory_num | |||
|int(11) | |||
|directory number where files submitted by this team are stored | |||
|- | |||
!grade_for_submission | |||
|int(11) | |||
|Stores the grade assigned by the instructor, if any | |||
|- | |||
!comment_for_submission | |||
|text | |||
|Stores feedback from the instructor for the team | |||
|} | |||
== Teams Variable Documentation (2023 version) == | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |- | ||
! | !id | ||
|int(11) | |int(11) | ||
| | | | ||
|- | |- | ||
! | !name | ||
|varchar(255) | |varchar(255) | ||
|Name of the team | |Name of the team | ||
|- | |- | ||
! | !parent_id | ||
|int(11) | |int(11) | ||
|ID of assignment or course that this team is participating in | |ID of assignment or course that this team is participating in | ||
|- | |- | ||
! | !type | ||
|varchar(255) | |varchar(255) | ||
|Type of the team, either AssignmentTeam or CourseTeam | |Type of the team, either AssignmentTeam or CourseTeam | ||
|- | |- | ||
! | !comments_for_advertisement | ||
|text | |text | ||
|text for comments | |text for comments | ||
|- | |- | ||
! | !advertise_for_partner | ||
|tinyint(1) | |tinyint(1) | ||
|Boolean | |Boolean that tells whether the team is advertising for a partner | ||
|- | |- | ||
! | !submitted_hyperlinks | ||
| | |text | ||
|List of submitted hyperlinks | |List of submitted hyperlinks | ||
|- | |- | ||
!directory_num | !directory_num | ||
|int(11) | |int(11) | ||
|directory number where files submitted by this team are stored | |directory number where files submitted by this team are stored | ||
|- | |- | ||
!grade_for_submission | !grade_for_submission | ||
|int(11) | |int(11) | ||
|Stores the grade assigned by the instructor, if any | |Stores the grade assigned by the instructor, if any | ||
|- | |- | ||
!comment_for_submission | !comment_for_submission | ||
|text | |text | ||
|Stores feedback from the instructor for the team | |Stores feedback from the instructor for the team | ||
|} | |} | ||
== E/R diagram of tables referencing users | |||
== E/R diagram of tables referencing users table == | |||
The following image shows the tables referencing teams table | The following image shows the tables referencing teams table | ||
[[File:teams_export.png]] | [[File:teams_export.png]] | ||
| Line 49: | Line 91: | ||
== E/R diagram of tables users table is referencing to == | == E/R diagram of tables users table is referencing to == | ||
The teams table is not referenced by any other tables | 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. | ||
Latest revision as of 03:42, 9 December 2025
Teams Variable Documentation (Reimplementation)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | |
| name | varchar(255) | Name of the team |
| parent_id | int(11) | ID of assignment or course that this team is participating in |
| type | varchar(255)
|
Type of the team, either AssignmentTeam or CourseTeam |
| submitted_hyperlinks | text | List of submitted hyperlinks |
| directory_num | int(11) | directory number where files submitted by this team are stored |
| grade_for_submission | int(11) | Stores the grade assigned by the instructor, if any |
| comment_for_submission | text | Stores feedback from the instructor for the team |
Teams Variable Documentation (2023 version)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | |
| name | varchar(255) | Name of the team |
| parent_id | int(11) | ID of assignment or course that this team is participating in |
| type | varchar(255)
|
Type of the team, either AssignmentTeam or CourseTeam |
| comments_for_advertisement | text | text for comments |
| advertise_for_partner | tinyint(1) | Boolean that tells whether the team is advertising for a partner |
| submitted_hyperlinks | text | List of submitted hyperlinks |
| directory_num | int(11) | directory number where files submitted by this team are stored |
| grade_for_submission | int(11) | Stores the grade assigned by the instructor, if any |
| comment_for_submission | text | Stores feedback from the instructor for the team |
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.