Link to Source to Patient and Visit tables - UPDATED Saturday 3/27/10 at 1:30p

Class:

I had made an entry in Nicole's post about the schema, but in case you did not see my post there, I am creating a separate post to hightlight the MySQL source code to create the tables "Patient" and "Visit". You will need to create the MySQL database with a name of "mayoproject". (without the quotes of course)

Here is the link to the source:

Source file on GoogleDocs

UPDATE:
There was an error in the original posting of the source for the create table for patient in the height and weigth fields. They should have been 5,1 and not the 4,1 and 3,1 that was posted earlier. I have updated the source on Google Docs as well.