Skip to content

public.manager_conversations_participants

Columns

Name Type Default Nullable Children Parents Comment
id bigint false
managerconversation_id bigint false public.manager_conversations
user_id bigint false public.users

Constraints

Name Type Definition
manager_conversation_managerconversation__8f9f76e7_fk_manager_c FOREIGN KEY FOREIGN KEY (managerconversation_id) REFERENCES manager_conversations(id) DEFERRABLE INITIALLY DEFERRED
manager_conversations_pa_managerconversation_id_u_2b6563e6_uniq UNIQUE UNIQUE (managerconversation_id, user_id)
manager_conversations_participants_pkey PRIMARY KEY PRIMARY KEY (id)
manager_conversations_participants_user_id_65bb4550_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
manager_conversations_pa_managerconversation_id_u_2b6563e6_uniq CREATE UNIQUE INDEX manager_conversations_pa_managerconversation_id_u_2b6563e6_uniq ON public.manager_conversations_participants USING btree (managerconversation_id, user_id)
manager_conversations_part_managerconversation_id_8f9f76e7 CREATE INDEX manager_conversations_part_managerconversation_id_8f9f76e7 ON public.manager_conversations_participants USING btree (managerconversation_id)
manager_conversations_participants_pkey CREATE UNIQUE INDEX manager_conversations_participants_pkey ON public.manager_conversations_participants USING btree (id)
manager_conversations_participants_user_id_65bb4550 CREATE INDEX manager_conversations_participants_user_id_65bb4550 ON public.manager_conversations_participants USING btree (user_id)

Generated by tbls