28
edits
Changes
→DEVICE
=== DEVICE ===
=== DEVICE ===
The device ID is the basic unit for a medical device, and is used to connect to other tables. Relating an application to devices, for example, makes use of the DEVICE_ID, and this is the table that defines characteristics that are 1-to-1 with the device in this sense. These include the trade name of the device, the risk class under the [https://laws-lois.justice.gc.ca/eng/regulations/sor-98-282/ Medical Devices Regulations], and terms used to group devices together (PNC, GMDN code, and usage code as examples).
==== DEVICE_AUDIT ====
==== DEVICE_AUDIT ====
The DEVICE_AUDIT table captures the history of changes made to device tables such as adding or removing companies, addition of new device identifiers, etc. As it is an audit table, it has many more rows than the base tables do, and is not efficient to use in most queries of the system.
==== DEVICE_IDENTIFIER ====
==== DEVICE_IDENTIFIER ====