|The phpBB Doctor is currently available for private clients only. At this time we are not accepting any new work until we can clear out our current backlog. Thank you for your patience.|
|Tables Table Structure||
Flag table to allow users to subscribe to a topic. When further posts are made, the user is notified.
||Foreign key to the phpbb_topics table, contains the topic_id of the topic being watched by the user.
||Foreign key to the phpbb_users table, contains the user_id for the user watching this topic.
||Bit field denoting (for watched topics) whether a user needs to be notified or not. If the user has been notified it is 0. If the user needs to be notified it is a 1. It would make sense if it were named need_to_notify instead.
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)] [Glossary Entry]
Graphical Database Diagram (Future Feature)
|Topic Watched by User
||phpbb_topics.topic_id = phpbb_topics_watch.topic_id
|User Watching Topic
||phpbb_users.user_id = phpbb_topics_watch.user_id