ALTER TABLE exam DROP CONSTRAINT exam_type;
ALTER TABLE exam ADD CONSTRAINT exam_type FOREIGN KEY (exam_type) REFERENCES exam_type (type_no) MATCH SIMPLE;
UPDATE db_version SET db_version=1.05;
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010001, 1010001, '胆嚢異常なし', 'The gallbladder within normal limits', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010010, 1010010, '胆嚢一部描出不良', 'The gallbladder cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010020, 1010020, '胆嚢描出不能', 'The gallbladder cannot be visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010100, 1010100, '胆嚢ポリープ', 'Gallbladder polyps', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010200, 1010200, '胆嚢腫瘤', 'Gallbladder tumors', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010300, 1010300, '胆嚢腺筋腫症', 'Adenomyomatosis', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010400, 1010400, 'びまん性胆嚢壁肥厚', 'Diffuse gallbladder wall thickening', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010500, 1010500, '胆嚢腫大', 'Enlarged gallbladder', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010600, 1010600, '胆嚢結石', 'Gallbladder stones', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010700, 1010700, '胆嚢結石または胆嚢気腫', 'Gallbladder stones or pneumobilia', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010800, 1010800, '胆砂', 'Biliary sand', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1010900, 1010900, '胆泥', 'Biliary sludge', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1011000, 1011000, '胆嚢壁評価不良', 'The gallbladder wall cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1012000, 1012000, '胆嚢摘出後', 'After gallbladder removal', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020001, 1020001, '肝外胆管異常なし', 'Extrahepatic bile duct within normal limits', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020010, 1020010, '肝外胆管一部描出不良', 'Extrahepatic bile duct cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020020, 1020020, '肝外胆管描出不能', 'Extrahepatic bile duct cannot be visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020100, 1020100, '肝外胆管拡張', 'Extrahepatic bile duct dilatation', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020200, 1020200, '肝外胆管結石', 'Stones in extrahepatic bile duct', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020300, 1020300, '肝外胆管デブリ', 'Sludge in extrahepatic bile duct', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020400, 1020400, '肝外胆管腫瘍', 'Extrahepatic bile duct tumors', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020500, 1020500, '肝外胆管壁肥厚', 'Extrahepatic bile duct wall thickening', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1020600, 1020600, '肝外胆管気腫', 'Pneumobilia in extrahepatic bile duct', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030001, 1030001, '肝異常所見なし', 'The liver within normal limits', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030010, 1030010, '肝一部描出不良', 'The liver cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030020, 1030020, '肝描出不能', 'The liver cannot be visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030100, 1030100, '肝腫瘍', 'Liver tumors', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030200, 1030200, '肝血管腫', 'Liver hemangiomas', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030300, 1030300, '肝嚢胞', 'Liver cysts', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030400, 1030400, '肝嚢胞性腫瘍', 'Cystic tumors of the liver', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030500, 1030500, '肝内石灰化', 'Liver calcification', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030600, 1030600, '肝内胆管結石または気腫', 'Intrahepatic bile duct stones or Pneumobilia', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030700, 1030700, '脂肪肝', 'Fatty liver', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030800, 1030800, '慢性肝障害', 'Chronic hepatopathy', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1030900, 1030900, '肝内胆管拡張', 'Intrahepatic bile duct dilatation', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1031000, 1031000, '肝血管異常', 'Vascular disorders of the liver', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040001, 1040001, '脾異常所見なし', 'The spleen within normal limits', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040010, 1040010, '脾一部描出不良', 'The spleen cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040020, 1040020, '脾描出不能', 'The spleen cannot be visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040100, 1040100, '脾腫', 'Enlarged spleen', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040200, 1040200, '副脾', 'Accesory spleen', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040300, 1040300, '脾内石灰化', 'Splenic calcification', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040400, 1040400, '脾嚢胞', 'Splenic cysts', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040500, 1040500, '脾腫瘤', 'Splenic tumors', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040600, 1040600, '脾嚢胞性腫瘍', 'Cystic masses of the spleen', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040700, 1040700, '脾門部腫瘤', 'Tumors at the splenic hilum', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1040800, 1040800, '脾門部異常血管', 'Abnormalities of splenic hilar vessels', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1042000, 1042000, '脾摘出後', 'After spleen removal', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050001, 1050001, '膵異常所見なし', 'The pancreas within normal limits', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050010, 1050010, '膵一部描出不良', 'The pancreas cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050020, 1050020, '膵描出不能', 'The pancreas cannot be visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050100, 1050100, '膵管拡張', 'The pancreatic duct dilatation', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050200, 1050200, '膵嚢胞', 'Pancreatic cysts', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050300, 1050300, '膵萎縮', 'Pancreatic atrophy', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050400, 1050400, '膵石', 'Pancreatic stones', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050500, 1050500, '膵腫瘤', 'Pancreatic tumors', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050600, 1050600, '膵嚢胞性腫瘍', 'Cystic tumors of the pancreas', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050700, 1050700, '膵腫大', 'Enlarged pancreas', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1050800, 1050800, '変形', 'Deformed pancreas', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060001, 1060001, '腎異常所見なし', 'Kidneys within normal limits', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060010, 1060010, '腎一部描出不良', 'Kidneys cannot be well visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060020, 1060020, '腎描出不能', 'Kidneys cannot be visualized', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060100, 1060100, '腎嚢胞', 'Kedney cysts', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060200, 1060200, '腎嚢胞性腫瘤', 'Cystic tumors of the kidney', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060300, 1060300, '多発性嚢胞腎', 'Polycystic kidney disease', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060400, 1060400, '腎腫瘤', 'Kidney tumors', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060500, 1060500, '腎血管筋脂肪腫', 'Renal angiomyolipoma', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060600, 1060600, '腎石灰化', 'Renal calcification', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060700, 1060700, '腎結石', 'Kidney stones', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060800, 1060800, '腎盂拡張', 'Pyelectasis', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1060900, 1060900, '水腎症', 'Hydronephrosis', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1061000, 1061000, '腎の変形', 'Deformed kidney', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1061100, 1061100, '腎腫大', 'Enlarged kidney', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1061200, 1061200, '腎萎縮', 'Atrophic kidney', TRUE);
INSERT INTO diag_name (no, diag_order, name_jp, name_eng, diag_visible) VALUES(1062000, 1062000, '腎摘出後', 'After kidney removal', TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1000000, 1000000, 1000000, 'Abdomen', '腹部', 0, TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1010000, 1010001, 1019999, 'Gallbladder', '胆嚢', 1, TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1020000, 1020001, 1029999, 'Extrahepatic bile duct', '肝外胆管', 2, TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1030000, 1030001, 1039999, 'Liver', '肝臓', 3, TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1040000, 1040001, 1049999, 'Spleen', '脾臓', 1, TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1050000, 1050001, 1059999, 'Pancreas', '膵臓', 2, TRUE);
INSERT INTO diag_category (id, start_no, end_no, name_eng, name_jp, bt_order, visible) VALUES(1060000, 1060001, 1069999, 'Kidney', '腎臓', 3, TRUE);
UPDATE default_findings SET findings=E'GB：\r\nCBD： mm、IHBD dilatation（）\r\nLiver：edge sharp、surface smooth、実質均一\r\n　　　 肝腎ｺﾝﾄﾗｽﾄ（）、深部減衰（）\r\n　　 　脈管の不明瞭化（）\r\nPancreas：正常・腫大・萎縮（体部の太さ mm）\r\n　　　　　内部ｴｺｰ（↑→↓・均一・不均一）、MPD mm\r\nSpleen：\r\nKidney：\r\n膀胱：\r\n前立腺：××mm→g\r\n子宮・卵巣：' WHERE exam_type=1001;
UPDATE default_findings SET findings=E'大きさ： 右葉　××mm(normal,swelling)\r\n　　　　　左葉　××mm(normal,swelling)\r\n　　　　　峡部厚　mm(normal,swelling)\r\n実質エコー：homogenous,heterogenous、血流増加（）\r\n右葉：\r\n左葉：' WHERE exam_type=1002;
UPDATE default_findings SET findings=E'【右】：［総頚動脈径体部］\r\n　　　　　 内径拡大：（）\r\n　　　 　　プラーク：（）\r\n　　　　　 内膜の表面性状：平滑、やや不整、不整、潰瘍形成\r\n　　　 　　平均IMT：　mm\r\n               PSV:  cm/s   、EDV:  cm/s\r\n               RI:   、PI:   \r\n　　　 ［球部～内頚動脈］\r\n　　　 　　プラーク：（）\r\n　　　 　　内膜の表面性状：平滑、やや不整、不整、潰瘍形成\r\n【左】：［総頚動脈径体部］\r\n　　　　　 内径拡大：（）\r\n　　　　 　プラーク：（）\r\n　　　　 　内膜の表面性状：平滑、やや不整、不整、潰瘍形成\r\n　　　　 　平均IMT：　mm\r\n               PSV:  cm/s   、EDV:  cm/s\r\n               RI:   、PI:   \r\n　　    ［球部～内頚動脈］\r\n　　　 　　プラーク：（）\r\n　　　　 　内膜の表面性状：平滑、やや不整、不整、潰瘍形成' WHERE exam_type=1003;
UPDATE default_findings SET findings=E'右：\r\n左：' WHERE exam_type=1004;
UPDATE default_findings SET findings=E'MV：EF slope  mm/sec、MR（－,±,1+,2+,3+）\r\n        Prolapse(AML,PML)　、MVA  cm2\r\nLV inflow：E波　cm/s、A波　cm/s、\r\n　　           E/A　、A/E　、DcT　ms\r\nLV outflow：velocity  cm/s\r\nLV：IVST　mm、PWT mm、\r\n　　 LVDd  mm、LVDs　mm、\r\n       EDV ml、ESV ml、SV ml、\r\n       CO  l/min   (HR )\r\n　　 EF　%、FS　%\r\n　　 asynergy（）\r\nLA：LAD　mm　、Trombus()\r\nAO：AoD　mm         　　LA/Ao\r\nAV：AVD mm、　AR（－,±,1+,2+,3+） 、AVA  cm2\r\n右心系：dilatation()、RVD  mm\r\nTV： TR（－,±,1+,2+,3+）、V m/sec、PG mmHg、\r\n        推定RVP mmHg\r\nPV：PR（－,±,1+,2+,3+）\r\nIVC：　mm（呼吸性変動 有無）\r\n【Comment】' WHERE exam_type=1005;
INSERT INTO words (words1, words2, words3, operator) VALUES('異常所見なし', '描出不良', 'mm', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('×', 'SE', 'Acoustic shadow', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('辺縁低エコー帯', '後方エコー', '外側陰影', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('cyst', 'cystic echo', '摘出後', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('polyp', 'debris', 'sludge', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('stone', 'comet-like echo', 'sonolucent layer', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('頸部', '体部', '底部', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('左葉', '右葉', 'dull', 'Abdomen US');
INSERT INTO words (words1, words2, words3, operator) VALUES('mosaic pattern', 'chameleon sign', 'wax and wane sign', 'Abdomen US');