Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table unite_mesure
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idunite_mesure |
serial |
|
nextval('unite_mesure_idunite_mesure_seq'::regclass) |
|
|||
|
|
libelle |
varchar(90) |
|
|
|
||
|
|
coefficient |
numeric |
|
|
|
|
|
|
idunite_reference |
integer |
|
|
|
avril 2008. pointe vers idunite_mesure. ex : pour unite=cm, l unite de reference est le m. |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
idunite_reference |
idunite_mesure |
Restrict |
Restrict |
|
Immediate |
|
Check Constraints
There are no check constraints for table unite_mesure
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
libelle |
|
|
||
btree |
|
idunite_mesure |
|
Triggers
There are no triggers for table unite_mesure
Rules
There are no rules for table unite_mesure
Policies
There are no policies for table unite_mesure
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
idunite |
idunite_mesure |
Restrict |
Restrict |
|
Immediate |
|
||||
idunite |
idunite_mesure |
Restrict |
Restrict |
|
Immediate |
|
||||
idunite_mesure |
idunite_mesure |
Restrict |
Restrict |
|
Immediate |
|
||||
idunite |
idunite_mesure |
Restrict |
Restrict |
|
Immediate |
|
||||
idunite_reference |
idunite_mesure |
Restrict |
Restrict |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
65 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.unite_mesure (
idunite_mesure SERIAL,
libelle VARCHAR(90) NOT NULL,
coefficient NUMERIC NOT NULL,
idunite_reference INTEGER NOT NULL,
CONSTRAINT unite_libelle UNIQUE(libelle),
CONSTRAINT unite_mesure_pkey PRIMARY KEY(idunite_mesure),
CONSTRAINT reference FOREIGN KEY (idunite_reference)
REFERENCES public.unite_mesure(idunite_mesure)
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE
) ;
COMMENT ON COLUMN public.unite_mesure.idunite_reference
IS 'avril 2008. pointe vers idunite_mesure. ex : pour unite=cm, l unite de reference est le m. ';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |