UPDATES AND OPTIMIZATIONS
UPDATES AND OPTIMIZATIONS

Created pharmacy_audit_return table
Created phar_aud_ret_seq table
Created trg_aud_ret_seq trigger

Modified patient_category table
-Dropped patient_id column
-Populated the tabe with status values

Modified Patient Table
-Modified patient_status from varchar(255) to int(2)
-Modified date_checkin from not null to default null
-Created foreign key of patient_status referenceing patient_category(category_id)

Modified discharge_schedule table
-Dropped patient_id unique index

Modified Billing table
-dropped column room_price
-dropped column pharm_price
-dropped column lab_price
-dropped column rad_price
-dropped column csr_price
-added column date_paid datetime
-modified column date_submitted from timestamp to datetime
-added column date_updated timestamp

Modified lalboratory_request
-dropped column lab_patient_checkin

Modified csr_request table
-added patient_id column
-linked patient_id column to patient(patient_id) 

Modified purchasing_csr table
jj6584/his,jj6584/his,jj6584/his