Forum OpenACS Q&A: Re: Purpose of acs_tables created by ACS in PostgreSQL

most of them belongs to the acs-core packages, a good start on understanding some of the tables will be to check what an acs-object is:
https://openacs.org/doc/openacs-5-1/objects.html