If you need phpBB3 ERD, take a look.

[Lim531]

Hi all,

PhpBB3 ERD See if you need it.

https://www.erdcloud.com/d/23zvQbme2zHiLtYmf

If there is something wrong, please let me know.

[AmigoJack]

(for those not immediately grasping what he's about: an entity-relationship diagram displaying all database tables and how they're ...well... related to each other)

something wrong

Yes:

1. phpbb_sessions.session_user_id is not connected to phpbb_users
2. phpbb_sessions.session_forum_id is not connected to phpbb_forums
3. phpbb_topics_track.forum_id is not connected to phpbb_forums
4. phpbb_poll_votes.poll_option_id is not connected to phpbb_poll_options
5. phpbb_poll_votes.vote_user_id is not connected to phpbb_users
6. phpbb_attachments.post_msg_id is not connected to phpbb_privmsgs
7. phpbb_attachments.poster_id is not connected to phpbb_users
8. phpbb_banlist.ban_userid is not connected to phpbb_users
9. phpbb_modules.parent_id is not connected to phpbb_modules
10. phpbb_modules.left_id is not connected to phpbb_modules
11. phpbb_modules.right_id is not connected to phpbb_modules
12. phpbb_groups.group_rank is not connected to phpbb_ranks
13. phpbb_privmsgs.author_id is not connected to phpbb_users
14. phpbb_privmsgs.icon_id is not connected to phpbb_icons
15. phpbb_privmsgs.message_edit_user is not connected to phpbb_users
16. phpbb_privmsgs_to.author_id is not connected to phpbb_users
17. phpbb_privmsgs_to.folder_id is not connected to phpbb_privmsgs_folder
18. phpbb_privmsgs_rules.rule_folder_id is not connected to phpbb_privmsgs_folder
19. phpbb_privmsgs_rules.rule_group_id is not connected to phpbb_groups
20. phpbb_privmsgs_rules.rule_user_id is not connected to phpbb_users

...and I give up. Just too many things are missing.

[javiexin]

Might not be perfect, but definitely helps, a lot!
-javiexin

PS: Please, see the bottle half full, and not half empty. This is QUITE an improvement from what there was before!

[.m.]

^ may be few experienced users can collaborate & make it a perfect informative system ..

[3Di]

(for those not immediately grasping what he's about: an entity-relationship diagram displaying all database tables and how they're ...well... related to each other)

something wrong

Yes:

...snipblah ..

...and I give up. Just too many things are missing.

May I chime in? What a welcome to a first time poster here, congrats.
The OP is attempting (with good results) to help out the Community.
If you feel you are able to do that better go for it, instead of posting such a non-constuctive criticism.

Let's accurately understand wht the OP stated:

If there is something wrong, please let me know.

By you reported as

something wrong

Once again, don't use an excerpt of a sentence (please!). Isn't nice!
Again, the Op asks in a polite manner to let him know if there are issues or so on, which means is willing to continue his hard job in favor of us, the Community.

And yes, as Javier said. Take a note.

PS: Please, see the bottle half full, and not half empty. This is QUITE an improvement from what there was before!

And more..
You give up about this? Yes please, do it but before of letting the OP abandon this useful project.

Hi all,

PhpBB3 ERD See if you need it.

https://www.erdcloud.com/d/23zvQbme2zHiLtYmf

If there is something wrong, please let me know.

Hi and welcome.

Thanks for your hard work, very interesting.

Let us know how we can help you, in case.
Regards.

[AmigoJack]

see the bottle half full, and not half empty

That's an assumption, and it is a wrong one. As a realist I see the bottle neither half empty, nor half full - it's not my problem that people tend to distinguish into black and white only. And I'm sure you wouldn't want half empty/full phpBB releases either - Lim531 released its version as such without further explanations (maybe there are reasons why relations are missing, but there's no hint his work is still in progress), so I have to take it as such.

If you feel you are able to do that better go for it

I neither implied, nor declined that. If it wouldn't be in that software/format I could do a better diagram, but I wonder that nobody ever asked for it and suddenly it seems to be highly demanded.

such a non-constuctive criticism

You mean precisely naming missing relations is not constructive? I wonder what you call something that is really not constructive.

you reported as

something wrong

Once again, don't use an excerpt of a sentence

I have no idea why the very essence of a sentence (a phrase) is not enough to refer to. And you also didn't elaborate why omitting the other words isn't "nice".

Op asks in a polite manner

And where did I answer impolitely? I elaborated what is missing and after a while I was too tired to typing the table names again and again, and I gave up. Shouldn't I have written that? Just because I'm not super-polite and not using smileys doesn't mean I'm rude/unfriendly.

[3Di]

Nothing to add, thanks.

[paulvill76]

Just Great , there should be some software to Diagram DB Relationships right ?

So far explains very good and in detail all DB and PK .

[Lim531]

Thank AmigoJack.
Thanks to you, I was able to make a lot of changes.