Skip to content

public.conversations

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone false
id bigint false public.conversations_participants public.messages
is_archived boolean false
job_id bigint false public.jobs
worker_id bigint true public.users

Constraints

Name Type Definition
conversations_job_id_a6b55b20_fk_jobs_id FOREIGN KEY FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED
conversations_pkey PRIMARY KEY PRIMARY KEY (id)
conversations_worker_id_f94ba5c9_fk_users_id FOREIGN KEY FOREIGN KEY (worker_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
conversatio_created_694913_idx CREATE INDEX conversatio_created_694913_idx ON public.conversations USING btree (created_at)
conversatio_is_arch_6a98e0_idx CREATE INDEX conversatio_is_arch_6a98e0_idx ON public.conversations USING btree (is_archived)
conversatio_job_id_73f49a_idx CREATE INDEX conversatio_job_id_73f49a_idx ON public.conversations USING btree (job_id)
conversations_job_id_a6b55b20 CREATE INDEX conversations_job_id_a6b55b20 ON public.conversations USING btree (job_id)
conversations_pkey CREATE UNIQUE INDEX conversations_pkey ON public.conversations USING btree (id)
conversations_worker_id_f94ba5c9 CREATE INDEX conversations_worker_id_f94ba5c9 ON public.conversations USING btree (worker_id)

Generated by tbls