Home

Your premium source for custom modification services for phpBB

   logo

HomeForumsBlogMOD ManagerFAQSearch Log in

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
phpbb_topics_watch
Flag table to allow users to subscribe to a topic. When further posts are made, the user is notified.
Column Name Datatype Default Column Description
topic_id mediumint(8) unsigned
 0 Foreign key to the phpbb_topics table, contains the topic_id of the topic being watched by the user.
user_id mediumint(8)
 0 Foreign key to the phpbb_users table, contains the user_id for the user watching this topic.
notify_status tinyint(1)
 0 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.

Table relationships
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
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)] [Glossary Entry]

Glossary | Graphical Database Diagram (Future Feature)


HomeForumsMOD ManagerFAQSearch Register Log in
Not endorsed by or affiliated with the phpBB Group
Powered by phpBB © phpBB Group 		Terms of Service
Web design by MomentsOfLight.com logo