...
mysql> describe marcRecords;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| marc | mediumtext | YES | | NULL | |
| json | mediumtext | YES | | NULL | |
| instanceId | varchar(36) | YES | | NULL | |
| shadowFlag | varchar(1) | YES | | NULL | |
| catalogedDate | varchar(8) | YES | | NULL | |
| marcHoldings | varchar(1) | YES | | NULL | |
| catalogKey | int(11) | NO | PRI | NULL | |
+---------------+-------------+------+-----+---------+-------+
...
mysql> describe marcHoldingsRecords;
+------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+----------------+
| catalogKey | int(11) | YES | | NULL | |
| m852c | varchar(10) | YES | | NULL | |
| m863c | mediumtext | YES | | NULL | |
| m863e | mediumtext | YES | | NULL | m863 |
| m863x | mediumtext | YES | | NULL | |
| m863z | mediumtext | YES | | NULL | |
| m866 | mediumtext | YES | | NULL | |
| m867 | mediumtext | YES | | NULL | |
| m868 | mediumtext | YES | | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
+------------+-------------+------+-----+---------+----------------+
m852c is the location per the ILS and will have to be translated into a FOLIO location by bibLoad.pl - the data in rows m863, m866, m867, and m868 contain pipe-delimited data like so:
- m863 : enumeration|chronology|staffNote|publicNote||
- m866-8 : holdingsStatement|note||