DiscInDisTypeInProgType


Description

Discipline type program assignments linking disciplines to discipline types within specific program types. This junction table manages the complex relationship between disciplines, discipline types, and program types to support discipline-specific configuration and user assignment for healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkDischargeTypeID Unknown 0 null

Discharge type reference - Links to the discharge type
pkDiscDisTypeID int identity 4 √ null
UserInDiscipline.pkDiscDisTypeID FK_UserInDiscipline_DiscInDisTypeInProgType C

Primary key - Unique identifier for each discipline-type-program assignment
fkDisciplineID int 4 √ null

Discipline reference - Links to Discipline table
fkDPID int 4 √ null

Discipline type program reference - Links to discipline type in program type configuration
fkProgramTypeID Unknown 0 null

Program type reference - Links to the program type
IsDefault Unknown 0 null

Default flag - Boolean indicating if this is the default discharge type for the discipline-program combination

Indexes

Constraint Name Type Sort Column(s)
PK_DiscInDisTypeInProgType Primary key Asc pkDiscDisTypeID

Relationships

Close relationships within degrees of separation