KEYS Table
Contains a list of keys that have been allocated, and the name of the person the keys have been allocated to.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
KEY_NUMBER |
The key identification number. |
VARCHAR2 |
11 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
QUANTITY |
The number of a particular key allocated to a person. |
NUMBER |
38 |
UNIT_ID |
The Institute-assigned identification number of a department, school, center, or lab. |
VARCHAR2 |
6 |