123
Tables (10)
ALARM
- id — INT
- sensor_id — VARCHAR(50) — NOT NULL
- alarm — VARCHAR(100) — NOT NULL
- kind — VARCHAR(50) — NOT NULL
- time — DATETIME — NOT NULL
- color — VARCHAR(20) — NOT NULL
Forecast_WEATHER
- uid — INT
- category — VARCHAR(50) — NOT NULL
- fcst_value — VARCHAR(100) — NOT NULL
- fcst_date — DATE — NOT NULL
- fcst_time — TIME — NOT NULL
- nx — INT — NOT NULL
- ny — INT — NOT NULL
Historical_WeatherData
- WeatherDataID — INT
- Date — DATE — NOT NULL
- Time — TIME — NOT NULL
- Temperature — FLOAT — NOT NULL
- Humidity — FLOAT — NOT NULL
- Precipitation — FLOAT
- WindSpeed — FLOAT — NOT NULL
- Cloudiness — FLOAT
LOGIN_FAIL_LOG
- id — INT
- user_uid — INT — NOT NULL
- fail_count — INT — NOT NULL
- last_date — DATETIME — NOT NULL
LOGIN_HISTORY
- id — INT
- user_uid — INT — NOT NULL
- ip — VARCHAR(39) — NOT NULL
- login_date — DATETIME — NOT NULL
SENSOR
- id — INT
- sensor_id — VARCHAR(50) — NOT NULL
- temp — FLOAT — NOT NULL
- humi — FLOAT — NOT NULL
- wl — FLOAT — NOT NULL
- con — FLOAT — NOT NULL
- ax — FLOAT — NOT NULL
- ay — FLOAT — NOT NULL
- az — FLOAT — NOT NULL
- time — DATETIME — NOT NULL
SENSORS
- uid — INT
- sensor_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- lat — FLOAT — NOT NULL
- lon — FLOAT — NOT NULL
- create_date — DATETIME — NOT NULL
SensorDataHourly
- HourlyDataID — INT
- SensorID — VARCHAR(50) — NOT NULL
- Hour — DATETIME — NOT NULL
- AverageTemperature — FLOAT — NOT NULL
- AverageHumidity — FLOAT — NOT NULL
- AverageWaterLevel — FLOAT — NOT NULL
- AverageConductivity — FLOAT — NOT NULL
- AverageInclinationX — FLOAT — NOT NULL
- AverageInclinationY — FLOAT — NOT NULL
- AverageInclinationZ — FLOAT — NOT NULL
USER
- uid — INT
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- salt — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
User_Sensor
- user_id — INT
- sensor_id — INT