If you need phpBB3 ERD, take a look.

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Get Involved
Post Reply
Lim531
Registered User
Posts: 2
Joined: Mon May 22, 2017 11:37 am

If you need phpBB3 ERD, take a look.

Post by 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.

User avatar
AmigoJack
Registered User
Posts: 5715
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: If you need phpBB3 ERD, take a look.

Post by 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)


Lim531 wrote:
Tue May 23, 2017 3:07 am
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.
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

User avatar
javiexin
Code Contributor
Posts: 1157
Joined: Wed Oct 12, 2011 11:46 pm
Location: Madrid, Spain
Name: Javier
Contact:

Re: If you need phpBB3 ERD, take a look.

Post by 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.
Registered User
Posts: 489
Joined: Wed Nov 04, 2009 8:39 pm

Re: If you need phpBB3 ERD, take a look.

Post by .m. »

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

User avatar
3Di
Former Team Member
Posts: 15456
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: If you need phpBB3 ERD, take a look.

Post by 3Di »

AmigoJack wrote:
Tue May 23, 2017 3:16 pm
(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)
Lim531 wrote:
Tue May 23, 2017 3:07 am
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:
Lim531 wrote:
Tue May 23, 2017 3:07 am
If there is something wrong, please let me know.
By you reported as
AmigoJack wrote:
Tue May 23, 2017 3:16 pm
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.
javiexin wrote:
Thu May 25, 2017 9:54 am
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.
Lim531 wrote:
Tue May 23, 2017 3:07 am
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.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
:studio_microphone: Premium extensions @ The Studio

User avatar
AmigoJack
Registered User
Posts: 5715
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: If you need phpBB3 ERD, take a look.

Post by AmigoJack »

javiexin wrote:
Thu May 25, 2017 9:54 am
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.

3Di wrote:
Fri May 26, 2017 5:47 am
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.

3Di wrote:
Fri May 26, 2017 5:47 am
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.

3Di wrote:
Fri May 26, 2017 5:47 am
you reported as
AmigoJack wrote:
Tue May 23, 2017 3:16 pm
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".

3Di wrote:
Fri May 26, 2017 5:47 am
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.
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

User avatar
3Di
Former Team Member
Posts: 15456
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: If you need phpBB3 ERD, take a look.

Post by 3Di »

Nothing to add, thanks. :geek:
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
:studio_microphone: Premium extensions @ The Studio

User avatar
paulvill76
Registered User
Posts: 81
Joined: Tue Dec 06, 2011 2:51 am
Location: Brno , Czech Republic
Name: Pablo Villaronga
Contact:

Re: If you need phpBB3 ERD, take a look.

Post by 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
Registered User
Posts: 2
Joined: Mon May 22, 2017 11:37 am

Re: If you need phpBB3 ERD, take a look.

Post by Lim531 »

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

Post Reply

Return to “phpBB Discussion”