Skip to content

public.messages

Columns

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

Constraints

Name Type Definition
messages_conversation_id_5ef638db_fk_conversations_id FOREIGN KEY FOREIGN KEY (conversation_id) REFERENCES conversations(id) DEFERRABLE INITIALLY DEFERRED
messages_pkey PRIMARY KEY PRIMARY KEY (id)
messages_sender_id_dc5a0bbd_fk_users_id FOREIGN KEY FOREIGN KEY (sender_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
messages_convers_8904b4_idx CREATE INDEX messages_convers_8904b4_idx ON public.messages USING btree (conversation_id)
messages_conversation_id_5ef638db CREATE INDEX messages_conversation_id_5ef638db ON public.messages USING btree (conversation_id)
messages_pkey CREATE UNIQUE INDEX messages_pkey ON public.messages USING btree (id)
messages_sender__6ae55a_idx CREATE INDEX messages_sender__6ae55a_idx ON public.messages USING btree (sender_id)
messages_sender_id_dc5a0bbd CREATE INDEX messages_sender_id_dc5a0bbd ON public.messages USING btree (sender_id)
messages_sent_at_219716_idx CREATE INDEX messages_sent_at_219716_idx ON public.messages USING btree (sent_at)

Generated by tbls