28
edits
Changes
Jump to navigation
Jump to search
Line 71:
Line 71: − + +
→DEVICE_ID
=== DEVICE_ID ===
=== DEVICE_ID ===
DEVICE_ID is the primary key for this table. The Device ID is a grouping up of sometimes multiple model numbers into a group that one can think of as being the “device”; examples would be a type of breast implant, or a style and type of tubing made by a specific company. Here is a screenshot from the current (2022) MDALL, showing the various levels of the device hierarchy.
DEVICE_ID is the primary key for this table. The Device ID is a grouping up of sometimes multiple model numbers into a group that one can think of as being the “device”; examples would be a type of breast implant, or a style and type of tubing made by a specific company. Here is a screenshot from the current (2022) [[Medical Devices Active Licence Listing]] ([https://health-products.canada.ca/mdall-limh/ MDALL]), showing the various levels of the device hierarchy.
[[File:Device hierarchy.png|thumb|Screenshot from the MDALL illustrating the many-to one relationships between device identifiers, device IDs, and licences.]]
As you can see in this example, the licence is for SALINE-FILLED MAMMARY PROTHESIS – SMOOTH, but it has at least two DEVICE_IDs included, that were issued at different times. Each of these DEVICE_IDs then has many models numbers, chiefly differing in this case in the size of the implant. For tubing or screws, as another example, device identifiers may be the length of the tubing or screws.
As you can see in this example, the licence is for SALINE-FILLED MAMMARY PROTHESIS – SMOOTH, but it has at least two DEVICE_IDs included, that were issued at different times. Each of these DEVICE_IDs then has many models numbers, chiefly differing in this case in the size of the implant. For tubing or screws, as another example, device identifiers may be the length of the tubing or screws.
