--DROP TABLE DMSTPrecisionType2 CASCADE; CREATE TABLE DMSTPrecisionType2 ( DMSTPrecisionType2_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DMSTPrecisionType2 (DMSTPrecisionType2_id, code, codeSystem, displayName) VALUES (1, 'a', '2.16.756.5.30.1.112.3.1.201812.4', 'attached'); INSERT INTO DMSTPrecisionType2 (DMSTPrecisionType2_id, code, codeSystem, displayName) VALUES (2, 'n', '2.16.756.5.30.1.112.3.1.201812.4', 'not attached');