Schema
Owner
biljou_param
Tablespace
(default)
Descriptions
There is no description for table data_meteo_aladin45_futur
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
id_maille |
integer |
|
|
|
|
||
|
date_donnee |
timestamp(6) |
|
|
|
|
||
|
|
tempmoy |
real |
|
|
|
|
|
|
|
rayonnement_global |
real |
|
|
|
|
|
|
|
dsat |
real |
|
|
|
|
|
|
|
vent2m |
real |
|
|
|
|
|
|
|
pluvio |
real |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table data_meteo_aladin45_futur
Check Constraints
There are no check constraints for table data_meteo_aladin45_futur
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
id_maille, date_donnee |
|
|||
btree |
|
date_donnee |
|
|
Index de performance sur la colonne date_donnee |
|
btree |
|
id_maille |
|
|
Index de performance sur la colonne id_maille |
Triggers
There are no triggers for table data_meteo_aladin45_futur
Rules
There are no rules for table data_meteo_aladin45_futur
Policies
There are no policies for table data_meteo_aladin45_futur
Referenced
There are no tables referenced by table data_meteo_aladin45_futur
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
474417500 |
Pages |
3953480 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.data_meteo_aladin45_futur (
id_maille INTEGER NOT NULL,
date_donnee TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL,
tempmoy REAL,
rayonnement_global REAL,
dsat REAL,
vent2m REAL,
pluvio REAL,
CONSTRAINT data_meteo_aladin45_futur_pkey PRIMARY KEY(id_maille, date_donnee)
) ;
CREATE INDEX x_btr_date_data_meteo_aladin45_futur ON public.data_meteo_aladin45_futur
USING btree (date_donnee);
COMMENT ON INDEX public.x_btr_date_data_meteo_aladin45_futur
IS 'Index de performance sur la colonne date_donnee';
CREATE INDEX x_btr_maille_data_meteo_aladin45_futur ON public.data_meteo_aladin45_futur
USING btree (id_maille);
COMMENT ON INDEX public.x_btr_maille_data_meteo_aladin45_futur
IS 'Index de performance sur la colonne id_maille';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |