Open bsoetaer opened 9 years ago
bsoetaer
commented
9 years ago May want to do this later and have separate DBs for development so we don't screw with each other's data.
A setup script for setting up the DB and populating it some would be good for now to get everyone started and have in case the data is messed up.
bsoetaer
commented
9 years ago Have default database table setup scripts from project description. Added a default admin user to this setup file which adds an admin user with the username admin and password admin.
If we need more in depth data later consider using sql ldr to add data. Haven't done this yet as I am not sure what data will be needed. DB constraints must be observed for the sql ldr (can't add a row to pacs_images if the record_id doesn't already exist in the radioloy_record table) Link to quick sqlldr tutorial: http://www.thegeekstuff.com/2012/06/oracle-sqlldr/
Create Database tables: users(user_name,password,class,person_id,date_registered) persons(person_id,first_name,last_name,address,email,phone) family_doctor(doctor_id,patient_id) radiology_record(record_id,patient_id,doctor_id,radiologist_id,test_type,prescribing_date,test_date,diagnosis, description) pacs_images(record_id,image_id,thumbnail,regular_size,full_size)
Share database tables with team. We can add additional tables later if needed.