records

1 rows


Description

Table to hold core metada of the record

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('records_id_seq'::regclass)
record_contributors.record_id record_contributors_record_id_fkeyC
record_creators.record_id record_creators_record_id_fkeyC
record_files.record_id record_files_record_id_fkeyC
record_fundings.record_id record_fundings_record_id_fkeyC
record_licenses.record_id record_licenses_record_id_fkeyC
record_subjects.record_id record_subjects_record_id_fkeyC
record_trails.record_id record_trails_record_id_fkeyC
title text 2147483647 null
description text 2147483647 √ null
submission_type text 2147483647 'Regular'::text

Indicate the record was submitted by an individual(Regular) or other data system, now only support SAMIS(BundleDelivery)
general_type text 2147483647 'Dataset'::text

Part of datacite resourceTypeGeneral controlled list
specific_type text 2147483647 √ null

More specific than general_type
doi text 2147483647 √ null

DOI of the record assigned by Datacite.
days_until_release int4 10 0

Indicate how many days after doi_status is changed to Findable the resource is publicly available.
doi_issued_date date 13 √ null

The date that the doi is assigned by datacite.
doi_status text 2147483647 √ null

Allowed value:Draft,Findable
process_status text 2147483647 'Accepted'::text

Indicate the lifecycle stage of the record in ADA system
created_at timestamp 29,6 now()

The date that the row was inserted
updated_at timestamp 29,6 now()

The date that the row was updated

Indexes

Constraint Name Type Sort Column(s)
records_pkey Primary key Asc id
idx_records_doi Performance Asc doi
records_title_key Must be unique Asc title

Check Constraints

Constraint Name Constraint
records_doi_status_check ((doi_status = ANY (ARRAY['Draft'::text, 'Findable'::text])))
records_process_status_check ((process_status = ANY (ARRAY['Accepted'::text, 'Submitted'::text, 'InReview'::text, 'Published'::text, 'Rejected'::text, 'Archived'::text])))
records_general_type_check ((general_type = ANY (ARRAY['Collection'::text, 'Dataset'::text, 'Event'::text, 'Image'::text, 'InteractiveResource'::text, 'Model'::text, 'PhysicalObject'::text, 'Service'::text, 'Software'::text, 'text'::text, 'Workflow'::text, 'Other'::text])))
records_submission_type_check ((submission_type = ANY (ARRAY['Regular'::text, 'BundleDelivery'::text])))

Relationships

Close relationships within degrees of separation