I would like to implement a management of asterisk files through database, I have got a few tables like pjsip (ps_aour, ps_auth …), queue (queue, queue_members …) and the extensions is through a switch statement in the dialplan. However, I am missing tables from other folders like manager, http, agent, cdr_ *, res_ *, ari …
Do you know where I can find these tables?
or I will have to create them

Dont know what guide you followed, but you should install Alembic is a full database migration tool, with support for upgrading the schemas of existing databases, versioning of schemas, creation of new tables and databases and other things