 
 
 
-
-
-
+ -- table for nonclassification terms
+
+create table htax_noclassterm (
+	nc_tid number not null,
+	tid number not null,
+	term_type varchar2(255) not null,
+	term_value varchar2(255) not null
+);
+
+	create or replace public synonym htax_noclassterm for htax_noclassterm;
+	grant all on htax_noclassterm to manage_taxonomy;
+
+	ALTER TABLE htax_noclassterm ADD PRIMARY KEY (nc_tid);
+
+	ALTER TABLE htax_noclassterm ADD CONSTRAINT fk_htaxnc_dataset_id  FOREIGN KEY (tid) REFERENCES hierarchical_taxonomy(tid);
 
 
 CREATE OR REPLACE PROCEDURE proc_hierac_tax IS

				performSearch();
			});
		});


		function performSearch(){

					}
				);
			});
			$( "#srch" ).change(function() {
				performSearch();
			});
