tdis_element


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tdis_element_id_seq'::regclass)
tdis_collection.element_id tdis_collection_isan_element_fkC
tdis_element_contact.element_id tdis_element_contact_element_fkC
tdis_element_history.element_id tdis_element_history_element_fkC
tdis_member.element_id tdis_member_isan_element_fkC
tdis_upload.element_id tdis_upload_element_fkC
user_id int4 10 null
tdis_user.contact_id tdis_element_user_fkR
controlled_vocabulary_id int4 10 √ null
tdis_controlled_vocabulary.id tdis_element_controlled_vocabulary_fkR
title varchar 2147483647 null
description text 2147483647 null
purpose text 2147483647 √ null
custody_chain _varchar 2147483647 √ null
license varchar 2147483647 √ null
keyword_term varchar 2147483647 √ null
metadata_date date 13 √ null
guid uuid 2147483647 √ uuid_generate_v1()
element_type varchar 2147483647 √ null
created timestamptz 35,6 null
updated timestamptz 35,6 null
deleted bool 1 false
textsearchable_index_col tsvector 2147483647 √ to_tsvector('english'::regconfig, (((((COALESCE(title, ''::character varying))::text || ' '::text) || COALESCE(description, ''::text)) || ' '::text) || COALESCE(purpose, ''::text)))
creator_name varchar 2147483647 √ null
scale_id int4 10 √ null
tdis_scale.id tdis_element_scale_fkR

Indexes

Constraint Name Type Sort Column(s)
tdis_element_pk Primary key Asc id
textsearch_idx Performance Asc textsearchable_index_col

Relationships

Close relationships within degrees of separation