bubblesnet
commented
1 year ago - ac_device, checked, outletid_outlet can be null if no outlet attached
- additive, checked, spec_url can be null if no url
- alertcondition, checked, longmessage can be null??, remedied_datetimemillis can be null before remedy, eventid_event can be null if not attached to an event
- automationsettings, checked
- contact, checked, all can be null??? - fix it
- crop, checked
- currentevent, checked, subeventdatetimemillis null if no subevent, floatvalue,intvalue,textvalue null if none, time(???)
- device, lastseen null if never seen, devicename, externalid, log_level, picamera (fix!), resolutionx/y, usbcamera(fix!), lastpicture_filename/ lastpicture_datetimemillis if no pictures yet
- devicetype, checked, all nullable (fix!!)
- dispenser, checked, currently_loaded_additive null if no additive yet,
- displaysettings, checked
- event, checked, subeventdatetimemillis null if no subevent (subevent isn't implemented), floatvalue,intvalue,textvalue null if none, stringvalue nullable(FIX!!), time(???), units/valuename nullable if not measurement
- growlog, stationid/deviceid null if not attached to station, chemicaladdedamount/units null if no addition, action, freeform_text, seedid_seed, seed_name all null(??),
- module, checked, i2caddress null if not i2c, protocol null (FIX!!)
- notification, checked, alertcondition null if didn't come from alert(FIX!!), datetimemillis (FIX!!)
- outlet, checked, onoff nullable (check!!)
- plant, checked
- registrationcode, checked, deviceid_device/usedatemillis null if not registered yet,
- seed, checked seed_url null if none,
- sensor, checked, extraconfig/calibration null if none,
- site, checked
- station, checked
- user, checked, username (CHECK!!),, userid/created/timezone/provisioned null (FIX!!), deleted if still active, passwordsalt if no pw set yet, mobilenumber if not set
- usersettings, checked
see item #71 - lots of attributes that should be not-null/default something are neither. check entire DB