mandatory, primary, unique, auto increment constraint added