db_globoxylo
 Previous topic Chapter index Next topic

Table: t_grouping_grp

 

 

Schema

public

 

Owner

globoxylo

 

Tablespace

(default)

 

Descriptions

Table of sets regrouping measures in order to factorize the environment of these measures (variable, unit, standard, protocol, file, operator (s)). The satellite information is then associated with the measurement grouping and no longer with each individual measurement.

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

grp_id

serial

 

nextval('t_grouping_grp_grp_id_seq'::regclass)

Numerical automatic identifier of the grouping

 

grp_tym_id

integer

 

 

 

 

Automatic numeric identifier of the associated measurement type

 

grp_fil_id

integer

 

 

 

 

Automatic numeric identifier of the associated file

 

grp_prot_id

integer

 

 

 

 

Automatic numeric identifier of the associated protocol

 

grp_std_id

integer

 

 

 

 

Automatic numeric identifier of the associated standard

 

grp_uni_id

integer

 

 

 

 

Unique numeric identifier of the associated measurement unit

 

 

grp_code

varchar(32)

 

 

Code of the group to identify it for a human operator

 

 

grp_name

varchar(32)

 

 

 

Group name

 

 

grp_description

text

 

 

 

Description of the grouping

 

Foreign Keys

Name

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

c_fk_fil_grp

grp_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 file

c_fk_prot_grp

grp_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 protocol

c_fk_std_grp

grp_std_id

public.tr_standard_std

std_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 standard

c_fk_tym_grp

grp_tym_id

public.tr_type_measure_tym

tym_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 type of measure

c_fk_uni_grp

grp_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 unit

 

Check Constraints

There are no check constraints for table t_grouping_grp

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

c_uni_code_grp

btree

 

grp_code

 

The code of a group must be unique

t_grouping_grp_pkey

btree

 

grp_id

 

x_btr_fkey_fil_grp

btree

 

grp_fil_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_grp

btree

 

grp_prot_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_std_grp

btree

 

grp_std_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_tym_grp

btree

 

grp_tym_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_uni_grp

btree

 

grp_uni_id

 

 

Foreign key index to speed up updates / deletion

 

Triggers

There are no triggers for table t_grouping_grp

 

Rules

There are no rules for table t_grouping_grp

 

Policies

There are no policies for table t_grouping_grp

 

Referenced

Table

Schema

Foreign Key

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

tj_grp_msam_gms

public

c_fk_grp_gms

gms_grp_id

public.t_grouping_grp

grp_id

No Action

No Action

 

Immediate

The gms_grp_id field necessarily corresponds to an existing grouping

tj_grp_mtre_gmt

public

c_fk_grp_gmt

gmt_grp_id

public.t_grouping_grp

grp_id

No Action

No Action

 

Immediate

The gmt_grp_id field necessarily corresponds to an existing grouping

tj_grp_mzon_gmz

public

c_fk_grp_gmz

gmz_grp_id

public.t_grouping_grp

grp_id

No Action

No Action

 

Immediate

The gmz_grp_id field necessarily corresponds to an existing grouping

tj_rol_ope_grp_rog

public

c_fk_grp_rog

rog_grp_id

public.t_grouping_grp

grp_id

No Action

No Action

 

Immediate

The rog_grp_id field necessarily corresponds to an existing grouping

 

Properties

Property

Value

Inherited From

 

Rows

