changed boolean to NUMBER(1) so oracle can be used