It is now the 5th OPEN Period for CACAO Fall 2017! It will end on Tuesday November 21, 2017 at 11:59 pm CST
This is your chance to make annotations OR challenge other team's annotations. You may also DEFEND or suggest improvements to your own annotations IF they have been challenged. Please note, although we ENCOURAGE challenges, an excess of identical challenges that do not appear to be applicable to the annotation or well thought out will be considered spam and ignored.

Have any questions? Please email us at ecoliwiki@gmail.com

Archived Cacao semesters

From GONUTS
Jump to: navigation, search


Archived data

The CACAO class is powered by a custom MediaWiki extension. Since inception, the software has grown in complexity to accommodate the needs of the class. In the Summer of 2011 the software was rewritten and the database-schema expanded. These changes were not 100% backwards-compatible, meaning that the data (the scores for teams and annotations per student) from the previous semesters of CACAO could not be displayed. However, this data has been archived and is freely available.

Downloads

Please download the data the following URL: http://gonuts.tamu.edu/files/cacao_archive.sql.gz

Documentation

The data is gzipped SQL, from a MySQL 5.5.19 database. It can be loaded directly into most standard MySQL installations with the following command (you will probably need to know your MySQL username/password):

gunzip -c cacao_archive.sql.gz | mysql -u USERNAME -pPASSWORD DATABASE

MySQL describe

Using the MySQL DESCRIBE command, the single table looks like this:

+--------------------------+--------------------------------------+------+-----+-------------------+-----------------------------+
| Field                    | Type                                 | Null | Key | Default           | Extra                       |
+--------------------------+--------------------------------------+------+-----+-------------------+-----------------------------+
| challenge_id             | int(15) unsigned                     | NO   | PRI | NULL              | auto_increment              | 
| row_id                   | int(10) unsigned                     | NO   | MUL | NULL              |                             | 
| author                   | int(5) unsigned                      | NO   |     | NULL              |                             | 
| author_group             | text                                 | YES  |     | NULL              |                             | 
| rebuttal                 | text                                 | YES  |     | NULL              |                             | 
| challenger               | int(5) unsigned                      | NO   |     | NULL              |                             | 
| challenger_group         | text                                 | YES  |     | NULL              |                             | 
| awarded_identified       | tinyint(1)                           | YES  |     | NULL              |                             | 
| awarded_corrected        | tinyint(1)                           | YES  |     | NULL              |                             | 
| reason                   | text                                 | YES  |     | NULL              |                             | 
| corrected_annotation     | text                                 | YES  |     | NULL              |                             | 
| challenge_time           | datetime                             | YES  |     | NULL              |                             | 
| rebuttal_time            | datetime                             | YES  |     | NULL              |                             | 
| judgement_time           | datetime                             | YES  |     | NULL              |                             | 
| reviewer                 | int(5) unsigned                      | YES  |     | NULL              |                             | 
| public_reviewer_comments | text                                 | YES  |     | NULL              |                             | 
| private_review_comments  | text                                 | YES  |     | NULL              |                             | 
| status                   | enum('submitted','refuted','judged') | YES  |     | NULL              |                             | 
| timestamp                | timestamp                            | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | 
| accepted                 | bit(1)                               | YES  |     | NULL              |                             | 
| accepted_uid             | int(5) unsigned                      | YES  |     | NULL              |                             | 
| session                  | text                                 | YES  |     | NULL              |                             | 
+--------------------------+--------------------------------------+------+-----+-------------------+-----------------------------+


The meaning of the columns is:

challenge_id Unique identifier for the table
row_id A foreign key to the TableEdit ext_TableEdit_row database table, referencing the row of a table which contains the annotation
author A foreign key to the user table, the author of the annotation
author_group The group of the annotations author
rebuttal The rebuttal of the author, entered after the annotation was challenged
challenger Foreign key to the user table, the student challenging this annotation
challenger_group The group of the challenger
awarded_identified Points awarded for identifying a problem
awarded_corrected Points awarded for correcting a problem
reason The reason for the challenge
corrected_annotation The (optional) corrected annotation to accompany the challenge
challenge_time Timestamp of the challenge action
rebuttal_time Timestamp of the rebuttal action
judgement_time Timestamp of the judgement action
reviewer Foreign key to the user table, the instructor that reviewed the challenge
public_reviewer_comments Publicly available comments made by the instructor/reviewer
private_review_comments Comments that can only be seen by admins/instructors/reviewers
status The current status of this annotation/challenge
timestamp Timestamp of the last thing that occured
accepted Whether or not this annotation was acceptable for inclusion into the Gene Association File
accepted_uid Foreign key to the user table, the instructor that marked this annotation as acceptable
session The CACAO semester/session for this annotation/challenge