Skip to content

public.contacts_saved_jobs

Columns

Name Type Default Nullable Children Parents Comment
contact_id bigint false public.contacts
id bigint false
job_id bigint false public.jobs

Constraints

Name Type Definition
contacts_saved_jobs_contact_id_78053d31_fk_contacts_id FOREIGN KEY FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED
contacts_saved_jobs_contact_id_job_id_75f77aa7_uniq UNIQUE UNIQUE (contact_id, job_id)
contacts_saved_jobs_job_id_9a3e7562_fk_jobs_id FOREIGN KEY FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED
contacts_saved_jobs_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
contacts_saved_jobs_contact_id_78053d31 CREATE INDEX contacts_saved_jobs_contact_id_78053d31 ON public.contacts_saved_jobs USING btree (contact_id)
contacts_saved_jobs_contact_id_job_id_75f77aa7_uniq CREATE UNIQUE INDEX contacts_saved_jobs_contact_id_job_id_75f77aa7_uniq ON public.contacts_saved_jobs USING btree (contact_id, job_id)
contacts_saved_jobs_job_id_9a3e7562 CREATE INDEX contacts_saved_jobs_job_id_9a3e7562 ON public.contacts_saved_jobs USING btree (job_id)
contacts_saved_jobs_pkey CREATE UNIQUE INDEX contacts_saved_jobs_pkey ON public.contacts_saved_jobs USING btree (id)

Generated by tbls