--DROP TABLE IPSPackage CASCADE; CREATE TABLE IPSPackage ( IPSPackage_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (1, '30000500', '0.4.0.127.0.16.1.1.2.1', 'Administration system'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (2, '30001000', '0.4.0.127.0.16.1.1.2.1', 'Ampoule'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (3, '30002000', '0.4.0.127.0.16.1.1.2.1', 'Applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (4, '30004000', '0.4.0.127.0.16.1.1.2.1', 'Bag'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (5, '30006000', '0.4.0.127.0.16.1.1.2.1', 'Barrel'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (6, '30007000', '0.4.0.127.0.16.1.1.2.1', 'Blister'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (7, '30008000', '0.4.0.127.0.16.1.1.2.1', 'Bottle'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (8, '30009000', '0.4.0.127.0.16.1.1.2.1', 'Box'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (9, '30010000', '0.4.0.127.0.16.1.1.2.1', 'Brush'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (10, '30011000', '0.4.0.127.0.16.1.1.2.1', 'Brush applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (11, '30012000', '0.4.0.127.0.16.1.1.2.1', 'Cannula'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (12, '30013000', '0.4.0.127.0.16.1.1.2.1', 'Cap'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (13, '30014000', '0.4.0.127.0.16.1.1.2.1', 'Cartridge'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (14, '30015000', '0.4.0.127.0.16.1.1.2.1', 'Child-resistant closure'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (15, '30016000', '0.4.0.127.0.16.1.1.2.1', 'Cup'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (16, '30017000', '0.4.0.127.0.16.1.1.2.1', 'Dabbing applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (17, '30019000', '0.4.0.127.0.16.1.1.2.1', 'Dredging applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (18, '30020000', '0.4.0.127.0.16.1.1.2.1', 'Dredging container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (19, '30022000', '0.4.0.127.0.16.1.1.2.1', 'Dropper applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (20, '30023000', '0.4.0.127.0.16.1.1.2.1', 'Dropper container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (21, '30023005', '0.4.0.127.0.16.1.1.2.1', 'Fixed cryogenic vessel'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (22, '30024000', '0.4.0.127.0.16.1.1.2.1', 'Gas cylinder'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (23, '30025000', '0.4.0.127.0.16.1.1.2.1', 'High pressure transdermal delivery device'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (24, '30026000', '0.4.0.127.0.16.1.1.2.1', 'Implanter'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (25, '30026500', '0.4.0.127.0.16.1.1.2.1', 'Inhaler'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (26, '30027000', '0.4.0.127.0.16.1.1.2.1', 'In-ovo injection device'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (27, '30028000', '0.4.0.127.0.16.1.1.2.1', 'Injection needle'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (28, '30029000', '0.4.0.127.0.16.1.1.2.1', 'Injection syringe'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (29, '30031000', '0.4.0.127.0.16.1.1.2.1', 'Intramammary syringe'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (30, '30032000', '0.4.0.127.0.16.1.1.2.1', 'Jar'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (31, '30033000', '0.4.0.127.0.16.1.1.2.1', 'Measuring device'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (32, '30034000', '0.4.0.127.0.16.1.1.2.1', 'Measuring spoon'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (33, '30035000', '0.4.0.127.0.16.1.1.2.1', 'Metering pump'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (34, '30036000', '0.4.0.127.0.16.1.1.2.1', 'Metering valve'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (35, '30036005', '0.4.0.127.0.16.1.1.2.1', 'Mobile cryogenic vessel'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (36, '30037000', '0.4.0.127.0.16.1.1.2.1', 'Mouthpiece'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (37, '30038000', '0.4.0.127.0.16.1.1.2.1', 'Multidose container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (38, '30039000', '0.4.0.127.0.16.1.1.2.1', 'Multidose container with airless pump'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (39, '30040000', '0.4.0.127.0.16.1.1.2.1', 'Multipuncturer'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (40, '30041000', '0.4.0.127.0.16.1.1.2.1', 'Nasal applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (41, '30042000', '0.4.0.127.0.16.1.1.2.1', 'Nebuliser'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (42, '30043000', '0.4.0.127.0.16.1.1.2.1', 'Needle applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (43, '30044000', '0.4.0.127.0.16.1.1.2.1', 'Nozzle'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (44, '30045000', '0.4.0.127.0.16.1.1.2.1', 'Oral syringe'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (45, '30046000', '0.4.0.127.0.16.1.1.2.1', 'Pipette'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (46, '30047000', '0.4.0.127.0.16.1.1.2.1', 'Pipette applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (47, '30048000', '0.4.0.127.0.16.1.1.2.1', 'Pour-on container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (48, '30049000', '0.4.0.127.0.16.1.1.2.1', 'Pre-filled gastroenteral tube'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (49, '30050000', '0.4.0.127.0.16.1.1.2.1', 'Pre-filled pen'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (50, '30051000', '0.4.0.127.0.16.1.1.2.1', 'Pre-filled syringe'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (51, '30052000', '0.4.0.127.0.16.1.1.2.1', 'Pressurised container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (52, '30053000', '0.4.0.127.0.16.1.1.2.1', 'Prick test applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (53, '30053500', '0.4.0.127.0.16.1.1.2.1', 'Roll-on container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (54, '30054000', '0.4.0.127.0.16.1.1.2.1', 'Sachet'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (55, '30055000', '0.4.0.127.0.16.1.1.2.1', 'Scarifier'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (56, '30056000', '0.4.0.127.0.16.1.1.2.1', 'Screw cap'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (57, '30057000', '0.4.0.127.0.16.1.1.2.1', 'Single-dose container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (58, '30058000', '0.4.0.127.0.16.1.1.2.1', 'Spatula'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (59, '30059000', '0.4.0.127.0.16.1.1.2.1', 'Spot-on applicator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (60, '30060000', '0.4.0.127.0.16.1.1.2.1', 'Spray container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (61, '30061000', '0.4.0.127.0.16.1.1.2.1', 'Spray pump'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (62, '30062000', '0.4.0.127.0.16.1.1.2.1', 'Spray valve'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (63, '30063000', '0.4.0.127.0.16.1.1.2.1', 'Stab vaccinator'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (64, '30064000', '0.4.0.127.0.16.1.1.2.1', 'Stopper'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (65, '30064500', '0.4.0.127.0.16.1.1.2.1', 'Straw'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (66, '30065000', '0.4.0.127.0.16.1.1.2.1', 'Strip'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (67, '30066000', '0.4.0.127.0.16.1.1.2.1', 'Tablet container'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (68, '30067000', '0.4.0.127.0.16.1.1.2.1', 'Tube'); INSERT INTO IPSPackage (IPSPackage_id, code, codeSystem, displayName) VALUES (69, '30069000', '0.4.0.127.0.16.1.1.2.1', 'Vial');