Any changes will be documented here. This can be anything from taking something out of a form, ro changing a data type, as these are the things i need to keep a record of.
7/4 Geocoding
I forgot that i need to keep the geocode for each address. I will add this into the form when i get to implementation. Also this will have to be calculated every time the user edits an existing address or adds a new address.
Pirmary Keys
Figuring out whether some of the ID's should be integers or characters. Most likely this will change.
Client Table
I have moved the phone number and fax number into the client addresses table. Mainly because if a client has many locations, obviously each of these locations is going to have their own phone number and fax number.. derrr!
15/4 Street Number
Changed this to a string in case the number is something like 31 b etc.
15/4 Management Table
Added in a table to hold data about the business that is using the application. Mainly this is to keep information about where the business is located, so when the map is made and the user selects start from home, it knows where this is. Rename table to management instead of manage.
17/4 Change management table
Renamed manage to management. Also split this into two different tables as the one business may have many locations.
17/4 Prioritys
I forgot to add in how the user will determine the priority of a task. I am thinking i will allow them to mark jobs as urgent.
28/4 Table Changes
I changed the user permission PK to a composite key instead of a surrogate one.
AFTER DESIGN STAGE AND INTO IMPLEMENTATION PHASE ONE
2/5 Database Desisions
Decided to merge back management tables seing as the reason i put them back together was because i forgot about the one to many relationship haha.
2/5 User Permissions
Decided that i would take out the permission table and user/permission table for now. I am leaning towards just using microsofts user authentication.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment