pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr
 Previous topic Chapter index Next topic

Table: t_measure_mzon

 

 

Schema

public

 

Owner

woodseer

 

Tablespace

(default)

 

Descriptions

Table of metadata measures for study zones

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

mzon_id

serial

 

nextval('t_measure_mzon_mzon_id_seq'::regclass)

Numeric automatic identifier of the metadata measurement of the zone

 

mzon_zon_id

integer

 

 

 

Automatic numeric zone identifier

 

mzon_var_id

integer

 

 

 

Unique numeric identifier of the associated variable

 

mzon_uni_id

integer

 

 

 

 

Unique numeric identifier of the associated measurement unit

 

mzon_fil_id

integer

 

 

 

Automatic numeric identifier of the associated file

 

mzon_std_id

integer

 

 

 

 

Automatic numeric identifier of the associated standard

 

mzon_tym_id

integer

 

 

 

 

Automatic numeric identifier of the associated measurement type

 

mzon_prot_id

integer

 

 

 

 

Unique numeric identifier of the associated protocol

 

 

mzon_value_num

double precision

 

 

 

 

value of the measurement if it is of numeric type

 

 

mzon_value_text

varchar

 

 

 

 

value of the measure if it is a text type

 

 

mzon_value_date

date

 

 

 

 

value of the measure if it is of type date

 

 

mzon_date_measurement

date

 

 

 

 

date of measurement

 

 

mzon_precision_date_measurement

double precision

 

 

 

 

Clarification concerning the measurement date

 

 

mzon_precision_measurement

double precision

 

 

 

 

Accuracy of the measurement value

 

 

mzon_observation

varchar

 

 

 

 

Additional information associated with the measure

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

c_fk_fil_mzon

mzon_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a measurement can be attached to O or 1 file

c_fk_prot_mzon

mzon_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a measurement can be attached to O or 1 protocol

c_fk_std_mzon

mzon_std_id

public.tr_standard_std

std_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 standard

c_fk_tym_mzon

mzon_tym_id

public.tr_type_measure_tym

tym_id

No Action

No Action

 

Immediate

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

c_fk_uni_mzon

mzon_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a measure can be attached to 0 or 1 unit

c_fk_var_mzon

mzon_var_id

public.tr_variable_var

var_id

No Action

No Action

 

Immediate

a measure must be linked to one and only one variable

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

 

Check Constraints

There are no check constraints for table t_measure_mzon

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

c_uni_zon_var_datemeasure_mzon

btree

 

mzon_zon_id, mzon_var_id, mzon_date_measurement

 

 

c_uni_zon_var_mzon

btree

 

mzon_zon_id, mzon_var_id

 

the variable / zone pair is unique if the measurement date field is not filled in.

t_measure_mzon_pkey

btree

 

mzon_id

 

x_btr_fkey_fil_mzon

btree

 

mzon_fil_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_mzon

btree

 

mzon_prot_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_std_mzon

btree

 

mzon_std_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_tym_mzon

btree

 

mzon_tym_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_uni_mzon

btree

 

mzon_uni_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_var_mzon

btree

 

mzon_var_id

 

 

Foreign key index to speed up updates / deletion

x_btr_fkey_zon_mzon

btree

 

mzon_zon_id

 

 

Foreign key index to speed up updates / deletion

 

Triggers

There are no triggers for table t_measure_mzon

 

Rules

There are no rules for table t_measure_mzon

 

Policies

There are no policies for table t_measure_mzon

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tj_rol_ope_mzon_romzon

public

c_fk_mzon_romzon

