Database schema/relationships documentation?
Database schema/relationships documentation?
I have a couple of phpBB projects that I am considering. It would be nice if there was some existing documentation on the structure and relationships of data in the database. Is there anything other than the source code and sql schema (which doesn't capture a lot of relationships that the software relies on)?
Re: Database schema/relationships documentation?
Have you looked at Tables - phpBB Development Wiki?
Re: Database schema/relationships documentation?
No, I had not found that. It is almost exactly what I was looking for.
Re: Database schema/relationships documentation?
Attached are a couple of things I found a loong time ago, when I had a similar question.
BEWARE: THESE ARE FOR 3.0, not for 3.1/3.2
Significant parts are common, but others have changed, there have been (very relevant) additions and deletions, both tables and fields.
Al least, something to get started. I am attaching these here as I have not been able to find a working link any more. Take a look at the author so that you give credit to where it belongs, not me.
Regards,
-javiexin
PS: If someone has or know of an equivalent diagram for 3.1/3.2, it would be a great documentation addition. Specially if done in manageable chunks, not all-in-one, that makes it too complex.
BEWARE: THESE ARE FOR 3.0, not for 3.1/3.2
Significant parts are common, but others have changed, there have been (very relevant) additions and deletions, both tables and fields.
Al least, something to get started. I am attaching these here as I have not been able to find a working link any more. Take a look at the author so that you give credit to where it belongs, not me.
Regards,
-javiexin
PS: If someone has or know of an equivalent diagram for 3.1/3.2, it would be a great documentation addition. Specially if done in manageable chunks, not all-in-one, that makes it too complex.
Re: Database schema/relationships documentation?
I just found out about this:
https://www.phpbb.com/community/viewtop ... &t=2424496
Might not be perfect (at least there are quite some missing relations), but definitely helps!
-javiexin
https://www.phpbb.com/community/viewtop ... &t=2424496
Might not be perfect (at least there are quite some missing relations), but definitely helps!
-javiexin