[GeoNode-users] geonode database for user account layer list , and about erd

[Giovani Fronza]

I produced this diagram through reverse engineering in Astah software. It
has all the tables and database relationships of Geonode version 2.4,
without cardinality.
I hope this can help you.


​

2017-06-15 3:40 GMT-03:00 Cezary Statkiewicz <
cezary.statkiewicz at geo-solutions.it>:

> On Thursday, June 15, 2017 7:28:21 AM CEST Simone Dalmasso wrote:
> > Hi, I don't think there's such diagram. The description of the geonode
> > tables are the django models which you can find in the geonode codebase,
> > models.py files.
> >
> > 2017-06-15 2:11 GMT+02:00 원영진 <icetiger at nate.com>:
> > > We are studying GEONODE for our business and It helps so much more
> than we
> > > imagined.
> > >
> > > I am searching the information about database which stores users ,
> layers
> > > and so on.
> > > And at last I found the database and tables in my postgresql
> > > But I can not find the database document in the internet
> > > The description about each table, filed and erd(entity relationship
> > > diagram)
> > > Is there something for reference?
> > > I look forward to hearing from you soon.
> > > Thank you.
>
>  Side note: you can generate model diagram with graph_models command
> (provided
> by django_extensions app). You'll need to install pydot or pygraphviz for
> image output.
>
>  To get diagram image for all apps (using pydot), call:
>
>  ./manage.py  graph_models  --all-applications --verbose-names --pydot --
> output diagram.png
>
>  Best Regards,
>
>  Cezary Statkiewicz
>
> --
> Regards,
> Cezary Statkiewicz
> ==
> GeoServer Professional Services from the experts!
> Visit http://goo.gl/it488V for more information.
> ==
> Cezary Statkiewicz
> Senior Software Engineer
>
> GeoSolutions S.A.S.
> Via di Montramito 3/A
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax:     +39 0584 1660272
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i
> file/s allegato/i sono da considerarsi strettamente riservate. Il loro
> utilizzo è consentito esclusivamente al destinatario del messaggio, per le
> finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio
> senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia
> via e-mail e di procedere alla distruzione del messaggio stesso,
> cancellandolo
> dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in
> parte,
> distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità
> diverse,
> costituisce comportamento contrario ai principi dettati dal D.Lgs.
> 196/2003.
>
> The information in this message and/or attachments, is intended solely for
> the
> attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative
> Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use
> not
> in accord with its purpose, any disclosure, reproduction, copying,
> distribution, or either dissemination, either whole or partial, is strictly
> forbidden except previous formal approval of the named addressee(s). If you
> are not the intended recipient, please contact immediately the sender by
> telephone, fax or e-mail and delete the information in this message that
> has
> been received in error. The sender does not give any warranty or accept
> liability as the content, accuracy or completeness of sent messages and
> accepts no responsibility  for changes made after they were sent or for
> other
> risks which arise as a result of e-mail transmission, viruses, etc.
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20170619/1951e315/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ER Diagram1.png
Type: image/png
Size: 730011 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20170619/1951e315/attachment-0001.png>