Teams users: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 29: | Line 29: | ||
|int(11) | |int(11) | ||
|id of the participant object for this user in this assignment. (This field is not yet in use.) | |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 table == | ||
This table is not referenced by any other tables | This table is not referenced by any other tables | ||
Latest revision as of 19:57, 24 September 2024
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.