PostgreSQL tables are not related to modules. They are related to OpenERP models, like
stock.move. Every module can have zero-to-many models.
The table names are generated by using the model names and replacing all
For example the table name of
It is not possible to assign each database table to a specific module because many tables are used by different modules and there are about 600 tables.
We use http://schemaspy.sourceforge.net/ to help visualize the tables in the database, understand their dependencies and suggest which tables should be populated before others - accounting information before products and partners for example.
ORM manages the persistence of data inside PostgreSQL. As others are posting, which tables are used depends a lot on python code in many different places.
Another method we use to understand the tables involved is to set the server to log the SQL requests.
You can see all the tables in postgres by connecting to your database and listing the tables.
sudo su - postgres psql -d yourdatabase
now type this command to list all the tables in a DB
If you look in the python file for the associated module, it will list the models for that module. The models translate into tables in postgres. The model name will be changed from model.name to model_name
A module is not required to have tables, so there might be no tables for some modules.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/11/13, 9:03 AM|
|Seen: 7915 times|
|Last updated: 3/16/15, 8:10 AM|