From e9f3d47100fd5f61342af0a6f8e1abbe3bea9093 Mon Sep 17 00:00:00 2001 From: Luiz Gustavo Monteiro Date: Sun, 26 Oct 2025 14:36:11 -0300 Subject: Added database model --- database/init_scripts/create_table.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'database/init_scripts') diff --git a/database/init_scripts/create_table.sql b/database/init_scripts/create_table.sql index 8ee801a..ae5b3d1 100644 --- a/database/init_scripts/create_table.sql +++ b/database/init_scripts/create_table.sql @@ -1,3 +1,18 @@ +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, -- cgit v1.2.3