Teams: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
!parent_id | !parent_id | ||
|int(11) | |int(11) | ||
|ID of assignment that this team is participating in | |ID of assignment or course that this team is participating in | ||
|- | |- | ||
!type | !type | ||
|varchar(255) | |varchar(255) | ||
|Type of the team | |Type of the team, either AssignmentTeam or CourseTeam | ||
|- | |- | ||
!comments_for_advertisement | !comments_for_advertisement | ||
| Line 25: | Line 25: | ||
!advertise_for_partner | !advertise_for_partner | ||
|tinyint(1) | |tinyint(1) | ||
|Boolean | |Boolean that tells whether the team is advertising for a partner | ||
|- | |- | ||
!submitted_hyperlinks | !submitted_hyperlinks | ||
Latest revision as of 17:44, 28 October 2025
| 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.