Discipline


Description

Healthcare discipline definitions managing healthcare disciplines and specialties for provider classification and service categorization. This master table defines disciplines such as Physical Therapy, Occupational Therapy, Speech Therapy, etc., with lock flags to support provider specialization and service delivery organization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DisciplineID int identity 4 √ null
CustomConfigInDiscipline.fkDisciplineID FK__CustomCon__fkDis__22F6A45E R

Primary key - Unique identifier for each healthcare discipline
Discipline nvarchar 100 √ null

Discipline name - Name of the healthcare discipline or specialty
Lock bit 1 √ null

Lock flag - Boolean indicating if the discipline is locked from modification

Indexes

Constraint Name Type Sort Column(s)
PK_Discipline Primary key Asc DisciplineID

Relationships

Close relationships within degrees of separation