Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table mesure
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idmesure |
serial |
|
nextval('mesure_idmesure_seq'::regclass) |
|
|||
|
|
nom |
varchar(90) |
|
|
|
||
|
|
nom_court |
varchar(30) |
|
|
|
|
|
|
|
commentaire |
text |
|
|
|
|
|
|
|
recup_unite_enr |
varchar(50) |
|
|
|
|
|
|
|
idunite_enreg |
integer |
|
|
|
|
avril 2008. suppression de cette variable, remplace par table relation_unite_enreg. (nm) |
|
idtype_mes |
integer |
|
|
|
|
|
|
|
|
date_creation |
date |
|
|
|
|
|
|
|
date_maj |
date |
|
|
|
|
|
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
idtype_mes |
idtype_mesure |
Restrict |
Restrict |
|
Immediate |
|
Check Constraints
There are no check constraints for table mesure
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
nom_court |
|
|
||
btree |
|
nom |
|
|
||
btree |
|
idmesure |
|
Triggers
There are no triggers for table mesure
Rules
There are no rules for table mesure
Policies
There are no policies for table mesure
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
idmesure_mesure |
idmesure |
No Action |
No Action |
|
Immediate |
|
||||
idmesure |
idmesure |
No Action |
No Action |
|
Immediate |
|
||||
idmesure |
idmesure |
Restrict |
Restrict |
|
Immediate |
|
||||
idmesure |
idmesure |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
63 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.mesure (
idmesure SERIAL,
nom VARCHAR(90) NOT NULL,
nom_court VARCHAR(30),
commentaire TEXT,
recup_unite_enr VARCHAR(50),
idunite_enreg INTEGER,
idtype_mes INTEGER,
date_creation DATE,
date_maj DATE,
CONSTRAINT mesure_nom_court UNIQUE(nom_court),
CONSTRAINT mesure_nom_key UNIQUE(nom),
CONSTRAINT pk_mesure PRIMARY KEY(idmesure),
CONSTRAINT type_mes FOREIGN KEY (idtype_mes)
REFERENCES public.type_mesure(idtype_mesure)
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE
) ;
COMMENT ON COLUMN public.mesure.idunite_enreg
IS 'avril 2008. suppression de cette variable, remplace par table relation_unite_enreg. (nm)';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |