Difference between revisions of "MDS Database"

From wiki
Jump to navigation Jump to search
Line 34: Line 34:
  
 
Device tables are those for which the DEVICE_ID is the basis for lookup, and that describe the characteristic of devices. Information related to the licence is not directly related to the device, and is captured elsewhere.
 
Device tables are those for which the DEVICE_ID is the basis for lookup, and that describe the characteristic of devices. Information related to the licence is not directly related to the device, and is captured elsewhere.
 +
 +
=== DEVICE ===
 +
 +
==== DEVICE_AUDIT ====
 +
 +
==== DEVICE_IDENTIFIER ====
 +
 +
==== DEVICE_SUPERSEDE ====
 +
 +
==== DEVICE_RELATION ====
 +
 +
==== DEVICE_MATERIALS ====
 +
 +
===== DEVICE_SPECIES =====
 +
 +
===== DEVICE_TISSUES =====
 +
 +
===== DEVICE_DERIVATIVES =====
 +
 +
==== DEVICE_SAP ====
 +
 +
==== DEVICE_DRUGS ====
 +
 +
===== DRUG_TAB =====
 +
 +
==== USAGE_CODE_TAB ====
 +
 +
==== PREF_NAME_MAST ====
 +
 +
===== PREF_NAME_AUDIT =====
 +
 +
==== PREF_DESC_DTL ====
  
 
== Establishments ==
 
== Establishments ==

Revision as of 16:22, 4 May 2022

This will be a page about the database side of the MDS system - about documenting the fields, decodes, and how the system is used. For information about the user interface and the history of the system, see Medical Device System.

The whole of the MDS system is vast and complex, and covers multiple areas from the applications for device licences, the tracking of establishments, companies and contact lists, finance, lists of physicians for Special Access Program, Incidents, and so on. It would be inefficient to try to cover all these various uses in a single go, so instead these will be broken out by the overall sections of the database.

Applications

Describe Applications here

Certificates

Describe certificates here

Companies

Describe Company table relationships here

Devices

The tables relating specifically to devices

The “Device” tables consist mostly of those tables starting with the term “DEVICE” as well as a few tables that are used to decode these; a few “Dev” tables are actually paired instead with the APPLICATION tables. There will be some overlap as a decode table may be used by more than one set of tables. The following are the tables that are described in this section.

  • DEVICE
    • DEVICE_AUDIT
    • DEVICE_IDENTIFIER
    • DEVICE_SUPERSEDE
    • DEVICE_RELATION
    • DEVICE_MATERIALS
      • DEVICE_SPECIES
      • DEVICE_TISSUES
      • DEVICE_DERIVATIVES
    • DEVICE_SAP
    • DEVICE_DRUGS
      • DRUG_TAB
    • USAGE_CODE_TAB
    • PREF_NAME_MAST
      • PREF_NAME_AUDIT
    • PREF_DESC_DTL

Device tables are those for which the DEVICE_ID is the basis for lookup, and that describe the characteristic of devices. Information related to the licence is not directly related to the device, and is captured elsewhere.

DEVICE

DEVICE_AUDIT

DEVICE_IDENTIFIER

DEVICE_SUPERSEDE

DEVICE_RELATION

DEVICE_MATERIALS

DEVICE_SPECIES
DEVICE_TISSUES
DEVICE_DERIVATIVES

DEVICE_SAP

DEVICE_DRUGS

DRUG_TAB

USAGE_CODE_TAB

PREF_NAME_MAST

PREF_NAME_AUDIT

PREF_DESC_DTL

Establishments

Establishments go here

Incidents

Incidents go here