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.
- The request# column is the primary key for a checkout request. The Identity attribute guarantees that a unique number will be generated for each new request added to the table. The identity seed and identity increment are 1. The first request# to be assigned is 1, and each subsequently added request# will be incremented by 1.
- The bib# column is the foreign key that links the request table to the title table, and represents the first one-to-many relationship in which the request table participates. This is how we track what title is checked out.
- The borrower# column is the foreign key that links the request table to the borrower table, and represents the second one-to-many relationship in which the request table participates. This is how we track who has each copy of a title checked out.
- The req_queue_ord column is the number that describes where the request is in the queue for a title.
- The pick_up_location column is the location where the item will be delivered. This can be a different location from the location in the borrower table. The default is the borrower location.
- The comment column is the comment that can accompany a request.
- The date_requested holds the date the request is submitted. The default is today's date.