GroupPopularityMView

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

uuid

2147483647

√

null

totalPostCount

int8

19

√

null

totalUserCount

int8

19

√

null

latestPostCount

int8

19

√

null

groupCreatedAt

timestamptz

35,6

√

null

popularity

numeric

0

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH group_statics AS (
         SELECT groups.id,
            count(DISTINCT posts.id) AS "totalPostCount",
            count(DISTINCT group_users."UserId") AS "totalUserCount",
            count(DISTINCT posts.id) FILTER (WHERE (date_part('day'::text, (now() - posts."createdAt")) < (3)::double precision)) AS "latestPostCount",
            groups."createdAt" AS "groupCreatedAt"
           FROM ((gcud."Groups" groups
             LEFT JOIN gcud."Posts" posts ON ((posts."GroupId" = groups.id)))
             LEFT JOIN gcud."GroupUsers" group_users ON ((group_users."GroupId" = groups.id)))
          GROUP BY groups.id
        )
 SELECT group_statics.id,
    group_statics."totalPostCount",
    group_statics."totalUserCount",
    group_statics."latestPostCount",
    group_statics."groupCreatedAt",
    ((((group_statics."totalPostCount")::numeric * 0.3) + ((group_statics."totalUserCount")::numeric * 0.3)) + ((group_statics."latestPostCount")::numeric * 0.4)) AS popularity
   FROM group_statics;

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views