ReportedCandidates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
reporterId uuid 2147483647 √ null
Users.id ReportedCandidates_reporterId_fkey N
reportedUserId uuid 2147483647 √ null
Users.id ReportedCandidates_reportedUserId_fkey N
companyId uuid 2147483647 √ null
Companies.id ReportedCandidates_companyId_fkey N
jobId uuid 2147483647 √ null
Jobs.id ReportedCandidates_jobId_fkey N
reason enum_ReportedCandidates_reason 2147483647 null
additionalInfo text 2147483647 null
attachments jsonb 2147483647 √ null

Attachments uploaded by the reporter as supporting evidence.
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
ReportedCandidates_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation