employees
Записей: ~57
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('employees_id_seq':... | |
| name | character varying(300) | NULL | ||
| organization_id | integer(32) | NULL | ||
| position | character varying(200) | NULL | ||
| character varying(100) | NULL | |||
| phone | character varying(20) | NULL | ||
| last_name | character varying(100) | NULL | ||
| first_name | character varying(100) | NULL | ||
| middle_name | character varying(100) | NULL | ||
| is_active | boolean | NULL | true | |
| modules | ARRAY | NULL | '{}'::text[] | |
| password_hash | character varying(255) | NULL | ||
| must_change_password | boolean | NULL | true | |
| invite_token | character varying(100) | NULL | ||
| invite_expires | timestamp without time zone | NULL | ||
| last_login | timestamp without time zone | NULL | ||
| is_email_verified | boolean | NULL | false | |
| user_type | character varying(20) | NULL | 'client'::character varying | |
| role | character varying(20) | NULL | 'user'::character varying | |
| callbox_sync_status | character varying(20) | NULL | ||
| callbox_sync_error | text | NULL | ||
| suo_sync_status | character varying(20) | NULL | ||
| suo_sync_error | text | NULL | ||
| reset_token | character varying(100) | NULL | ||
| reset_token_expires | timestamp without time zone | NULL |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| employees_email_unique | CREATE UNIQUE INDEX employees_email_unique ON public.employees USING btree (e... |
| employees_pkey | CREATE UNIQUE INDEX employees_pkey ON public.employees USING btree (id) |
| idx_employees_email | CREATE INDEX idx_employees_email ON public.employees USING btree (email) |
| idx_employees_invite_token | CREATE INDEX idx_employees_invite_token ON public.employees USING btree (invi... |