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 records with the CRQ number in a "CRQ"
column and an identifier for each piece of equipment affected by work done
under that CRQ in a "Device" column. information on equipment that is affected
by the CRQ in the Equipment table. I have another table named "Device" that
holds details for each device, including the manufacturer and model number as
well as the physical location of the device. The information in the
"Description" column in the "Device" table matches the "Device" name in
the "Equipment" table. The two tables have the following structure:
| Name | Type |
|---|---|
| CRQ | Text |
| Device | Text |
| Project | Text |
| Notes | Text |
| Name | Type |
|---|---|
| Description | Text Unique |
| Manufacturer | Text |
| Model | Text |
| Site | Text |
| Building | Text |
| Room | Text |
| Notes | Text |
Equipment.Device = Device.Description
[ More Info ]
