FraudCaseFiles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
FraudCaseFileLogs.FraudCaseFileId FraudCaseFileLogs_FraudCaseFileId_fkey C
InterceptedFraudMessages.fraudCaseFileId InterceptedFraudMessages_fraudCaseFileId_fkey R
CompanyId uuid 2147483647 null
Companies.id FraudCaseFiles_CompanyId_fkey C
status enum_FraudCaseFiles_status 2147483647 null
statusReason enum_FraudCaseFiles_statusReason 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
reportedSource enum_FraudCaseFiles_reportedSource 2147483647 'USER'::"enum_FraudCaseFiles_reportedSource"

Indexes

Constraint Name Type Sort Column(s)
FraudCaseFiles_pkey Primary key Asc id
FraudCaseFiles_CompanyId_idx Performance Asc CompanyId
FraudCaseFiles_CompanyId_unique Must be unique Asc CompanyId

Check Constraints

Constraint Name Constraint
FraudCaseFiles_status_valid ((((status = 'PENDING'::"enum_FraudCaseFiles_status") AND ("statusReason" = ANY (ARRAY['FURTHER_INVESTIGATION_REQUIRED'::"enum_FraudCaseFiles_statusReason", 'WAITING_FOR_FOLLOW_UP_RESULT'::"enum_FraudCaseFiles_statusReason", 'WAITING_FOR_QUANTITATIVE_EVIDENCE'::"enum_FraudCaseFiles_statusReason", 'REOPENED'::"enum_FraudCaseFiles_statusReason"]))) OR ((status = 'RESOLVED'::"enum_FraudCaseFiles_status") AND ("statusReason" = ANY (ARRAY['CONFIRMED_FRAUD'::"enum_FraudCaseFiles_statusReason", 'DIRECT_TO_QUALITY'::"enum_FraudCaseFiles_statusReason", 'COMPANY_ALREADY_BLOCKED'::"enum_FraudCaseFiles_statusReason", 'CONFIRMED_NOT_FRAUD'::"enum_FraudCaseFiles_statusReason"]))) OR ((status = 'IGNORED'::"enum_FraudCaseFiles_status") AND ("statusReason" IS NULL))))

Relationships

Close relationships within degrees of separation