Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| updateType | enum_FraudUpdateForJobs_updateType | 2147483647 | null |
|
|
This field determines if fraud update is done manually or automatically |
|||||
| jobId | uuid | 2147483647 | null |
|
|
Foreign Key to the Jobs Table |
|||||
| houstonUserId | uuid | 2147483647 | √ | null |
|
|
Foreign Key to the Users Table. If the value is null, that means the system auto update fraud report flag |
||||
| previousFraudReportFlag | enum_Jobs_fraudReportFlag | 2147483647 | √ | null |
|
|
Contains fraud report flag of a job before fraud update |
||||
| newFraudReportFlag | enum_Jobs_fraudReportFlag | 2147483647 | null |
|
|
Contains fraud report flag of a job after fraud update |
|||||
| remarks | text | 2147483647 | √ | null |
|
|
Contains the detail of fraud report for the reported job |
||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| automationTrigger | enum_AutomationTrigger_type | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FraudUpdateForJobs_pkey | Primary key | Asc | id |
| FraudUpdateForJobs_automationTrigger_idx | Performance | Asc | automationTrigger |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| FraudUpdateForJobs_updateType_houstonUserId_nullable_check | (((("updateType" = 'MANUAL'::"enum_FraudUpdateForJobs_updateType") AND ("houstonUserId" IS NOT NULL)) OR (("updateType" = 'AUTO'::"enum_FraudUpdateForJobs_updateType") AND ("houstonUserId" IS NULL)))) |
| FraudUpdateForJobs_fraudReportFlag_check | (("previousFraudReportFlag" <> "newFraudReportFlag")) |
Relationships
Close relationships within degrees of separation
