← BackSQL

voc-1.2.276.0.76.3.1.195.11.9-2024-02-11T211652.sql

Download
    --DROP TABLE age_in_categories CASCADE;
    CREATE TABLE age_in_categories (
            age_in_categories_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (1, '0', '1.2.276.0.76.3.1.195.5.100', '0 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (2, '1', '1.2.276.0.76.3.1.195.5.100', '1 Jahr');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (3, '2', '1.2.276.0.76.3.1.195.5.100', '2 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (4, '3', '1.2.276.0.76.3.1.195.5.100', '3 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (5, '4', '1.2.276.0.76.3.1.195.5.100', '4 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (6, '5-9', '1.2.276.0.76.3.1.195.5.100', '5-9 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (7, '10-14', '1.2.276.0.76.3.1.195.5.100', '10-14 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (8, '15-19', '1.2.276.0.76.3.1.195.5.100', '15-19 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (9, '20-24', '1.2.276.0.76.3.1.195.5.100', '20-24 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (10, '25-29', '1.2.276.0.76.3.1.195.5.100', '25-29 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (11, '30-34', '1.2.276.0.76.3.1.195.5.100', '30-34  Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (12, '35-39', '1.2.276.0.76.3.1.195.5.100', '35-39 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (13, '40-44', '1.2.276.0.76.3.1.195.5.100', '40-44 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (14, '45-49', '1.2.276.0.76.3.1.195.5.100', '45-49 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (15, '50-54', '1.2.276.0.76.3.1.195.5.100', '50-54 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (16, '55-59', '1.2.276.0.76.3.1.195.5.100', '55-59 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (17, '60-64', '1.2.276.0.76.3.1.195.5.100', '60-64 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (18, '65-69', '1.2.276.0.76.3.1.195.5.100', '65-69 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (19, '70-74', '1.2.276.0.76.3.1.195.5.100', '70-74 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (20, '75-79', '1.2.276.0.76.3.1.195.5.100', '75-79 Jahre');
        
    INSERT INTO age_in_categories (age_in_categories_id, code, codeSystem, displayName)
            VALUES (21, '80+', '1.2.276.0.76.3.1.195.5.100', '80+ Jahre');