17.7. 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.