Skip to content

public.job_applications

Columns

Name Type Default Nullable Children Parents Comment
contact_id bigint false public.contacts
declined_at timestamp with time zone true
declined_by_id bigint true public.users
declined_reason text false
id bigint false public.offers
is_read boolean false
job_id bigint false public.jobs
motivation text false
salesforce_ref varchar(255) false
status varchar(255) false
submitted_at timestamp with time zone false

Constraints

Name Type Definition
job_applications_contact_id_51f9f6f7_fk_contacts_id FOREIGN KEY FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED
job_applications_declined_by_id_94c2b4ef_fk_users_id FOREIGN KEY FOREIGN KEY (declined_by_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
job_applications_job_id_5c9703b7_fk_jobs_id FOREIGN KEY FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED
job_applications_pkey PRIMARY KEY PRIMARY KEY (id)
unique_job_application UNIQUE UNIQUE (job_id, contact_id)

Indexes

Name Definition
job_applica_salesfo_5aac07_idx CREATE INDEX job_applica_salesfo_5aac07_idx ON public.job_applications USING btree (salesforce_ref)
job_applications_contact_id_51f9f6f7 CREATE INDEX job_applications_contact_id_51f9f6f7 ON public.job_applications USING btree (contact_id)
job_applications_declined_by_id_94c2b4ef CREATE INDEX job_applications_declined_by_id_94c2b4ef ON public.job_applications USING btree (declined_by_id)
job_applications_job_id_5c9703b7 CREATE INDEX job_applications_job_id_5c9703b7 ON public.job_applications USING btree (job_id)
job_applications_pkey CREATE UNIQUE INDEX job_applications_pkey ON public.job_applications USING btree (id)
unique_job_application CREATE UNIQUE INDEX unique_job_application ON public.job_applications USING btree (job_id, contact_id)

Generated by tbls