Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| blockingRole | enum_ChatBlockingList_blockingRole | 2147483647 | null |
|
|
What the row blocks: CANDIDATE (employer blocks candidate), COMPANY or JOB (candidate blocks company/job). |
|||||
| companyId | uuid | 2147483647 | null |
|
|
||||||
| candidateId | uuid | 2147483647 | null |
|
|
||||||
| employerId | uuid | 2147483647 | √ | null |
|
|
The specific employer (Users.id) who performed the block, when applicable. Null for candidate-initiated blocks. |
||||
| jobId | uuid | 2147483647 | √ | null |
|
|
|||||
| chatChannelId | uuid | 2147483647 | √ | null |
|
|
Equals the applicationId of the chat channel. The channel itself lives in Redis/Mongo, so this is a loose reference (no FK). |
||||
| reason | enum_ChatBlockingList_reason | 2147483647 | √ | null |
|
|
Union of the ReportedCandidates reason vocabulary (employer blocks candidate) and EReportJobReason (candidate blocks company/job). Optional. |
||||
| reportDetail | jsonb | 2147483647 | √ | null |
|
|
Optional report payload: { description, evidenceFiles: … }. |
||||
| isDeleteChannel | bool | 1 | false |
|
|
Whether the chat channel and its messages were deleted at block time. |
|||||
| status | enum_ChatBlockingList_status | 2147483647 | 'BLOCKED'::"enum_ChatBlockingList_status" |
|
|
||||||
| verified | enum_ChatBlockingList_verified | 2147483647 | 'UNVERIFIED'::"enum_ChatBlockingList_verified" |
|
|
||||||
| verifiedDetail | jsonb | 2147483647 | √ | null |
|
|
|||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
||||||
| deviceId | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ChatBlockingList_pkey | Primary key | Asc | id |
| ChatBlockingList_candidateId_idx | Performance | Asc | candidateId |
| ChatBlockingList_chatChannelId_idx | Performance | Asc | chatChannelId |
| ChatBlockingList_companyId_deviceId_status_idx | Performance | Asc/Asc/Asc | companyId + deviceId + status |
| ChatBlockingList_companyId_idx | Performance | Asc | companyId |
Relationships
Close relationships within degrees of separation
