dois


Description

Stores all DOIs used in the system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
doi_id BIGINT 19 √ null
doi_settings.doi_id doi_settings_doi_id_foreignC
issues.doi_id issues_doi_id_foreignN
publication_galleys.doi_id publication_galleys_doi_id_foreignN
publications.doi_id publications_doi_id_foreignN
context_id BIGINT 19 null
journals.journal_id dois_context_id_foreignC
doi VARCHAR 255 null
status SMALLINT 5 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc doi_id
dois_context_id Performance Asc context_id

Relationships

Close relationships within degrees of separation