ReportedJobs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
HoustonReportedJobActionLogs.reportedJobId HoustonReportedJobActionLogs_reportedJobId_fkey C
JobFraudAnalysisRecords.reportedJobEndId JobFraudAnalysisRecords_reportedJobEndId_fkey C
JobFraudAnalysisRecords.reportedJobStartId JobFraudAnalysisRecords_reportedJobStartId_fkey C
createdAt timestamptz 35,6 now()
JobId uuid 2147483647 null
Jobs.id ReportedJobs_JobId_fkey C

Foreign Key to the Jobs Table
UserId uuid 2147483647 √ null
Users.id ReportedJobs_UserId_fkey N

Foreign Key to the Users Table
reason enum_ReportedJobs_reason 2147483647 null

The reason for which the job was reported
reportDetails varchar 500 √ null

Additional details about the reason for which the job was reported
attachments jsonb 2147483647 √ null

The media attachments related for proof of job being a scam, fraud or inappropriate
resolutionStatus enum_ReportResolutionStatus 2147483647 'PENDING'::"enum_ReportResolutionStatus"
resolutionReason enum_ReportResolutionReason 2147483647 √ null
ResolverId uuid 2147483647 √ null
Users.id ReportedJobs_ResolverId_fkey N
issueCategories jsonb 2147483647 '[]'::jsonb

Internal Operations Issue Categories selected after reviewing a candidate job report

Indexes

Constraint Name Type Sort Column(s)
ReportedJobs_pkey Primary key Asc id
ReportedJobs_createdAt_idx Performance Asc createdAt
ReportedJobs_JobId_idx Performance Asc JobId
ReportedJobs_reason_idx Performance Asc reason
ReportedJobs_UserId_JobId_reason_idx Performance Asc/Asc/Asc UserId + JobId + reason

Check Constraints

Constraint Name Constraint
ReportedJobs_resolution_reason_if_invalid (((("resolutionStatus" = 'INVALID'::"enum_ReportResolutionStatus") AND ("resolutionReason" IS NOT NULL)) OR (("resolutionStatus" = ANY (ARRAY['PENDING'::"enum_ReportResolutionStatus", 'VALID'::"enum_ReportResolutionStatus"])) AND ("resolutionReason" IS NULL))))
ReportedJobs_issueCategories_is_array_check ((jsonb_typeof("issueCategories") = 'array'::text))

Relationships

Close relationships within degrees of separation