ContactType


Description

Contact type definitions defining categories of contacts for patient and organizational communication. This lookup table manages contact type classifications such as emergency contact, family member, provider, or organization to support contact organization and communication management in healthcare settings.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TypeID int identity 4 √ null

Primary key - Unique identifier for each contact type
TypeDesc varchar 50 √ null

Type description - Descriptive name for the contact type

Indexes

Constraint Name Type Sort Column(s)
PK__ContactType__6225902D Primary key Asc TypeID

Relationships

Close relationships within degrees of separation