...
mysql> describe marcRecords;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| marc | mediumtext | YES | | NULL | |
| instanceId | varchar(36) | YES | | NULL | |
| shadowFlag | varchar(1) | YES | | NULL | |
| catalogedDate | varchar(8) | YES | | NULL | |
| marclistOffset | int(11) | YES | | NULL | |
| catalogKey | int(11) | NO | PRI | NULL | |
+----------------+-------------+------+-----+---------+-------+
mysql> describe itemData;
+-------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| analyticPosition | int(11) | YES | | NULL | |
| callNumShadowFlag | varchar(1) | YES | | NULL | |
| circNote | mediumtext | YES | | NULL | |
| publicNote | mediumtext | YES | | NULL | |
| staffNote | mediumtext | YES | | NULL | |
| itemCat1 | varchar(10) | YES | | NULL | |
| itemCat2 | varchar(10) | YES | | NULL | |
| itemShadowFlag | varchar(1) | YES | | NULL | |
| catalogKey | int(11) | YES | | NULL | |
| barcode | varchar(16) | NO | PRI | NULL | |
+-------------------+-------------+------+-----+---------+-------+The next step will be to write loadMARCrecords.pl and loadItemData.pl...
For MARC Holdings Records I've added a column to the marcRecords table to give bibLoad.pl a heads up that there is data in the marcHoldingsRecords table