new_books
+------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+-------------------+----------------+
| nbid | int(10) | NO | PRI | NULL | auto_increment |
| sys_no | varchar(255) | NO | | | |
| isbn | varchar(255) | NO | | | |
| author | varchar(255) | NO | | | |
| title | varchar(255) | NO | MUL | | |
| call_num | varchar(255) | NO | | | |
| class | varchar(1) | NO | | | |
| added | timestamp | NO | | CURRENT_TIMESTAMP | |
| up_to_date | int(1) | NO | | 1 | |
+------------+--------------+------+-----+-------------------+----------------+
This table contains lists of books currently on the “Recent Acquisitions” shelf
for use in generating the New Books
page.
- nbid: a unique ID for this new book
- sys_no: a system number. Corresponds to the system number of the catalog entry in Aleph.
- isbn: The book’s ISBN.
- author: The book’s author.
- title: The book’s title.
- call_num: The book’s call number.
- class: The book’s classification (top level Library of Congress, based on first letter of call number).
- added: The time this book was added to the table.
- up_to_date: boolean; see below
When Access Services puts out a fresh cart of books, they run the
New Books update tool,
which is only accessible from computers in the staff IP range. It does the follow:
- Marks the whole table as out of date (up_to_date field = 0)
- Grabs a list of all books currently on the shelf
- Adds any new ones
- Updates the entries for any still on the shelf (up_to_date field = 1)
- Deletes any entries whose up_to_date values is still 0 to prune out of date copies.