Device Warranty Storage Table
Data model
Fields
| Field | Type | Description |
|---|---|---|
| created_date* | DATETIME | Date of creation of the warranty record |
| device_id* | INT | Unique device identifier |
| end_date | DATETIME | Warranty End Date |
| modification_date* | DATETIME | Warranty Record Modification Date |
| start_date | DATETIME | Initial warranty date |
Primary Key
| PK_AAM_DEVICE_WARRANTY |
|---|
| device_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_id* | dbo.AAM_DEVICE | id | FK01_AAM_DEVICE_WARRANTY |