changed primary key to not be auto generated and fixed data type