authors

0 rows


Description

The authors of a publication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
author_id bigserial 19 √ nextval('authors_author_id_seq'::regclass)
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 int2 5 '1'::smallint
publication_id int8 19 null
publications.publication_id authors_publication_id_foreignC
seq float8 17,17 '0'::double precision
user_group_id int8 19 √ null
user_groups.user_group_id authors_user_group_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
authors_pkey Primary key Asc author_id
authors_user_group_id Performance Asc user_group_id

Relationships

Close relationships within degrees of separation