Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table topographie_lieu
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idlc_sol_pedo |
integer |
|
|
|
|
|
|
|
idlc_antecedent |
integer |
|
|
|
|
|
|
|
idlc_exposition |
integer |
|
|
|
|
|
|
|
idlc_drainage |
integer |
|
|
|
|
|
|
|
idlc_roche_mere |
integer |
|
|
|
|
|
|
idlieu |
integer |
|
|
|
||||
|
|
surface |
numeric |
|
|
|
|
|
|
|
morcellement |
integer |
|
|
|
|
|
|
|
pente_mini |
integer |
|
|
|
|
|
|
|
pente_maxi |
integer |
|
|
|
|
|
|
|
flore_herbacee |
text |
|
|
|
|
|
|
|
flore_arbustive |
text |
|
|
|
|
|
|
|
profondeur_mini |
integer |
|
|
|
|
|
|
|
profondeur_maxi |
integer |
|
|
|
|
|
|
|
ph |
numeric |
|
|
|
|
|
|
|
teneur_argile |
integer |
|
|
|
|
|
|
|
teneur_sable |
integer |
|
|
|
|
|
|
|
teneur_limon |
integer |
|
|
|
|
|
|
|
commentaire |
text |
|
|
|
|
|
|
|
recup_nom_lieu |
varchar(50) |
|
|
|
|
|
|
|
recup_code_sol_pedo |
integer |
|
|
|
|
|
|
|
recup_code_exposition |
integer |
|
|
|
|
|
|
|
recup_code_drainage |
integer |
|
|
|
|
|
|
|
recup_code_roche_mere |
integer |
|
|
|
|
|
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
idlc_antecedent |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_drainage |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_exposition |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_roche_mere |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlc_sol_pedo |
id_lc |
No Action |
No Action |
|
Immediate |
|
||
idlieu |
idlieu |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table topographie_lieu
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
idlieu |
|
Triggers
There are no triggers for table topographie_lieu
Rules
There are no rules for table topographie_lieu
Policies
There are no policies for table topographie_lieu
Referenced
There are no tables referenced by table topographie_lieu
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
652 |
Pages |
7 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.topographie_lieu (
idlc_sol_pedo INTEGER,
idlc_antecedent INTEGER,
idlc_exposition INTEGER,
idlc_drainage INTEGER,
idlc_roche_mere INTEGER,
idlieu INTEGER NOT NULL,
surface NUMERIC,
morcellement INTEGER,
pente_mini INTEGER,
pente_maxi INTEGER,
flore_herbacee TEXT,
flore_arbustive TEXT,
profondeur_mini INTEGER,
profondeur_maxi INTEGER,
ph NUMERIC,
teneur_argile INTEGER,
teneur_sable INTEGER,
teneur_limon INTEGER,
commentaire TEXT,
recup_nom_lieu VARCHAR(50),
recup_code_sol_pedo INTEGER,
recup_code_exposition INTEGER,
recup_code_drainage INTEGER,
recup_code_roche_mere INTEGER,
CONSTRAINT topographie_lieu_pkey PRIMARY KEY(idlieu),
CONSTRAINT fk_antecedent FOREIGN KEY (idlc_antecedent)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_drainage FOREIGN KEY (idlc_drainage)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_exposition FOREIGN KEY (idlc_exposition)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_roche_mere FOREIGN KEY (idlc_roche_mere)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_sol_pedo FOREIGN KEY (idlc_sol_pedo)
REFERENCES public.donnees_liste_classique(id_lc)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_topographie_lieu_lieu FOREIGN KEY (idlieu)
REFERENCES public.lieu(idlieu)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |