submissions

1687 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_id serial 10 √ nextval('submissions_submission_id_seq'::regclass)
archive_file_checksum.submission_id archive_file_checksum_submission_id_fkeyR
author_list.submission_id author_list_submission_id_fkeyR
data_type_list.submission_id data_type_list_submission_id_fkeyR
dataset_file_list.submission_id dataset_file_list_submission_id_fkeyR
dataset_relation.submission_id dataset_relation_submission_id_fkeyR
download_stats.submission_id download_stats_submission_id_fkeyR
fundings.submission_id fundings_submissions_fkeyR
submission_external_identifier.submission_id submission_external_identifier_submission_id_fkeyR
submission_geometry.submission_id submission_geometry_submission_id_fkeyR
submission_relation.related_submission_id submission_relation_related_submission_id_fkeyR
submission_relation.submission_id submission_relation_submission_id_fkeyR
system_id int4 10 null
dataset_group.dataset_group_id submissions_system_id_fkeyR

id of specific community. PJ on 12/10/2021
email varchar 100 √ null

Deprecated, populated with blank value. PJ on 12/9/2021
creator text 2147483647 √ null

Deprecated, populated with blank value. PJ on 12/9/2021
release_date date 13 null
title varchar 500 null
description text 2147483647 null
rights text 2147483647 √ null

Deprecated, populated with blank value. PJ on 12/9/2021
publication_doi varchar 256 √ null

DOIs of the related publications. PJ on 12/10/2021
related_publications text 2147483647 √ null
language_id int4 10 null
languages.language_id submissions_language_id_fkeyR

id of specific language used for the content of record. PJ on 12/10/2021
dataset_type_id int4 10 null
dataset_types.dataset_type_id submissions_dataset_type_id_fkeyR

id of specific DCMI type for the record. PJ on 12/10/2021
submission_coverage_scope_id int4 10 √ null
submission_coverage_scopes.submission_coverage_scope_id submissions_submission_coverage_scope_id_fkeyR
keywords text 2147483647 √ null
geo_keywords text 2147483647 √ null
dataset_file varchar 100 √ null

Deprecated, populated with blank value. PJ on 12/9/2021
owner int4 10 null
grl_user.account_id submissions_owner_fkeyR
created_by int4 10 null
grl_user.account_id submissions_created_by_fkeyR
created_date timestamp 29,6 null

The date on which the record was created. PJ on 12/10/2021
last_modified timestamp 29,6 null

The date on which the record was most recently modified. PJ on 12/10/2021
last_modified_by int4 10 null
admin_status_modified timestamp 29,6 √ null
admin_status_modified_by int4 10 √ null
admin_edit_modified timestamp 29,6 √ null
admin_edit_modified_by int4 10 √ null
dataset_doi varchar 100 √ null

DOI of the record assigned by Datacite. PJ on 12/10/2021
dataset_doi_register int4 10 1
status_id int4 10 0
status.status_id submissions_status_id_fkeyR
doi_created_date timestamp 29,6 √ null

The date on which the DOI was assigned to the record. PJ on 12/10/2021
license_id int4 10 √ null
license.license_id submissions_license_id_fkeyR

id of specific license applied all files. PJ on 12/10/2021
system_to_notify varchar 25 √ null

indicated the record need to be sync to PetDB/AstroDB. PJ on 12/10/2021

Indexes

Constraint Name Type Sort Column(s)
submissions_pkey Primary key Asc submission_id
dataset_type_id_1 Performance Asc dataset_type_id
language_id_1 Performance Asc language_id
submission_coverage_scope_id_1 Performance Asc submission_coverage_scope_id

Relationships

Close relationships within degrees of separation