--DROP TABLE manchestertriagesystem CASCADE;
CREATE TABLE manchestertriagesystem (
manchestertriagesystem_id int NOT NULL PRIMARY KEY,
code varchar(255) NOT NULL,
codeSystem varchar(255) NOT NULL,
displayName varchar(255) NOT NULL
);
INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName)
VALUES (1, '1', '1.2.276.0.76.5.438', 'sofort - rot - 0 Minuten');
INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName)
VALUES (2, '2', '1.2.276.0.76.5.438', 'sehr dringend - orange - 10 Minuten');
INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName)
VALUES (3, '3', '1.2.276.0.76.5.438', 'dringend - gelb - 30 Minuten');
INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName)
VALUES (4, '4', '1.2.276.0.76.5.438', 'normal - grün - 90 Minuten');
INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName)
VALUES (5, '5', '1.2.276.0.76.5.438', 'nicht dringend - blau - 120 Minuten');