--DROP TABLE NACAscore CASCADE; CREATE TABLE NACAscore ( NACAscore_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (1, '0', '1.2.276.0.76.5.82', 'NACA 0'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (2, 'I', '1.2.276.0.76.5.82', 'NACA I'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (3, 'II', '1.2.276.0.76.5.82', 'NACA II'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (4, 'III', '1.2.276.0.76.5.82', 'NACA III'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (5, 'IV', '1.2.276.0.76.5.82', 'NACA IV'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (6, 'V', '1.2.276.0.76.5.82', 'NACA V'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (7, 'VI', '1.2.276.0.76.5.82', 'NACA VI'); INSERT INTO NACAscore (NACAscore_id, code, codeSystem, displayName) VALUES (8, 'VII', '1.2.276.0.76.5.82', 'NACA VII');