SpecialtyInDiscipline


Description

Specialty discipline associations linking provider specialties to specific disciplines for organizational and credentialing management. This junction table manages the relationship between specialties and disciplines to support multi-disciplinary care teams, provider organization, and discipline-specific specialty tracking for healthcare service delivery and provider management.

Columns

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

Primary key - Unique identifier for each specialty-discipline association
specialtyID int 4 √ null
Specialty.specialtyID FK__Specialty__speci__69DC8BE5 C

Specialty reference - Links to Specialty table for the provider specialty
DisciplineID int 4 √ null

Discipline reference - Links to discipline that this specialty belongs to

Indexes

Constraint Name Type Sort Column(s)
PK__SpecialtyInDisci__68E867AC Primary key Asc specDiscID

Relationships

Close relationships within degrees of separation