 INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (9, NULL, NULL, NULL, 'VALUE2_VALUE2', NULL, 'VALUE2_CODE_CODE2', 'VALUE2_CODE_CODE_SYSTEM1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (10, NULL, NULL, NULL, 'VALUE2_VALUE3', NULL, 'VALUE2_CODE_CODE3', 'VALUE2_CODE_CODE_SYSTEM2', 'VALUE2_CODE_CODE_SYSTEM_NAME1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (11, NULL, NULL, NULL, 'VALUE2_VALUE4', NULL, 'VALUE2_CODE_CODE4', 'VALUE2_CODE_CODE_SYSTEM3', 'VALUE2_CODE_CODE_SYSTEM_NAME2', '1.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (12, NULL, NULL, NULL, 'VALUE2_VALUE5', 'NA', 'VALUE2_CODE_CODE5', 'VALUE2_CODE_CODE_SYSTEM4', 'VALUE2_CODE_CODE_SYSTEM_NAME3', '1.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (12, NULL, NULL, NULL, 'VALUE2_VALUE5', 'NULL, 'VALUE2_CODE_CODE5', 'VALUE2_CODE_CODE_SYSTEM4', 'VALUE2_CODE_CODE_SYSTEM_NAME3', '1.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VALUE3_VALUE1', NULL, 'VALUE3_CODE_CODE1', 'VALUE3_CODE_CODE_SYSTEM1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO sc_datatype (id, value1_value, value1_code_code, value2_null_flavor, value2_value, value2_code_null_flavor, value2_code_code, value2_code_code_system, value2_code_code_system_name, value2_code_code_system_ver, value3_null_flavor, value3_value, value3_code_null_flavor, value3_code_code, value3_code_code_system, value3_code_code_system_name, value3_code_code_system_ver, value3_code_display_nflavor, value3_code_display_value, value3_code_orig_txt_nflavor, value3_code_orig_txt_desc, value3_code_orig_txt_value) VALUES (15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'VALUE3_VALUE2', NULL, 'VALUE3_CODE_CODE1', 'VALUE3_CODE_CODE_SYSTEM1', 'VALUE3_CODE_CODE_SYSTEM_NAME1', 'VALUE3_CODE_CODE_SYSTEM_VER1', NULL, NULL, NULL, NULL, NULL);

INSERT INTO bl_datatype (id, value1_value, value2_null_flavor, value2_value) VALUES (1, NULL, NULL, NULL);
INSERT INTO bl_datatype (id, value1_value, value2_null_flavor, value2_value) VALUES (2, '1', NULL, NULL);
INSERT INTO bl_datatype (id, value1_value, value2_null_flavor, value2_value) VALUES (3, NULL, NULL, '1');
INSERT INTO bl_datatype (id, value1_value, value2_null_flavor, value2_value) VALUES (4, NULL, 'INV', '0');


--


CREATE TABLE bl_nonnull_datatype (
    id integer NOT NULL,
    value1_value boolean
);


