3:08 PM
@Igor If you write my username preceded by the "@" sign e.g. @MDCCL I receive a chat message notification.
Well, then (7) What are the attributes that you want to keep track of at the exact point in time when a letter is being sent, perhaps, letter number, date of departure, warehouse of departure, warehouse of destination, sender and courier?
(8) Do you know beforehand (e.g., at the point in time when a letter is being sent) who is going to be the receiver of a letter at the destination warehouse?
(9) What are the attributes that you want to keep track of when a letter is being transported, maybe, courier, point of location, vehicule number?
5 hours later…
8:05 PM
@MDCCL
6. Yes.
7. Yes, maybe except sender - see (8)
8. In my design sender is only the original sender of a letter (client of the company) and receiver (recipient) is a person to which letters is addressed - there is always one sender and one recipient for a letter. Who receives letter at a warehouse is not really my concern - I only care about which warehouse it is.
9. Yes, courier, vehicle and location.
6. Yes.
7. Yes, maybe except sender - see (8)
8. In my design sender is only the original sender of a letter (client of the company) and receiver (recipient) is a person to which letters is addressed - there is always one sender and one recipient for a letter. Who receives letter at a warehouse is not really my concern - I only care about which warehouse it is.
9. Yes, courier, vehicle and location.
10. No, for one transport there can only be one courier.
11. Only time and date of receptions and courier.
12. Letter cannot be transported back to the same warehouse after being put to the destination warehouse, however, if transport haven't reached destination warehouse (there was accident and transport must go back), then letter can return.
11. Only time and date of receptions and courier.
12. Letter cannot be transported back to the same warehouse after being put to the destination warehouse, however, if transport haven't reached destination warehouse (there was accident and transport must go back), then letter can return.
« first day next day → last day (43 days later) »
Transcript for
Nov2
Nov '163
Nov4
Discussion on question by Igor: How t…
Imported from a comment discussion on dba.stackexchange.com/qu...