refining model of chr in sql file