Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| myGroupNewPostsNotificationId | uuid | 2147483647 | null |
|
|
||||||
| groupId | uuid | 2147483647 | null |
|
|
id for group with most recent posts when new my group posts notification was sent |
|||||
| rank | int4 | 10 | null |
|
|
Store ordering of groups. Group with most recent post when notification was sent get better rank |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| MyGroupNewPostsNotificationTopGroups_pkey | Primary key | Asc/Asc | myGroupNewPostsNotificationId + groupId |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| MyGroupNewPostsNotificationTopGroups_rank_check | (((rank >= 1) AND (rank <= 3))) |
Relationships
Close relationships within degrees of separation
