tdis_collections

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

tdis_identifier

varchar

2147483647

√

null

collection_id

int4

√

null

project_name

varchar

2147483647

√

null

project_id

int4

√

null

username

varchar

2147483647

√

null

user_first_name

varchar

2147483647

√

null

user_last_name

varchar

2147483647

√

null

user_id

int4

√

null

controlled_vocabulary

varchar

2147483647

√

null

controlled_vocabulary_id

int4

√

null

jurisdiction

text

2147483647

√

null

jurisdiction_code

text

2147483647

√

null

jurisdiction_id

int4

√

null

title

varchar

2147483647

√

null

description

text

2147483647

√

null

purpose

text

2147483647

√

null

extent

text

2147483647

√

null

custody_chain

_varchar

2147483647

√

null

license

varchar

2147483647

√

null

keyword_term

varchar

2147483647

√

null

contacts

_int4

√

null

metadata_date

date

√

null

created

timestamptz

35,6

√

null

updated

timestamptz

35,6

√

null

View Definition

SELECT ((((e.element_type)::text || '-'::text) || e.guid))::character varying AS tdis_identifier,
    c.element_id AS collection_id,
    p.name AS project_name,
    p.id AS project_id,
    u.username,
    u.first_name AS user_first_name,
    u.last_name AS user_last_name,
    u.contact_id AS user_id,
    cv.name AS controlled_vocabulary,
    cv.id AS controlled_vocabulary_id,
    j.name AS jurisdiction,
    j.code AS jurisdiction_code,
    j.id AS jurisdiction_id,
    e.title,
    e.description,
    e.purpose,
    st_astext(st_envelope((st_extent(m.geom))::geometry)) AS extent,
    e.custody_chain,
    e.license,
    e.keyword_term,
    COALESCE(array_agg(DISTINCT ARRAY[ec.contact_id, ec.role_id]) FILTER (WHERE (ec.contact_id IS NOT NULL)), '{}'::integer[]) AS contacts,
    e.metadata_date,
    e.created,
    e.updated
   FROM (((((((tdis_element e
     JOIN tdis_users u ON ((e.user_id = u.contact_id)))
     JOIN tdis_collection c ON ((e.id = c.element_id)))
     JOIN tdis_jurisdiction j ON ((c.jurisdiction_id = j.id)))
     JOIN tdis_project p ON ((c.project_id = p.id)))
     LEFT JOIN tdis_member m ON ((m.collection_id = c.element_id)))
     LEFT JOIN tdis_controlled_vocabulary cv ON ((e.controlled_vocabulary_id = cv.id)))
     LEFT JOIN tdis_element_contact ec ON ((e.id = ec.element_id)))
  GROUP BY ((((e.element_type)::text || '-'::text) || e.guid))::character varying, c.element_id, p.name, p.id, u.username, u.first_name, u.last_name, u.contact_id, cv.name, cv.id, j.name, j.code, j.id, e.title, e.description, e.purpose, e.custody_chain, e.license, e.keyword_term, e.metadata_date, e.created, e.updated;

Columns

View Definition

Possibly Referenced Tables/Views