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

Index: c_uni_acq_var_macq

Schema

public

Table

t_measure_macq

Tablespace

(default)

Descriptions

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

Condition for partial index

(macq_date_measure IS NULL)

Definition

CREATE UNIQUE INDEX c_uni_acq_var_macq ON public.t_measure_macq
 USING btree (macq_acq_id, macq_var_id)
 WHERE (macq_date_measure IS NULL);

COMMENT ON INDEX public.c_uni_acq_var_macq
IS 'The variable / acquisition 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