persons
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('persons_id_seq'::r... |
|
| full_name |
character varying(300) |
NOT NULL |
|
|
| iin |
character varying(12) |
NULL |
|
|
| phone |
character varying(20) |
NULL |
|
|
| email |
character varying(100) |
NULL |
|
|
| created_at |
timestamp with time zone |
NULL |
now() |
|
| is_active |
boolean |
NOT NULL |
true |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| ix_persons_id |
CREATE INDEX ix_persons_id ON public.persons USING btree (id) |
| persons_pkey |
CREATE UNIQUE INDEX persons_pkey ON public.persons USING btree (id) |
Используется в