1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| ID_DATA integer primary key,
ID_OBS integer,
BURP_BTYP integer,
VCOORD integer,
VARNO integer,
VCOORD_TYPE integer,
OBSVALUE real,
FLAG integer,
OMP real,
OMA real,
OBS_ERROR real,
FG_ERROR real
)
table|HEADER|HEADER|3|CREATE TABLE HEADER (
ID_OBS integer primary key,
ID_STN varchar (50),
LAT real,
LON real,
CODTYP integer,
DATE integer,
TIME integer,
STATUS integer,
DELAY integer,
RUNN integer,
OARS integer,
ELEV real
)
table|OmF|OmF|4|CREATE TABLE OmF (
ID_OBS integer,
ID_DATA integer,
FHOUR integer,
OMF real
)
index|idx1|DATA|793|CREATE INDEX idx1 ON DATA(ID_OBS, VCOORD,VARNO)
index|idx2|OmF|1115|CREATE INDEX idx2 ON OMF(ID_DATA, FHOUR)
table|sqlite_stat1|sqlite_stat1|1116|CREATE TABLE sqlite_stat1(tbl,idx,stat)
table|resume|resume|1117|CREATE TABLE resume(date integer , time integer , run varchar(9))
table|rdb4_schema|rdb4_schema|1119|CREATE TABLE rdb4_schema( schema varchar(9) ) |
Partager