<bdo id='bmVwA'></bdo><ul id='bmVwA'></ul>
  • <legend id='bmVwA'><style id='bmVwA'><dir id='bmVwA'><q id='bmVwA'></q></dir></style></legend>

    <small id='bmVwA'></small><noframes id='bmVwA'>

      <i id='bmVwA'><tr id='bmVwA'><dt id='bmVwA'><q id='bmVwA'><span id='bmVwA'><b id='bmVwA'><form id='bmVwA'><ins id='bmVwA'></ins><ul id='bmVwA'></ul><sub id='bmVwA'></sub></form><legend id='bmVwA'></legend><bdo id='bmVwA'><pre id='bmVwA'><center id='bmVwA'></center></pre></bdo></b><th id='bmVwA'></th></span></q></dt></tr></i><div id='bmVwA'><tfoot id='bmVwA'></tfoot><dl id='bmVwA'><fieldset id='bmVwA'></fieldset></dl></div>

      1. <tfoot id='bmVwA'></tfoot>

        Facebook 点赞通知跟踪(DB 设计)

        时间:2023-06-02
          <i id='pPpVB'><tr id='pPpVB'><dt id='pPpVB'><q id='pPpVB'><span id='pPpVB'><b id='pPpVB'><form id='pPpVB'><ins id='pPpVB'></ins><ul id='pPpVB'></ul><sub id='pPpVB'></sub></form><legend id='pPpVB'></legend><bdo id='pPpVB'><pre id='pPpVB'><center id='pPpVB'></center></pre></bdo></b><th id='pPpVB'></th></span></q></dt></tr></i><div id='pPpVB'><tfoot id='pPpVB'></tfoot><dl id='pPpVB'><fieldset id='pPpVB'></fieldset></dl></div>
                <tbody id='pPpVB'></tbody>

              <small id='pPpVB'></small><noframes id='pPpVB'>

            1. <tfoot id='pPpVB'></tfoot>
                • <bdo id='pPpVB'></bdo><ul id='pPpVB'></ul>
                • <legend id='pPpVB'><style id='pPpVB'><dir id='pPpVB'><q id='pPpVB'></q></dir></style></legend>

                  本文介绍了Facebook 点赞通知跟踪(DB 设计)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我只是想弄清楚 Facebook 的数据库是如何构建用于跟踪通知的.

                  I am just trying to figure out how Facebook's database is structured for tracking notifications.

                  我不会像 Facebook 那样深入研究复杂性.如果我们想象一个简单的通知表结构:

                  I won't go much into complexity like Facebook is. If we imagine a simple table structure for notificaitons:

                  通知(id、userid、update、time);

                  我们可以通过以下方式获取朋友的通知:

                  We can get the notifications of friends using:

                  SELECT `userid`, `update`, `time`
                  FROM `notifications`
                  WHERE `userid` IN 
                  (... query for getting friends...)
                  

                  但是,检查哪些通知已被读取,哪些尚未读取的表结构应该是什么?

                  However, what should be the table structure to check out which notifications have been read and which haven't?

                  推荐答案

                  我不知道这是否是最好的方法,但由于我没有从其他人那里得到任何想法,这就是我要做的.我希望这个答案也能帮助其他人.

                  I dont know if this is the best way to do this, but since I got no ideas from anyone else, this is what I would be doing. I hope this answer might help others as well.

                  我们有两张桌子

                  notification
                  -----------------
                  id (pk)
                  userid
                  notification_type (for complexity like notifications for pictures, videos, apps etc.)
                  notification
                  time
                  
                  
                  notificationsRead
                  --------------------
                  id (pk) (i dont think this field is required, anyways)
                  lasttime_read
                  userid
                  

                  想法是从通知表中选择通知并加入通知读取表并检查最后读取的通知和ID>通知ID的行.并且每次打开通知页面时都会更新通知读取表中的行.

                  The idea is to select notifications from notifications table and join the notificationsRead table and check the last read notification and rows with ID > notificationid. And each time the notifications page is opened update the row from notificationsRead table.

                  未读通知的查询我猜应该是这样的..

                  The query for unread notifications I guess would be like this..

                  SELECT `userid`, `notification`, `time` from `notifications` `notificationsRead`
                  WHERE 
                  `notifications`.`userid` IN ( ... query to get a list of friends ...) 
                  AND 
                  (`notifications`.`time` > (
                      SELECT `notificationsRead`.`lasttime_read` FROM `notificationsRead` 
                      WHERE `notificationsRead`.`userid` = ...$userid...
                  ))
                  

                  上面的查询没有被检查.感谢@espais 的数据库设计理念

                  The query above is not checked. Thanks to the idea of db design from @espais

                  这篇关于Facebook 点赞通知跟踪(DB 设计)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:通过 SSH 隧道的 MySQL 连接 - 如何指定其他 MySQL 服务器? 下一篇:将 Amazon RDS 中的表导出为 CSV 文件

                  相关文章

                  <i id='N4bJx'><tr id='N4bJx'><dt id='N4bJx'><q id='N4bJx'><span id='N4bJx'><b id='N4bJx'><form id='N4bJx'><ins id='N4bJx'></ins><ul id='N4bJx'></ul><sub id='N4bJx'></sub></form><legend id='N4bJx'></legend><bdo id='N4bJx'><pre id='N4bJx'><center id='N4bJx'></center></pre></bdo></b><th id='N4bJx'></th></span></q></dt></tr></i><div id='N4bJx'><tfoot id='N4bJx'></tfoot><dl id='N4bJx'><fieldset id='N4bJx'></fieldset></dl></div>

                      <tfoot id='N4bJx'></tfoot>

                      <small id='N4bJx'></small><noframes id='N4bJx'>

                        <bdo id='N4bJx'></bdo><ul id='N4bJx'></ul>
                      <legend id='N4bJx'><style id='N4bJx'><dir id='N4bJx'><q id='N4bJx'></q></dir></style></legend>