| 1 | Asset Assignment ID | Unique Identifier (Primary Key) | A unique identifier for each asset assignment record. | |
| 2 | Asset ID | Unique Identifier (Foreign Key) | Links to the specific asset being assigned. | |
| 3 | Assigned To | String | Name or ID of the personnel or department to whom the asset is assigned. | |
| 4 | Assignment Date | Date | The date when the asset was assigned. | |
| 5 | Return Date | Date | The expected return date for the asset (if applicable). | |
| 6 | Location ID | Unique Identifier (Foreign Key) | Links to the specific location where the asset is being assigned. | |
| 7 | Assignment Type | String | Type of assignment (e.g., temporary, permanent, emergency). | |
| 8 | Condition at Assignment | String | The condition of the asset at the time of assignment (e.g., new, good, needs repair). | |
| 9 | Usage Purpose: | Text | Purpose for which the asset is being assigned. | |
| 10 | Status: | String | Current status of the assignment (e.g., active, completed, overdue). | |
| 11 | Comments: | Text | Additional comments or notes regarding the assignment. | |
| 12 | Assigned By: | String | Name or ID of the personnel who made the assignment. | |
| 13 | Assignment Created Date: | DateTime | Date and time when the assignment record was created. | |
| 14 | Assignment Modified By: | String | Name or ID of the user who last modified the assignment record. | |
| 15 | Assignment Modified Date: | DateTime | Date and time when the assignment record was last modified. | |
| 16 | Approval Required | Boolean | Indicates if the asset assignment requires approval. | Optional |
| 17 | Approved By | String | Name or ID of the user who approved the asset assignment. | Optional |
| 18 | Approval Date | DateTime | Date and time when the asset assignment was approved. | Optional |
| 19 | Condition at Return: | String | The condition of the asset at the time of return (if applicable). | Optional |
| 20 | Return Confirmed By: | String | Name or ID of the personnel who confirmed the return of the asset. | Optional |
| 21 | Return Confirmed Date: | DateTime | Date and time when the return of the asset was confirmed. | Optional |
| 22 | Assignment Duration: | Time | Duration for which the asset was assigned. | Optional |
| 23 | Assignment History: | Text | History of previous assignments for the asset. | Optional |