Define Table Weather Info

bahrain-bp / mun-aquacrop

This repository will include the MUN AquaCorp challenge artifacts

0 stars 1 forks source link

Define Table Weather Info #8

Open izZERO opened 2 weeks ago

izZERO commented 2 weeks ago

(subject to change) CREATE TABLE WeatherReadings ( RID NUMERIC AUTO_INCREMENT NOT NULL, date DATE NOT NULL, radiation NUMERIC(10) NOT NULL, air_temp NUMERIC(10) NOT NULL, humidity NUMERIC(10) NOT NULL, wind_speed NUMERIC(10) NOT NULL, PRIMARY KEY (RID) );

chebibj commented 1 week ago

Can you add more details for each field? Field Definition, Data type, size, etc