HoustonTransferCompanyTaskLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
companyId uuid 2147483647 null
Companies.id HoustonTransferCompanyTaskLogs_companyId_fkey C
oldEmployerServiceRepId uuid 2147483647 √ null
Users.id HoustonTransferCompanyTaskLogs_oldEmployerServiceRepId_fkey N
newEmployerServiceRepId uuid 2147483647 √ null
Users.id HoustonTransferCompanyTaskLogs_newEmployerServiceRepId_fkey N
houstonUserId uuid 2147483647 √ null
Users.id HoustonTransferCompanyTaskLogs_houstonUserId_fkey N
taskStatus enum_HoustonTransferCompanyTaskLogs_taskStatus 2147483647 null

The status of the transfer company task
errorMessage text 2147483647 √ null

The error message if the transfer company task has failed
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
jobsTransferred int4 10 √ null

The number of jobs transferred once the transfer company task is completed
transferredAt timestamptz 35,6 √ null
salesRepType enum_HoustonTransferCompany_salesRepType 2147483647 'EMPLOYER_SERVICE_REP'::"enum_HoustonTransferCompany_salesRepType"
source enum_HoustonTransferCompany_source 2147483647 'USER'::"enum_HoustonTransferCompany_source"

Indexes

Constraint Name Type Sort Column(s)
HoustonTransferCompanyTaskLogs_pkey Primary key Asc id
HoustonTransferCompanyTaskLogs_companyId_salesRepType_idx Must be unique Asc/Asc companyId + salesRepType

Check Constraints

Constraint Name Constraint
HoustonTransferCompanyTaskLogs_taskStatus_jobsTransferred_check ((("taskStatus" = 'SUCCESS'::"enum_HoustonTransferCompanyTaskLogs_taskStatus") OR ("jobsTransferred" IS NULL)))
HoustonTransferCompanyTaskLogs_taskStatus_errorMessage_check ((("taskStatus" = 'FAILURE'::"enum_HoustonTransferCompanyTaskLogs_taskStatus") OR ("errorMessage" IS NULL)))

Relationships

Close relationships within degrees of separation