UserFeedbacks


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
UserId uuid 2147483647 √ null
Users.id UserFeedbacks_UserId_fkey N
loginRole enum_Users_role 2147483647 √ null
CompanyId uuid 2147483647 √ null
Companies.id UserFeedbacks_CompanyId_fkey N
email text 2147483647 null
type enum_UserFeedbacks_type 2147483647 null
title text 2147483647 √ null
description text 2147483647 null
attachments jsonb 2147483647 '[]'::jsonb
userIP text 2147483647 null
envInfo jsonb 2147483647 null
header jsonb 2147483647 null
userData jsonb 2147483647 √ null
extInfo jsonb 2147483647 √ null
status enum_UserFeedbacks_status 2147483647 'NEW'::"enum_UserFeedbacks_status"
ChannelId uuid 2147483647 √ null
ChatAutoInvitations.channelId Implied Constraint R
processedInfo jsonb 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
UserFeedbacks_pkey Primary key Asc id
UserFeedbacks_CompanyId_idx Performance Asc CompanyId
UserFeedbacks_createdAt_idx Performance Asc createdAt
UserFeedbacks_status_idx Performance Asc status
UserFeedbacks_type_idx Performance Asc type
UserFeedbacks_UserId_idx Performance Asc UserId
UserFeedbacks_zendeskTicketId_idx Performance

Relationships

Close relationships within degrees of separation