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

Where can we find a database scheme?

By
Krijn
on 8/15/14, 12:36 PM 12,034 views

Is there a scheme of the database, so by customization we can easyly can see the structure of table and there depenties....

We are looking for a scheme of OpenErp version 7.

Thanks in advanced...
 

1

Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
5823
| 7 7 8
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo USA

Fabrice Henrion (fhe)
On 8/15/14, 4:07 PM

It's available here for v8: http://useopenerp.com/

Awesome find/post. Thanks!

Stephen Mack
on 8/15/14, 7:37 PM
0
Landis Arnold
On 5/18/16, 10:15 PM

One can "see" the database structure (as in the database) pretty directly.  Postgres can be browsed and updated w/ many client tools.  Here is a good list below at the bottom of this note.  Recently I have been able also to connect with FileMaker Pro which is helpful.

What I think you are really asking though is a "viewed" Index of the Database structure.  I used to get this with a great Commercial package (FoxPro based) called SBT (or SBT Pro).  Can't say it will be that easy to find "one compendium" for this with Odoo.  Generally each Module has another pass at modifying the structure somewhat.  You can look at each module to see what they are doing.  

Ideally, there may be some way to "watch the data" as you work so that you could see what you are changing and when.  Would seem quite practical in any event.


\Community\_Guide\_to\_PostgreSQL\_GUI\_Tools\\\

\

0
Nate Foster
On 8/15/14, 3:20 PM

I second what Thacker Scott recomends for getting a good view of the database. 

Also, if you enable "Technical Settings" for your admin user, then goto "Settings" 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. 

Cheers,

Nate

 

 

0
ThackerS (ts)
On 8/15/14, 3:15 PM

Dear Krijin.
Actually, you can't see openerp database schema.
I recommend you to use pgAdmin III to see openerp databases and their tables and structures. pgAdmin III is used by many openerp developers. It is very helpful tool. I recommend it for you.

http://www.pgadmin.org/

http://www.youtube.com/watch?v=9XNhlgriT

Best regards
 

0

Stephen Mack

--Stephen Mack--
5023
| 8 8 9
Santiago, Chile
--Stephen Mack--

Some people call me a karma whore, I only ask for 10 points if you like my answer and 15 if I happen to get it correct.

Stephen Mack
On 8/15/14, 1:38 PM

Honestly I don't know if one exists but you may want to start with the OpenUpgrade project as they do a lot of database analysis.

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

4 follower(s)

Stats

Asked: 8/15/14, 12:36 PM
Seen: 12034 times
Last updated: 5/19/16, 3:28 AM