Odoo Help

0

I want to know which are the tables of the database of OpenERP 7 ?

By
SKAL
on 3/11/13, 9:03 AM 9,010 views

I need to know for each module of OpenERP 7 what are its tables assiciated in PostgreSQL.

Ok, Thank you Sir.

SKAL
on 3/11/13, 9:15 AM

select table_name, table_type, table_catalog from information_schema.tables where table_schema = 'public'

mike
on 3/11/13, 9:43 AM
2

Andreas Brueckl

--Andreas Brueckl--
5161
| 7 8 7
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl
On 3/11/13, 9:09 AM

PostgreSQL tables are not related to modules. They are related to OpenERP models, like sale.order or stock.move. Every module can have zero-to-many models.

The table names are generated by using the model names and replacing all . by _. For example the table name of sale.order is sale_order.

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.

1

Ray Carnes

--Ray Carnes--
17330
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Major Skills:

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 3/11/13, 3:28 PM

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.

0

AJ Schrafel Paper Corp

--AJ Schrafel Paper Corp--
2120
| 4 5 8
Bronx, United States
--AJ Schrafel Paper Corp--

Exploring OpenERP for business

AJ Schrafel Paper Corp
On 3/11/13, 11:39 AM

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

/dt

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.

how to get the database name?

sneha antony
on 3/27/14, 4:59 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 3/11/13, 9:03 AM
Seen: 9010 times
Last updated: 3/16/15, 8:10 AM