Tribune

Home » Liferay Documentation

Vista Combinata Vista Piatta Vista ad Albero
Discussioni [ Precedente | Successivo ]
toggle
Grzegorz Kucner
Database documentation
27 luglio 2011 2.16
Risposta

Grzegorz Kucner

Punteggio: Junior Member

Messaggi: 38

Data di Iscrizione: 26 gennaio 2009

Messaggi recenti

Hi,

Where can I find database documentation for Liferay 6.0.6 CE database tables. I need to put documentation for each table and column which is used in Liferay installation into technical project documentation. It seems that there is no such documentation at all and I have to do it myself emoticon Which means I have to create big document describing each table and column one by one. Can anybody help me?
Leo Pratlong
RE: Database documentation
27 luglio 2011 2.35
Risposta

Leo Pratlong

Punteggio: Expert

Messaggi: 362

Data di Iscrizione: 6 luglio 2010

Messaggi recenti

Try Reverse Engineering with tool like Power AMC.
But since Liferay DB does not use foreign keys, I don't know if it will be efficient.

You can also find info in javadoc for each Model class.
Hitoshi Ozawa
RE: Database documentation
27 luglio 2011 2.39
Risposta

Hitoshi Ozawa

Punteggio: Liferay Legend

Messaggi: 7990

Data di Iscrizione: 23 marzo 2010

Messaggi recenti

Download the Liferay source and all the sql scripts are in the sql directory.

I think all members of this forum will greatly appreciate if you can contribute your finished documenation. :-)
Grzegorz Kucner
RE: Database documentation
27 luglio 2011 2.41
Risposta

Grzegorz Kucner

Punteggio: Junior Member

Messaggi: 38

Data di Iscrizione: 26 gennaio 2009

Messaggi recenti

Leo PRATLONG:
Try Reverse Engineering with tool like Power AMC.
But since Liferay DB does not use foreign keys, I don't know if it will be efficient.


That's my emergency plan, but this still a lot of work to do and for sure there will be problem describing some columns of workflow tables.

Leo PRATLONG:
You can also find info in javadoc for each Model class.

It is still incomplete as far as I know.
Mika Koivisto
RE: Database documentation
27 luglio 2011 15.51
Risposta

Mika Koivisto

LIFERAY STAFF

Punteggio: Liferay Legend

Messaggi: 1498

Data di Iscrizione: 7 agosto 2006

Messaggi recenti

First of all why would you have to document the database structure of a product your team didn't develop? It just doesn't make sense to me. For instance would you ask IBM for their documentation on the database schema Websphere portal uses?

Unfortunately we don't have any formal documentation of the database schema. The whole schema is generated from service.xml(s) by service builder. You can find the sql for your DB from the sql directory of the portal source like Hitoshi already mentioned.
Szymon Gołębiewski
RE: Database documentation
11 novembre 2011 15.01
Risposta

Szymon Gołębiewski

Punteggio: Regular Member

Messaggi: 247

Data di Iscrizione: 8 giugno 2009

Messaggi recenti

Any luck with this documentation Grzegorz?
Hitoshi Ozawa
RE: Database documentation
11 novembre 2011 17.38
Risposta

Hitoshi Ozawa

Punteggio: Liferay Legend

Messaggi: 7990

Data di Iscrizione: 23 marzo 2010

Messaggi recenti

Come to think of it, I think the best choice may be to just look at the service.xml file using Liferay IDE to gett the graphical entity relationships and the tables.
If you can't decipher it, I think there are many people who'll be able to do it for a fee.