director linkmanager_category Таблица public linkmanager_category Коло

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
director=# \d linkmanager_category
Таблица "public.linkmanager_category"
Колонка | Тип | Модификаторы
---------------+------------------------+-------------------------------------------------------------------
id | integer | not null default nextval('linkmanager_category_id_seq'::regclass)
slug | character varying(255) | not null
title | character varying(255) | not null
links | integer | not null
meta_title | character varying(255) | not null
meta_keywords | character varying(255) | not null
parent_id | integer |
lft | integer | not null
rght | integer | not null
tree_id | integer | not null
level | integer | not null
Индексы:
"linkmanager_category_pkey" PRIMARY KEY, btree (id)
"linkmanager_category_level" btree ("level")
"linkmanager_category_lft" btree (lft)
"linkmanager_category_parent_id" btree (parent_id)
"linkmanager_category_rght" btree (rght)
"linkmanager_category_tree_id" btree (tree_id)
Ограничения целостности:
"linkmanager_category_level_check" CHECK ("level" >= 0)
"linkmanager_category_lft_check" CHECK (lft >= 0)
"linkmanager_category_links_check" CHECK (links >= 0)
"linkmanager_category_rght_check" CHECK (rght >= 0)
"linkmanager_category_tree_id_check" CHECK (tree_id >= 0)
Ограничения по внешнему ключу:
"parent_id_refs_id_6982938b" FOREIGN KEY (parent_id) REFERENCES linkmanager_category(id) DEFERRABLE INITIALLY DEFERRED