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_primary_contact_idN
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 Performance Asc publication_id
authors_user_group_id Performance Asc user_group_id

Relationships

Close relationships within degrees of separation