public.manager_messages_read_by¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | ||||
| managermessage_id | bigint | false | public.manager_messages | |||
| user_id | bigint | false | public.users |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| manager_messages_rea_managermessage_id_92f4fec5_fk_manager_m | FOREIGN KEY | FOREIGN KEY (managermessage_id) REFERENCES manager_messages(id) DEFERRABLE INITIALLY DEFERRED |
| manager_messages_read_by_managermessage_id_user_i_48003d73_uniq | UNIQUE | UNIQUE (managermessage_id, user_id) |
| manager_messages_read_by_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| manager_messages_read_by_user_id_d081a5a1_fk_users_id | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| manager_messages_read_by_managermessage_id_92f4fec5 | CREATE INDEX manager_messages_read_by_managermessage_id_92f4fec5 ON public.manager_messages_read_by USING btree (managermessage_id) |
| manager_messages_read_by_managermessage_id_user_i_48003d73_uniq | CREATE UNIQUE INDEX manager_messages_read_by_managermessage_id_user_i_48003d73_uniq ON public.manager_messages_read_by USING btree (managermessage_id, user_id) |
| manager_messages_read_by_pkey | CREATE UNIQUE INDEX manager_messages_read_by_pkey ON public.manager_messages_read_by USING btree (id) |
| manager_messages_read_by_user_id_d081a5a1 | CREATE INDEX manager_messages_read_by_user_id_d081a5a1 ON public.manager_messages_read_by USING btree (user_id) |
Generated by tbls