Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgencyId | Unknown | 0 | null |
|
|
Agency reference - Reference to agency receiving the package |
||
| DeletedBy | Unknown | 0 | null |
|
|
Deletion administrator - User who removed the assignment |
||
| DeletedDate | Unknown | 0 | null |
|
|
Deletion timestamp - When the assignment was removed |
||
| ExpirationDate | Unknown | 0 | null |
|
|
Assignment expiration - When the package assignment expires |
||
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each package assignment |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if assignment is currently active |
||
| PackageAssignedId | int identity | 4 | √ | null |
|
|
Package assignment identifier - Alternative identifier for the assignment |
|
| PackageId | int | 4 | √ | null |
|
|
Package reference - Reference to the package being assigned |
|
| AgencyAssigned | int | 4 | √ | null |
|
|
Assigned agency - Agency that was assigned the package |
|
| AssignedDate | date | 20 | √ | null |
|
|
Assignment date - When the package was assigned |
|
| AssignedBy | int | 4 | √ | null |
|
|
Assignment administrator - User who assigned the package |
|
| DeleteBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted the assignment |
|
| Cost | int | 4 | √ | null |
|
|
Assignment cost - Cost associated with the package assignment |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PackageAssigned | Primary key | Asc | PackageAssignedId |