ReachOut

1844 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"ReachOut_id_seq"'::regclass)
uuid uuid 2147483647 null
response json 2147483647 √ null
solvedBy int4 10 √ null
organizationId int4 10 √ null
Organization.id Implied Constraint R
completedOn timestamptz 35,6 √ null
status varchar 255 √ null
ticketNumber varchar 255 √ null
isDeleted bool 1 √ null
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
ticketAssignTo int4 10 √ null
remarks text 2147483647 √ null
category varchar 255 √ null
chatMessage json 2147483647 √ null
isAdminRead bool 1 √ true
isUserRead bool 1 √ true
ticketAssignToJson jsonb 2147483647 √ null
ticketAssignResponseTime jsonb 2147483647 √ null
ticketResovedTime timestamptz 35,6 √ null
ticketResovedLastTime timestamptz 35,6 √ null
adminFirstResponseTime timestamptz 35,6 √ null
ticketResovedTimeMin varchar 255 √ null
ticketAcknowledgeTimeMin varchar 255 √ null
ticketCloseMin varchar 255 √ null
ticketStatusChangeJson jsonb 2147483647 √ '[]'::jsonb
ticketAcknowledgedAt varchar 255 √ null
ticketEscalatedAt timestamptz 35,6 √ null
mergeTicketData jsonb 2147483647 √ '[]'::jsonb
isMergeTicket bool 1 √ false
programId int4 10 √ null
Program.id Implied Constraint R
accomplishmentId int4 10 √ null
Accomplishment.id Implied Constraint R
couserId int4 10 √ null
portfolioId int4 10 √ null
underReview varchar 255 √ null
gradeId int4 10 √ null
isParentTicket bool 1 √ false
assignmentGradeId int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
ReachOut_pkey Primary key Asc id
ReachOut_id_idx Performance Asc id
ReachOut_uuid_idx Performance Asc uuid

Relationships

Close relationships within degrees of separation