romzon_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The rom_mzon_id field necessarily corresponds to an existing measure

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.t_measure_mzon (
 mzon_id SERIAL,
 mzon_zon_id INTEGER NOT NULL,
 mzon_var_id INTEGER NOT NULL,
 mzon_uni_id INTEGER,
 mzon_fil_id INTEGER NOT NULL,
 mzon_std_id INTEGER,
 mzon_tym_id INTEGER,
 mzon_prot_id INTEGER,
 mzon_value_num DOUBLE PRECISION,
 mzon_value_text VARCHAR,
 mzon_value_date DATE,
 mzon_date_measurement DATE,
 mzon_precision_date_measurement DOUBLE PRECISION,
 mzon_precision_measurement DOUBLE PRECISION,
 mzon_observation VARCHAR,
 CONSTRAINT c_uni_zon_var_datemeasure_mzon UNIQUE(mzon_zon_id, mzon_var_id, mzon_date_measurement),
 CONSTRAINT t_measure_mzon_pkey PRIMARY KEY(mzon_id),
 CONSTRAINT c_fk_fil_mzon FOREIGN KEY (mzon_fil_id)
   REFERENCES public.tr_file_fil(fil_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_prot_mzon FOREIGN KEY (mzon_prot_id)
   REFERENCES public.tr_protocol_prot(prot_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_std_mzon FOREIGN KEY (mzon_std_id)
   REFERENCES public.tr_standard_std(std_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_tym_mzon FOREIGN KEY (mzon_tym_id)
   REFERENCES public.tr_type_measure_tym(tym_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_uni_mzon FOREIGN KEY (mzon_uni_id)
   REFERENCES public.tr_unit_uni(uni_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_var_mzon FOREIGN KEY (mzon_var_id)
   REFERENCES public.tr_variable_var(var_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_zon_mzon FOREIGN KEY (mzon_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_measure_mzon
IS 'Table of metadata measures for study zones';

COMMENT ON COLUMN public.t_measure_mzon.mzon_id
IS 'Numeric automatic identifier of the metadata measurement of the zone';

COMMENT ON COLUMN public.t_measure_mzon.mzon_zon_id
IS 'Automatic numeric zone identifier';

COMMENT ON COLUMN public.t_measure_mzon.mzon_var_id
IS 'Unique numeric identifier of the associated variable';

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

COMMENT ON COLUMN public.t_measure_mzon.mzon_fil_id
IS 'Automatic numeric identifier of the associated file';

COMMENT ON COLUMN public.t_measure_mzon.mzon_std_id
IS 'Automatic numeric identifier of the associated standard';

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

COMMENT ON COLUMN public.t_measure_mzon.mzon_prot_id
IS 'Unique numeric identifier of the associated protocol';

COMMENT ON COLUMN public.t_measure_mzon.mzon_value_num
IS 'value of the measurement if it is of numeric type';

COMMENT ON COLUMN public.t_measure_mzon.mzon_value_text
IS 'value of the measure if it is a text type';

COMMENT ON COLUMN public.t_measure_mzon.mzon_value_date
IS 'value of the measure if it is of type date';

COMMENT ON COLUMN public.t_measure_mzon.mzon_date_measurement
IS 'date of measurement';

COMMENT ON COLUMN public.t_measure_mzon.mzon_precision_date_measurement
IS 'Clarification concerning the measurement date';

COMMENT ON COLUMN public.t_measure_mzon.mzon_precision_measurement
IS 'Accuracy of the measurement value';

COMMENT ON COLUMN public.t_measure_mzon.mzon_observation
IS 'Additional information associated with the measure';

COMMENT ON CONSTRAINT c_fk_fil_mzon ON public.t_measure_mzon
IS 'a measurement can be attached to O or 1 file';

COMMENT ON CONSTRAINT c_fk_prot_mzon ON public.t_measure_mzon
IS 'a measurement can be attached to O or 1 protocol';

COMMENT ON CONSTRAINT c_fk_std_mzon ON public.t_measure_mzon
IS 'a measure can be attached to O or 1 standard';

COMMENT ON CONSTRAINT c_fk_tym_mzon ON public.t_measure_mzon
IS 'a measure can be attached to O or 1 type of measure';

COMMENT ON CONSTRAINT c_fk_uni_mzon ON public.t_measure_mzon
IS 'a measure can be attached to 0 or 1 unit';

COMMENT ON CONSTRAINT c_fk_var_mzon ON public.t_measure_mzon
IS 'a measure must be linked to one and only one variable';

COMMENT ON CONSTRAINT c_fk_zon_mzon ON public.t_measure_mzon
IS 'a measure must be attached to one and only one object';

CREATE UNIQUE INDEX c_uni_zon_var_mzon ON public.t_measure_mzon
 USING btree (mzon_zon_id, mzon_var_id)
 WHERE (mzon_date_measurement IS NULL);

COMMENT ON INDEX public.c_uni_zon_var_mzon
IS 'the variable / zone pair is unique if the measurement date field is not filled in.';

CREATE INDEX x_btr_fkey_fil_mzon ON public.t_measure_mzon
 USING btree (mzon_fil_id);

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

CREATE INDEX x_btr_fkey_prot_mzon ON public.t_measure_mzon
 USING btree (mzon_prot_id);

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

CREATE INDEX x_btr_fkey_std_mzon ON public.t_measure_mzon
 USING btree (mzon_std_id);

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

CREATE INDEX x_btr_fkey_tym_mzon ON public.t_measure_mzon
 USING btree (mzon_tym_id);

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

CREATE INDEX x_btr_fkey_uni_mzon ON public.t_measure_mzon
 USING btree (mzon_uni_id);

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

CREATE INDEX x_btr_fkey_var_mzon ON public.t_measure_mzon
 USING btree (mzon_var_id);

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

CREATE INDEX x_btr_fkey_zon_mzon ON public.t_measure_mzon
 USING btree (mzon_zon_id);

COMMENT ON INDEX public.x_btr_fkey_zon_mzon
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
 Previous topic Chapter index Next topic