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
name CharField   NOT NULL
impact_factor FloatField   NOT NULL
website_url CharField   NOT NULL
encoding CharField   NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Users

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

Institutions

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

Projects

Column Type Reference Attributes
id CharField   NOT NULL, PRIMARY KEY
title TextField   NOT NULL
short_name CharField   NULL
abstract TextField   NULL
science_theme CharField   NULL
project_type CharField   NULL
submitted_date ExtendDateTimeField   NOT NULL
accepted_date ExtendDateField   NULL
actual_start_date ExtendDateField   NULL
actual_end_date ExtendDateField   NULL
closed_date ExtendDateField   NULL
suspense_date ExtendDateField   NULL
encoding CharField   NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Instruments

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

Citations

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

Contributors

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

Datasets

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

Relationships

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
name CharField   NOT NULL
display_name CharField   NOT NULL
description TextField   NOT NULL
encoding CharField   NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

DataSources

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
name CharField   NOT NULL
uri CharField   NOT NULL
display_name CharField   NOT NULL
description TextField   NOT NULL
encoding CharField   NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Keywords

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

Groups

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

AnalyticalTools

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

InstrumentUser

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
instrument ForeignKeyField Instruments.id NOT NULL
user ForeignKeyField Users.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

InstitutionUser

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
user ForeignKeyField Users.id NOT NULL
institution ForeignKeyField Institutions.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

CitationContributor

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

CitationKeyword

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

ProjectInstrument

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
project ForeignKeyField Projects.id NOT NULL
instrument ForeignKeyField Instruments.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

ProjectUser

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
user ForeignKeyField Users.id NOT NULL
project ForeignKeyField Projects.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

ProjectGroup

Column Type Reference Attributes
group ForeignKeyField Groups.id NOT NULL
project ForeignKeyField Projects.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

CitationProject

Column Type Reference Attributes
citation ForeignKeyField Citations.id NOT NULL
project ForeignKeyField Projects.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Transactions

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

TransSIP

Column Type Reference Attributes
id ForeignKeyField Transactions.id NOT NULL, PRIMARY KEY
submitter ForeignKeyField Users.id NOT NULL
instrument ForeignKeyField Instruments.id NOT NULL
project ForeignKeyField Projects.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

TransSAP

Column Type Reference Attributes
id ForeignKeyField Transactions.id NOT NULL, PRIMARY KEY
submitter ForeignKeyField Users.id NOT NULL
analytical_tool ForeignKeyField AnalyticalTools.id NOT NULL
project ForeignKeyField Projects.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

Files

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

Keys

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

Values

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

FileKeyValue

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

TransactionKeyValue

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

UserGroup

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

DatasetFile

Column Type Reference Attributes
dataset ForeignKeyField Datasets.id NOT NULL
file ForeignKeyField Files.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

DatasetProjectUser

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
dataset ForeignKeyField Datasets.id NOT NULL
user ForeignKeyField Users.id NOT NULL
project ForeignKeyField Projects.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

InstrumentGroup

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

AToolProject

Column Type Reference Attributes
project ForeignKeyField Projects.id NOT NULL
analytical_tool ForeignKeyField AnalyticalTools.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

AToolTransaction

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

TransactionUser

Column Type Reference Attributes
uuid UUIDField   NOT NULL, PRIMARY KEY
user ForeignKeyField Users.id NOT NULL
transaction ForeignKeyField Transactions.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

DOIEntries

Column Type Reference Attributes
doi CharField   NOT NULL, PRIMARY KEY
status CharField   NOT NULL
released BooleanField   NOT NULL
site_url CharField   NOT NULL
encoding CharField   NOT NULL
creator ForeignKeyField Users.id NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   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
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

DOITransaction

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

CitationTransaction

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

CitationDOI

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

DOIAuthorMapping

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

DOIInfo

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

InstrumentDataSource

Column Type Reference Attributes
instrument ForeignKeyField Instruments.id NOT NULL
data_source ForeignKeyField DataSources.uuid NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated ExtendDateTimeField   NOT NULL
deleted ExtendDateTimeField   NULL

InstrumentKeyValue

Column Type Reference Attributes
instrument ForeignKeyField Instruments.id NOT NULL
key ForeignKeyField Keys.id NOT NULL
value ForeignKeyField Values.id NOT NULL
relationship ForeignKeyField Relationships.uuid NOT NULL
created ExtendDateTimeField   NOT NULL
updated 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.