Data model for SWID-Tags

[d22]

Added the SWID extension to the DB model.

See the following files: https://github.com/tnc-ba/doku/blob/master/db/database-2014-03-22.png https://github.com/tnc-ba/doku/blob/master/db/model_with_layers.mwb

@cfaessler, please review the model, so we can send it to Mr. Steffen and Tobias.

[cfaessler]

@d22 are you doing the changes discussed at the last meeting?

[d22]

Yes, I will update the model.

[d22]

Updated the model, @cfaessler please review: https://github.com/tnc-ba/doku/blob/master/images/db/database-model.png

Changes are:

• Relation between SWID tags and entities
• No roles table anymore
• Removed 'blacklist' flags from 'packages' table
• Model fits on an A3 page again :wink:

I didn't upated (remove) the 'keys' table and also didn't add the trusted flag in the devices table, as this are DB changes which need mr. Steffen to be involved.

[cfaessler]

All layer labels except "SWID Tag Erweiterung" are english.

[cfaessler]

cardinality of files <-> swid_files is 1..0* (not every file is related to a swid_file)

[cfaessler]

Same for session <-> swid_measurement_reports

[d22]

Updated accordingly (commit tnc-ba/doku@7822747083b1b93be7234c270ecde7e88afcda37)

[d22]

Update schema, no multipe measurements possible atm.

[d22]

@cfaessler, please check if the changes are correct, tnx!