needed modification to the schema and the SQL model file