Borrower Table

The borrower table holds the borrower information. The borrower table diagram shows the column properties of the table.

• The borrower# column is the primary key for a borrower. The Identity attribute guarantees that a unique number will be generated for each new borrower added to the table. The identity seed and identity increment are 1. The first borrower# to be assigned is 1, and each subsequently added borrower# will be incremented by 1.
• The alias column is required. This information is the borrower's Windows NT® logon name. This information is verified by information in the F & M Exchange directory. The fname, lname, location, phone, title, and dept columns are populated with information from Exchange. All columns have a varchar data type.
• The fname and lname columns allow 64 characters, but the varchar data type ensures that the storage size is the actual length of the data entered. Both fields are required, that is, null values are not allowed.
• The location column is the office location of the borrower. This is not a required field.
• The phone is the phone number of the borrower. This is not a required field.
• The title column is the title of the borrower. This is not a required field.
• The dept column is the department of the borrower. This is not a required field.
• The last_cko_date column stores the last date the borrower checked out a library title. The data type is datetime.
• The n_ckos column is where the total number of checkouts for the borrower is tracked. A default value of zero is entered when the record is first created and the borrower has not yet submitted a request to check out a library title.
• The is_staff column identifies a borrower as an administrator. Administrators have special privileges. This field is a tinyint data type, but is really used as a Boolean field. The values stored are 1 or 0 indicating True or False. The borrower is or is not an administrator.