updated database schema and json body format