Table tr_study_zone

db_globoxylo

Table: tr_study_zone_zon

Schema

public

Owner

postgres

Tablespace

(default)

Descriptions

Table of study zones representing a geographic entity of variable level and that can be nested.

Columns

Name	Data type	Default	Description
zon_id	serial	nextval('tr_study_zone_zon_zon_id_seq'::regclass)	automatic numeric identifier of the study zone
zon_typz_id	integer		automatic numeric identifier of the type of study zone
zon_code	varchar(64)		Study zone code
zon_label	varchar(96)		Label of the study zone
zon_tree	public.ltree		Complete single tree structure of the zone, each node being separated by the character '.'

Foreign Keys

Name	Columns	FK Table	FK Columns	Delete Action	Update Action	Deferrable	Check Time	Description
c_fk_typz_zon	zon_typz_id	public.tr_type_study_zone_typz	typz_id	No Action	No Action		Immediate	a study zone must be attached to 1 and 1 type of study zone

Check Constraints

There are no check constraints for table tr_study_zone_zon

Indices

Name	Type	Columns	Description
c_uni_tree_zon	btree	zon_tree	The entire tree structure of a study zone must be unique
tr_study_zone_zon_pkey	btree	zon_id
x_btr_fkey_typz_zon	btree	zon_typz_id	Foreign key index to speed up updates / deletion
x_gist_tree_zon	gist	zon_tree	Index of optimization of tree traversals on the tree object of type ltree

Triggers

There are no triggers for table tr_study_zone_zon

Rules

There are no rules for table tr_study_zone_zon

Policies

There are no policies for table tr_study_zone_zon

Referenced

Table	Schema	Foreign Key	Columns	FK Table	FK Columns	Delete Action	Update Action	Deferrable	Check Time	Description
t_measure_mzon	public	c_fk_zon_mzon	mzon_zon_id	public.tr_study_zone_zon	zon_id	No Action	No Action		Immediate	a measure must be attached to one and only one object
t_tree_tre	public	c_fk_zon_tre	tre_zon_id	public.tr_study_zone_zon	zon_id	No Action	No Action		Immediate	A tree is attached to one and only one study area

Properties

Property	Value
Inherited From
Rows	-1
Pages	0
System
Temporary
With OID

Definition

CREATE TABLE public.tr_study_zone_zon ( zon_id SERIAL, zon_typz_id INTEGER NOT NULL, zon_code VARCHAR(64) NOT NULL, zon_label VARCHAR(96) NOT NULL, zon_tree public.ltree NOT NULL, CONSTRAINT c_uni_tree_zon UNIQUE(zon_tree), CONSTRAINT tr_study_zone_zon_pkey PRIMARY KEY(zon_id), CONSTRAINT c_fk_typz_zon FOREIGN KEY (zon_typz_id) REFERENCES public.tr_type_study_zone_typz(typz_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE ) ; COMMENT ON TABLE public.tr_study_zone_zon IS 'Table of study zones representing a geographic entity of variable level and that can be nested.'; COMMENT ON COLUMN public.tr_study_zone_zon.zon_id IS 'automatic numeric identifier of the study zone'; COMMENT ON COLUMN public.tr_study_zone_zon.zon_typz_id IS 'automatic numeric identifier of the type of study zone'; COMMENT ON COLUMN public.tr_study_zone_zon.zon_code IS 'Study zone code'; COMMENT ON COLUMN public.tr_study_zone_zon.zon_label IS 'Label of the study zone'; COMMENT ON COLUMN public.tr_study_zone_zon.zon_tree IS 'Complete single tree structure of the zone, each node being separated by the character ''.'''; COMMENT ON CONSTRAINT c_fk_typz_zon ON public.tr_study_zone_zon IS 'a study zone must be attached to 1 and 1 type of study zone'; COMMENT ON CONSTRAINT c_uni_tree_zon ON public.tr_study_zone_zon IS 'The entire tree structure of a study zone must be unique'; CREATE INDEX x_btr_fkey_typz_zon ON public.tr_study_zone_zon USING btree (zon_typz_id); COMMENT ON INDEX public.x_btr_fkey_typz_zon IS 'Foreign key index to speed up updates / deletion'; CREATE INDEX x_gist_tree_zon ON public.tr_study_zone_zon USING gist (zon_tree public.gist_ltree_ops); COMMENT ON INDEX public.x_gist_tree_zon IS 'Index of optimization of tree traversals on the tree object of type ltree';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)