long_term_archive_json_input

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

submission_id

int4

10

√

null

archiveJob

json

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT s.submission_id,
    ( SELECT row_to_json(aaa.*) AS row_to_json
           FROM ( SELECT s.title AS "itemName",
                    translate(btrim((date_trunc('second'::text, ('now'::text)::timestamp(0) with time zone))::text), ' '::text, 'T'::text) AS "jobSubmissionDate",
                    ( SELECT array_to_json(ARRAY[( SELECT row_to_json(xx.*) AS row_to_json
                                   FROM ( SELECT 'DOI'::text AS "identifierType",
    s.dataset_doi AS identifier) xx), ( SELECT row_to_json(yy.*) AS row_to_json
                                   FROM ( SELECT 'EarthChem submission_ID'::text AS "identifierType",
    concat('urn:ecl:submission:', s.submission_id) AS identifier) yy)]) AS array_to_json) AS identifiers,
                    ( SELECT row_to_json(zz.*) AS row_to_json
                           FROM ( SELECT 'http://datacite.org/schema/kernel-4'::text AS format,
                                    concat('https://mds.datacite.org/metadata/'::text,
CASE
 WHEN ((s.dataset_doi)::text <> ''::text) THEN ltrim((s.dataset_doi)::text, 'doi:'::text)
 ELSE NULL::text
END) AS "metadataFileLocation") zz) AS "metadataLink",
                    ( SELECT array_to_json(pg_catalog.array_agg(row_to_json(d.*))) AS array_to_json
                           FROM ( SELECT concat('%path%/submissions/in/'::text, s.submission_id, '/'::text, dfl.dataset_server_filename) AS "fileLocation",
                                    concat(dff.data_file_format, ': ', dff.data_file_format_name) AS format
                                   FROM dataset_file_list dfl,
                                    data_file_formats dff
                                  WHERE ((s.submission_id = dfl.submission_id) AND (dfl.data_file_format_id = dff.data_file_format_id))) d) AS "contentItems",
                    ''::text AS "archiveAccessionDate",
                    ''::text AS "archiveID",
                    'EarthChem Library'::text AS "sourceSystem",
                    'getFile-dcv4-tgzbagit-v2'::text AS "archiveWorkflow",
                    '2.0'::text AS version) aaa) AS "archiveJob"
   FROM submissions s
  WHERE (s.status_id = 2)
  ORDER BY s.submission_id;

long_term_archive_json_input

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views