complete api and frontend attachement with api and full db support