Skip to content

public.manager_messages

Columns

Name Type Default Nullable Children Parents Comment
content text false
conversation_id bigint false public.manager_conversations
id bigint false public.manager_messages_read_by
media varchar(100) true
sender_id bigint false public.users
sent_at timestamp with time zone false

Constraints

Name Type Definition
manager_messages_conversation_id_0b28b175_fk_manager_c FOREIGN KEY FOREIGN KEY (conversation_id) REFERENCES manager_conversations(id) DEFERRABLE INITIALLY DEFERRED
manager_messages_pkey PRIMARY KEY PRIMARY KEY (id)
manager_messages_sender_id_62437b21_fk_users_id FOREIGN KEY FOREIGN KEY (sender_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
manager_mes_convers_ddbbaa_idx CREATE INDEX manager_mes_convers_ddbbaa_idx ON public.manager_messages USING btree (conversation_id)
manager_mes_sender__cb4c4c_idx CREATE INDEX manager_mes_sender__cb4c4c_idx ON public.manager_messages USING btree (sender_id)
manager_mes_sent_at_5e3bd4_idx CREATE INDEX manager_mes_sent_at_5e3bd4_idx ON public.manager_messages USING btree (sent_at)
manager_messages_conversation_id_0b28b175 CREATE INDEX manager_messages_conversation_id_0b28b175 ON public.manager_messages USING btree (conversation_id)
manager_messages_pkey CREATE UNIQUE INDEX manager_messages_pkey ON public.manager_messages USING btree (id)
manager_messages_sender_id_62437b21 CREATE INDEX manager_messages_sender_id_62437b21 ON public.manager_messages USING btree (sender_id)

Generated by tbls