Skip to content

public.jobs

Columns

Name Type Default Nullable Children Parents Comment
archived_at timestamp with time zone true
company_id bigint true public.companies
contact_person_id bigint true public.contacts
created_at timestamp with time zone false
created_by_id bigint true public.users
description text false
end_date date true
first_day_instructions text false
has_flexible_start_date boolean false
has_no_end_date boolean false
hourly_rate numeric(10,2) true
hours_per_week numeric(10,2) true
id bigint false public.contacts_saved_jobs public.conversations public.job_applications public.job_fixed_schedules public.job_media_files public.job_shift_schedules public.job_skills public.placements public.worker_job_distances
job_id varchar(255) false
location_id bigint true public.job_locations
number_of_shifts integer true
position_id bigint true public.job_positions
published_at timestamp with time zone true
requested_quantity integer true
required_position_id bigint true public.preferred_positions
salesforce_ref varchar(18) false
schedule varchar(20) false
start_date date true
status varchar(20) false
updated_at timestamp with time zone false
working_days varchar(10)[] true

Constraints

Name Type Definition
jobs_company_id_ded082d2_fk_companies_id FOREIGN KEY FOREIGN KEY (company_id) REFERENCES companies(id) DEFERRABLE INITIALLY DEFERRED
jobs_contact_person_id_34fed4bc_fk_contacts_id FOREIGN KEY FOREIGN KEY (contact_person_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED
jobs_created_by_id_5f1a45f0_fk_users_id FOREIGN KEY FOREIGN KEY (created_by_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
jobs_location_id_eca98fc1_fk_job_locations_id FOREIGN KEY FOREIGN KEY (location_id) REFERENCES job_locations(id) DEFERRABLE INITIALLY DEFERRED
jobs_number_of_shifts_check CHECK CHECK ((number_of_shifts >= 0))
jobs_pkey PRIMARY KEY PRIMARY KEY (id)
jobs_position_id_a3eda344_fk_job_positions_id FOREIGN KEY FOREIGN KEY (position_id) REFERENCES job_positions(id) DEFERRABLE INITIALLY DEFERRED
jobs_requested_quantity_check CHECK CHECK ((requested_quantity >= 0))
jobs_required_position_id_f519a413_fk_preferred_positions_id FOREIGN KEY FOREIGN KEY (required_position_id) REFERENCES preferred_positions(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
jobs_company_9d0fb7_idx CREATE INDEX jobs_company_9d0fb7_idx ON public.jobs USING btree (company_id)
jobs_company_id_ded082d2 CREATE INDEX jobs_company_id_ded082d2 ON public.jobs USING btree (company_id)
jobs_contact_person_id_34fed4bc CREATE INDEX jobs_contact_person_id_34fed4bc ON public.jobs USING btree (contact_person_id)
jobs_created_by_id_5f1a45f0 CREATE INDEX jobs_created_by_id_5f1a45f0 ON public.jobs USING btree (created_by_id)
jobs_job_id_824140_idx CREATE INDEX jobs_job_id_824140_idx ON public.jobs USING btree (job_id)
jobs_locatio_7e8b44_idx CREATE INDEX jobs_locatio_7e8b44_idx ON public.jobs USING btree (location_id)
jobs_location_id_eca98fc1 CREATE INDEX jobs_location_id_eca98fc1 ON public.jobs USING btree (location_id)
jobs_pkey CREATE UNIQUE INDEX jobs_pkey ON public.jobs USING btree (id)
jobs_positio_375173_idx CREATE INDEX jobs_positio_375173_idx ON public.jobs USING btree (position_id)
jobs_position_id_a3eda344 CREATE INDEX jobs_position_id_a3eda344 ON public.jobs USING btree (position_id)
jobs_required_position_id_f519a413 CREATE INDEX jobs_required_position_id_f519a413 ON public.jobs USING btree (required_position_id)
jobs_salesfo_1a4390_idx CREATE INDEX jobs_salesfo_1a4390_idx ON public.jobs USING btree (salesforce_ref)

Generated by tbls