Table t_object

pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr

Table: t_object_obj

Schema

public

Owner

woodseer

Tablespace

(default)

Descriptions

Table of objects (objetcs of differents natures merged in this table)

Fields

Name	Data type	Default	Description
obj_id	serial	nextval('t_object_obj_obj_id_seq'::regclass)	Digital automatic identifier of the object
obj_tree	public.ltree		Complete single tree structure of the object, each node being separated by the character ''.''
obj_nobj_id	integer		Identifier of the corresponding nature of the object
obj_zon_id	integer		Identifier of the origin study zone of the object
obj_tax_id	integer		Identifier of the taxon from which the object is associated
obj_proj_id	integer		Identifier of the project from which the object is issued.
obj_code_object_project	varchar(128)		Free code of the object in the project

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time	Description
c_fk_nobj_obj	obj_nobj_id	public.tr_nature_object_nobj	nobj_id	No Action	No Action	Immediate	An object is link to 1 and only 1 nature of object
c_fk_proj_obj	obj_proj_id	public.t_project_proj	proj_id	No Action	No Action	Immediate	An object is link to 1 and only 1 project
c_fk_tax_obj	obj_tax_id	public.tr_taxon_tax	tax_id	No Action	No Action	Immediate	An object is link to 0 or 1 taxon
c_fk_zon_obj	obj_zon_id	public.tr_study_zone_zon	zon_id	No Action	No Action	Immediate	An object is link to 0 or 1 study zone

Check Constraints

There are no check constraints for table t_object_obj

Indices

Name	Type	Fields	Description
c_uni_tree_proj_obj	btree	obj_tree, obj_proj_id	The complete tree structure of an object must be unique for the same project
t_object_obj_pkey	btree	obj_id
x_btr_fkey_nobj_obj	btree	obj_nobj_id	Foreign key index to speed up updates / deletion
x_btr_fkey_proj_obj	btree	obj_proj_id	Foreign key index to speed up updates / deletion
x_btr_fkey_tax_obj	btree	obj_tax_id	Foreign key index to speed up updates / deletion
x_btr_fkey_zon_obj	btree	obj_zon_id	Foreign key index to speed up updates / deletion

Triggers

There are no triggers for table t_object_obj

Rules

There are no rules for table t_object_obj

Policies

There are no policies for table t_object_obj

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
t_acquisition_acq	public	c_fk_obj_acq	acq_obj_id	public.t_object_obj	obj_id	No Action	No Action		Immediate	an acquisition must be associated to one and only one object
t_measure_mobj	public	c_fk_obj_mobj	mobj_obj_id	public.t_object_obj	obj_id	No Action	No Action		Immediate	a measure must be attached to one and only one object

Properties

Property	Value
Inherited From
Rows	120
Pages	2
System
Temporary
With OID

Definition

CREATE TABLE public.t_object_obj ( obj_id SERIAL, obj_tree public.ltree NOT NULL, obj_nobj_id INTEGER NOT NULL, obj_zon_id INTEGER, obj_tax_id INTEGER, obj_proj_id INTEGER NOT NULL, obj_code_object_project VARCHAR(128), CONSTRAINT c_uni_tree_proj_obj UNIQUE(obj_tree, obj_proj_id), CONSTRAINT t_object_obj_pkey PRIMARY KEY(obj_id), CONSTRAINT c_fk_nobj_obj FOREIGN KEY (obj_nobj_id) REFERENCES public.tr_nature_object_nobj(nobj_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE, CONSTRAINT c_fk_proj_obj FOREIGN KEY (obj_proj_id) REFERENCES public.t_project_proj(proj_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE, CONSTRAINT c_fk_tax_obj FOREIGN KEY (obj_tax_id) REFERENCES public.tr_taxon_tax(tax_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE, CONSTRAINT c_fk_zon_obj FOREIGN KEY (obj_zon_id) REFERENCES public.tr_study_zone_zon(zon_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE ) ; COMMENT ON TABLE public.t_object_obj IS 'Table of objects (objetcs of differents natures merged in this table)'; COMMENT ON COLUMN public.t_object_obj.obj_id IS 'Digital automatic identifier of the object'; COMMENT ON COLUMN public.t_object_obj.obj_tree IS 'Complete single tree structure of the object, each node being separated by the character ''''.'''''; COMMENT ON COLUMN public.t_object_obj.obj_nobj_id IS 'Identifier of the corresponding nature of the object'; COMMENT ON COLUMN public.t_object_obj.obj_zon_id IS 'Identifier of the origin study zone of the object'; COMMENT ON COLUMN public.t_object_obj.obj_tax_id IS 'Identifier of the taxon from which the object is associated'; COMMENT ON COLUMN public.t_object_obj.obj_proj_id IS 'Identifier of the project from which the object is issued.'; COMMENT ON COLUMN public.t_object_obj.obj_code_object_project IS 'Free code of the object in the project'; COMMENT ON CONSTRAINT c_fk_nobj_obj ON public.t_object_obj IS 'An object is link to 1 and only 1 nature of object'; COMMENT ON CONSTRAINT c_fk_proj_obj ON public.t_object_obj IS 'An object is link to 1 and only 1 project'; COMMENT ON CONSTRAINT c_fk_tax_obj ON public.t_object_obj IS 'An object is link to 0 or 1 taxon'; COMMENT ON CONSTRAINT c_fk_zon_obj ON public.t_object_obj IS 'An object is link to 0 or 1 study zone'; COMMENT ON CONSTRAINT c_uni_tree_proj_obj ON public.t_object_obj IS 'The complete tree structure of an object must be unique for the same project'; CREATE INDEX x_btr_fkey_nobj_obj ON public.t_object_obj USING btree (obj_nobj_id); COMMENT ON INDEX public.x_btr_fkey_nobj_obj IS 'Foreign key index to speed up updates / deletion'; CREATE INDEX x_btr_fkey_proj_obj ON public.t_object_obj USING btree (obj_proj_id); COMMENT ON INDEX public.x_btr_fkey_proj_obj IS 'Foreign key index to speed up updates / deletion'; CREATE INDEX x_btr_fkey_tax_obj ON public.t_object_obj USING btree (obj_tax_id); COMMENT ON INDEX public.x_btr_fkey_tax_obj IS 'Foreign key index to speed up updates / deletion'; CREATE INDEX x_btr_fkey_zon_obj ON public.t_object_obj USING btree (obj_zon_id); COMMENT ON INDEX public.x_btr_fkey_zon_obj IS 'Foreign key index to speed up updates / deletion';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23