/*sudo -u dolphin psql -U dolphin -d dolphin -W < initdata.sql*/ INSERT INTO d_facility (id, facilityid, facilityname, zipcode, address, telephone, url, registereddate, membertype) VALUES (1,'1.3.6.1.4.1.9414.10.1','シルククリニック','231-0023','横浜市中区山下町1番地','045-681-5251','http://www.hospital.jp','2014-12-30','FACILITY_USER'); INSERT INTO d_users (id, userid, password, sirname, givenname, commonname, license, licensedesc, licensecodesys, department, departmentdesc, departmentcodesys, membertype, memo, registereddate, email, facility_id) VALUES (2,'1.3.6.1.4.1.9414.10.1:admin','21232f297a57a5a743894a0e4a801fc3','オープン','ドルフィン','オープン ドルフィン','doctor','医師','MML0026','01','内科','MML0028','FACILITY_USER','\N','2014-12-30','admin@hospital.jp',1); INSERT INTO d_roles (id, user_id, c_role, c_user) VALUES (3,'1.3.6.1.4.1.9414.10.1:admin','admin',2); INSERT INTO d_roles (id, user_id, c_role, c_user) VALUES (4,'1.3.6.1.4.1.9414.10.1:admin','user',2); |
カルテ番号,患者名,採取日時,GOT,GPT,LDH,ALP,.... 0001,ヤマダタロウ,2012/03/04,30,40,200,300,.... 0002,ヤマダハナコ,2012/03/04,20,30,250,250,.... .... |
/*sudo -u dolphin psql -U dolphin -d dolphin -W < insert_patient.sql*/ INSERT INTO d_patient (id,facilityid, fullname, kananame, gender, patientid,birthday) VALUES (1,'1.3.6.1.4.1.9414.10.1','テスト カンジャイチ','テスト カンジャイチ','male','00001','1935-10-10'); INSERT INTO d_patient (id,facilityid, fullname, kananame, gender, patientid,birthday) VALUES (2,'1.3.6.1.4.1.9414.10.1','テスト カンジャニ','テスト カンジャニ','male','00002','1935-10-10'); INSERT INTO d_karte (id, created, patient_id) VALUES (1,'2014-12-22',1); INSERT INTO d_karte (id, created, patient_id) VALUES (2,'2014-12-22',2); |