Table "team.social_share"

ColumnTypeNullableDefaultStorageDescription
"shareId"bigintnot nullnextval('"SocialShare_shareId_seq"'::regclass)plain
"projectId"integernot nullplain
"userId"integerplain
"type"integernot nullplain
"title"character varying(128)extended
"description"character varying(1024)extended
"emoji"integerplain
"tags"text[]extended
"wallIds"bigint[]extended
"sessionId"character varying(37)not nullextended
"sessionStart"timestamp with time zonenot nullplain
"sessionEnd"timestamp with time zoneplain
"createdAt"timestamp with time zonenow()plain
"updatedAt"timestamp with time zonenow()plain
"identityId"character varying(80)extended
"public"booleanplain
"resolved"booleanplain
"reviewLevel"integerplain
"priority"integerplain
"secret"character varying(256)extended
"mediaUpdatedAt"timestamp with time zoneplain
"assignedUserIds"bigint[]extended
"requestUpdate"timestamp with time zoneplain
"anonymousId"character varying(37)extended
"apologizedAt"timestamp with time zoneplain
"apologizedByUserId"integerplain
"apologyMsg"character varying(2000)extended

Indexes:

"SocialShare_pkey" PRIMARY KEY, btree ("shareId")
"SocialShare--projectId-identityId-sessionId-createdAt" btree ("projectId", "identityId", "sessionId", "createdAt")
"SocialShare--secret-projectId-public-shareId-sessionAt" btree (secret, "projectId", public, "shareId", "sessionId")
"socialshare_projectid_apologizedat_apologizedbyuserid_index" btree ("projectId", "apologizedAt", "apologizedByUserId")
"socialshare_projectid_apologizedbyuserid_apologizedat_index" btree ("projectId", "apologizedByUserId", "apologizedAt")
"socialshare_projectid_index" btree ("projectId")
"socialshare_userid_index" btree ("userId")
Foreign-key constraints:
"FK_SocialShare_userId" FOREIGN KEY ("userId") REFERENCES "user"("userId") ON UPDATE CASCADE ON DELETE CASCADE
Referenced by:
TABLE "social_share_comment" CONSTRAINT "FK_SocialShareComment_shareId" FOREIGN KEY ("shareId") REFERENCES social_share("shareId") ON UPDATE CASCADE ON DELETE CASCADE
TABLE "social_share_like" CONSTRAINT "FK_SocialShareComment_shareId" FOREIGN KEY ("shareId") REFERENCES social_share("shareId") ON UPDATE CASCADE ON DELETE CASCADE

Policies:

POLICY "SocialShare__rls_1_policy"
USING (("projectId" = get_user_accessible_project_id()))

Access method:

heap
Last updated on by John Gracey