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 | |
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.