contacts

11302 rows


Description

This table lists persons and organizations referenced by the Chronologies, Collectors, DatasetPIs, DatasetSubmissions, Projects, PublicationAuthors, SampleAnalysts, and SiteImages tables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contactid serial 10 nextval('ndb.seq_contacts_contactid'::regclass)
chronologies.contactid fk_chronologies_contactsR
collectors.contactid fk_collectors_contactsR
constituentdatabases.contactid fk_constituentdatabases_contactsR
dataprocessors.contactid fk_dataprocessors_contactsR
datasetpis.contactid fk_datasetpis_contactsR
datasetsubmissions.contactid fk_datasetsubmissions_contactsR
datasettaxonnotes.contactid fk_datasettaxonnotes_contactsR
datataxonnotes.contactid fk_datataxonnotes_contactsR
isometadata.analystid fk_isometadata_contactsR
publicationauthors.contactid fk_publicationauthors_contactsR
sampleanalysts.contactid fk_sampleanalysts_contactsR
siteimages.contactid fk_siteimages_contactsR
synonymy.contactid fk_synonymy_contactsR
taxa.validatorid fk_validatoridR
stewards.contactid fk_stewards_contactsR
stewardupdates.contactid fk_stewardupdates_contactsR
aliasid int4 10 null
contactname varchar 80 null
contactstatusid int4 10 null
contactstatuses.contactstatusid fk_contacts_contactstatusesN
familyname varchar 80 null
leadinginitials varchar 16 null
givennames varchar 80 null
suffix varchar 16 null
title varchar 16 null
phone varchar 64 null
fax varchar 64 null
email varchar 64 null
url varchar 255 null
address text 2147483647 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
contacts_pkey Primary key Asc contactid
familynames_idx Performance Asc familyname

Relationships