Resolve "update sms foreign and mock tables"

Closes #131 (closed)

For the implementation of the STAMPLATE STA Schema, we need to update the SMS foreign and mock tables.

Linked MR:

tsm-dispatcher!105 (merged)

post-scriptum: We will also update the SMS-CV sync script here.

assigned to @joost.hemmen1

mentioned in merge request tsm-dispatcher!105 (merged)

added 1 commit

• df315743 - add device_contact_role foreign table

Compare with previous version

added 1 commit

• a120e7fa - add device_contact_role to sms tables

Compare with previous version

added 1 commit

• 3399d3f4 - add configuration_contact_role.id, .role_uri and .role_name

Compare with previous version

added 1 commit

• f038a410 - Update file sms_ddl.sql

Compare with previous version

added 1 commit

• e4083fd5 - add more cv tables

Compare with previous version

added 1 commit

• da8eb54e - add missing columns in foreign tables

Compare with previous version

added 1 commit

• f996110d - add missing fields

Compare with previous version

changed the description

added 1 commit

• 26966a04 - add new cv tables to sync script

Compare with previous version

added 1 commit

• 7074ac7d - fix typo

Compare with previous version

added 1 commit

• b6ecaee3 - Update 3 files

Compare with previous version

marked this merge request as ready

requested review from @florian.gransee

approved this merge request

merged

mentioned in commit 4c723a39