Database Properties
Database Type: PostgreSQL - 14.15 (Ubuntu 14.15-1.pgdg22.04+1)
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| DeletedPosts | 1 | 3 | 11 | Table | Deleted Posts table, a post copy with deleted reason when it is deleted by the group admin |
| ReportedUsers | 1 | 4 | 9 | Table | This table contains list of users who got reported by other users |
| TopicTabs | 1 | 0 | 5 | Table | |
| PostShares | 0 | 2 | 3 | Table | |
| Groups | 6 | 2 | 9 | Table | |
| BlacklistedLinks | 0 | 0 | 5 | Table | This table contains list of blacklisted links that will be used for content moderation |
| ContentScores | 0 | 3 | 7 | Table | This table is used to store the assigned score of each content based on the parameters. |
| BlackListedContents | 1 | 2 | 6 | Table | Monitored contents table, contains all the flagged contents which is reported by CMS moderation system or user. |
| Contents | 11 | 0 | 2 | Table | Contents table, a super table to be extended by all the content related tables. |
| BannerHashtags | 0 | 2 | 2 | Table | |
| MyGroupNewPostsNotifications | 1 | 1 | 5 | Table | Associated Notification table to store information about new posts in notification recipient’s groups within given time interval |
| Banners | 1 | 0 | 7 | Table | |
| CMSContentOverallScores | 0 | 1 | 5 | Table | This table is used to store the CMS overall score of each content. |
| GroupShares | 0 | 2 | 3 | Table | |
| BlackListedContentBlackListedWords | 0 | 2 | 2 | Table | |
| ReplyNotifications | 0 | 2 | 2 | Table | |
| Attachments | 0 | 3 | 7 | Table | Attachments table, a sub table extends Contents table to make attachment can be reacted to and replied to, a content record can has many attachments. An attachment cannot be attached to an attachment. |
| Bookmarks | 0 | 2 | 4 | Table | Bookmarks table, have many to one relationship with both Contents and Users tables. |
| MyGroupNewPostsNotificationTopGroups | 0 | 2 | 3 | Table | Stores top group ids for new my group posts notification, ranked by most recent posts when notfication was sent |
| ScoreMethods | 0 | 0 | 5 | Table | This table is used to store the global method setting of the scoring system. |
| DeletedPostNotifications | 0 | 2 | 2 | Table | |
| GroupTypes | 1 | 0 | 8 | Table | |
| Replies | 2 | 5 | 9 | Table | Replies table, ParentReplyId of a layer one reply is null. |
| Reactions | 1 | 2 | 6 | Table | Reactions table, have many to one relationship with both Contents and Users tables |
| GroupDeletionNotifications | 0 | 1 | 3 | Table | |
| Hashtags | 5 | 0 | 1 | Table | |
| Publishers | 0 | 2 | 5 | Table | Publisher table, contains all the users will be used as publisher of the contents. |
| BlockedUsers | 0 | 2 | 5 | Table | This table contains list of users who got blocked by other users. |
| ReportNotifications | 0 | 2 | 2 | Table | |
| GroupRenameNotifications | 0 | 2 | 2 | Table | |
| ParameterCategories | 1 | 1 | 6 | Table | This table is used to store all the categories and the parameter it belong to. |
| TopicTabHashtags | 0 | 2 | 2 | Table | |
| ScoreParameters | 2 | 0 | 10 | Table | This table is used to store all the score parameters and its setting in the system. |
| ReportUserReasons | 1 | 0 | 6 | Table | This table contains list of reasons for report a user |
| GroupUsers | 0 | 2 | 6 | Table | |
| ReactionNotifications | 0 | 2 | 2 | Table | |
| Posts | 1 | 3 | 9 | Table | Posts table, a sub table extends Contents table. |
| PostPopularityMView | 0 | 0 | 4 | View | Calculates popularity score of posts |
| VHashtagPopularity | 0 | 1 | 2 | View | |
| CMSContents | 0 | 0 | 10 | View | This view is to union the POST and REPLY tables. This is used for getting all posts and comments/replies in a single list for CMS moderation query. |
| HashtagPopularityMView | 0 | 1 | 2 | View | Calculates popularity score of hashtags |
| GroupPopularity | 0 | 0 | 6 | View | |
| HashtagPopularity | 0 | 1 | 2 | View | |
| PostPopularity | 0 | 0 | 4 | View | |
| GroupPopularityMView | 0 | 0 | 6 | View | Calculates popularity score of groups |
| UserGroupNewPostCountMView | 0 | 0 | 5 | View |