Skip to content

public.conversations_participants

Columns

Name Type Default Nullable Children Parents Comment
conversation_id bigint false public.conversations
id bigint false
user_id bigint false public.users

Constraints

Name Type Definition
conversations_partic_conversation_id_988acf55_fk_conversat FOREIGN KEY FOREIGN KEY (conversation_id) REFERENCES conversations(id) DEFERRABLE INITIALLY DEFERRED
conversations_participan_conversation_id_user_id_7f9cba6f_uniq UNIQUE UNIQUE (conversation_id, user_id)
conversations_participants_pkey PRIMARY KEY PRIMARY KEY (id)
conversations_participants_user_id_968b244f_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
conversations_participan_conversation_id_user_id_7f9cba6f_uniq CREATE UNIQUE INDEX conversations_participan_conversation_id_user_id_7f9cba6f_uniq ON public.conversations_participants USING btree (conversation_id, user_id)
conversations_participants_conversation_id_988acf55 CREATE INDEX conversations_participants_conversation_id_988acf55 ON public.conversations_participants USING btree (conversation_id)
conversations_participants_pkey CREATE UNIQUE INDEX conversations_participants_pkey ON public.conversations_participants USING btree (id)
conversations_participants_user_id_968b244f CREATE INDEX conversations_participants_user_id_968b244f ON public.conversations_participants USING btree (user_id)

Generated by tbls