Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkClassID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each plan/program, auto-incrementing integer |
|
| ClassType | nvarchar | 200 | √ | null |
|
|
Program type - Classification or type of the educational program or service plan |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Program description - Detailed description of the program content, objectives, and structure |
|
| StartingAge | int | 4 | √ | null |
|
|
Minimum age - Minimum age requirement for enrollment in this program |
|
| MaxAge | int | 4 | √ | null |
|
|
Maximum age - Maximum age limit for enrollment in this program |
|
| Capacity | int | 4 | √ | null |
|
|
Program capacity - Maximum number of participants that can be enrolled in this program |
|
| EffectiveDate | date | 20 | √ | null |
|
|
Program start date - Date when this program becomes effective and available |
|
| InactiveDate | date | 20 | √ | null |
|
|
Program end date - Date when this program becomes inactive or unavailable |
|
| DateCreated | date | 20 | √ | null |
|
|
Creation date - When this program was first created in the system |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this program |
|
| DateUpdated | date | 20 | √ | null |
|
|
Last modification date - When this program was most recently updated |
|
| Deleted | bit | 1 | null |
|
|
Soft delete flag - Boolean indicating if program is logically deleted (required field) |
||
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| Archived | bit | 1 | √ | null |
|
|
Archive status - Boolean indicating if program is archived but retained for historical reference |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Classes | Primary key | Asc | pkClassID |