44045 rows


The Collectors table lists the people who collected Collection Units.


Column Type Size Nulls Auto Default Children Parents Comments
collectorid serial 10 nextval('ndb.seq_collectors_collectorid'::regclass)

An arbitrary Collector identification number.

collectionunitid int4 10 null
collectionunits.collectionunitid fk_collectors_collectionunitsC

CollectionUnit collected. Field links to CollectionUnits table.

contactid int4 10 null
contacts.contactid fk_collectors_contactsR

Person who collected the CollectionUnit. Multiple individuals are listed in separate records. Field links to the Contacts table.

collectororder int4 10 null

Order in which Collectors should be listed.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


Constraint Name Type Sort Column(s)
collectors_pkey Primary key Asc collectorid