The table t_xauthor
Prev | Chapter 15. Reference database design | Next

## The table t_xauthor

This table cross-references the table t_author and t_refdb.

xauthor_id

  This is the unique ID of a t_xauthor entry, stored as a BIGINT value (INTEGER for SQLite).

author_id

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

refdb_id

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

xauthor_type

  This ENUM field has the three possible values “primary”, “secondary”, and “tertiary” which denote that the person is a regular author, an editor, or a series editor in the given reference, respectively. PostgreSQL implements this as a SMALLINT value, SQLite uses a TEXT field.

xauthor_position

  This INT field stores the original position of the author in the paper. The sequence of authors is taken from the sequence they appear in the RIS file.

Prev | Up | Next
The table t_user | Home | The table t_xkeyword