JCKalt / General-Work

Modeling database
0 stars 0 forks source link

eyedro device report modeling #117

Open JCKalt opened 9 months ago

JCKalt commented 9 months ago

Representing what I know about Christi's reports so far. A report as she has shown it is a set of "hours" that get tagged with a report date (5pm-5pm on given tz) and an device_enabled status. (on/off).

e.g.

Report groups set of time sequential "buckets" of equal duration

Report-Id: Description: Customer-Id: Report-Type:
Enable-Pattern: start-off (always) Start-Timestamp: End-Timestamp: Display-Group-Id: Bucket-Start-Seconds-Local: e.g 5pm Bucket-Duration: 1-day,2-day,week,month