Child pages
  • DB Schema - component tables

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Every component table contains five standard columns. These are explained on the page for Matching and Storing Device AttributesChanges.

Each component table is joined to the system table by component.system_id = and uses "on delete cascade". Hence if you delete the entry in the system table for a device, the joined component tables will also have the data for this device deleted.