Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AssociationID | Unknown | 0 | null |
|
|
Primary key - DisTypeIDInProgType unique identifier for each association |
|||||
| DefaultRate | Unknown | 0 | null |
|
|
Default rate - Default billing rate for this discipline in this program |
|||||
| DPID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| DisTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| fkDisciplineTypeID | Unknown | 0 | null |
|
|
Discipline type reference - Reference to the discipline type |
|||||
| fkProgramTypeID | Unknown | 0 | null |
|
|
Program type reference - Reference to the program type |
|||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this discipline is required for this program type |
|||||
| MaxUnitsPerWeek | Unknown | 0 | null |
|
|
Maximum units per week - Maximum service units allowed per week |
|||||
| ProgramID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DisTypeIDInProgType | Primary key | Asc | DPID |
| IX_DisTypeID | Performance | Asc | DisTypeID |