authors


Description

The authors of a publication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
author_id BIGINT 19 √ null
author_settings.author_id author_settings_author_idC
publications.primary_contact_id publications_author_idN
submission_chapter_authors.author_id submission_chapter_authors_author_id_foreignC
submission_chapters.primary_contact_id submission_chapters_primary_contact_id_foreignN
email VARCHAR 90 null
include_in_browse SMALLINT 5 1
publication_id BIGINT 19 null
publications.publication_id authors_publication_id_foreignC
seq DOUBLE 8,2 0.00
user_group_id BIGINT 19 √ NULL
user_groups.user_group_id authors_user_group_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc author_id
authors_publication_id_foreign Performance Asc publication_id
authors_user_group_id Performance Asc user_group_id

Relationships

Close relationships within degrees of separation