public.manager_conversations¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | false | ||||
| id | bigint | false | public.manager_conversations_participants public.manager_messages | |||
| is_archived | boolean | false | ||||
| worker_id | bigint | true | public.users |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| manager_conversations_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| manager_conversations_worker_id_03f0af05_fk_users_id | FOREIGN KEY | FOREIGN KEY (worker_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| manager_con_created_a2f23c_idx | CREATE INDEX manager_con_created_a2f23c_idx ON public.manager_conversations USING btree (created_at) |
| manager_con_is_arch_1f1bd2_idx | CREATE INDEX manager_con_is_arch_1f1bd2_idx ON public.manager_conversations USING btree (is_archived) |
| manager_conversations_pkey | CREATE UNIQUE INDEX manager_conversations_pkey ON public.manager_conversations USING btree (id) |
| manager_conversations_worker_id_03f0af05 | CREATE INDEX manager_conversations_worker_id_03f0af05 ON public.manager_conversations USING btree (worker_id) |
Generated by tbls