
INSERT INTO cara.medical_info (patient_id,allergies,drug_contraindictions,implants) VALUES (1,'Cobalt\nAspirine','none','Pacemaker\nHip Joint');

INSERT INTO cara.study (patient_id,cara_id,hosp_id,cara_desc,hosp_desc,cara_study_code,hosp_study_code,modality,laterality,incidence,date,prescription_date,prescribing_physician,hospital,responsable_physician,events,contrast_product,contrast_product_volume,isotope,activity,dicom_ids,report,status) VALUES (1,'cara543','hosp34533','caraDesc','XRAY of left arm','carastudy123','hospstudy123','CR','sinister','incidence',{ts '2007-01-02 15:56:40'},{ts '2007-01-01 09:22:40'},'Walter','CHEM','Müller','no events','no contrast product',0,'no isotope',0,null,null,'planed');
INSERT INTO cara.study (patient_id,cara_id,hosp_id,cara_desc,hosp_desc,cara_study_code,hosp_study_code,modality,laterality,incidence,date,prescription_date,prescribing_physician,hospital,responsable_physician,events,contrast_product,contrast_product_volume,isotope,activity,dicom_ids,report,status) VALUES (1,'cara23452343','hosp345432','caraDesc','BREAST','carastudy3424','hospstudy123464','DR','','incidence',{ts '2006-09-10 15:56:40'},{ts '2006-09-12 09:22:40'},'Schmidt','Hopital Kirchberg','Walter','no events','no contrast product',0,'no isotope',0,null,null,'planed');
INSERT INTO cara.study (patient_id,cara_id,hosp_id,cara_desc,hosp_desc,cara_study_code,hosp_study_code,modality,laterality,incidence,date,prescription_date,prescribing_physician,hospital,responsable_physician,events,contrast_product,contrast_product_volume,isotope,activity,dicom_ids,report,status) VALUES (1,'cara123','hosp123','caraDesc','CT of Head','carastudy123','hospstudy123','CT','median','incidence',{ts '2007-03-06 15:56:40'},{ts '2007-03-04 09:22:40'},'Meier','CHL','Schulz','no events','no contrast product',0,'no isotope',0,null,'some text...','done');
INSERT INTO cara.study (patient_id,cara_id,hosp_id,cara_desc,hosp_desc,cara_study_code,hosp_study_code,modality,laterality,incidence,date,prescription_date,prescribing_physician,hospital,responsable_physician,events,contrast_product,contrast_product_volume,isotope,activity,dicom_ids,report,status) VALUES (1,'cara23452343','hosp345432','caraDesc','BODY','carastudy3424','hospstudy123464','NM','','incidence',{ts '2004-03-10 15:56:40'},{ts '2004-03-12 09:22:40'},'Meier','CHL','Frank','no events','no contrast product',0,'no isotope',0,null,'more text','done');
INSERT INTO cara.study (patient_id,cara_id,hosp_id,cara_desc,hosp_desc,cara_study_code,hosp_study_code,modality,laterality,incidence,date,prescription_date,prescribing_physician,hospital,responsable_physician,events,contrast_product,contrast_product_volume,isotope,activity,dicom_ids,report,status) VALUES (1,'cara543','hosp34533','caraDesc','XRAY of head','carastudy123','hospstudy123','DR','proximal','incidence',{ts '2005-12-10 15:56:40'},{ts '2005-12-12 09:22:40'},'Walter','CHL','Müller','no events','no contrast product',0,'no isotope',0,'12312343546456456',null,'done');
INSERT INTO cara.study (patient_id,cara_id,hosp_id,cara_desc,hosp_desc,cara_study_code,hosp_study_code,modality,laterality,incidence,date,prescription_date,prescribing_physician,hospital,responsable_physician,events,contrast_product,contrast_product_volume,isotope,activity,dicom_ids,report,status) VALUES (1,'cara23452343','hosp345432','caraDesc','BODY','carastudy3424','hospstudy123464','MR','','incidence',{ts '2006-09-10 15:56:40'},{ts '2006-09-12 09:22:40'},'Schmidt','CHL','Walter','no events','no contrast product',0,'no isotope',0,'12341234146647235345134','other text','done');
