Archived Cacao semesters

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