Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AppAssignedId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each app assignment record, auto-incrementing integer |
|
| AppId | int | 4 | √ | null |
|
|
Application reference - Foreign key linking to Apps.pkAppID for the application being assigned |
|
| AgencyAssigned | int | 4 | √ | null |
|
|
Target agency - Reference to the agency receiving the application assignment for multi-tenant management |
|
| AssignedDate | date | 20 | √ | null |
|
|
Assignment date - When the application was assigned to the agency for tracking and billing purposes |
|
| AssignedBy | int | 4 | √ | null |
|
|
Assignment administrator - User ID who performed the application assignment for accountability |
|
| DeleteBy | int | 4 | √ | null |
|
|
Removal administrator - User ID who removed or revoked the application assignment |
|
| Cost | int | 4 | √ | null |
|
|
Assignment cost - Financial cost associated with this application assignment for billing and budget tracking |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AppAssigned | Primary key | Asc | AppAssignedId |