Table "team.gallery_session_view"

ColumnTypeNullableDefaultStorageDescription
"viewId"bigintnot nullnextval('"UserEngagementTracking_userEngagementId_seq"'::regclass)plain
"projectId"integernot nullplain
"userId"integernot nullplain
"typeId"integerplain
"identityId"character varying(255)extended
"details"jsonbextended
"viewedAt"timestamp with time zoneCURRENT_TIMESTAMPplain
"sessionId"character varying(37)extended

Indexes:

"UserEngagementTracking_pkey" PRIMARY KEY, btree ("viewId")
"IDX__GallerySessionView--projectId-sessionId-viewedAt" btree ("projectId", "sessionId", "viewedAt")
"userengagementtracking_projectid_occuredat_userid_typeid_index" btree ("projectId", "viewedAt", "userId", "typeId")
"userengagementtracking_userid_projectid_occuredat_typeid_index" btree ("userId", "projectId", "viewedAt", "typeId")

Access method:

heap
Last updated on by John Gracey