Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each program type assignment, auto-incrementing integer |
|
| ProgramTypeId | int | 4 | √ | null |
|
|
Program type reference - Reference to the program type being assigned |
|
| AgencyId | int | 4 | √ | null |
|
|
Agency reference - Reference to the agency receiving the program type assignment |
|
| AssignedDate | date | 20 | √ | null |
|
|
Assignment date - When the program type was assigned to the agency |
|
| AssignedBy | int | 4 | √ | null |
|
|
Assignment administrator - User ID who performed the program type assignment |
|
| DeletedBy | int | 4 | √ | null |
|
|
Removal administrator - User ID who removed or revoked the program type assignment |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Removal timestamp - When the program type assignment was removed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ProgramT__3214EC2709EB1428 | Primary key | Asc | ID |