Request Table

The request table holds the borrowers' requests for library titles. A queue is maintained by bib#. That is, for each new request for a bib# the previously largest req_queue_ord value is incremented by one and assigned to the request. This keeps the requests sequentially in the order in which they were made. The first number in the queue is always 1. The request table diagram shows the column properties of the table.