Timeline for Database design for a timesheet app?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 19, 2018 at 14:38 | comment | added | Zakaria Naji | employees in this company work two shifts in one day(08-12 and 14-18). so one employee can work for exemple only the moring in one day or even two seperate projects the next day. how do you suggest to handle this? | |
| Aug 18, 2018 at 23:43 | comment | added | Michael - sqlbot | "two separate projects" sounds like an antipattern. It is often a sign of bad strategy to specify a constraint involving a number other than 0, 1, or ∞. See the Zero One Infinity Rule. Columns like project_id_1 and project_id_2 would be the big red flag, here. | |
| Aug 18, 2018 at 14:23 | vote | accept | Zakaria Naji | ||
| Aug 18, 2018 at 14:26 | |||||
| Aug 18, 2018 at 14:15 | vote | accept | Zakaria Naji | ||
| Aug 18, 2018 at 14:21 | |||||
| Aug 18, 2018 at 13:47 | answer | added | Germano Manente Neto | timeline score: 0 | |
| Aug 18, 2018 at 12:58 | comment | added | Philᵀᴹ | "I'm designing the database schema for a time tracking application and I need a little piece of advice. " -- edit your question with what you have designed so far, we're not going to do this for you | |
| Aug 18, 2018 at 12:55 | history | edited | Zakaria Naji | CC BY-SA 4.0 |
added 1 character in body
|
| Aug 18, 2018 at 12:49 | history | edited | Zakaria Naji | CC BY-SA 4.0 |
added 1 character in body
|
| Aug 18, 2018 at 12:40 | review | First posts | |||
| Aug 18, 2018 at 18:24 | |||||
| Aug 18, 2018 at 12:37 | history | asked | Zakaria Naji | CC BY-SA 4.0 |