contact

0 rows


Description

Model persons, institutes, groups, organizations, etc.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contact_id serial 10 √ nextval('contact_contact_id_seq'::regclass)
contact_relationship.object_id contact_relationship_object_id_fkey C
contact_relationship.subject_id contact_relationship_subject_id_fkey C
nd_experiment_contact.contact_id nd_experiment_contact_contact_id_fkey C
project_contact.contact_id project_contact_contact_id_fkey C
stockcollection.contact_id stockcollection_contact_id_fkey N
type_id int4 10 √ null
cvterm.cvterm_id contact_type_id_fkey R

What type of contact is this? E.g. “person”, “lab”.
name varchar 255 null
description varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
contact_pkey Primary key Asc contact_id
contact_c1 Must be unique Asc name

Relationships

Close relationships within degrees of separation