Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table data_meteo_agri4cast_passe
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
date_donnee |
timestamp(6) |
|
|
|
|
||
|
id_maille |
integer |
|
|
|
|
||
|
|
temperature_max |
real |
|
|
|
|
|
|
|
temperature_min |
real |
|
|
|
|
|
|
|
tempmoy |
real |
|
|
|
|
|
|
|
ea |
real |
|
|
|
|
|
|
|
vent10m |
real |
|
|
|
|
|
|
|
vent2m |
real |
|
|
|
|
|
|
|
pluvio |
real |
|
|
|
|
|
|
|
et0 |
real |
|
|
|
|
|
|
|
rayonnement_global |
real |
|
|
|
|
|
|
|
es |
real |
|
|
|
|
|
|
|
dsat |
real |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table data_meteo_agri4cast_passe
Check Constraints
There are no check constraints for table data_meteo_agri4cast_passe
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
Rules
There are no rules for table data_meteo_agri4cast_passe
Policies
There are no policies for table data_meteo_agri4cast_passe
Referenced
There are no tables referenced by table data_meteo_agri4cast_passe
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
335498750 |
Pages |
3458750 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.data_meteo_agri4cast_passe (
date_donnee TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL,
id_maille INTEGER NOT NULL,
temperature_max REAL,
temperature_min REAL,
tempmoy REAL,
ea REAL,
vent10m REAL,
vent2m REAL,
pluvio REAL,
et0 REAL,
rayonnement_global REAL,
es REAL,
dsat REAL,
CONSTRAINT data_meteo_agri4cast_passe_2020_pkey PRIMARY KEY(id_maille, date_donnee)
) ;
CREATE INDEX x_btr_date_agri4cast_passe_2020 ON public.data_meteo_agri4cast_passe
USING btree (date_donnee);
COMMENT ON INDEX public.x_btr_date_agri4cast_passe_2020
IS 'Index de performance sur la colonne id_maille';
CREATE INDEX x_btr_maille_agri4cast_passe_2020 ON public.data_meteo_agri4cast_passe
USING btree (id_maille);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |