tbl_contact_types

0 rows


Description

Specifies various contact types, categorizing them by their roles or functions such as laboratory, sample taker, or dataset creator. This categorization aids in linking contacts to their respective roles within the system.

Columns

Column Type Size Nulls Auto Children Parents Comments
contact_type_id int4 10 √
tbl_dataset_contacts.contact_type_id fk_dataset_contacts_contact_type_id R

Primary key (automatically incremented).
contact_type_name varchar(150) 150

Name of the contact type, representing the role or function (e.g., researcher, laboratory, field technician).
date_updated timestamptz 35,6 √
description text 2147483647 √

Comprehensive description of the contact type, detailing its role within the system.

Indexes

Constraint Name Type Sort Column(s)
tbl_contact_types_pkey Primary key Asc contact_type_id

Relationships

Close relationships within degrees of separation