pggeodb-preprod.nancy.inra.fr/db_peuplier |
|
Table: culti
pggeodb-preprod.nancy.inra.fr/db_peuplier |
|
Table: culti
Schema
Owner
Administrateur
Tablespace
(default)
Descriptions
There is no description for table culti
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
culti |
integer |
|
|
|
|
|
|
|
campagne |
integer |
|
|
|
|
|
|
|
date_obs |
date |
|
|
|
|
|
|
|
placette |
integer |
|
|
|
|
|
|
|
libculti |
char |
|
|
|
|
|
|
|
plac |
integer |
|
|
|
|
|
|
|
CIRC5 |
integer |
|
|
|
|
|
|
|
CODE_PROBLEME |
char(12) |
|
|
|
|
|
|
|
libCODE_PROBLEME |
char(60) |
|
|
|
|
|
|
|
DEFOPOURC |
integer |
|
|
|
|
|
|
|
ID_ECHANTILLON |
integer |
|
|
|
|
|
|
|
MARSBRU5 |
integer |
|
|
|
|
|
|
|
MELAPEU5 |
integer |
|
|
|
|
|
|
|
MORT50POURC |
integer |
|
|
|
|
|
|
|
OBSERVATION |
text |
|
|
|
|
|
|
|
ORG2 |
char(2) |
|
|
|
|
|
|
|
libORG2 |
char(60) |
|
|
|
|
|
|
|
ORGANE |
char(2) |
|
|
|
|
|
|
|
libORGANE |
char(60) |
|
|
|
|
|
|
|
PHLOPASPOURC |
integer |
|
|
|
|
|
|
|
PHLOPASSEV |
char(1) |
|
|
|
|
|
|
|
libPHLOPASSEV |
char(60) |
|
|
|
|
|
|
|
PRCNT_TIGES |
real |
|
|
|
|
|
|
|
PROBLEME2 |
char(7) |
|
|
|
|
|
|
|
libPROBLEME2 |
char(60) |
|
|
|
|
|
|
|
SEVERITE |
char(12) |
|
|
|
|
|
|
|
libSEVERITE |
char(60) |
|
|
|
|
|
|
|
SYMP2 |
char(7) |
|
|
|
|
|
|
|
libSYMP2 |
char(60) |
|
|
|
|
|
|
|
SYMPTOME |
char(7) |
|
|
|
|
|
|
|
libSYMPTOME |
char(60) |
|
|
|
|
|
|
|
XYLOPOURC |
integer |
|
|
|
|
|
|
|
CULTIVAR19 |
char(3) |
|
|
|
|
|
|
|
libCULTIVAR19 |
char(60) |
|
|
|
|
|
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
campagne |
campagne |
No Action |
No Action |
|
Immediate |
|
||
placette, campagne, date_obs |
placette, campagne, date_obs |
No Action |
No Action |
|
Immediate |
|
||
plac, placette, campagne, date_obs |
plac, placette, campagne, date_obs |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table culti
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
culti, placette, campagne, date_obs |
|
|
|
Triggers
There are no triggers for table culti
Rules
There are no rules for table culti
Policies
There are no policies for table culti
Referenced
There are no tables referenced by table culti
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
986 |
Pages |
38 |
System |
|
Temporary |
|
With OID |
|
Definition
culti INTEGER NOT NULL,
campagne INTEGER NOT NULL,
date_obs DATE NOT NULL,
placette INTEGER NOT NULL,
libculti CHAR,
plac INTEGER,
"CIRC5" INTEGER,
"CODE_PROBLEME" CHAR(12),
"libCODE_PROBLEME" CHAR(60),
"DEFOPOURC" INTEGER,
"ID_ECHANTILLON" INTEGER,
"MARSBRU5" INTEGER,
"MELAPEU5" INTEGER,
"MORT50POURC" INTEGER,
"OBSERVATION" TEXT,
"ORG2" CHAR(2),
"libORG2" CHAR(60),
"ORGANE" CHAR(2),
"libORGANE" CHAR(60),
"PHLOPASPOURC" INTEGER,
"PHLOPASSEV" CHAR(1),
"libPHLOPASSEV" CHAR(60),
"PRCNT_TIGES" REAL,
"PROBLEME2" CHAR(7),
"libPROBLEME2" CHAR(60),
"SEVERITE" CHAR(12),
"libSEVERITE" CHAR(60),
"SYMP2" CHAR(7),
"libSYMP2" CHAR(60),
"SYMPTOME" CHAR(7),
"libSYMPTOME" CHAR(60),
"XYLOPOURC" INTEGER,
"CULTIVAR19" CHAR(3),
"libCULTIVAR19" CHAR(60),
CONSTRAINT pk_generique334_culti PRIMARY KEY(culti, placette, campagne, date_obs),
CONSTRAINT fk_culti_to_campagne FOREIGN KEY (campagne)
REFERENCES generique334.campagne(campagne)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_culti_to_observation FOREIGN KEY (placette, campagne, date_obs)
REFERENCES generique334.observation(placette, campagne, date_obs)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT fk_culti_to_plac FOREIGN KEY (plac, placette, campagne, date_obs)
REFERENCES generique334.plac(plac, placette, campagne, date_obs)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|