docs/metadatamodel.rst
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.