Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkClassID | int identity | 4 | √ | null |
|
|
Plan primary key - Unique identifier for each educational plan or class |
||||
| ClassType | nvarchar | 200 | √ | null |
|
|
Class type - Type or category of the educational class or program |
||||
| Description | nvarchar | 1073741823 | √ | null |
|
|
Plan description - Detailed description of the educational plan or class |
||||
| StartingAge | int | 4 | √ | null |
|
|
Starting age - Minimum age for enrollment in this plan |
||||
| MaxAge | int | 4 | √ | null |
|
|
Maximum age - Maximum age for enrollment in this plan |
||||
| Capacity | int | 4 | √ | null |
|
|
Plan capacity - Maximum number of students that can be enrolled |
||||
| EffectiveDate | date | 20 | √ | null |
|
|
Effective date - Date when this plan becomes available |
||||
| InactiveDate | date | 20 | √ | null |
|
|
Inactive date - Date when this plan is no longer available |
||||
| DateCreated | date | 20 | √ | null |
|
|
Creation date - Date when this plan was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this plan |
||||
| DateUpdated | date | 20 | √ | null |
|
|
Last update date - Date when this plan was last modified |
||||
| Deleted | bit | 1 | null |
|
|
Deletion flag - Soft delete flag for audit trail purposes |
|||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this plan |
||||
| Archived | bit | 1 | √ | null |
|
|
Archive flag - Indicates if this plan has been archived |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Classes | Primary key | Asc | pkClassID |
Relationships
Close relationships within degrees of separation
