--(3)术语表（Term）
begin transaction;
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1,NULL,0,'Registro del examen',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(11,1,0,'Motivo de consulta',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1101,11,1,'Prurito vulvar',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1102,11,1,'Prurito vaginal',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1103,11,1,'Ardor vulvar',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1104,11,1,'Ardor vaginal',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1105,11,1,'Ulceración de la vulva',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1106,11,1,'Neoplasias de la vulva',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1107,11,1,'Eritroplasia de la vulva',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1108,11,1,'Vulvodinia ',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1109,11,1,'Dolor abdominal',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1110,11,1,'Distensión abdominal',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,'Relaciones sexuales con dolor',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1113,11,1,'Relaciones sexuales con sangre',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1114,11,1,'Secreción blanca espesa',NULL,14,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1115,11,1,'Secreción verdosa',NULL,15,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1116,11,1,'Secreción blanquecina',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1117,11,1,'Secreción blanca y amarilla',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1118,11,1,'Menstruación irregular',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1119,11,1,'Examinar',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,'Cambios celulares inflamatorios (tricomoniasis, candidiasis, vaginosis bacteriana, actinobacterias, herpes, etc.)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90103,901,1,'Cambios celulares reactivos (inflamación, atrofia, tratamiento con radiación, anticonceptivos)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90104,901,1,'Células glandulares después de histerectomía',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90105,901,1,'Células endometriales normales presentes en el útero a los 40 años',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90106,901,1,'Hiperqueratosis',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 (células glandulares atípicas no especificadas, endocervicales)',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90113,901,1,'AGC-NOS (células glandulares atípicas no especificadas, endometriales)',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90114,901,1,'AGC-NOS (células glandulares atípicas no especificadas, indeterminadas)',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90115,901,1,'AGC-FN (células glandulares atípicas probablemente neoplásicas, endocervicales)',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90116,901,1,'AGC-FN (células glandulares atípicas probablemente neoplásicas, indeterminadas)',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 (endocervical)',NULL,18,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90119,901,1,'Adenocarcinoma (endometrial)',NULL,19,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90120,901,1,'Adenocarcinoma (extrauterino)',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90121,901,1,'Adenocarcinoma (indeterminado)',NULL,21,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90122,901,1,'No proporcionados con citología',NULL,22,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90401,904,1,'Prueba ADN de VPH +',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90402,904,1,'Prueba ADN de VPH -',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90403,904,1,'VPH 16',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90404,904,1,'VPH 18',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90405,904,1,'12 tipos de alto riesgo, excepto VPH 16 y 18',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90406,904,1,'VPH A9 de alto riesgo',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90407,904,1,'VPH A7 de alto riesgo',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90408,904,1,'VPH A5/A6 de alto riesgo',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91101,911,1,'Epitelio escamoso original (maduro)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91102,911,1,'Epitelio escamoso original (atrófico)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91103,911,1,'Epitelio cilíndrico',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91104,911,1,'Epitelio cilíndrico (ectópico)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91105,911,1,'Epitelio escamoso metaplásico',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91106,911,1,'Quistes de Naboth',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91107,911,1,'Aberturas de criptas (glándula)',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91108,911,1,'Deciduosis en embarazo',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91109,911,1,'Yodada de Lugol: tinción parcial',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91110,911,1,'Yodada de Lugol: con tinción',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91111,911,1,'Sangrado endocervical',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91112,911,1,'Sangrado cervical',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91401,914,1,'Ausencia de vasos',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91402,914,1,'Epitelio acetoblanco fino y suave',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91403,914,1,'Epitelio acetoblanco denso',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91404,914,1,'Epitelio acetoblanco invisible',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91405,914,1,'Punteado fino y simétrico',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91406,914,1,'Punteado grueso y asimétrico',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91407,914,1,'Mosaico fino y simétrico',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91408,914,1,'Mosaico grueso y asimétrico',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91409,914,1,'Yodada de Lugol: sin tinción',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91410,914,1,'Yodada de Lugol: tinción parcial',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91411,914,1,'Yodada de Lugol: con tinción',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91412,914,1,'Leucoplasia',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91413,914,1,'Sangrado endocervical',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91414,914,1,'Sangrado cervical',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91701,917,1,'Vasos atípicos',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91702,917,1,'Vasos frágiles',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91703,917,1,'Superficie irregular',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91704,917,1,'Lesión exofítica',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,'Ulceración (necrótica)',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91707,917,1,'Tumor/neoplasia macroscópica',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92101,921,1,'Zona de transformación congénita',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92102,921,1,'Condiloma',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92103,921,1,'Pólipo (ectocervical)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92104,921,1,'Pólipo (endocervical)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92105,921,1,'Pólipo',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92106,921,1,'Inflamación/infección',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92107,921,1,'Estenosis cervical',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92108,921,1,'Anomalía congénita',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92109,921,1,'Efectos del tratamiento',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,'Erosión (traumática)',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92112,921,1,'Quiste',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92113,921,1,'Estenosis vaginal',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92401,924,1,'Posible invasión (cervical)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92402,924,1,'Posible invasión (vaginal)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92403,924,1,'Posible invasión (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,'VAIN de alto grado',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92406,924,1,'VIN de alto grado',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,'VAIN de bajo grado',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92409,924,1,'VIN de bajo grado',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92410,924,1,'Resultados normales de la colposcopia',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92411,924,1,'Zona de transformación congénita',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92412,924,1,'Condiloma cervical',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92413,924,1,'Condiloma vaginal',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92414,924,1,'Condiloma vulvar',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92415,924,1,'Pseudocondiloma genital',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92416,924,1,'Pólipo cervical',NULL,16,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92417,924,1,'Pólipo vaginal',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,'Estenosis cervical',NULL,21,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92422,924,1,'Estenosis vaginal',NULL,22,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92423,924,1,'Anomalía congénita',NULL,23,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92424,924,1,'Efectos del tratamiento',NULL,24,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92425,924,1,'Endometriosis cervical',NULL,25,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92426,924,1,'Endometriosis vaginal',NULL,26,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92427,924,1,'Mioma cervical',NULL,27,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92428,924,1,'Mioma submucoso del útero',NULL,28,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92429,924,1,'Tras histerectomía total',NULL,29,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92430,924,1,'Erosión epitelial de la vagina (traumática)',NULL,30,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92431,924,1,'Quistes vaginales',NULL,31,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92432,924,1,'Herpes vulvar',NULL,32,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92433,924,1,'Ulceración vulvar',NULL,33,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92434,924,1,'Distrofia vulvar',NULL,34,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92701,927,1,'Biopsia cervical',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92702,927,1,'Biopsia de varios puntos y ECC',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92703,927,1,'Biopsia de varios puntos',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92704,927,1,'ECC (legrado endocervical)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92705,927,1,'Diagnóstico por conización',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92706,927,1,'Tratamiento completo',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92707,927,1,'Seguimiento',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92708,927,1,'Polipectomía cervical',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92709,927,1,'Polipectomía y biopsia a 180° y 360° a la derecha',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92710,927,1,'Se recomienda fisioterapia',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92711,927,1,'Biopsia vulvar',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92712,927,1,'Biopsia vaginal',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92713,927,1,'Biopsia de neoplasia',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92714,927,1,'Revisión 6 semanas después del parto',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92715,927,1,'Revisión a los 3 de embarazo',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93101,931,1,'Cambios inflamatorios en el tejido cervical',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93102,931,1,'Epitelio escamoso metaplásico',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93103,931,1,'Cambios atróficos en el epitelio escamoso',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93104,931,1,'Degeneración decidual',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93105,931,1,'Condiloma plano',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93106,931,1,'Hiperqueratosis',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93107,931,1,'Ausencia de epitelio escamoso',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93108,931,1,'NIC-1',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93109,931,1,'NIC-2',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93110,931,1,'NIC-3',NULL,10,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93111,931,1,'Afectación glandular',NULL,11,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93112,931,1,'Afectación glandular amplia',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93113,931,1,'Carcinoma escamoso microinvasor',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93114,931,1,'Carcinoma escamoso invasor',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,'Adenocarcinoma invasor',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93117,931,1,'Infiltración linfocítica',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93118,931,1,'Condiloma genital',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93119,931,1,'Pólipo',NULL,19,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93120,931,1,'Granuloma inflamatorio',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,'Extraiga la gasa a las 24 h. Siga indicaciones del médico y una buena higiene. No tenga relaciones sexuales ni tome baños en 15 días y evite actividades intensas. Puede haber hemorragia vaginal leve en los 10 días siguientes. Si el sangrado es más abundante que en una menstruación normal, acuda al médico. Vuelva a revisión con la historia clínica para que le indiquen tratamiento de seguimiento.',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94702,947,1,'Extraiga la gasa a las 24 h. Siga las indicaciones del médico y tenga una buena higiene.',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94703,947,1,'No tenga relaciones sexuales ni tome baños durante 15 días y evite las actividades intensas.',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94704,947,1,'Puede producirse hemorragia vaginal leve en los 10 días siguientes. Si el sangrado es más abundante que en una menstruación normal, acuda al médico.',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94705,947,1,'Siga las indicaciones del médico. Vuelva a revisión con la historia clínica para que le indiquen un tratamiento de seguimiento.',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97101,971,1,'Hemorragia activa (vasos frágiles)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97102,971,1,'Superficie irregular',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97103,971,1,'Lesión exofítica (excluyendo condiloma y pólipos)',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,'Ulceración (necrótica)',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97106,971,1,'Tumor/neoplasia macroscópica',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97201,972,1,'Rápida aparición de epitelio acetoblanco denso con bordes afilados',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97202,972,1,'Signo de borde',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97203,972,1,'Signo de borde interno',NULL,30,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97204,972,1,'Orificios glandulares blancos',NULL,40,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97501,975,1,'Cervicitis crónica',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97502,975,1,'Lesión condilomatosa (o lesiones coilocíticas)',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97503,975,1,'NIC-1',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97504,975,1,'NIC-2',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97505,975,1,'NIC-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,'Carcinoma escamoso cervical',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,'Extraiga la gasa a las 24 h. Siga indicaciones del médico y una buena higiene. No tenga relaciones sexuales, tome baños ni realice actividades intensas durante 1 mes. Tome la medicación como se le ha indicado. Podría tener exudado vaginal acuoso durante 10 días y hemorragia leve los 10 días siguientes. Si el sangrado es más abundante que en una menstruación normal o tiene fiebre, vaya al médico.',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97702,977,1,'Extraiga la gasa a las 24 h. Siga las indicaciones del médico y tenga una buena higiene.',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97703,977,1,'No tenga relaciones sexuales, tome baños o realice actividades intensas durante 2 meses.',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97704,977,1,'Tome la medicación como le ha indicado el médico.',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97705,977,1,'Podría tener exudado vaginal acuoso durante 10 días y hemorragia leve los 10 días siguientes. Si el sangrado es más abundante que en una menstruación normal o tiene fiebre, vaya al médico.',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98101,981,1,'Acetoblanqueamiento tenue (no completamente opaco)',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98102,981,1,'Acetoblanqueamiento indiferenciado',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98103,981,1,'Acetoblanqueamiento transparente o translúcido',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98104,981,1,'Área acetoblanca más allá del borde de la zona de transformación',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98105,981,1,'Color blanco nieve e intenso brillo (raro)',0,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98106,981,1,'Coloración intermedia y blanquecina y superficie brillante (la mayoría de las lesiones deben clasificarse en esta categoría)',1,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98107,981,1,'Pálido, opaco, blanco ostra',2,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98108,981,1,'Gris',2,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98401,984,1,'Contorno con microcondilomas y micropapilares',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98402,984,1,'Lesiones planas sin márgenes claros',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98403,984,1,'Bordes en forma de pluma o finamente dentados',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98404,984,1,'Lesiones anguladas y melladas',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98405,984,1,'Lesiones satélites más allá del borde de la zona de transformación',0,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98406,984,1,'Lesiones con formas regulares y simétricas con bordes suaves y rectos.',1,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98407,984,1,'Bordes enrollados escamosos',2,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98408,984,1,'Demarcaciones internas entre zonas de apariencia colposcópica dispar: una central de cambios mayores y otra periférica de cambios menores',2,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98701,987,1,'Capilares finos, cercanos, de calibre y disposición uniforme',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98702,987,1,'Patrones vasculares mal formados de punteado o mosaico finos',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98703,987,1,'Vasos más allá del borde de la zona de transformación',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98704,987,1,'Capilares finos en lesiones microcondilomatosas o micropapilares',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98705,987,1,'Ausencia de vasos',1,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98706,987,1,'Punteado o mosaico grueso bien definido, nítidamente delineado y dispuesto amplia y aleatoriamente',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99101,991,1,'Captación positiva de yodo que confiere al tejido un color castaño-caoba',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99102,991,1,'Lesión insignificante que no capta la tinción con yodo, es decir, tinción amarilla de una lesión con tres o menos puntos en los tres primeros criterios',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99103,991,1,'Zonas más allá del borde de la zona de transformación, que resaltan en la colposcopia por ser yodo negativas (suelen deberse a paraqueratosis)',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99104,991,1,'Captación parcial de yodo; aspecto moteado, jaspeado',1,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99105,991,1,'Lesión significativa que no capta la tinción con yodo, es decir, tinción amarilla de una lesión con cuatro o más puntos en los tres primeros criterios',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,'NIC-3',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99202,992,1,'NIC-2',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99203,992,1,'Colposcopia defectuosa, ASIL, NIC-1',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99204,992,1,'Colposcopia defectuosa, ASC-H, NIC-1',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99205,992,1,'Colposcopia defectuosa, AGC, NIC-1',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99206,992,1,'NIC-1 persistente durante 2 años',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,'Hiperplasia de la mucosa cervical',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99302,993,1,'Hiperplasia/excrecencia cervical',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99303,993,1,'Hiperplasia/excrecencia vaginal',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99304,993,1,'Hiperplasia/excrecencia vulvar',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99305,993,1,'Hiperplasia/excrecencia perineal',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99401,994,1,'Primer área: longitud () anchura ()',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99402,994,1,'Segunda área: longitud () anchura ()',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99403,994,1,'Tercera área: longitud () anchura ()',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,'Ninguna ',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95202,952,1,'Transparente',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95203,952,1,'Turbio, lechoso (ni transparente ni opaco)',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95204,952,1,'Distinto, blanco opaco',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95301,953,1,'Difuso',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95302,953,1,'Satélites blancos "geográficos" con filos pero irregulares',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95303,953,1,'Bien diferenciada y lisa, diferencia a nivel de la superficie, incluyendo "blancos"',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95401,954,1,'Fina, regular',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95402,954,1,'Ausente',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95403,954,1,'Gruesa',2,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95404,954,1,'Atípica',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 a 15 mm ',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95503,955,1,'2 cuadrantes',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 a 4 cuadrantes',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95506,955,1,'De forma endocervical',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95601,956,1,'Marrón',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95602,956,1,'Débilmente amarilla',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95603,956,1,'En parches amarillos',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95604,956,1,'Amarilla distinta',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;