InterceptedFraudMessages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
fraudCaseFileId uuid 2147483647 √ null
FraudCaseFiles.id InterceptedFraudMessages_fraudCaseFileId_fkey R
jobId uuid 2147483647 √ null
Jobs.id InterceptedFraudMessages_jobId_fkey N
channelId uuid 2147483647 √ null
ChatAutoInvitations.channelId Implied Constraint R
senderId uuid 2147483647 √ null
Users.id InterceptedFraudMessages_senderId_fkey N
externalMessageId varchar 255 null
content text 2147483647 √ null
detectedSensitiveWords text 2147483647 √ null
eventTime timestamptz 35,6 null
eventCategory varchar 255 √ null
eventType varchar 255 √ null
messageType varchar 255 √ null
contentType varchar 255 √ null
deviceId varchar 255 √ null
platform varchar 255 √ null
userIp text 2147483647 √ null
coordinate varchar 255 √ null
resolutionStatus enum_ReportResolutionStatus 2147483647 'PENDING'::"enum_ReportResolutionStatus"
ResolverId uuid 2147483647 √ null
Users.id InterceptedFraudMessages_ResolverId_fkey N
createdAt timestamptz 35,6 CURRENT_TIMESTAMP
updatedAt timestamptz 35,6 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
InterceptedFraudMessages_pkey Primary key Asc id
intercepted_fraud_messages__resolver_id Performance Asc ResolverId
intercepted_fraud_messages_event_category Performance Asc eventCategory
intercepted_fraud_messages_event_time Performance Asc eventTime
intercepted_fraud_messages_event_type Performance Asc eventType
intercepted_fraud_messages_fraud_case_file_id Performance Asc fraudCaseFileId
intercepted_fraud_messages_job_id Performance Asc jobId
intercepted_fraud_messages_sender_id Performance Asc senderId
InterceptedFraudMessages_externalMessageId_key Must be unique Asc externalMessageId
unique_message_per_context Must be unique Asc/Asc/Asc/Asc jobId + channelId + senderId + externalMessageId

Relationships

Close relationships within degrees of separation