pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: pedotheque_sn
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: pedotheque_sn
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table pedotheque_sn
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_pedo_sn |
serial |
|
|
|
nextval('pedotheque_sn_id_pedo_sn_seq'::regclass) |
|
|
|
nature_ech |
varchar |
|
|
|
|
|
|
|
nom_projet |
varchar |
|
|
|
|
|
|
|
date_lieu |
varchar |
|
|
|
|
|
|
|
date_enreg |
varchar |
|
|
|
|
|
|
|
pers_enreg |
varchar |
|
|
|
|
|
|
|
proprio |
varchar |
|
|
|
|
|
|
|
nb_ech |
varchar |
|
|
|
|
|
|
|
lieu_stock |
varchar |
|
|
|
|
|
|
|
num_serie |
varchar |
|
|
|
|
|
|
|
id_proprio |
varchar |
|
|
|
|
|
|
|
longitude_sn |
integer |
|
|
|
|
|
|
|
latitude_sn |
integer |
|
|
|
|
|
|
|
bloc |
varchar |
|
|
|
|
|
|
|
parcelle |
varchar |
|
|
|
|
|
|
|
traitement |
varchar |
|
|
|
|
|
|
|
horizon |
varchar |
|
|
|
|
|
|
|
ref_sn |
varchar |
|
|
|
|
|
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
organe |
varchar |
|
|
|
|
|
|
|
autre_pedo_sn |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table pedotheque_sn
Check Constraints
There are no check constraints for table pedotheque_sn
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id_pedo_sn |
|
|
|
Triggers
There are no triggers for table pedotheque_sn
Rules
There are no rules for table pedotheque_sn
Policies
There are no policies for table pedotheque_sn
Referenced
There are no tables referenced by table pedotheque_sn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
130 |
Pages |
5 |
System |
|
Temporary |
|
With OID |
|
Definition
id_pedo_sn SERIAL,
nature_ech VARCHAR,
nom_projet VARCHAR,
date_lieu VARCHAR,
date_enreg VARCHAR,
pers_enreg VARCHAR,
proprio VARCHAR,
nb_ech VARCHAR,
lieu_stock VARCHAR,
num_serie VARCHAR,
id_proprio VARCHAR,
longitude_sn INTEGER,
latitude_sn INTEGER,
bloc VARCHAR,
parcelle VARCHAR,
traitement VARCHAR,
horizon VARCHAR,
ref_sn VARCHAR,
geom public.geometry,
organe VARCHAR,
autre_pedo_sn INTEGER,
CONSTRAINT "pmk_pedo-sn" PRIMARY KEY(id_pedo_sn)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|