Where can I get a database schema for Odoo?
I'd like to visually represent the tables so that I can understand the relationships.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilité
- Inventaire
- PoS
- Projet
- MRP
Cette question a été signalée
1
Répondre
30836
Vues
It is possible but only really works for understanding very small pieces of Odoo at a time.
For example, let's look at the TAG field on a Lead:
This can be represented visually like this:
You can see that CRM Tags can be used on Sales Orders as well as Leads.
However, even a very small Odoo database contains HUNDREDS of tables. There are also INTERNAL tables for storing the User Interface, the Access Controls (Security), the Reports, etc.
It can quickly become very complicated to work with a visual representation.
It might work better to leverage the DATABASE STRUCTURE menu in Odoo (available in Developer Mode)
A 'model' is closest to a table in PostgreSQL, but some fields/columns can be defined by Python and might not even be persisted in PostgreSQL.
For more information, see
https://www.odoo.com/documentation/14.0/developer/reference/addons/orm.html
Note: the visual representation was created automatically by the free version of
Just to give you an idea, this is the visual representation of the Sales Order table and TWENTY-TWO relationships:
And for res.partner (Contact) there are 68 related tables:
You know, this is a very impressive response and you even add links to tools that may be helpful in future.
Thank you.
Ssh! - don't tell anyone else though, my inbox will be inundated with questions!
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire
Thank you for this detailed answer.