pggeodb-preprod.nancy.inra.fr/db_peuplier |
|
Table: placette
pggeodb-preprod.nancy.inra.fr/db_peuplier |
|
Table: placette
Schema
Owner
Administrateur
Tablespace
(default)
Descriptions
There is no description for table placette
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
placette |
integer |
|
|
|
|
|
|
|
code_placette |
char(60) |
|
|
|
|
|
|
|
code_referentiel |
char(12) |
|
|
|
|
|
|
|
x |
double precision |
|
|
|
|
|
|
|
y |
double precision |
|
|
|
|
|
|
|
lat |
char(20) |
|
|
|
|
|
|
|
long |
char(20) |
|
|
|
|
|
|
|
code_ifn |
char(12) |
|
|
|
|
|
|
|
qd |
char(9) |
|
|
|
|
|
|
|
code_propriete |
char(12) |
|
|
|
|
|
|
|
code_peuplement |
char(12) |
|
|
|
|
|
|
|
code_ess_dom |
char(12) |
|
|
|
|
|
|
|
nomforet |
char(255) |
|
|
|
|
|
|
|
nature_placette |
char(12) |
|
|
|
|
|
|
|
lam_thegeom |
public.geometry |
|
|
|
|
|
|
|
strategie |
char(3) |
|
|
|
|
|
|
|
codeinsee |
char(5) |
|
|
|
|
|
|
|
releve_gps |
char(1) |
|
|
|
|
|
|
|
ANNEE_PLANTATION |
integer |
|
|
|
|
|
|
|
DENSITE |
integer |
|
|
|
|
|
|
|
xlam |
real |
|
|
|
|
|
|
|
ylam |
real |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table placette
Check Constraints
There are no check constraints for table placette
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
placette |
|
|
|
Triggers
There are no triggers for table placette
Rules
There are no rules for table placette
Policies
There are no policies for table placette
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
placette |
placette |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
56 |
Pages |
2 |
System |
|
Temporary |
|
With OID |
|
Definition
placette INTEGER NOT NULL,
code_placette CHAR(60),
code_referentiel CHAR(12),
x DOUBLE PRECISION,
y DOUBLE PRECISION,
lat CHAR(20),
long CHAR(20),
code_ifn CHAR(12),
qd CHAR(9),
code_propriete CHAR(12),
code_peuplement CHAR(12),
code_ess_dom CHAR(12),
nomforet CHAR(255),
nature_placette CHAR(12),
lam_thegeom public.geometry,
strategie CHAR(3),
codeinsee CHAR(5),
releve_gps CHAR(1),
"ANNEE_PLANTATION" INTEGER,
"DENSITE" INTEGER,
xlam REAL,
ylam REAL,
CONSTRAINT pk_generique334_placette PRIMARY KEY(placette)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|