-1

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.t_grouping_grp (
 grp_id SERIAL,
 grp_tym_id INTEGER,
 grp_fil_id INTEGER,
 grp_prot_id INTEGER,
 grp_std_id INTEGER,
 grp_uni_id INTEGER,
 grp_code VARCHAR(32) NOT NULL,
 grp_name VARCHAR(32) NOT NULL,
 grp_description TEXT NOT NULL,
 CONSTRAINT c_uni_code_grp UNIQUE(grp_code),
 CONSTRAINT t_grouping_grp_pkey PRIMARY KEY(grp_id),
 CONSTRAINT c_fk_fil_grp FOREIGN KEY (grp_fil_id)
   REFERENCES public.tr_file_fil(fil_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_prot_grp FOREIGN KEY (grp_prot_id)
   REFERENCES public.tr_protocol_prot(prot_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_std_grp FOREIGN KEY (grp_std_id)
   REFERENCES public.tr_standard_std(std_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_tym_grp FOREIGN KEY (grp_tym_id)
   REFERENCES public.tr_type_measure_tym(tym_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_uni_grp FOREIGN KEY (grp_uni_id)
   REFERENCES public.tr_unit_uni(uni_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.t_grouping_grp
IS 'Table of sets regrouping measures in order to factorize the environment of these measures (variable, unit, standard, protocol, file, operator (s)). The satellite information is then associated with the measurement grouping and no longer with each individual measurement.';

COMMENT ON COLUMN public.t_grouping_grp.grp_id
IS 'Numerical automatic identifier of the grouping';

COMMENT ON COLUMN public.t_grouping_grp.grp_tym_id
IS 'Automatic numeric identifier of the associated measurement type';

COMMENT ON COLUMN public.t_grouping_grp.grp_fil_id
IS 'Automatic numeric identifier of the associated file';

COMMENT ON COLUMN public.t_grouping_grp.grp_prot_id
IS 'Automatic numeric identifier of the associated protocol';

COMMENT ON COLUMN public.t_grouping_grp.grp_std_id
IS 'Automatic numeric identifier of the associated standard';

COMMENT ON COLUMN public.t_grouping_grp.grp_uni_id
IS 'Unique numeric identifier of the associated measurement unit';

COMMENT ON COLUMN public.t_grouping_grp.grp_code
IS 'Code of the group to identify it for a human operator';

COMMENT ON COLUMN public.t_grouping_grp.grp_name
IS 'Group name';

COMMENT ON COLUMN public.t_grouping_grp.grp_description
IS 'Description of the grouping';

COMMENT ON CONSTRAINT c_fk_fil_grp ON public.t_grouping_grp
IS 'a grouping can be attached to O or 1 file';

COMMENT ON CONSTRAINT c_fk_prot_grp ON public.t_grouping_grp
IS 'a grouping can be attached to O or 1 protocol';

COMMENT ON CONSTRAINT c_fk_std_grp ON public.t_grouping_grp
IS 'a grouping can be attached to O or 1 standard';

COMMENT ON CONSTRAINT c_fk_tym_grp ON public.t_grouping_grp
IS 'a grouping can be attached to O or 1 type of measure';

COMMENT ON CONSTRAINT c_fk_uni_grp ON public.t_grouping_grp
IS 'a grouping can be attached to O or 1 unit';

COMMENT ON CONSTRAINT c_uni_code_grp ON public.t_grouping_grp
IS 'The code of a group must be unique';

CREATE INDEX x_btr_fkey_fil_grp ON public.t_grouping_grp
 USING btree (grp_fil_id);

COMMENT ON INDEX public.x_btr_fkey_fil_grp
IS 'Foreign key index to speed up updates / deletion';

CREATE INDEX x_btr_fkey_prot_grp ON public.t_grouping_grp
 USING btree (grp_prot_id);

COMMENT ON INDEX public.x_btr_fkey_prot_grp
IS 'Foreign key index to speed up updates / deletion';

CREATE INDEX x_btr_fkey_std_grp ON public.t_grouping_grp
 USING btree (grp_std_id);

COMMENT ON INDEX public.x_btr_fkey_std_grp
IS 'Foreign key index to speed up updates / deletion';

CREATE INDEX x_btr_fkey_tym_grp ON public.t_grouping_grp
 USING btree (grp_tym_id);

COMMENT ON INDEX public.x_btr_fkey_tym_grp
IS 'Foreign key index to speed up updates / deletion';

CREATE INDEX x_btr_fkey_uni_grp ON public.t_grouping_grp
 USING btree (grp_uni_id);

COMMENT ON INDEX public.x_btr_fkey_uni_grp
IS 'Foreign key index to speed up updates / deletion'; 


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
 Previous topic Chapter index Next topic