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

I would agree with earlier posters that you should use a real database tool such as PGadminIII.

If you are coding at the granular level of the back-end database, you need to STUDY all of the implications of any action - and be familiar with EVERY mod that may be affected by changes.

I recommend against any “easy” solution; unless you are very comfortable with the back-end, don’t touch it or data loss is likely.

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
 

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\\\

\

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.