db_venik
Previous topic Chapter index Next topic

Table: relation_unite_enreg

 

 

Schema

public

 

Owner

albenard

 

Tablespace

(default)

 

Descriptions

avril 2008. pour les differentes unites enregistrees dans la base pour chaque mesure (ex : debourrement : date ou numero)

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

idmesure

integer

 

 

 

 

idunite_mesure

integer

 

 

 

 

 

Foreign Keys

Name

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

mesure

idmesure

public.mesure

idmesure

Restrict

Restrict

 

Immediate

 

unite

idunite_mesure

public.unite_mesure

idunite_mesure

Restrict

Restrict

 

Immediate

 

 

Check Constraints

There are no check constraints for table relation_unite_enreg

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

relation_unite_enreg_pkey

btree

 

idmesure, idunite_mesure

 

 

Triggers

There are no triggers for table relation_unite_enreg

 

Rules

There are no rules for table relation_unite_enreg

 

Policies

There are no policies for table relation_unite_enreg

 

Referenced

There are no tables referenced by table relation_unite_enreg

 

Properties

Property

Value

Inherited From

 

Rows

79

Pages

1

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.relation_unite_enreg (
 idmesure INTEGER NOT NULL,
 idunite_mesure INTEGER NOT NULL,
 CONSTRAINT relation_unite_enreg_pkey PRIMARY KEY(idmesure, idunite_mesure),
 CONSTRAINT mesure FOREIGN KEY (idmesure)
   REFERENCES public.mesure(idmesure)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE
,
 CONSTRAINT unite FOREIGN KEY (idunite_mesure)
   REFERENCES public.unite_mesure(idunite_mesure)
   ON DELETE RESTRICT
   ON UPDATE RESTRICT
   NOT DEFERRABLE

) ;

COMMENT ON TABLE public.relation_unite_enreg
IS 'avril 2008. pour les differentes unites enregistrees dans la base pour chaque mesure (ex : debourrement : date ou numero)';

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