reporter.old_super_simple_record (view)

↑ reporter schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

id

bigint

Yes

fingerprint

text

Yes

quality

integer

Yes

tcn_source

text

Yes

tcn_value

text

Yes

title

text

Yes

author

text

Yes

publisher

text

Yes

pubdate

text

Yes

isbn

text[]

Yes

issn

text[]

Yes

View Definition

 SELECT r.id,
    r.fingerprint,
    r.quality,
    r.tcn_source,
    r.tcn_value,
    oils_json_to_text(d.title) AS title,
    oils_json_to_text(d.author) AS author,
    oils_json_to_text(d.publisher) AS publisher,
    oils_json_to_text(d.pubdate) AS pubdate,
        CASE
            WHEN d.isbn = 'null'::text THEN NULL::text[]
            ELSE ( SELECT ARRAY( SELECT json_array_elements_text(d.isbn::json) AS json_array_elements_text) AS "array")
        END AS isbn,
        CASE
            WHEN d.issn = 'null'::text THEN NULL::text[]
            ELSE ( SELECT ARRAY( SELECT json_array_elements_text(d.issn::json) AS json_array_elements_text) AS "array")
        END AS issn
   FROM biblio.record_entry r
     JOIN metabib.wide_display_entry d ON r.id = d.source;
Previous
Next