Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ItemMarketAssignedID | int identity | 4 | √ | null |
|
|
Assignment identifier - Alternative identifier for the assignment |
|
| ItemMarketId | int | 4 | √ | null |
|
|
Item market identifier - Reference to the item market relationship |
|
| AgencyId | int | 4 | √ | null |
|
|
Agency reference - Reference to agency receiving the item assignment |
|
| AssignBy | int | 4 | √ | null |
|
|
Assignment user - User who assigned the item to the market |
|
| AssignDate | datetime | 16,3 | √ | null |
|
|
Assignment timestamp - When the assignment was created |
|
| AssignedBy | Unknown | 0 | null |
|
|
Assignment administrator - User who performed the item assignment |
||
| AssignedDate | Unknown | 0 | null |
|
|
Assignment date - When the item was assigned to the market/agency |
||
| DeleteBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted the assignment |
|
| VersionNumber | float | 8 | √ | null |
|
|
Version number - Version of the item that was assigned |
|
| Cost | int | 4 | √ | null |
|
|
Assignment cost - Cost associated with this item assignment |
|
| ClientItemId | int | 4 | √ | null |
|
|
Client item identifier - Client-specific identifier for the assigned item |
|
| 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 item assignment expires |
||
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each item assignment, auto-incrementing integer |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if assignment is currently active |
||
| ItemId | Unknown | 0 | null |
|
|
Item reference - Reference to the marketplace item being assigned |
||
| LicenseTerms | Unknown | 0 | null |
|
|
License terms - Terms and conditions for item usage |
||
| MarketId | Unknown | 0 | null |
|
|
Market reference - Reference to the market or marketplace where item is assigned |
||
| Priority | Unknown | 0 | null |
|
|
Assignment priority - Priority level for this item assignment |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ItemMarketAssigned | Primary key | Asc | ItemMarketAssignedID |