Tohme Database Schema

mysql> show tables;
+------------------------------+
| Tables_in_tohme              |
+------------------------------+
| Assignments                  |
| BinnedLabels                 |
| GoldenLabels                 |
| Images                       |
| Intersections                |
| IpAddresses                  |
| LabelAttributes              |
| LabelBins                    |
| LabelConfidenceScores        |
| LabelCorrectnesses           |
| LabelingTaskAttributes       |
| LabelingTaskComments         |
| LabelingTaskCounts           |
| LabelingTaskEnvironments     |
| LabelingTaskInteractions     |
| LabelingTasks                |
| LabelPhotographerPovs        |
| LabelPoints                  |
| Labels                       |
| LabelTypes                   |
| NearbyPanoramas              |
| PanoramaLinks                |
| PanoramaProjectionProperties |
| Panoramas                    |
| Qualifications               |
| TaskImages                   |
| TaskPanoramaAttributes       |
| TaskPanoramas                |
| ValidationTaskCounts         |
| ValidationTaskInteractions   |
| ValidationTaskResults        |
| ValidationTasks              |
+------------------------------+
32 rows in set (0.00 sec)

mysql> describe Labels;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| LabelId            | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| LabelingTaskId     | int(11)          | NO   | MUL | NULL    |                |
| LabelGSVPanoramaId | varchar(64)      | NO   | MUL |         |                |
| LabelTypeId        | int(11)          | NO   |     | NULL    |                |
| Deleted            | tinyint(4)       | YES  |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> describe LabelPoints;
+-----------------+------------------+------+-----+---------+----------------+
| Field           | Type             | Null | Key | Default | Extra          |
+-----------------+------------------+------+-----+---------+----------------+
| LabelPointId    | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| LabelId         | int(11)          | NO   | MUL | NULL    |                |
| svImageX        | int(11)          | YES  |     | NULL    |                |
| svImageY        | int(11)          | YES  |     | NULL    |                |
| originalCanvasX | int(11)          | YES  |     | 0       |                |
| originalCanvasY | int(11)          | YES  |     | 0       |                |
| originalHeading | int(11)          | YES  |     | 0       |                |
| originalPitch   | int(11)          | YES  |     | 0       |                |
| originalZoom    | int(11)          | YES  |     | 1       |                |
| canvasX         | int(11)          | YES  |     | 0       |                |
| canvasY         | int(11)          | YES  |     | 0       |                |
| heading         | int(11)          | YES  |     | 0       |                |
| pitch           | int(11)          | YES  |     | 0       |                |
| zoom            | int(11)          | YES  |     | 1       |                |
| svImageHeight   | int(11)          | YES  |     | 6656    |                |
| svImageWidth    | int(11)          | YES  |     | 13312   |                |
| canvasHeight    | int(11)          | YES  |     | NULL    |                |
| canvasWidth     | int(11)          | YES  |     | NULL    |                |
| alphaX          | double           | YES  |     | NULL    |                |
| alphaY          | double           | YES  |     | NULL    |                |
| labelLat        | double           | YES  |     | NULL    |                |
| labelLng        | double           | YES  |     | NULL    |                |
+-----------------+------------------+------+-----+---------+----------------+
22 rows in set (0.00 sec)

mysql> select count(*) from LabelPoints;
+----------+
| count(*) |
+----------+
|  1090519 |
+----------+
1 row in set (0.26 sec)

mysql> select count(*) from Labels;
+----------+
| count(*) |
+----------+
|   234283 |
+----------+
1 row in set (0.05 sec)

mysql> describe GoldenLabels;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| GoldenLabelId | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| TaskImageId   | int(11)          | YES  | MUL | NULL    |                |
| LabelTypeId   | int(11)          | YES  | MUL | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> describe BinnedLabels;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| BinnedLabelId | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| LabelBinId    | int(11)          | YES  | MUL | NULL    |                |
| LabelId       | int(11)          | YES  | MUL | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> describe Assignments;
+--------------------+-------------+------+-----+-------------------+-------------------+
| Field              | Type        | Null | Key | Default           | Extra             |
+--------------------+-------------+------+-----+-------------------+-------------------+
| AssignmentId       | int(11)     | NO   | PRI | NULL              | auto_increment    |
| AmazonTurkerId     | varchar(64) | NO   | MUL |                   |                   |
| AmazonHitId        | varchar(64) | NO   |     |                   |                   |
| AmazonAssignmentId | varchar(64) | NO   |     |                   |                   |
| InterfaceType      | varchar(64) | NO   |     |                   |                   |
| InterfaceVersion   | varchar(64) | NO   |     |                   |                   |
| Completed          | tinyint(1)  | NO   |     | NULL              |                   |
| NeedQualification  | tinyint(1)  | NO   |     | NULL              |                   |
| TaskDescription    | varchar(64) | YES  |     | NULL              |                   |
| DatetimeInserted   | timestamp   | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
+--------------------+-------------+------+-----+-------------------+-------------------+
10 rows in set (0.00 sec)