Timeline for How to model the database tables for calculating on peak and off peak usage data
Current License: CC BY-SA 3.0
37 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 11, 2018 at 6:52 | history | protected | gnat | ||
| Apr 11, 2018 at 6:04 | answer | added | Ahmed Syed | timeline score: -1 | |
| Apr 11, 2018 at 1:36 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 12, 2018 at 0:59 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 10, 2018 at 0:49 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 11, 2018 at 12:53 | comment | added | Sean Burton | I might suggest further normalising the periods by replacing PeakStartTime, PeakDuration, OffPeakStartTime and OffPeakDuration with PeriodType(Peak, Offpeak, etc), PeriodStartTime, PeriodDuration. This would allow you to add other period types to the day without having to add new columns. Will also support more than one period of each type in a day, for example an off-peak period at the beginning of the day, on-peak during the middle of the day, then another off-peak period at the end of the day. | |
| Jan 10, 2018 at 23:56 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 11, 2017 at 23:14 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 11, 2017 at 22:38 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 12, 2017 at 21:40 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 12, 2017 at 20:29 | answer | added | TheCatWhisperer | timeline score: 1 | |
| Sep 12, 2017 at 20:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 13, 2017 at 19:16 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 14, 2017 at 18:32 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 14, 2017 at 17:51 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 15, 2017 at 17:14 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 15, 2017 at 16:14 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 16, 2017 at 16:09 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 14, 2017 at 15:49 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 15, 2017 at 15:10 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 16, 2016 at 14:21 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 16, 2016 at 14:21 | answer | added | David Aldridge | timeline score: -1 | |
| Nov 16, 2016 at 12:55 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 17, 2016 at 12:14 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 17, 2016 at 11:44 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 18, 2016 at 11:26 | answer | added | Joel Brown | timeline score: -1 | |
| Aug 18, 2016 at 8:38 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 19, 2016 at 8:37 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 19, 2016 at 7:59 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 20, 2016 at 7:09 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 20, 2016 at 21:41 | comment | added | scorpion05 | Cool. This is much better than what I was thinking - putting start time and duration instead of putting start time and end time. | |
| Apr 20, 2016 at 16:48 | comment | added | Robert Harvey | The columns in your configuration table should be: ConfigurationID, ContractID, DayOfWeek, PeakStartTime, PeakDuration, OffPeakStartTime, OffPeakDuration | |
| Apr 20, 2016 at 16:42 | comment | added | scorpion05 | That is true. But in my where clause I would need to get the time intervals for on peak and off peak usage. So I am wondering what is the best way to model the on peak and off peak configuration so that I can easily use them in the where clause of my usage table. | |
| Apr 20, 2016 at 6:19 | answer | added | Kilian Foth | timeline score: 1 | |
| Apr 20, 2016 at 5:40 | comment | added | Robert Harvey | All you need is the data table you described in the first paragraph of your question. You can write any query against that usage table that you need, including days, days of the week months, year over year by day, and so on. | |
| Apr 20, 2016 at 4:58 | review | First posts | |||
| Apr 21, 2016 at 12:34 | |||||
| Apr 20, 2016 at 4:55 | history | asked | scorpion05 | CC BY-SA 3.0 |