public.offers¶

Columns¶

Name	Type	Nullable	Children	Parents
accepted_at	timestamp with time zone	true
created_at	timestamp with time zone	false
end_date	date	true
expiration_days	integer	false
expires_at	timestamp with time zone	true
id	bigint	false	public.offer_daily_schedules public.placements
is_read	boolean	false
job_application_id	bigint	false		public.job_applications
message	text	false
rejected_at	timestamp with time zone	true
rejection_reason	varchar(255)	false
rejection_reason_description	varchar(200)	false
salesforce_ref	varchar(255)	false
start_date	date	false
status	varchar(255)	false
updated_at	timestamp with time zone	false
withdrawal_reason	varchar(1500)	false
withdrawn_at	timestamp with time zone	true
withdrawn_by_id	bigint	true		public.users

Name	Type	Definition
offers_expiration_days_check	CHECK	CHECK ((expiration_days >= 0))
offers_job_application_id_0969d438_fk_job_applications_id	FOREIGN KEY	FOREIGN KEY (job_application_id) REFERENCES job_applications(id) DEFERRABLE INITIALLY DEFERRED
offers_pkey	PRIMARY KEY	PRIMARY KEY (id)
offers_withdrawn_by_id_be24f8d2_fk_users_id	FOREIGN KEY	FOREIGN KEY (withdrawn_by_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
unique_job_application_offer	UNIQUE	UNIQUE (job_application_id)

Name	Definition
offers_pkey	CREATE UNIQUE INDEX offers_pkey ON public.offers USING btree (id)
offers_salesfo_583d27_idx	CREATE INDEX offers_salesfo_583d27_idx ON public.offers USING btree (salesforce_ref)
offers_withdrawn_by_id_be24f8d2	CREATE INDEX offers_withdrawn_by_id_be24f8d2 ON public.offers USING btree (withdrawn_by_id)
unique_job_application_offer	CREATE UNIQUE INDEX unique_job_application_offer ON public.offers USING btree (job_application_id)

Generated by tbls