Skip to content

public.job_shift_schedules

Columns

Name Type Default Nullable Children Parents Comment
end_time time without time zone false
id bigint false
job_id bigint false public.jobs
start_time time without time zone false

Constraints

Name Type Definition
job_shift_schedules_job_id_623e1b17_fk_jobs_id FOREIGN KEY FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED
job_shift_schedules_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
job_shift_s_end_tim_e00545_idx CREATE INDEX job_shift_s_end_tim_e00545_idx ON public.job_shift_schedules USING btree (end_time)
job_shift_s_job_id_e7f7e1_idx CREATE INDEX job_shift_s_job_id_e7f7e1_idx ON public.job_shift_schedules USING btree (job_id)
job_shift_s_start_t_348098_idx CREATE INDEX job_shift_s_start_t_348098_idx ON public.job_shift_schedules USING btree (start_time)
job_shift_schedules_job_id_623e1b17 CREATE INDEX job_shift_schedules_job_id_623e1b17 ON public.job_shift_schedules USING btree (job_id)
job_shift_schedules_pkey CREATE UNIQUE INDEX job_shift_schedules_pkey ON public.job_shift_schedules USING btree (id)

Generated by tbls