martin-heusse / gresi-monitor

MIT License
1 stars 2 forks source link

Theoric and Optimal production compute on zoomChart #15

Open Gashmob opened 2 years ago

Gashmob commented 2 years ago
  1. Adding functions in js to compute theoric and optimal production of solar panel for a given date. The result is showed on the second graph (zoomChart).

  2. Update database :

    • Delete localization and peak_power columns on *meters tables
    • Make name column unique on *meters tables
    • Adding table metersdata :
      metersdata ( 
      name varchar(256) primary key, 
      longitude float not null, 
      latitude float not null, 
      peak_power float not null, 
      azimuth float not null, 
      tilt float not null 
      )
    • Adding foreign key on *meters(name) references metersdata(name)