fixed refference generation and removed id column in web app