I have an SQLite
database stored on my MacBook Pro laptop that I use to track work requests. The
database file is named CRQ.db, since it tracks work done under
a Change Request (CRQ). Within that database are several
tables
two of which are "Equipment" and "Device". For every CRQ that I need to
deal with, I store information on equipment that is affected by the CRQ. The
equipment table has the following structure:
| Name | Type |
|---|---|
| CRQ | Text |
| Device | Text |
| Project | Text |
| Notes | Text |
The device field holds a unique name assigned to the particular device. A device may be affected by more than one CRQ, so it can, potentially, occur multiple times in the table. A CRQ can affect multiple pieces of equipment.
The device table has the following structure:
| Name | Type |
|---|---|
| Description | Text Unique |
| Manufacturer | Text |
| Model | Text |
| Site | Text |
| Building | Text |
| Room | Text |
| Notes | Text |
[ More Info ]
