HI Guys - Is there any documentation available for ODOO data model diagrams ? If I wanted to find the complete documentation on relationship between one table to other table then what is way around ?
Thanks in Advance
Kashif
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
12071
Views
Yes,
visit="https://techneith.com/products/odoo-data-model/"
Live\ Demo Link\ 'https://youtu.be/dtg7YP7Nhpw'
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:
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
0
Nov 25
|
3368 | ||
|
2
Aug 25
|
3948 | ||
|
1
Jul 25
|
1943 | ||
|
1
Aug 25
|
1154 | ||
|
0
May 25
|
2157 |
Anyone can reply?
"ODOO DATA MODEL" is not a question. I have edited your post to make the title a question. In the future, please consider using a Question that can make it clear what you ask without requiring people to open your post, as this will often increase the chances people will respond and make everything clearer for others looking for the same answer.