Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| DisciplineCode | Unknown | 0 | null |
|
|
Discipline code - Short code or abbreviation for the discipline |
|||||
| DisciplineDescription | Unknown | 0 | null |
|
|
Description - Detailed description of the discipline and its scope |
|||||
| DisciplineName | Unknown | 0 | null |
|
|
Discipline name - Name of the healthcare discipline (Speech Therapy, OT, PT, etc.) |
|||||
| DisciplineTypeID | Unknown | 0 | null |
|
|
Primary key - DisciplineType unique identifier for each discipline |
|||||
| DisTypeID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| DisTypeName | varchar | 30 | √ | null |
|
|
Name field - Descriptive name or identifier for DisciplineType records |
||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this discipline is currently available |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__DisciplineType__30C33EC3 | Primary key | Asc | DisTypeID |