Schema
Owner
biljou_param
Tablespace
(default)
Descriptions
There is no description for table data_meteo_safran_passe
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
id_maille |
integer |
|
|
|
|
||
|
|
fichier_origine |
varchar |
|
|
|
|
|
|
|
lambx |
bigint |
|
|
|
|
|
|
|
lamby |
bigint |
|
|
|
|
|
|
date_donnee |
timestamp(6) |
|
|
|
|
||
|
|
prenei_q |
real |
|
|
|
|
|
|
|
preliq_q |
real |
|
|
|
|
|
|
|
tempmoy |
real |
|
|
|
|
|
|
|
ff_q |
real |
|
|
|
|
|
|
|
q_q |
real |
|
|
|
|
|
|
|
dli_q |
real |
|
|
|
|
|
|
|
rayonnement_global |
real |
|
|
|
|
|
|
|
humidite |
real |
|
|
|
|
|
|
|
evap_q |
real |
|
|
|
|
|
|
|
etp_q |
real |
|
|
|
|
|
|
|
pe_q |
double precision |
|
|
|
|
|
|
|
swi_q |
real |
|
|
|
|
|
|
|
drainc_q |
real |
|
|
|
|
|
|
|
runc_q |
real |
|
|
|
|
|
|
|
resr_neige_q |
real |
|
|
|
|
|
|
|
resr_neige6_q |
real |
|
|
|
|
|
|
|
hteurneige_q |
real |
|
|
|
|
|
|
|
hteurneige6_q |
real |
|
|
|
|
|
|
|
hteurneigex_q |
real |
|
|
|
|
|
|
|
snow_frac_q |
real |
|
|
|
|
|
|
|
ecoulement_q |
real |
|
|
|
|
|
|
|
wg_racine_q |
real |
|
|
|
|
|
|
|
wgi_racine_q |
real |
|
|
|
|
|
|
|
tinf_h_q |
real |
|
|
|
|
|
|
|
tsup_h_q |
real |
|
|
|
|
|
|
|
vent2m |
double precision |
|
|
|
|
|
|
|
pluvio |
real |
|
|
|
|
|
|
|
dsat |
real |
|
|
|
|
|
|
|
ea |
real |
|
|
|
|
|
|
|
es |
real |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table data_meteo_safran_passe
Check Constraints
There are no check constraints for table data_meteo_safran_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_safran_passe
Rules
There are no rules for table data_meteo_safran_passe
Policies
There are no policies for table data_meteo_safran_passe
Referenced
There are no tables referenced by table data_meteo_safran_passe
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
231010530 |
Pages |
11217352 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.data_meteo_safran_passe (
id_maille INTEGER NOT NULL,
fichier_origine VARCHAR,
lambx BIGINT,
lamby BIGINT,
date_donnee TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL,
prenei_q REAL,
preliq_q REAL,
tempmoy REAL,
ff_q REAL,
q_q REAL,
dli_q REAL,
rayonnement_global REAL,
humidite REAL,
evap_q REAL,
etp_q REAL,
pe_q DOUBLE PRECISION,
swi_q REAL,
drainc_q REAL,
runc_q REAL,
resr_neige_q REAL,
resr_neige6_q REAL,
hteurneige_q REAL,
hteurneige6_q REAL,
hteurneigex_q REAL,
snow_frac_q REAL,
ecoulement_q REAL,
wg_racine_q REAL,
wgi_racine_q REAL,
tinf_h_q REAL,
tsup_h_q REAL,
vent2m DOUBLE PRECISION,
pluvio REAL,
dsat REAL,
ea REAL,
es REAL,
CONSTRAINT data_meteo_safran_passe_pkey PRIMARY KEY(id_maille, date_donnee)
) ;
CREATE INDEX x_btr_date_safran_passe ON public.data_meteo_safran_passe
USING btree (date_donnee);
COMMENT ON INDEX public.x_btr_date_safran_passe
IS 'Index de performance sur la colonne id_maille';
CREATE INDEX x_btr_maille_safran_passe ON public.data_meteo_safran_passe
USING btree (id_maille);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |