Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| jobId | uuid | 2147483647 | null |
|
|
||||||
| actionUserId | uuid | 2147483647 | √ | null |
|
|
|||||
| previousStatus | enum_Jobs_status | 2147483647 | null |
|
|
||||||
| updatedStatus | enum_Jobs_status | 2147483647 | null |
|
|
||||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
||||||
| automationTrigger | enum_AutomationTrigger_type | 2147483647 | √ | null |
|
|
|||||
| closureInfo | jsonb | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| JobStatusLogs_pkey | Primary key | Asc | id |
| JobStatusLogs_automationTrigger_idx | Performance | Asc | automationTrigger |
| public_JobStatusLogs_jobId_idx | Performance | Asc | jobId |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| JobStatusLogs_closureInfo_valid | ((("closureInfo" IS NULL) OR (((jsonb_typeof("closureInfo") = 'object'::text) AND (("closureInfo" ->> 'triggerType'::text) = ANY (ARRAY['EMPLOYER_DEACTIVATION'::text, 'JOB_EXPIRY'::text])) AND (("closureInfo" ->> 'employerResponseStatus'::text) = ANY (ARRAY['PENDING'::text, 'DISMISSED'::text, 'SUBMITTED'::text])) AND (jsonb_typeof(("closureInfo" -> 'jobStatusLogId'::text)) = 'string'::text) AND (length(btrim(("closureInfo" ->> 'jobStatusLogId'::text))) > 0) AND ((("closureInfo" ->> 'employerResponseStatus'::text) <> 'SUBMITTED'::text) OR ((jsonb_typeof(("closureInfo" -> 'answers'::text)) = 'object'::text) AND (jsonb_typeof((("closureInfo" -> 'answers'::text) -> 'reason'::text)) = 'string'::text) AND (length(btrim((("closureInfo" -> 'answers'::text) ->> 'reason'::text))) > 0) AND (jsonb_typeof(("closureInfo" -> 'submittedAt'::text)) = 'string'::text) AND (length(btrim(("closureInfo" ->> 'submittedAt'::text))) > 0) AND (jsonb_typeof(("closureInfo" -> 'submittedByUserId'::text)) = 'string'::text) AND (length(btrim(("closureInfo" ->> 'submittedByUserId'::text))) > 0)))) IS TRUE))) NOT VALID |
Relationships
Close relationships within degrees of separation
