mysql> describe contest_problems;
+------------+------------+------+-----+---------+-------+
| Field      | Type       | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| pid        | int(8)     | NO   | PRI | NULL    |       |
| pid_letter | varchar(2) | YES  |     | NULL    |       |
+------------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe contest_results;
+--------------+-----------+------+-----+-------------------+-----------------------------+
| Field        | Type      | Null | Key | Default           | Extra                       |
+--------------+-----------+------+-----+-------------------+-----------------------------+
| rid          | int(8)    | NO   | PRI | NULL              | auto_increment              |
| tid          | int(8)    | NO   | MUL | NULL              |                             |
| pid          | int(8)    | NO   | MUL | NULL              |                             |
| attempts     | int(8)    | NO   |     | NULL              |                             |
| time         | int(8)    | NO   |     | NULL              |                             |
| last_updated | timestamp | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+--------------+-----------+------+-----+-------------------+-----------------------------+
6 rows in set (0.00 sec)

mysql> describe contest_results_latest;
+--------------+-----------+------+-----+---------------------+-------+
| Field        | Type      | Null | Key | Default             | Extra |
+--------------+-----------+------+-----+---------------------+-------+
| rid          | int(8)    | NO   |     | 0                   |       |
| tid          | int(8)    | NO   |     | NULL                |       |
| pid          | int(8)    | NO   |     | NULL                |       |
| attempts     | int(8)    | NO   |     | NULL                |       |
| time         | int(8)    | NO   |     | NULL                |       |
| last_updated | timestamp | NO   |     | 0000-00-00 00:00:00 |       |
+--------------+-----------+------+-----+---------------------+-------+
6 rows in set (0.01 sec)

mysql> describe contest_sites;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| sid          | int(8)       | NO   | PRI | NULL    | auto_increment |
| name         | varchar(255) | NO   |     | NULL    |                |
| startTime    | time         | YES  |     | NULL    |                |
| globalSiteId | int(8)       | NO   |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> describe contest_teams;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| tid           | int(8)       | NO   | PRI | NULL    | auto_increment |
| sid           | int(8)       | NO   | MUL | NULL    |                |
| name          | varchar(255) | NO   | MUL | NULL    |                |
| reservationId | int(8)       | NO   |     | NULL    |                |
| instituteName | varchar(255) | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> describe contest_users;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| uid      | int(8)       | NO   | PRI | NULL    | auto_increment |
| username | varchar(255) | NO   | UNI | NULL    |                |
| password | varchar(255) | NO   |     | NULL    |                |
| isAdmin  | bit(1)       | NO   |     | b'0'    |                |
| sid      | int(8)       | YES  | MUL | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)