JobBoostingTasks


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
JobId uuid 2147483647 null
Jobs.id JobBoostingTasks_JobId_fkey C
CompanyId uuid 2147483647 null
Companies.id JobBoostingTasks_CompanyId_fkey C
addMore jsonb 2147483647 √ null
filters jsonb 2147483647 √ null
boostType enum_JobBoostingTasks_boostType 2147483647 null
boostInfo jsonb 2147483647 √ null
targetCount int4 10 √ null
achievedCount int4 10 √ 0
startTime timestamptz 35,6 √ null
endTime timestamptz 35,6 √ null
status enum_JobBoostingTasks_status 2147483647 'NEW'::"enum_JobBoostingTasks_status"
source enum_JobBoostingTasks_source 2147483647 null
metadata jsonb 2147483647 √ null
UserId uuid 2147483647 null
Users.id JobBoostingTasks_UserId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
JobBoostingTasks_pkey Primary key Asc id
JobBoostingTasks_boostType_idx Performance Asc boostType
JobBoostingTasks_CompanyId_idx Performance Asc CompanyId
JobBoostingTasks_JobId_idx Performance Asc JobId
JobBoostingTasks_status_idx Performance Asc status
JobBoostingTasks_UserId_idx Performance Asc UserId

Relationships

Close relationships within degrees of separation