Fri, Aug 11, 2017 8:42 pm

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.