...
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 = 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.
...