--(3)术语表（Term）
begin transaction;
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1,NULL,0,'Examination Record',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(11,1,0,'Chief Complaint',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1101,11,1,'Vulvar pruritus',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1102,11,1,'Vaginal pruritus',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1103,11,1,'Vulvar burning',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1104,11,1,'Vaginal burning',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1105,11,1,'Vulvar ulceration',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1106,11,1,'Vulvar neoplasm',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1107,11,1,'Vulvar erythroplasia',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1108,11,1,'Vulvodynia',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1109,11,1,'Abdominal pain',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1110,11,1,'Abdominal distension',NULL,10,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1111,11,1,'Lumbago',NULL,11,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1112,11,1,'Intercourse with pain',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1113,11,1,'Intercourse with blood',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1114,11,1,'Soybean curd residue discharge',NULL,14,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1115,11,1,'Greenish discharge',NULL,15,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1116,11,1,'Hoar discharge',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1117,11,1,'Leukorrhagia and yellow',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1118,11,1,'Irregual menstruation',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1119,11,1,'Examine',NULL,19,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(9,NULL,0,'RVW',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(901,9,0,'TCT',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(904,9,0,'HPV',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(907,9,0,'RECENTDIG',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(911,9,0,'NOMALCOPFINDING',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(914,9,0,'ABNOMALCOPFINDING',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(917,9,0,'INVASIVECANCER',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(921,9,0,'MISCELLANEOUS',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(924,9,0,'PRIDIAG',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(927,9,0,'TREAT',NULL,10,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(931,9,0,'BIOPSYDIAG',NULL,11,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(934,9,0,'TRANSFERREMARK',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(937,9,0,'RECENTDIGREMARK',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(941,9,0,'COLPFINDINGREMARK',NULL,14,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(944,9,0,'PRIDIAGREMARK',NULL,15,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(947,9,0,'TREATRMARK',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(951,9,0,'BIOPSYDIAGREMARK',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(971,9,0,'ORIGINALSEE',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(973,9,0,'OPSPROCESS',NULL,19,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(975,9,0,'OPSDIAGAFTER',NULL,20,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(977,9,0,'OPSATTENTION',NULL,21,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(981,9,0,'COLOR',NULL,22,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(984,9,0,'MARGIN',NULL,23,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(987,9,0,'VESSEL',NULL,24,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(991,9,0,'IODINE',NULL,25,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(990,9,0,'FITCYTOLOGY',NULL,26,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(992,9,0,'FITPATHOLOGY',NULL,27,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(993,9,0,'FITOTHER',NULL,28,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(994,9,0,'MELT',NULL,29,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(995,9,0,'RING',NULL,30,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(996,9,0,'TRIANGLE',NULL,31,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(997,9,0,'SQUARE',NULL,32,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(998,9,0,'ACUS',NULL,33,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(999,9,0,'SPHERICITY',NULL,34,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(972,9,0,'HIGHLESION',NULL,35,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(952,9,0,'Aceto uptake',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(953,9,0,'Margin/surface',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(954,9,0,'Vessels',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(955,9,0,'Lesion size',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(956,9,0,'Iodine Staining',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(957,9,0,'Remark Term',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90101,901,1,'NILM',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90102,901,1,'Inflammatory cell changes (trichomoniasis, candidiasis, bacterial vaginosis, actinomycetes, herpes, etc.)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90103,901,1,'Reactive cell changes (Inflammation, atrophy, radiation therapy, contraception)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90104,901,1,'Glandular cells after hysterectomy',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90105,901,1,'Normal endometrial cells visible in the uterus of a woman of age 40',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90106,901,1,'Hyperkeratosis',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90107,901,1,'ASC-US',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90108,901,1,'ASC-H',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90109,901,1,'LSIL',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90110,901,1,'HSIL',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90111,901,1,'SCC',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90112,901,1,'AGC-NOS (atypical glandular cells not specified, in cervical canal)',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90113,901,1,'AGC-NOS (atypical glandular cells not specified, in endometrium)',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90114,901,1,'AGC-NOS (atypical glandular cells not specified, uncertain)',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90115,901,1,'AGC-FN (atypical glandular cells favoring neoplasia, in cervical canal)',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90116,901,1,'AGC-FN (atypical glandular cells favoring neoplasia, uncertain)',NULL,16,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90117,901,1,'AIS (Adenocarcinoma In Situ)',NULL,17,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90118,901,1,'Adenocarcinoma (in cervical canal)',NULL,18,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90119,901,1,'Adenocarcinoma (in endometrium)',NULL,19,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90120,901,1,'Adenocarcinoma (outside the uterus)',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90121,901,1,'Adenocarcinoma (uncertain)',NULL,21,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90122,901,1,'Not satisfied with cytology',NULL,22,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90401,904,1,'HPV DNA test +',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90402,904,1,'HPV DNA test -',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90403,904,1,'HPV 16',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90404,904,1,'HPV 18',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90405,904,1,'12 high-risk types, excluding HPV16 and HPV18',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90406,904,1,'High-risk HPV A9',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90407,904,1,'High-risk HPV A7',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90408,904,1,'High-risk HPV A5/A6',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91101,911,1,'Original squamous epithelium (Mature)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91102,911,1,'Original squamous epithelium (Atrophic)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91103,911,1,'Columnar epithelium',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91104,911,1,'Columnar epithelium (Ectopy)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91105,911,1,'Metaplastic squamous epithelium',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91106,911,1,'Nabothian cysts',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91107,911,1,'Crypt (gland) openings',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91108,911,1,'Deciduosis in pregnancy',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91109,911,1,'Lugol''s staining: partially stained',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91110,911,1,'Lugol''s staining: stained',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91111,911,1,'Endocervical bleeding',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91112,911,1,'Cervical bleeding',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91401,914,1,'Absent vessels',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91402,914,1,'Smooth, thin acetowhite epithelium',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91403,914,1,'Dense acetowhite epithelium',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91404,914,1,'Acetowhite epithelium invisible',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91405,914,1,'Fine, symmetrical punctuation',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91406,914,1,'Coarse, unsymmetrical punctuation',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91407,914,1,'Fine, symmetrical mosaic',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91408,914,1,'Coarse, unsymmetrical mosaic',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91409,914,1,'Lugol''s staining: non-stained',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91410,914,1,'Lugol''s staining: partially stained',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91411,914,1,'Lugol''s staining: stained',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91412,914,1,'Leukoplakia',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91413,914,1,'Endocervical bleeding',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91414,914,1,'Cervical bleeding',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91701,917,1,'Atypical vessels',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91702,917,1,'Fragile vessels',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91703,917,1,'Irregular surface',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91704,917,1,'Exophytic lesion',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91705,917,1,'Necrosis',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91706,917,1,'Ulceration (necrotic)',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91707,917,1,'Tumor/gross neoplasm',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92101,921,1,'Congenital transformation zone',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92102,921,1,'Condyloma',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92103,921,1,'Polyp(ectocervical)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92104,921,1,'Polyp(endocervical)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92105,921,1,'Polyp',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92106,921,1,'Inflammation/infection',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92107,921,1,'Cervical stenosis',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92108,921,1,'Congenital anomaly',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92109,921,1,'Post treatment consequence',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92110,921,1,'Endometriosis',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92111,921,1,'Erosion (traumatic)',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92112,921,1,'Cyst',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92113,921,1,'Vaginal stenosis',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92401,924,1,'Suspicious for invasion (cervical)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92402,924,1,'Suspicious for invasion (vaginal)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92403,924,1,'Suspicious for invasion (vulvar)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92404,924,1,'HSIL',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92405,924,1,'High-grade VAIN',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92406,924,1,'High-grade VIN',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92407,924,1,'LSIL',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92408,924,1,'Low-grade VAIN',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92409,924,1,'Low-grade VIN',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92410,924,1,'Normal colposcopic findings',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92411,924,1,'Congenital transformation zone',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92412,924,1,'Cervical condyloma',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92413,924,1,'Vaginal condyloma',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92414,924,1,'Vulvar condyloma',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92415,924,1,'Pseudo genital warts',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92416,924,1,'Cervical polyp',NULL,16,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92417,924,1,'Vaginal polyp',NULL,17,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92418,924,1,'Cervicitis',NULL,18,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92419,924,1,'Vaginitis',NULL,19,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92420,924,1,'Vulvitis',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92421,924,1,'Cervical stenosis',NULL,21,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92422,924,1,'Vaginal stenosis',NULL,22,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92423,924,1,'Congenital anomaly',NULL,23,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92424,924,1,'Post treatment consequence',NULL,24,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92425,924,1,'Cervical endometriosis',NULL,25,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92426,924,1,'Vaginal endometriosis',NULL,26,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92427,924,1,'Cervical myoma',NULL,27,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92428,924,1,'Submucous myoma of uterus',NULL,28,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92429,924,1,'Post total hysterectomy',NULL,29,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92430,924,1,'Vaginal epithelium erosion (traumatic)',NULL,30,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92431,924,1,'Vaginal cysts',NULL,31,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92432,924,1,'Vulvar herpes',NULL,32,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92433,924,1,'Vulvar ulceration',NULL,33,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92434,924,1,'Vulvar dystrophy',NULL,34,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92701,927,1,'Cervical biopsy',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92702,927,1,'Multipoint biopsy and ECC',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92703,927,1,'Multipoint biopsy',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92704,927,1,'ECC (Endocervical curettage)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92705,927,1,'Diagnostic conization',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92706,927,1,'Comprehensive treatment',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92707,927,1,'Follow-up',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92708,927,1,'Cervical polypectomy',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92709,927,1,'Polypectomy and biopsy in 6 and 12 o''clock direction',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92710,927,1,'Physical therapy is recommended',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92711,927,1,'Vulvar biopsy',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92712,927,1,'Vaginal biopsy',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92713,927,1,'Neoplasm biopsy',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92714,927,1,'Reexamination 6 weeks after childbirth',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92715,927,1,'Reexamination after 3 months of pregnancy',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93101,931,1,'Inflammatory changes in cervical tissue',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93102,931,1,'Squamous epithelium metaplasia',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93103,931,1,'Atrophic changes in squamous epithelium',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93104,931,1,'Decidual degeneration',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93105,931,1,'Condyloma latum',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93106,931,1,'Hyperkeratosis',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93107,931,1,'Lack of squamous epithelium',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93108,931,1,'CIN-1',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93109,931,1,'CIN-2',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93110,931,1,'CIN-3',NULL,10,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93111,931,1,'Glandular involvement',NULL,11,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93112,931,1,'Extensive glandular involvement',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93113,931,1,'Microinvasive squamous carcinoma',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93114,931,1,'Invasive squamous carcinoma',NULL,14,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93115,931,1,'Adenocarcinoma in Situ(AIS)',NULL,15,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93116,931,1,'Invasive adenocarcinoma',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93117,931,1,'Lymphocytic infiltration',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93118,931,1,'Genital warts',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93119,931,1,'Polyp',NULL,19,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93120,931,1,'Inflammatory granuloma',NULL,20,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93121,931,1,'Tuberculosis',NULL,21,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94701,947,1,'Remove gauze 24h later. Follow doctor''s advice and keep good hygiene. Refrain from sexual intercourse and tub bath for half a month and avoid strenuous activity. Slight vaginal bleeding may occur in next 10 days. See a doctor immediately if the bleeding exceeds the most daily bleeding in menstruation. Go for reexamination with your medical record to determine the follow-up treatment.',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94702,947,1,'Remove gauze 24h later. Follow doctor''s advice and keep good hygiene.',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94703,947,1,'Refrain from sexual intercourse and tub bath for half a month and avoid strenuous activity.',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94704,947,1,'Slight vaginal bleeding may occur in next 10 days. See a doctor immediately if the bleeding exceeds the most daily bleeding in menstruation.',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94705,947,1,'Follow doctor''s advice. Go for reexamination with your medical record to determine the follow-up treatment.',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97101,971,1,'Active bleeding (fragile vessels)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97102,971,1,'Irregular surface',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97103,971,1,'Exophytic lesion (excluding condyloma and polyp)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97104,971,1,'Necrosis',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97105,971,1,'Ulceration (necrotic)',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97106,971,1,'Tumor/gross neoplasm',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97201,972,1,'Rapid appearance of dense acetowhite epithelium with sharp borders',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97202,972,1,'Ridge sign',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97203,972,1,'Inner border sign',NULL,30,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97204,972,1,'Cuffed crypt (gland) openings',NULL,40,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97501,975,1,'Chronic cervicitis',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97502,975,1,'Condylomatous lesions (or koilocytic lesions)',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97503,975,1,'CIN-1',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97504,975,1,'CIN-2',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97505,975,1,'CIN-3',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97506,975,1,'Adenocarcinoma in Situ(AIS)',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97507,975,1,'Cervical squamous carcinoma',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97508,975,1,'Adenocarcinoma',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97701,977,1,'Remove gauze 24h later. Follow doctor''s advice and keep good hygiene. Refrain from sexual intercourse and tub bath for 1 month and avoid strenuous activity. Take drug as instructed. The vagina may have slight water or watery discharge within 10 days and slight bleeding 10 days later. See a doctor immediately if the bleeding exceeds the most daily bleeding in menstruation or you experience a fever.',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97702,977,1,'Remove gauze 24h later. Follow doctor''s advice and keep good hygiene.',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97703,977,1,'Refrain from sexual intercourse and tub bath for 2 months and avoid strenuous activity.',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97704,977,1,'Take drug as instructed by the doctor.',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97705,977,1,'Vagina may have slight water or watery discharge in 10 days and slight bleeding 10 days later. See a doctor immediately if bleeding exceeds the most daily bleeding in menstruation or you have a fever.',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98101,981,1,'Low-intensity acetowhitening (not completely opaque)',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98102,981,1,'Indistinct acetowhitening',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98103,981,1,'Transparent or translucent acetowhitening',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98104,981,1,'Acetowhitening beyond the margin of the transformation zone',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98105,981,1,'Pure snow-white colour with intense surface shine (rare)',0,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98106,981,1,'Intermediate shade-grey/white color and shiny surface (most lesions should be scored in this category)',1,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98107,981,1,'Dull, opaque, oyster white',2,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98108,981,1,'Grey',2,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98401,984,1,'Microcondylomatous or micropapillary contour',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98402,984,1,'Flat lesions with indistinct margins',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98403,984,1,'Feathered or finely scalloped margins',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98404,984,1,'Angular, jagged lesions',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98405,984,1,'Satellite lesions beyond the margin of the transformation zone',0,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98406,984,1,'Regular-shaped, symmetrical lesions with smooth, straight outlines',1,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98407,984,1,'Rolled, peeling edges',2,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98408,984,1,'Internal demarcations between areas of differing colposcopic appearance - a central area of high-grade change and peripheral area of low-grade change)',2,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98701,987,1,'Fine/uniform-calibre vessels - closely and uniformly placed',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98702,987,1,'Poorly formed patterns of fine punctation and/or mosaic',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98703,987,1,'Vessels beyond the margin of the transformation zone',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98704,987,1,'Fine vessels within microcondylomatous or micropapillary lesions',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98705,987,1,'Absent vessels',1,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98706,987,1,'Well defined coarse punctation or mosaic, sharply demarcated - and randomly and widely placed',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99101,991,1,'Positive iodine uptake giving mahogany-brown color',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99102,991,1,'Negative iodine uptake of insignificant lesion, i.e., yellow staining by a lesion scoring three points or less on the first three criteria',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99103,991,1,'Areas beyond the margin of the transformation zone, conspicuous on colposcopy, evident as iodine-negative areas (such areas are frequently due to parakeratosis)',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99104,991,1,'Partial iodine uptake - variegated, speckled appearance',1,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99105,991,1,'Negative iodine uptake of significant lesion, i.e., yellow staining by a lesion already scoring four points or more on the frist three criteria',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99001,990,1,'HSIL',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99002,990,1,'AGC-FN',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99003,990,1,'AIS',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99201,992,1,'CIN-3',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99202,992,1,'CIN-2',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99203,992,1,'Inadequate colposcopy, ASIL, CIN-1',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99204,992,1,'Inadequate colposcopy, ASC-H, CIN-1',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99205,992,1,'Inadequate colposcopy, AGC, CIN-1',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99206,992,1,'CIN-1 persisting for 2 years',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99207,992,1,'VAIN',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99208,992,1,'VIN',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99301,993,1,'Cervical mucosa hyperplasia',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99302,993,1,'Cervical hyperplasia/excrescence',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99303,993,1,'Vaginal hyperplasia/excrescence',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99304,993,1,'Vulvar hyperplasia/excrescence',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99305,993,1,'Perineum hyperplasia/excrescence',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99401,994,1,'First area: length () width ()',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99402,994,1,'Second area: length () width ()',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99403,994,1,'Third area: length () width ()',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99501,995,1,'2.5*1.0',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99502,995,1,'2.0*2.0',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99503,995,1,'2.0*1.5',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99504,995,1,'2.0*1.0',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99505,995,1,'1.5*1.5',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99506,995,1,'1.0*1.0',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99601,996,1,'2.0*1.5',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99602,996,1,'2.0*1.0',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99603,996,1,'1.7*1.2',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99604,996,1,'1.5*1.0',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99605,996,1,'1.0*1.0',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99701,997,1,'1.0*1.0',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99702,997,1,'1.0*0.7',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99801,998,1,'0.8*16*120',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99802,998,1,'0.25*5*55',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99901,999,1,'5mm',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99902,999,1,'3mm',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95201,952,1,'None ',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95202,952,1,'Transparent',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95203,952,1,'Shady, milky (not transparent not opaque)',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95204,952,1,'Distinct, opaque white',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95301,953,1,'Diffuse',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95302,953,1,'Sharp but irregular, jagged, "geographical" satellites',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95303,953,1,'Sharp and even, difference in surface level including "cuffing"',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95401,954,1,'Fine, regular',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95402,954,1,'Absent',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95403,954,1,'Coarse',2,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95404,954,1,'Atypical',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95501,955,1,'<5 mm',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95502,955,1,'5-15 mm ',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95503,955,1,'2 quadrants',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95504,955,1,'>15 mm',2,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95505,955,1,'3-4 quadrants',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95506,955,1,'Endocervically',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95601,956,1,'Brown',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95602,956,1,'Faintly yellow',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95603,956,1,'Patchy yellow',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95604,956,1,'Distinct yellow',2,4,0);
commit transaction;	

--(9) Code	
delete from Code;
begin transaction;
	insert into Code(id,ctype,code,codename,seq) values (12,'DateFormat',NULL,'yyyy-mm-dd',1);
	insert into Code(id,ctype,code,codename,seq) values (13,'DateFormat',NULL,'mm/dd/yyyy',2);
	insert into Code(id,ctype,code,codename,seq) values (14,'DateFormat',NULL,'dd/mm/yyyy',3);
	insert into Code(id,ctype,code,codename,seq) values (15,'BigLoop','B0010','2.0*1.5',1);
	insert into Code(id,ctype,code,codename,seq) values (16,'BigLoop','B0020','2.0*1.2',2);
	insert into Code(id,ctype,code,codename,seq) values (17,'BigLoop','B0030','2.0*0.8',3);
	insert into Code(id,ctype,code,codename,seq) values (18,'MiddleLoop','M0010','1.5*1.0',1);
	insert into Code(id,ctype,code,codename,seq) values (19,'MiddleLoop','M0020','1.2*0.8',2);
	insert into Code(id,ctype,code,codename,seq) values (20,'SmallLoop','S0010','1.0*1.0',1);
	insert into Code(id,ctype,code,codename,seq) values (21,'SmallLoop','S0020','0.8*0.7',2);
	insert into Code(id,ctype,code,codename,seq) values (22,'Triangle','T0010','2.0*1.5',1);
	insert into Code(id,ctype,code,codename,seq) values (23,'Triangle','T0020','2.0*1.0',2);
	insert into Code(id,ctype,code,codename,seq) values (24,'Triangle','T0030','1.0*0.8',3);
commit transaction;

-- (10)用户表 UserDoctor
--delete from UserDoctor;
begin transaction;
commit transaction;