UserInSpecialty


Description

User specialty assignments linking healthcare providers to their professional specialties and areas of expertise. This junction table establishes which specialties users are qualified to provide, supporting service matching, provider selection, and specialty-based scheduling for healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userID int 4 √ null
AccessUser.UserID FK__UserInSpe__userI__2EA782D5 C

User reference - Links to the healthcare provider (AccessUser.UserID)
fkspecialtyID int 4 √ null
Specialty.specialtyID FK__UserInSpe__fkspe__2F9BA70E C

Specialty reference - Links to the professional specialty (Specialty.specialtyID)
Status varchar 20 √ null

Assignment status - Current status of the specialty assignment (Active, Inactive, etc.)

Indexes

Constraint Name Type Sort Column(s)
IX_UserInSpecialty Performance Asc userID

Relationships

Close relationships within degrees of separation