suo_organization_parents
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('suo_organization_p... |
|
| organization_id |
integer(32) |
NOT NULL |
|
→ suo_organizations(id) |
| parent_id |
integer(32) |
NOT NULL |
|
→ suo_organizations(id) |
| created_at |
timestamp with time zone |
NULL |
now() |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| ix_suo_organization_parents_id |
CREATE INDEX ix_suo_organization_parents_id ON public.suo_organization_parent... |
| suo_organization_parents_pkey |
CREATE UNIQUE INDEX suo_organization_parents_pkey ON public.suo_organization_... |
| uq_org_parent |
CREATE UNIQUE INDEX uq_org_parent ON public.suo_organization_parents USING bt... |
Foreign Keys