The table t_xuser

The unique ID of an t_xuser entry is stored as a BIGINT value (INTEGER for SQLite).

This BIGINT value (INTEGER for SQLite) points to the ID of the user in the table t_user.

This is the ID of the reference in the t_refdb table, stored as a BIGINT value (INTEGER for SQLite).

This alphanumeric string must contain one of the following:

• NOT IN FILE (this is the default if nothing is specified)

• ON REQUEST

• IN FILE

This DATE field holds the date when a reprint was requested. If xuser_reprint contains something else than "ON REQUEST", this field is not relevant.

This alphanumeric field with a maximum of 255 characters contains the information where a physical copy of the article is stored. This may be a room number, a contact person, a binder or folder name or anything else that helps to track that copy down. This field is irrelevant if the reprint status is not "IN FILE".

This alphanumeric field of variable length contains notes or comments added by the user.