- added discount column and foreign key constraint for sql statements