Menu

#136 Redundant Column date in orders-Table

Structure
accepted
Database (5)
6
2013-09-13
2013-09-13
Anonymous
No

The orders Table has a Column called "date" that says at which date the meal can be fetched. But the meal itself has a date, too. This makes the date-Column in orders unnecessary; The date can be fetched with one join.
It even creates Bugs when changing the Date of the Meal without changing the dates of the Orders. This should not be the Case.

  • Delete the date-Column from the orders-Table
  • Rewrite the Queries accessing this Column to use the date of the meal-Table
    -[Also rename orders to Orders when we are at it, to make naming a little less confusing]

Discussion

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB