Teams: Difference between revisions

From Expertiza_Wiki
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 33: Line 33:
!directory_num
!directory_num
|int(11)  
|int(11)  
|directory number where details 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 of submission
|Stores the grade assigned by the instructor, if any
|-  
|-  
!comment_for_submission
!comment_for_submission
|text
|text
|Stores the comments for the submission
|Stores feedback from the instructor for the team
|}  
|}  
== E/R diagram of tables referencing users table  ==
== E/R diagram of tables referencing users table  ==

Latest revision as of 23:28, 3 November 2022

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 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 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.