--DROP TABLE SOASInfo CASCADE; CREATE TABLE SOASInfo ( SOASInfo_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SOASInfo (SOASInfo_id, code, codeSystem, displayName) VALUES (1, '001', '2.16.756.5.30.1.129.1.1.2', 'Center specific avoid'); INSERT INTO SOASInfo (SOASInfo_id, code, codeSystem, displayName) VALUES (2, '002', '2.16.756.5.30.1.129.1.1.2', 'Previous TX');