The following table references the variable names used throughout the CML application to the column names in the CML SQL Server database. Each entry in the first column links to the table where the entry is described. When the entry, for example bib#, is a column in more than one table, the table topic linked to is the one where the entry is a primary key.
| Column name | Variable name | Description |
|---|---|---|
| bib# | bib number
bib no title |
Unique identifier for a title in the F & M library. |
| borrower# | borrower
user |
Unique identifier for a person who is an F & M employee and a borrower of library materials. |
| item# | item
copy |
Unique identifier for a copy of a title in the F & M library. |
| barcode | bar code | The uniform product code (UPC) for a library item. That is, the numeric representation of vertical lines that a scanner can read. |