101946 rows


Column Type Size Nulls Auto Default Children Parents Comments
datasetid int4 10 null
datasets.datasetid fk_datasetpis_datasetsC

Dataset identification number. Field links to Dataset table.

contactid int4 10 null
contacts.contactid fk_datasetpis_contactsR

Contact identification number. Field links to Contacts table.

piorder int4 10 null

Order in which PIs are listed.

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


Constraint Name Type Sort Column(s)
datasetpis_pkey Primary key Asc/Asc datasetid + contactid
ix_contactid_datasetpis Performance Asc contactid
ix_datasetid_datasetpis Performance Asc datasetid