This question has been flagged
2 Replies
8136 Views

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

Avatar
Discard
Best Answer

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.

Avatar
Discard
Author Best Answer

thank you boemba

Avatar
Discard