Skip to Content
Menu
This question has been flagged
3 Replies
374 Zobrazenia

Hi, I'm looking for some guide of the structure of CRM tables to create some reports and dashboards. I tried to find it for several links and odoo web-site but with out any lucky.


If you have any documentation link, I will appreciate it.


Avatar
Zrušiť
Best Answer

There’s no official detailed ERD (Entity Relationship Diagram) published by Odoo, but you can explore the CRM structure through:

  1. Odoo Studio
    • Visual way to inspect models, fields, and relations in the CRM module.
  2. Technical > Models (Developer Mode)
    • Go to Settings > Technical > Models to view tables like crm.lead, crm.stage, res.partner, etc.
  3. Odoo Documentation
  4. Source Code
    • CRM models are located in:
      addons/crm/models/ — especially crm_lead.py, crm_stage.py.
  5. Community ERDs on GitHub
    • Search “Odoo CRM ERD GitHub” to find community-created diagrams.

Avatar
Zrušiť
Best Answer

Hii,

Here is some link please check

https://youtu.be/gamkEnHvNGM?si=MXLpRQsxiYL_lwKr

for database schema you can goto "Setting" at the bottom of the column on the left under the "Technical" section you will see a "Database Structure" menu that might be useful as well.  

i hope it is usefull

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
aug 19
5633
0
jan 19
4136
1
mar 15
4961
5
aug 23
12427
2
jún 22
11951