mysql> use oai
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------+
| Tables_in_oai |
+---------------+
| ids           |
| metadata      |
| setmap        |
| sets          |
+---------------+
4 rows in set (0.00 sec)

mysql> describe ids;
+----------------+--------------+------+-----+------------+----------------+
| Field          | Type         | Null | Key | Default    | Extra          |
+----------------+--------------+------+-----+------------+----------------+
| recID          | int(11)      |      | PRI | NULL       | auto_increment |
| OAI_Identifier | varchar(50)  | YES  |     | NULL       |                |
| objectName     | varchar(255) | YES  |     | NULL       |                |
| lastModDate    | date         |      |     | 0000-00-00 |                |
| exportable     | char(1)      |      |     | Y          |                |
| deleted        | char(1)      |      |     | N          |                |
+----------------+--------------+------+-----+------------+----------------+
6 rows in set (0.00 sec)

mysql> describe metadata;
+-------------+---------------+------+-----+---------+-------+
| Field       | Type          | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| recID       | int(11)       |      | MUL | 0       |       |
| varName     | varchar(50)   |      |     |         |       |
| value       | varchar(255)  |      |     |         |       |
| scheme      | varchar(32)   | YES  |     | NULL    |       |
| subfield    | varchar(32)   | YES  |     | NULL    |       |
| lastModDate | timestamp(14) | YES  |     | NULL    |       |
+-------------+---------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> describe sets;
+-------------+---------------+------+-----+---------+----------------+
| Field       | Type          | Null | Key | Default | Extra          |
+-------------+---------------+------+-----+---------+----------------+
| setID       | int(11)       |      | PRI | NULL    | auto_increment |
| setName     | varchar(50)   |      |     |         |                |
| setSpec     | varchar(50)   |      |     |         |                |
| lastModDate | timestamp(14) | YES  |     | NULL    |                |
+-------------+---------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> describe setmap;
+-------------+---------------+------+-----+---------+-------+
| Field       | Type          | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| setID       | int(11)       |      | MUL | 0       |       |
| recID       | int(11)       |      | MUL | 0       |       |
| lastModDate | timestamp(14) | YES  |     | NULL    |       |
+-------------+---------------+------+-----+---------+-------+
3 rows in set (0.00 sec)