database/init_scripts/create_table.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

create table if not exists station (
   id                integer,
   name              varchar(100),
   locationid        int null,
   installation_date date
);

create table if not exists climameasures (
   stationname  varchar(255),
   measurevalue int null,
   unit         float null,
   currenttime  timestamp default current_timestamp
);


create table if not exists climameasures (
   stationname  varchar(255),
   measurevalue int null,
   unit         float null,
   currenttime  timestamp default current_timestamp
);