use GENERATED BY DEFAULT to allow pk insert/update

refs #60
updated javadoc
refactor boolean expressions