Odoo Help

Welcome!

This community 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.

0

Databse schema

By
Zouhair
on 7/16/14, 8:35 AM 1,567 views

where i can found openerp 7 Databse schema? the structure of table and relation between them.

0
boemba
On 7/16/14, 10:34 AM

You can always reverse engeneer the database using one of these tools:

http://stackoverflow.com/questions/3223770/tools-to-generate-database-tables-diagram-with-postgresql

I tried schemaspy

download: http://schemaspy.sourceforge.net/

download java drivers for postgresql : http://jdbc.postgresql.org/download/postgresql-9.3-1102.jdbc41.jar

save in the same folder then execute command:

java -jar schemaSpy_5.0.0.jar -t pgsql -host localhost -port 5432 -db dbname -s public -u username -p password -o /Location where you want your scheme/ -dp postgresql-9.3-1102.jdbc41.jar

change italic with your values.

Hope this helps.

1
Zouhair
On 7/16/14, 12:02 PM

thank you boemba

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/16/14, 8:35 AM
Seen: 1567 times
Last updated: 3/16/15, 8:10 AM