Schema
Owner
globoxylo
Tablespace
(default)
Descriptions
Table of classification plans. Information relating to the classification of variables allowing them to be positioned in one or more repositories.
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
rank_id |
serial |
|
nextval('tr_ranking_rank_rank_id_seq'::regclass) |
Numeric automatic classification identifier |
|||
|
|
rank_tree |
public.ltree |
|
|
Complete single tree structure of the class, each node being separated by the character '.' |
||
|
|
rank_label |
varchar(32) |
|
|
|
Usual classification label |
|
|
|
rank_definition |
varchar |
|
|
|
Definition of classification |
Foreign Keys
There are no foreign keys for table tr_ranking_rank
Check Constraints
There are no check constraints for table tr_ranking_rank
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
rank_tree |
|
The ranking ltree is unique |
||
btree |
|
rank_id |
|
Triggers
There are no triggers for table tr_ranking_rank
Rules
There are no rules for table tr_ranking_rank
Policies
There are no policies for table tr_ranking_rank
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
cvar_rank_id |
rank_id |
No Action |
No Action |
|
Immediate |
The cvar_rank_id field necessarily corresponds to an existing ranking |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
-1 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_ranking_rank (
rank_id SERIAL,
rank_tree public.ltree NOT NULL,
rank_label VARCHAR(32) NOT NULL,
rank_definition VARCHAR NOT NULL,
CONSTRAINT c_uni_tree_rank UNIQUE(rank_tree),
CONSTRAINT tr_ranking_rank_pkey PRIMARY KEY(rank_id)
) ;
COMMENT ON TABLE public.tr_ranking_rank
IS 'Table of classification plans. Information relating to the classification of variables allowing them to be positioned in one or more repositories.';
COMMENT ON COLUMN public.tr_ranking_rank.rank_id
IS 'Numeric automatic classification identifier';
COMMENT ON COLUMN public.tr_ranking_rank.rank_tree
IS 'Complete single tree structure of the class, each node being separated by the character ''.''';
COMMENT ON COLUMN public.tr_ranking_rank.rank_label
IS 'Usual classification label';
COMMENT ON COLUMN public.tr_ranking_rank.rank_definition
IS 'Definition of classification';
COMMENT ON CONSTRAINT c_uni_tree_rank ON public.tr_ranking_rank
IS 'The ranking ltree is unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |