Skip to Content
This question has been flagged
#dictionary#DataDictionary#ERD#diagrams#relationships
2 Replies
3622 Views
Avatar
Stutti

Can anyone point me to a Odoo database Data Dictionary? I am not finding it on any of the documentation links. 

Thank you.

Avatar
Discard
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

To fetch the data as dictionary from odoo database tables as dictionary, you can use the orm method search_read.



Odoo ORM:  https://www.odoo.com/documentation/16.0/developer/reference/backend/orm.html

Watch: https://www.youtube.com/watch?v=8V-uOG8KkKA

Thanks

Avatar
Discard
Stutti
Author

Thank you Niyas. Actually, I am looking for the Entity Relationships. Maybe dictionary is not the right term. But maybe a dictionary of what the database entity relationships are. Like a record in res_partner connects to which entities? Is that published somewhere?

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi

Odoo database dictionary comprises tables ie, models, fields, orm methods, and relationships within the database.if you have an odoo database, you can access its database dictionary using pg_admin where we can execute queries and examine each table and column in our database.you can check the following development book of odoo


https://www.cybrosys.com/odoo/odoo-books/odoo-16-development/creating-odoo-modules/adding-models/

Hope it helps

Avatar
Discard