--DROP TABLE epSOSBloodGroup CASCADE; CREATE TABLE epSOSBloodGroup ( epSOSBloodGroup_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (1, '112144000', '2.16.840.1.113883.6.96', 'Blood group A'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (2, '278152006', '2.16.840.1.113883.6.96', 'Blood group A Rh(D) negative'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (3, '278149003', '2.16.840.1.113883.6.96', 'Blood group A Rh(D) positive'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (4, '165743006', '2.16.840.1.113883.6.96', 'Blood group AB'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (5, '278154007', '2.16.840.1.113883.6.96', 'Blood group AB Rh(D) negative'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (6, '278151004', '2.16.840.1.113883.6.96', 'Blood group AB Rh(D) positive'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (7, '112149005', '2.16.840.1.113883.6.96', 'Blood group B'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (8, '278153001', '2.16.840.1.113883.6.96', 'Blood group B Rh(D) negative'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (9, '278150003', '2.16.840.1.113883.6.96', 'Blood group B Rh(D) positive'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (10, '58460004', '2.16.840.1.113883.6.96', 'Blood group O'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (11, '278148006', '2.16.840.1.113883.6.96', 'Blood group O Rh(D) negative'); INSERT INTO epSOSBloodGroup (epSOSBloodGroup_id, code, codeSystem, displayName) VALUES (12, '278147001', '2.16.840.1.113883.6.96', 'Blood group O Rh(D) positive');