Skip to content

public.messages_read_by

Columns

Name Type Default Nullable Children Parents Comment
id bigint false
message_id bigint false public.messages
user_id bigint false public.users

Constraints

Name Type Definition
messages_read_by_message_id_68ec72a2_fk_messages_id FOREIGN KEY FOREIGN KEY (message_id) REFERENCES messages(id) DEFERRABLE INITIALLY DEFERRED
messages_read_by_message_id_user_id_9d4160cb_uniq UNIQUE UNIQUE (message_id, user_id)
messages_read_by_pkey PRIMARY KEY PRIMARY KEY (id)
messages_read_by_user_id_5eeda8ba_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
messages_read_by_message_id_68ec72a2 CREATE INDEX messages_read_by_message_id_68ec72a2 ON public.messages_read_by USING btree (message_id)
messages_read_by_message_id_user_id_9d4160cb_uniq CREATE UNIQUE INDEX messages_read_by_message_id_user_id_9d4160cb_uniq ON public.messages_read_by USING btree (message_id, user_id)
messages_read_by_pkey CREATE UNIQUE INDEX messages_read_by_pkey ON public.messages_read_by USING btree (id)
messages_read_by_user_id_5eeda8ba CREATE INDEX messages_read_by_user_id_5eeda8ba ON public.messages_read_by USING btree (user_id)

Generated by tbls