DateTime for Bookings etc

[isabellethorpe]

Also want to start off by saying instead of calling Booking a Booking I've called the Model Appointment as it made more sense

Within the models Appointment and Prescription we are meant to have both a date and time of

• time of booking
• the actual appointment time
• prescription order time

As we are able to access time from TimeDate do we need a separate time datatype? I think it is possible to separate the two in ASP. Not sure if we need to model it...

[JHuggins11]

DateTime will work for the times in the models. I only added Time as a separate data type in the ERD as I was using Visual Paradigm to draw it and it had separate Time and Timestamp data types when setting the field properties. Quite a few of the built-in data types in Visual Paradigm for the ERD aren't an exact match to the data types in C# (e.g. it has VARCHAR for text but that would just be a String in C#, Date would be DateTime).

EDIT: Oh, I didn't realise the DateOnly and TimeOnly data types existed. Those may work better than DateTime then.