/*Before you can run any of this script you must import the patient text into the patient Table, You also must have the ethnicity table created and populated */ use ClinicalDrugStudy /************************** Patient Table Updates by Rene Smiley 7/08/2008 ***************************/ UPDATE Patient SET patEmail='mjordan@hotmail.com', patGender='F', EthnicityID=1, patBirthDate ='1/23/1964', patStartDate ='7/01/2008' WHERE PatientID=1000; UPDATE Patient SET patEmail='tdanner@yahoo.com', patGender='M', EthnicityID=2, patBirthDate ='6/17/1972', patStartDate ='6/25/2008' WHERE PatientID=1003; UPDATE Patient SET patEmail='sterrance@gmail.com', patGender='F', EthnicityID=3, patBirthDate ='8/25/1982', patStartDate ='7/01/2008' WHERE PatientID=1006; UPDATE Patient SET patEmail='lcamlin@yahoo.com', patGender='M', EthnicityID=4, patBirthDate ='2/14/1976', patStartDate ='6/15/2008' WHERE PatientID=1009; UPDATE Patient SET patEmail='lsanderson@hotmail.com', patGender='M', EthnicityID=5, patBirthDate ='3/05/1967', patStartDate ='7/01/2008' WHERE PatientID=1012; UPDATE Patient SET patEmail='table@yahoo.com', patGender='F', EthnicityID=6, patBirthDate ='4/20/1959', patStartDate ='6/15/2008' WHERE PatientID=1015; UPDATE Patient SET patEmail='kevans@gmail.com', patGender='M', EthnicityID=5, patBirthDate ='5/31/1966', patStartDate ='6/25/2008' WHERE PatientID=1018; UPDATE Patient SET patEmail='bzukof@hotmail.com', patGender='M', EthnicityID=4, patBirthDate ='2/14/1969', patStartDate ='7/01/2008' WHERE PatientID=1021; UPDATE Patient SET patEmail='pmartinez@yahoo.com', patGender='M', EthnicityID=3, patBirthDate ='7/20/1962', patStartDate ='7/01/2008' WHERE PatientID=1024; UPDATE Patient SET patEmail='lpatterson@gmail.com', patGender='F', EthnicityID=2, patBirthDate ='8/08/1978', patStartDate ='6/15/2008' WHERE PatientID=1027; UPDATE Patient SET patEmail='bfranklin@hotmail.com', patGender='F', EthnicityID=1, patBirthDate ='9/22/1980', patStartDate ='7/01/2008' WHERE PatientID=1030; UPDATE Patient SET patEmail='skim@gmail.com', patGender='F', EthnicityID=1, patBirthDate ='10/18/1973', patStartDate ='7/01/2008' WHERE PatientID=1033; /********************* Insert for Doctor table ITC 224: Bi-Lan Chiong **********************/ USE ClinicalDrugStudy Insert into Doctor( docLastName, docFirstName, docAddress, docCity, docState, docZipCode) Values( 'Spock', 'Charles', '925 Minor Ave, Suite 522', 'Seattle', 'WA', '98122') Insert into Doctor( docLastName, docFirstName, docAddress, docCity, docState, docZipCode) Values( 'Freud', 'Sigmund', '325 Ninth Ave, Suite 201', 'Seattle', 'WA', '98104') Insert into Doctor( docLastName, docFirstName, docAddress, docCity, docState, docZipCode) Values( 'Seuss', 'Oscar', '1025 Broadway, Suite 1032', 'Seattle', 'WA', '98122') Insert into Doctor( docLastName, docFirstName, docAddress, docCity, docState, docZipCode) Values( 'Tanaka', 'Takashi', '725 Olive Way, Suite 2302', 'Seattle', 'WA', '98101') Insert into Doctor( docLastName, docFirstName, docAddress, docCity, docState, docZipCode) Values( 'Zelenkov', 'Margaret', '1725 Jefferson St, Suite 1056', 'Seattle', 'WA', '98122') /************************ Inserts for DoctorContact Hamere Anbesso **************************/ Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(1,'phone','206-542-4569') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(2,'email','ed@yahoo.com') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(3,'email','thomas@gmail.com') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(4,'phone','206-568-5789') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(5,'email','kls@gmail.com') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(2,'phone','206-456-7889') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(1,'email','klkl@yahoo.com') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(2,'phone','206-526-7856') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(5,'email','john@gmail.com') Insert into DoctorContact(DoctorID,drcContactType,drcContactinfo) values(4,10,'email','hillary@gmail.com') /*************** Inserts for Medical History Table Rebecca Luther ITC 224 ****************/ Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1000,1,1,1,1,1,1,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1003,1,0,1,0,1,0,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1006,0,1,0,1,0,1,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1009,0,0,0,0,0,0,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1012,1,1,1,1,1,1,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1015,1,0,1,0,1,0,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1018,0,1,0,1,0,1,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1021,1,1,1,0,0,0,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1024,0,0,0,1,1,1,'No Explanations Added Yet'); Insert into MedicalHistory (PatientID,mdhHeartDisease,mdhKidneydisease, mdhDiabetes, mdhLiverProblems,mdhDrugAbuse,mdhDepressionMedications, mdhExplanations) values (1027,1,1,0,0,1,1,'No Explanations Added Yet'); /************************* insert patient group Ali ****************************/ Insert into PatientGroup (PatientID, GroupID) Values(1000, 'A') Insert into PatientGroup (PatientID, GroupID) Values(1003, 'A') Insert into PatientGroup (PatientID, GroupID) Values(1006, 'A') Insert into PatientGroup (PatientID, GroupID) Values(1009, 'A') Insert into PatientGroup (PatientID, GroupID) Values(1012, 'A') Insert into PatientGroup (PatientID, GroupID) Values(1015, 'A') Insert into PatientGroup (PatientID, GroupID) Values(1018, 'B') Insert into PatientGroup (PatientID, GroupID) Values(1021, 'B') Insert into PatientGroup (PatientID, GroupID) Values(1024, 'B') Insert into PatientGroup (PatientID, GroupID) Values(1027, 'B') Insert into PatientGroup (PatientID, GroupID) Values(1030,'B') Insert into PatientGroup (PatientID, GroupID) Values(1033, 'B') /*******Inserts for Doctorpatient keziah koigi***********/ INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES (1,1000,'7/6/2006') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(2,1003,'5/6/2007') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(3,1006,'2/6/2007') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(4,1009,'2/6/2008') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(5,1012,'1/4/2008') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(1,1015,'4/4/2008') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(2,1018,'4/1/2006') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(3,1021,'2/6/2008') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(4,1024,'12/9/2008') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(5,1027,'11/4/2008') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(1,1030,'9/3/2006') INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient] ([DoctorID] ,[PatientID] ,[drpassigndate]) VALUES(1,1033,'2/9/2008') /*************************** Inserts for Appointment Derek Pavone ***************************/ Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(2,1003,'7/8/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(3,1006,'7/9/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(4,1009,'7/11/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(5,1012,'7/15/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(1,1015,'7/16/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(2,1018,'7/17/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(3,1021,'7/18/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(4,1024,'7/22/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(5,1027,'7/8/2008',0) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(1,1030,'7/22/2008',1) Insert into Appointment(DoctorID,PatientID,aptDate,aptKept) Values(2,1033,'7/23/2008',1) /************************************************ Inserts for appointmentDetail Lisa Huang ************************************************/ insert into AppointmentDetail(apdHeartRate, apdBloodPressureSystolic, apdBloodPressureDiastolic, apdBloodSugar, apdLiverEnzymes, apdDoctorNotes, apdTemperature) values( 75, 120,80,72,38.9,' I met with the patient for 30 minutes this afternoon. After the nurse had taken the blood pressure and other vitals, I asked how the patient was doing on the medication and if she had any concerns. The patient did admit to feeling "flat." I asked what she meant by that term and she explained that she wasnt feeling particularly depresseed, but that all of her emotions seemed to be leveled. Things that used to make her happy werent effecting her any more. the patient said she was having some trouble sleeping the patients appetite is down, though not gone. She says she isnt enjoying food as much as she used to The patient said she is feeling less depressed but not happy The patient said she has had no thoughts of suicide the patients general health is good the emotional flatness concerns me. Perhaps the base dosage is too large. Continue taking the medication Call with any concerns Schedule and appointment for next month I will check on the dosage ',98.5); insert into AppointmentDetail(apdHeartRate, apdBloodPressureSystolic, apdBloodPressureDiastolic, apdBloodSugar, apdLiverEnzymes, apdDoctorNotes, apdTemperature) values( 78, 110,75,80,45.9,' I met with the patient for 20 minutes this morning. After the nurse had taken the blood pressure and other vitals, I asked how the patient was doing on the medication and if she had any concerns. The patient did admit to feeling "flat." I asked what she meant by that term and she explained that she wasnt feeling particularly depresseed, but that all of her emotions seemed to be leveled. Things that used to make her happy werent effecting her any more. the patient said she was having some trouble sleeping the patients appetite is down, though not gone. She says she isnt enjoying food as much as she used to The patient said she is feeling less depressed but not happy The patient said she has had no thoughts of suicide the patients general health is good the emotional flatness concerns me. Perhaps the base dosage is too large. Continue taking the medication Call with any concerns Schedule and appointment for next month I will check on the dosage ',98.8); insert into AppointmentDetail(apdHeartRate, apdBloodPressureSystolic, apdBloodPressureDiastolic, apdBloodSugar, apdLiverEnzymes, apdDoctorNotes, apdTemperature) values( 80, 119,82,78,55.7,' I met with the patient for 20 minutes this morning. After the nurse had taken the blood pressure and other vitals, I asked how the patient was doing on the medication and if she had any concerns. The patient did admit to feeling "flat." I asked what she meant by that term and she explained that she wasnt feeling particularly depresseed, but that all of her emotions seemed to be leveled. Things that used to make her happy werent effecting her any more. the patient said she was having some trouble sleeping the patients appetite is down, though not gone. She says she isnt enjoying food as much as she used to The patient said she is feeling less depressed but not happy The patient said she has had no thoughts of suicide the patients general health is good the emotional flatness concerns me. Perhaps the base dosage is too large. Continue taking the medication Call with any concerns Schedule and appointment for next month I will check on the dosage ',97.9); insert into AppointmentDetail(apdHeartRate, apdBloodPressureSystolic, apdBloodPressureDiastolic, apdBloodSugar, apdLiverEnzymes, apdDoctorNotes, apdTemperature) values( 85, 122,81,85,43.6,' I met with the patient for 20 minutes this morning. After the nurse had taken the blood pressure and other vitals, I asked how the patient was doing on the medication and if she had any concerns. The patient did admit to feeling "flat." I asked what she meant by that term and she explained that she wasnt feeling particularly depresseed, but that all of her emotions seemed to be leveled. Things that used to make her happy werent effecting her any more. the patient said she was having some trouble sleeping the patients appetite is down, though not gone. She says she isnt enjoying food as much as she used to The patient said she is feeling less depressed but not happy The patient said she has had no thoughts of suicide the patients general health is good the emotional flatness concerns me. Perhaps the base dosage is too large. Continue taking the medication Call with any concerns Schedule and appointment for next month I will check on the dosage ',99.1); insert into AppointmentDetail(apdHeartRate, apdBloodPressureSystolic, apdBloodPressureDiastolic, apdBloodSugar, apdLiverEnzymes, apdDoctorNotes, apdTemperature) values( 68, 115,75,73,39.9,' I met with the patient for 20 minutes this morning. After the nurse had taken the blood pressure and other vitals, I asked how the patient was doing on the medication and if she had any concerns. The patient did admit to feeling "flat." I asked what she meant by that term and she explained that she wasnt feeling particularly depresseed, but that all of her emotions seemed to be leveled. Things that used to make her happy werent effecting her any more. the patient said she was having some trouble sleeping the patients appetite is down, though not gone. She says she isnt enjoying food as much as she used to The patient said she is feeling less depressed but not happy The patient said she has had no thoughts of suicide the patients general health is good the emotional flatness concerns me. Perhaps the base dosage is too large. Continue taking the medication Call with any concerns Schedule and appointment for next month I will check on the dosage ',98.5); insert into AppointmentDetail(apdHeartRate, apdBloodPressureSystolic, apdBloodPressureDiastolic, apdBloodSugar, apdLiverEnzymes, apdDoctorNotes, apdTemperature) values( 87, 130,87,120,88.9,' I met with the patient for 20 minutes this morning. After the nurse had taken the blood pressure and other vitals, I asked how the patient was doing on the medication and if she had any concerns. The patient did admit to feeling "flat." I asked what she meant by that term and she explained that she wasnt feeling particularly depresseed, but that all of her emotions seemed to be leveled. Things that used to make her happy werent effecting her any more. the patient said she was having some trouble sleeping the patients appetite is down, though not gone. She says she isnt enjoying food as much as she used to The patient said she is feeling less depressed but not happy The patient said she has had no thoughts of suicide the patients general health is good the emotional flatness concerns me. Perhaps the base dosage is too large. Continue taking the medication Call with any concerns Schedule and appointment for next month I will check on the dosage ',99.9);