Teams users: 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: | ||
== Teams Participants Variable Documentation (Reimplementation) == | |||
'''Note:''' This table has been renamed from ''teams_users'' to ''teams_participants''. | |||
The Teams Participants table maps users to teams; in rare cases, a single individual is on > 1 team for an assignment. | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |||
!id | |||
|int(11) | |||
| | |||
|- | |||
!team_id | |||
|int(11) | |||
|id of the team to which the user belongs to | |||
|- | |||
!user_id | |||
|int(11) | |||
|user id of student who belongs to the team | |||
| | |||
|- | |||
!duty_id | |||
|int(11) | |||
|indicates what role the user plays (what duty they have) for this assignment: manager, programmer, tester, etc. | |||
|- | |||
!pair_programming_status | |||
|varchar(1) | |||
|a team can declare that it is pair programming, so that members won't be penalized for not doing commits. | |||
| | |||
|- | |||
!participant_id | |||
|int(11) | |||
|id of the participant object for this user in this assignment. (This field is not yet in use.) | |||
|} | |||
== Teams Users Variable Documentation (2023 version) == | |||
The Teams table maps users to teams; in rare cases, a single individual is on > 1 team for an assignment. | The Teams table maps users to teams; in rare cases, a single individual is on > 1 team for an assignment. | ||
{| class="wikitable" | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | !Field Name !!Type !!Description | ||
|- | |- | ||
! | !id | ||
|int(11) | |int(11) | ||
| | | | ||
|- | |- | ||
! | !team_id | ||
|int(11) | |int(11) | ||
|id of the team to which the user belongs | |id of the team to which the user belongs to | ||
|- | |- | ||
! | !user_id | ||
|int(11) | |int(11) | ||
|user id of student who belongs to the team | |user id of student who belongs to the team | ||
| | | | ||
|- | |- | ||
! | !duty_id | ||
|int(11) | |int(11) | ||
|indicates what role the user plays (what duty they have) for this assignment: manager, programmer, tester, etc. | |indicates what role the user plays (what duty they have) for this assignment: manager, programmer, tester, etc. | ||
|- | |- | ||
! | !pair_programming_status | ||
|varchar(1) | |varchar(1) | ||
|a team can declare that it is pair programming, so that members won't be penalized for not doing commits. | |a team can declare that it is pair programming, so that members won't be penalized for not doing commits. | ||
| | | | ||
|- | |- | ||
! | !participant_id | ||
|int(11) | |int(11) | ||
|id of the participant object for this user in this assignment. | |id of the participant object for this user in this assignment. (This field is not yet in use.) | ||
|} | |||
| | |||
== E/R diagram of tables referencing teams_users table == | |||
== E/R diagram of tables referencing teams_users | |||
This table is not referenced by any other tables | This table is not referenced by any other tables | ||
Latest revision as of 03:56, 9 December 2025
Teams Participants Variable Documentation (Reimplementation)
Note: This table has been renamed from teams_users to teams_participants.
The Teams Participants table maps users to teams; in rare cases, a single individual is on > 1 team for an assignment.
| Field Name | Type | Description | |
|---|---|---|---|
| id | int(11) | ||
| team_id | int(11) | id of the team to which the user belongs to | |
| user_id | int(11)
|
user id of student who belongs to the team | |
| duty_id | int(11) | indicates what role the user plays (what duty they have) for this assignment: manager, programmer, tester, etc. | |
| pair_programming_status | varchar(1) | a team can declare that it is pair programming, so that members won't be penalized for not doing commits. | |
| participant_id | int(11) | id of the participant object for this user in this assignment. (This field is not yet in use.) |
Teams Users Variable Documentation (2023 version)
The Teams table maps users to teams; in rare cases, a single individual is on > 1 team for an assignment.
| Field Name | Type | Description | |
|---|---|---|---|
| id | int(11) | ||
| team_id | int(11) | id of the team to which the user belongs to | |
| user_id | int(11)
|
user id of student who belongs to the team | |
| duty_id | int(11) | indicates what role the user plays (what duty they have) for this assignment: manager, programmer, tester, etc. | |
| pair_programming_status | varchar(1) | a team can declare that it is pair programming, so that members won't be penalized for not doing commits. | |
| participant_id | int(11) | id of the participant object for this user in this assignment. (This field is not yet in use.) |
E/R diagram of tables referencing teams_users table
This table is not referenced by any other tables
E/R diagram of tables teams_users table is referencing to
The following image shows the tables referencing teams_users table is referencing to
Back to Database Tables Main page.