You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

stow data re ILS charges in a MySQL db so that Walter can then create loans in FOLIO...

  • via /circulation/check-out-by-barcode for loans w/fixed due dates
  • via /circulation/override-check-out-by-barcode for loans w/rolling due dates
  • update the db row with the relevant loanId (UUID) once the item has been checked out in FOLIO
mysql> describe chargeData;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| circRule | varchar(10) | YES | | NULL | |
| dateCharged | varchar(12) | YES | | NULL | |
| dateDue | varchar(12) | YES | | NULL | |
| itemBarcode | varchar(14) | YES | | NULL | |
| itemType | varchar(10) | YES | | NULL | |
| userBarcode | varchar(14) | YES | | NULL | |
| userProfile | varchar(10) | YES | | NULL | |
| loanId | varchar(36) | YES | | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
+-------------+-------------+------+-----+---------+----------------+
  • No labels