Open Stack

Hi Nick,

If you want to see the relations of db structure (like nova), you can use
Navicat/Navicat Data Modeler (license needed..).
Access to your db --> select all tables (ctrl+a) --> right click and choose
"Reverse Tables to Model",
then you'll get the results like the attachment I posted.

Please Enjoy.

wingwj
​


On Mon, Nov 18, 2013 at 1:49 AM, Nick Maslov <azpekt at gmail.com> wrote:

> Hi,
>
> I'm having a question loosely related to your request, Slawek :)
>
> Do anyone have docs about all the database tables, their relations and
> purpose?
>
> Thanks a lot!
>
> Sent from my iPad
>
> > On 15 лист. 2013, at 13:07, Sławek Kapłoński <slawek at kaplonski.pl>
> wrote:
> >
> > Hello,
> >
> > In nova database lot of data like quotas, reservations, security_groups
> and other are not phisically removed but are marked as deleted. So for
> example after tempest run on such infrastructure there is a lot of entries
> marked as deleted. So I' thinking for what all that data is stored in
> database and what could be consequences of removing it from database. Is it
> stored only for some kind of "history" what was happend or maybe is is
> important for some functions? Thanks in advance for any info about that or
> for any link to website where it is described :)
> >
> > --
> > Pozdrawiam
> > Sławek Kapłoński
> > slawek at kaplonski.pl
> >
> > _______________________________________________
> > Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> > Post to     : openstack at lists.openstack.org
> > Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
> _______________________________________________
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131118/4f7a637c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nova db.JPG
Type: image/jpeg
Size: 246797 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131118/4f7a637c/attachment.jpe>