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
publication_formats.doi_id publication_formats_doi_id_foreignN
publications.doi_id publications_doi_id_foreignN
submission_chapters.doi_id submission_chapters_doi_id_foreignN
submission_files.doi_id submission_files_doi_id_foreignN
context_id BIGINT 19 null
presses.press_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