name | type | comment | NOT NULL | primary key | foreign key |
---|---|---|---|---|---|
ID | INTEGER | unique ID for MI in evp scope | X | X | |
MI | INTEGER | - | X | mi.ID | |
user | VARCHAR | user of MI (eigentlich nur soetwas wie Inventarnummer beim USER) | mi.INVENTORY_NUMBER | ||
TYPE | INTEGER | device type in evp scope | X |