datasetpis

81590 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
datasetid int4 10 null
datasets.datasetid fk_datasetpis_datasetsC
contactid int4 10 null
contacts.contactid fk_datasetpis_contactsR
piorder int4 10 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

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

Relationships