name | type | comment | NOT NULL | primary key | foreign key |
---|---|---|---|---|---|
MCID | INTEGER | the unique Metrology CLoud ID for MI | X | X | |
specimen | INTEGER | - | X | specimen.ID | |
valid_verification_mark | BOOLEAN | MI has valid verification mark | X | ||
user | VARCHAR | user of MI | |||
last_service_date | DATE | date of last service | |||
IDENT_NUMBER | VARCHAR | serial number | X | ||
INVENTORY_NUMBER | VARCHAR | inventory number |