diff options
| author | Luiz Gustavo Monteiro <luizgu_mreis@hotmail.com> | 2025-10-26 14:36:11 -0300 |
|---|---|---|
| committer | Luiz Gustavo Monteiro <luizgu_mreis@hotmail.com> | 2025-10-26 14:36:11 -0300 |
| commit | e9f3d47100fd5f61342af0a6f8e1abbe3bea9093 (patch) | |
| tree | b914bab2b98f4974967fe3697a40b9daa51c27f8 /database/init_scripts | |
| parent | ba5f30be9f69d18cbb3ffe2d00ba9cf287b77f43 (diff) | |
Added database model
Diffstat (limited to 'database/init_scripts')
| -rw-r--r-- | database/init_scripts/create_table.sql | 15 |
1 files changed, 15 insertions, 0 deletions
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, |