Metadata Model

This covers all the objects and their relationships to other objects in the model.

All The Objects

Journals

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
impact_factor FloatField   NOT NULL
encoding CharField   NOT NULL
website_url CharField   NOT NULL
name CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

Users

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
middle_initial CharField   NOT NULL
last_name CharField   NOT NULL
encoding CharField   NOT NULL
network_id CharField   NULL
first_name CharField   NOT NULL
email_address CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Institutions

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
association_cd CharField   NOT NULL
name TextField   NOT NULL
encoding CharField   NOT NULL
is_foreign BooleanField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

Projects

Instruments

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
display_name CharField   NOT NULL
name CharField   NOT NULL
encoding CharField   NOT NULL
name_short CharField   NOT NULL
active BooleanField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

InstrumentCustodian

Column Type Reference Attributes
custodian ForeignKeyField Users.id NOT NULL
instrument ForeignKeyField Instruments.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

Citations

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
article_title TextField   NOT NULL
encoding CharField   NOT NULL
abstract_text TextField   NOT NULL
journal ForeignKeyField Journals.id NOT NULL
doi_reference CharField   NOT NULL
release_authorization_id CharField   NOT NULL
journal_volume IntegerField   NOT NULL
page_range CharField   NOT NULL
xml_text TextField   NOT NULL
journal_issue IntegerField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

Contributors

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
middle_initial CharField   NOT NULL
last_name CharField   NOT NULL
encoding CharField   NOT NULL
first_name CharField   NOT NULL
dept_code CharField   NOT NULL
institution ForeignKeyField Institutions.id NOT NULL
person ForeignKeyField Users.id NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

InstitutionPerson

Column Type Reference Attributes
person ForeignKeyField Users.id NOT NULL
institution ForeignKeyField Institutions.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

Keywords

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
keyword CharField   NOT NULL
encoding CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Groups

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
name CharField   NOT NULL
encoding CharField   NOT NULL
is_admin BooleanField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

AnalyticalTools

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
name CharField   NOT NULL
encoding CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

CitationContributor

Column Type Reference Attributes
author ForeignKeyField Contributors.id NOT NULL
citation ForeignKeyField Citations.id NOT NULL
author_precedence IntegerField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

CitationKeyword

Column Type Reference Attributes
citation ForeignKeyField Citations.id NOT NULL
keyword ForeignKeyField Keywords.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

ProjectInstrument

ProjectParticipant

ProjectGroup

CitationProject

Transactions

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
description TextField   NULL
suspense_date ExtendDateField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

TransSIP

TransSAP

Files

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
mimetype CharField   NOT NULL
transaction ForeignKeyField Transactions.id NOT NULL
name CharField   NOT NULL
encoding CharField   NOT NULL
hashsum CharField   NOT NULL
ctime ExtendDateTimeField   NOT NULL
hashtype CharField   NOT NULL
suspense_date ExtendDateField   NULL
subdir CharField   NOT NULL
mtime ExtendDateTimeField   NOT NULL
size BigIntegerField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

Keys

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
encoding CharField   NOT NULL
key CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Values

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
encoding CharField   NOT NULL
value CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

FileKeyValue

Column Type Reference Attributes
key ForeignKeyField Keys.id NOT NULL
value ForeignKeyField Values.id NOT NULL
file ForeignKeyField Files.id NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

TransactionKeyValue

Column Type Reference Attributes
transaction ForeignKeyField Transactions.id NOT NULL
value ForeignKeyField Values.id NOT NULL
key ForeignKeyField Keys.id NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

UserGroup

Column Type Reference Attributes
person ForeignKeyField Users.id NOT NULL
group ForeignKeyField Groups.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

InstrumentGroup

Column Type Reference Attributes
instrument ForeignKeyField Instruments.id NOT NULL
group ForeignKeyField Groups.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

AToolProject

AToolTransaction

Column Type Reference Attributes
analytical_tool ForeignKeyField AnalyticalTools.id NOT NULL
transaction ForeignKeyField Transactions.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

TransactionRelease

Column Type Reference Attributes
authorized_person ForeignKeyField Users.id NOT NULL
transaction ForeignKeyField Transactions.id NOT NULL, PRIMARY KEY
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

DOIEntries

Column Type Reference Attributes
status CharField   NOT NULL
doi CharField   NOT NULL, PRIMARY KEY
encoding CharField   NOT NULL
site_url CharField   NOT NULL
released BooleanField   NOT NULL
creator ForeignKeyField Users.id NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL
created ExtendDateTimeField   NOT NULL

DOIAuthors

Column Type Reference Attributes
id AutoField   NOT NULL, PRIMARY KEY
last_name CharField   NOT NULL
first_name CharField   NOT NULL
email CharField   NULL
affiliation CharField   NULL
orcid CharField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

DOITransaction

Column Type Reference Attributes
transaction ForeignKeyField TransactionRelease.transaction NOT NULL
doi ForeignKeyField DOIEntries.doi NOT NULL, PRIMARY KEY
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

CitationTransaction

Column Type Reference Attributes
transaction ForeignKeyField TransactionRelease.transaction NOT NULL
citation ForeignKeyField Citations.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

CitationDOI

Column Type Reference Attributes
doi ForeignKeyField DOIEntries.doi NOT NULL
citation ForeignKeyField Citations.id NOT NULL
deleted ExtendDateTimeField   NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL

DOIAuthorMapping

Column Type Reference Attributes
doi ForeignKeyField DOIEntries.doi NOT NULL
author ForeignKeyField DOIAuthors.id NOT NULL
author_order IntegerField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

DOIInfo

Column Type Reference Attributes
doi ForeignKeyField DOIEntries.doi NOT NULL
value CharField   NOT NULL
key CharField   NOT NULL
updated ExtendDateTimeField   NOT NULL
created ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Note

This document is generated by the GenMetadataModelMD.py script and needs to be regenerated whenever changes are made to the model.