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

Index: c_uni_det_var_mdet

Schema

public

Table

t_measure_mdet

Tablespace

(default)

Descriptions

The variable / singularity detection pair is unique if the measure date is not entered.

Condition for partial index

(mdet_date_measure IS NULL)

Definition

CREATE UNIQUE INDEX c_uni_det_var_mdet ON public.t_measure_mdet
 USING btree (mdet_det_id, mdet_var_id)
 WHERE (mdet_date_measure IS NULL);

COMMENT ON INDEX public.c_uni_det_var_mdet
IS 'The variable / singularity detection pair is unique if the measure date is not entered.';

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