db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: data_meteo_agri4cast_passe_2019
db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr |
|
Table: data_meteo_agri4cast_passe_2019
Schema
Owner
biljou_param
Tablespace
(default)
Descriptions
There is no description for table data_meteo_agri4cast_passe_2019
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
date_donnee |
timestamp(6) |
|
|
|
|
|
|
|
humidity_06h |
real |
|
|
|
|
|
|
|
humidity_09h |
real |
|
|
|
|
|
|
|
humidity_12h |
real |
|
|
|
|
|
|
|
humidity_15h |
real |
|
|
|
|
|
|
|
humidity_18h |
real |
|
|
|
|
|
|
|
snowdepth |
real |
|
|
|
|
|
|
|
id_maille |
integer |
|
|
|
|
|
|
|
temperature_max |
real |
|
|
|
|
|
|
|
temperature_min |
real |
|
|
|
|
|
|
|
tempmoy |
real |
|
|
|
|
|
|
|
ea |
real |
|
|
|
|
|
|
|
vent10m |
real |
|
|
|
|
|
|
|
vent2m |
real |
|
|
|
|
|
|
|
pluvio |
real |
|
|
|
|
|
|
|
e0 |
real |
|
|
|
|
|
|
|
es0 |
real |
|
|
|
|
|
|
|
et0 |
real |
|
|
|
|
|
|
|
rayonnement_global |
real |
|
|
|
|
|
|
|
es |
real |
|
|
|
|
|
|
|
dsat |
real |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table data_meteo_agri4cast_passe_2019
Check Constraints
There are no check constraints for table data_meteo_agri4cast_passe_2019
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id_maille, date_donnee |
|
|
|
|
btree |
|
date_donnee |
|
|
Index de performance sur la colonne id_maille |
|
btree |
|
id_maille |
|
|
|
Triggers
There are no triggers for table data_meteo_agri4cast_passe_2019
Rules
There are no rules for table data_meteo_agri4cast_passe_2019
Policies
There are no policies for table data_meteo_agri4cast_passe_2019
Referenced
There are no tables referenced by table data_meteo_agri4cast_passe_2019
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
303583550 |
Pages |
4006226 |
System |
|
Temporary |
|
With OID |
|
Definition
date_donnee TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL,
humidity_06h REAL,
humidity_09h REAL,
humidity_12h REAL,
humidity_15h REAL,
humidity_18h REAL,
snowdepth REAL,
id_maille INTEGER NOT NULL,
temperature_max REAL,
temperature_min REAL,
tempmoy REAL,
ea REAL,
vent10m REAL,
vent2m REAL,
pluvio REAL,
e0 REAL,
es0 REAL,
et0 REAL,
rayonnement_global REAL,
es REAL,
dsat REAL,
CONSTRAINT data_meteo_agri4cast_passe_2019_pkey PRIMARY KEY(id_maille, date_donnee)
) ;
CREATE INDEX x_btr_date_agri4cast_passe_2019 ON public.data_meteo_agri4cast_passe_2019
USING btree (date_donnee);
COMMENT ON INDEX public.x_btr_date_agri4cast_passe_2019
IS 'Index de performance sur la colonne id_maille';
CREATE INDEX x_btr_maille_agri4cast_passe_2019 ON public.data_meteo_agri4cast_passe_2019
USING btree (id_maille);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|