--(3)术语表（Term）
begin transaction;
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1,NULL,0,'Dossier examen',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(11,1,0,'Motif de consultation',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1101,11,1,'Prurit vulvaire',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1102,11,1,'Prurit vaginal',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1103,11,1,'Brûlures vulvaires',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1104,11,1,'Brûlures vaginales',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1105,11,1,'Ulcération vulvaire',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1106,11,1,'Néoplasmes vulvaires',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1107,11,1,'Erythroplasie vulvaire',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1108,11,1,'Vulvodynie ',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1109,11,1,'Douleur abdominale',NULL,9,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1110,11,1,'Distension abdominale',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,'Rapport sexuel douloureux',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1113,11,1,'Rapport sexuel avec perte de sang',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1114,11,1,'Pertes blanches épaisses',NULL,14,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1115,11,1,'Pertes verdâtres',NULL,15,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1116,11,1,'Pertes blanchâtres',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1117,11,1,'Pertes blanches et jaunes',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1118,11,1,'Règles irrégulières',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(1119,11,1,'Examiner',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,'Modification des cellules inflammatoires (trichomonase, candidose, vaginose bactérienne, actinomycètes, herpès, etc.)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90103,901,1,'Modification des cellules réactives (inflammation, atrophie, radiothérapie, contraception)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90104,901,1,'Cellules glandulaires après hystérectomie',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90105,901,1,'Cellules endométriales normales visibles dans l''utérus d''une femme de 40 ans',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90106,901,1,'Hyperkératose',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 (cellules glandulaires atypiques d''origine non précisée, dans le canal cervical)',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90113,901,1,'AGC-NOS (cellules glandulaires atypiques d''origine non précisée, dans l''endomètre)',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90114,901,1,'AGC-NOS (cellules glandulaires atypiques d''origine non précisée, zone incertaine)',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90115,901,1,'AGC-FN (cellules glandulaires atypiques suggérant une néoplasie, dans le canal cervical)',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90116,901,1,'AGC-FN (cellules glandulaires atypiques suggérant une néoplasie, zone incertaine)',NULL,16,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90117,901,1,'AIS (adénocarcinome in situ)',NULL,17,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90118,901,1,'Adénocarcinome (dans le canal cervical)',NULL,18,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90119,901,1,'Adénocarcinome (dans l''endomètre)',NULL,19,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90120,901,1,'Adénocarcinome (en dehors de l''utérus)',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90121,901,1,'Adénocarcinome (incertain)',NULL,21,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90122,901,1,'Cytologie non satisfaisante',NULL,22,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90401,904,1,'Test de dépistage du VPH +',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90402,904,1,'Test de dépistage du 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 types à haut risque, hormis VPH 16 et VPH 18',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90406,904,1,'VPH A9 à haut risque',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90407,904,1,'VPH A7 à haut risque',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(90408,904,1,'VPH A5/A6 à haut risque',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91101,911,1,'Epithélium pavimenteux originel (mature)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91102,911,1,'Epithélium pavimenteux originel (atrophique)',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91103,911,1,'Epithélium cylindrique',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91104,911,1,'Epithélium cylindrique (ectopie)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91105,911,1,'Epithélium pavimenteux métaplasique',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91106,911,1,'Œufs de Naboth',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91107,911,1,'Orifices cryptiques (glandulaires)',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91108,911,1,'Déciduose pendant la grossesse',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91109,911,1,'Coloration au Lugol : partiellement coloré',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91110,911,1,'Coloration au Lugol : coloré',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91111,911,1,'Saignements endocervicaux',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91112,911,1,'Saignements cervicaux',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91401,914,1,'Absence de vaisseaux',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91402,914,1,'Epithélium acéto-blanc lisse et fin',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91403,914,1,'Epithélium acéto-blanc dense',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91404,914,1,'Epithélium acéto-blanc invisible',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91405,914,1,'Ponctuation fine et symétrique',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91406,914,1,'Ponctuation épaisse et asymétrique',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91407,914,1,'Mosaïque fine et symétrique',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91408,914,1,'Mosaïque épaisse et asymétrique',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91409,914,1,'Coloration au Lugol : non coloré',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91410,914,1,'Coloration au Lugol : partiellement coloré',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91411,914,1,'Coloration au Lugol : coloré',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91412,914,1,'Leucoplasie',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91413,914,1,'Saignements endocervicaux',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91414,914,1,'Saignements cervicaux',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91701,917,1,'Vaisseaux atypiques',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91702,917,1,'Vaisseaux fragiles',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91703,917,1,'Surface irrégulière',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91704,917,1,'Lésion exophytique',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91705,917,1,'Nécrose',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91706,917,1,'Ulcération (nécrotique)',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(91707,917,1,'Tumeur/néoplasme évident',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92101,921,1,'Zone de transformation congénitale',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92102,921,1,'Condylome',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92103,921,1,'Polype (exocervical)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92104,921,1,'Polype (endocervical)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92105,921,1,'Polype',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,'Sténose cervicale',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92108,921,1,'Anomalie congénitale',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92109,921,1,'Conséquences post-traitement',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92110,921,1,'Endométriose',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92111,921,1,'Erosion (traumatique)',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92112,921,1,'Kyste',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92113,921,1,'Sténose vaginale',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92401,924,1,'Suspicion de lésion (cervicale) invasive',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92402,924,1,'Suspicion de lésion (vaginale) invasive',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92403,924,1,'Suspicion de lésion (vulvaire) invasive',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,'Néoplasie intraépithéliale vaginale de haut grade',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92406,924,1,'Néoplasie intraépithéliale vulvaire de haut grade',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,'Néoplasie intraépithéliale vaginale de bas grade',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92409,924,1,'Néoplasie intraépithéliale vulvaire de bas grade',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92410,924,1,'Résultats colposcopiques normaux',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92411,924,1,'Zone de transformation congénitale',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92412,924,1,'Condylome cervical',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92413,924,1,'Condylome vaginal',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92414,924,1,'Condylome vulvaire',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92415,924,1,'Pseudo-condylomes acuminés',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92416,924,1,'Polype cervical',NULL,16,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92417,924,1,'Polype vaginal',NULL,17,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92418,924,1,'Cervicite',NULL,18,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92419,924,1,'Vaginite',NULL,19,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92420,924,1,'Vulvite',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92421,924,1,'Sténose cervicale',NULL,21,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92422,924,1,'Sténose vaginale',NULL,22,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92423,924,1,'Anomalie congénitale',NULL,23,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92424,924,1,'Conséquences post-traitement',NULL,24,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92425,924,1,'Endométriose cervicale',NULL,25,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92426,924,1,'Endométriose vaginale',NULL,26,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92427,924,1,'Myome cervical',NULL,27,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92428,924,1,'Léiomyome utérin sous-muqueux',NULL,28,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92429,924,1,'Post-hystérectomie totale',NULL,29,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92430,924,1,'Erosion (traumatique) de l''épithélium vaginal',NULL,30,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92431,924,1,'Kystes vaginaux',NULL,31,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92432,924,1,'Herpès vulvaire',NULL,32,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92433,924,1,'Ulcération vulvaire',NULL,33,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92434,924,1,'Dystrophie vulvaire',NULL,34,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92701,927,1,'Biopsie cervicale',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92702,927,1,'Biopsie multipoint et ECG',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92703,927,1,'Biopsie multipoint',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92704,927,1,'ECG (curetage endocervical)',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92705,927,1,'Conisation diagnostique',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92706,927,1,'Traitement complet',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92707,927,1,'Suivi',NULL,7,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92708,927,1,'Polypectomie cervicale',NULL,8,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92709,927,1,'Polypectomie et biopsie à 6 et 12 heures (direction)',NULL,9,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92710,927,1,'Physiothérapie recommandée',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92711,927,1,'Biopsie vulvaire',NULL,11,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92712,927,1,'Biopsie vaginale',NULL,12,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92713,927,1,'Biopsie néoplasique',NULL,13,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92714,927,1,'Réexamen 6 semaines après l''accouchement',NULL,14,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(92715,927,1,'Réexamen après 3 mois de grossesse',NULL,15,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93101,931,1,'Changements inflammatoires des tissus cervicaux',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93102,931,1,'Epithélium pavimenteux métaplasique',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93103,931,1,'Changements atrophiques de l''épithélium pavimenteux',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93104,931,1,'Dégénérescence déciduale',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93105,931,1,'Condylome plat',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93106,931,1,'Hyperkératose',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93107,931,1,'Epithélium pavimenteux insuffisant',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,'Participation glandulaire',NULL,11,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93112,931,1,'Participation glandulaire étendue',NULL,12,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93113,931,1,'Carcinome épidermoïde micro-invasif',NULL,13,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93114,931,1,'Carcinome épidermoïde invasif',NULL,14,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93115,931,1,'Adénocarcinome in situ (AIS)',NULL,15,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93116,931,1,'Adénocarcinome invasif',NULL,16,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93117,931,1,'Infiltration lymphocytique',NULL,17,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93118,931,1,'Condylomes acuminés',NULL,18,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93119,931,1,'Polype',NULL,19,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93120,931,1,'Granulome inflammatoire',NULL,20,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(93121,931,1,'Tuberculose',NULL,21,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94701,947,1,'Retirez la gaze au bout de 24 h. Suivez les conseils du médecin. Adoptez de bonnes pratiques d''hygiène. Evitez rapp. sexuel/effort physique important et ne prenez pas de bain pdt 15 jrs. Légers saignements vaginaux possibles dans les 10 jrs. Voir imméd. médecin si saign. plus importants que règles les plus abondantes. Passez nvel examen avec dossier médical pr déterminer trait. de suivi approprié.',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94702,947,1,'Retirez la gaze au bout de 24 h. Suivez les conseils du médecin et adoptez de bonnes pratiques d''hygiène.',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94703,947,1,'Evitez tout rapport sexuel, tout effort physique important et ne prenez pas de bain pendant 15 jours.',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94704,947,1,'Légers saignements vaginaux possibles dans les 10 jrs. Voir imméd. médecin si saign. plus importants que règles les plus abondantes.',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(94705,947,1,'Suivez les conseils du médecin. Passez un nouvel examen sans oublier votre dossier médical afin de déterminer le traitement de suivi approprié.',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97101,971,1,'Saignement actif (vaisseaux fragiles)',NULL,1,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97102,971,1,'Surface irrégulière',NULL,2,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97103,971,1,'Lésion exophytique (sans condylome et polype)',NULL,3,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97104,971,1,'Nécrose',NULL,4,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97105,971,1,'Ulcération (nécrotique)',NULL,5,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97106,971,1,'Tumeur/néoplasme évident',NULL,6,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97201,972,1,'Apparition rapide d''un épithélium acéto-blanc dense aux contours nets',NULL,10,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97202,972,1,'Signe de crête',NULL,20,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97203,972,1,'Signe de bordure interne',NULL,30,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97204,972,1,'Orifices cryptiques (glandulaires) cernés',NULL,40,1);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97501,975,1,'Cervicite chronique',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97502,975,1,'Lésions condylomateuses (ou lésions koïlocytaires)',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,'Adénocarcinome in situ (AIS)',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97507,975,1,'Carcinome épidermoïde du col de l''utérus',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97508,975,1,'Adénocarcinome',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97701,977,1,'Retirez la gaze au bout de 24 h. Suivez les conseils du médecin. Adoptez de bonnes pratiques d''hygiène. Evitez rapp. sexuel/effort physique important et bains pdt 1 mois.Prenez méd. selon instructions. Léger écoulement vaginal aqueux possible ds les 10 jrs. Légers saignements possibles 10 jrs + tard. Voir imméd. médecin si saign. plus importants que règles les plus abondantes ou en cas de fièvre.',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97702,977,1,'Retirez la gaze au bout de 24 h. Suivez les conseils du médecin et adoptez de bonnes pratiques d''hygiène.',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97703,977,1,'Evitez tout rapport sexuel, tout effort physique important et ne prenez pas de bain pendant 2 mois.',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97704,977,1,'Prenez les médicaments en suivant les instructions du médecin.',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(97705,977,1,'Léger écoulement vaginal aqueux possible ds les 10 jrs. Légers saignements possibles 10 jrs + tard.Voir imméd. médecin si saign. plus importants que règles les plus abondantes ou en cas de fièvre.',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98101,981,1,'Acéto-blanchiment de faible intensité (pas complètement opaque)',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98102,981,1,'Acéto-blanchiment indistinct',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98103,981,1,'Acéto-blanchiment transparent ou translucide',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98104,981,1,'Acéto-blanchiment au-delà de la limite de la zone de transformation',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98105,981,1,'Blanc neige pur avec surface extrêmement brillante (rare)',0,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98106,981,1,'Couleur intermédiaire blanc/gris et surface brillante (la plupart des lésions entrent dans cette catégorie)',1,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98107,981,1,'Terne, opaque, blanc huître',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,'Contour microcondylomateux ou micropapillaire',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98402,984,1,'Lésions planes aux marges indistinctes',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98403,984,1,'Marges duveteuses ou finement dentelées',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98404,984,1,'Lésions anguleuses déchiquetées',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98405,984,1,'Lésions satellites au-delà de la limite de la zone de transformation',0,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98406,984,1,'Lésions symétriques de forme régulière aux contours lisses et francs',1,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98407,984,1,'Bords enroulés desquamants',2,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98408,984,1,'Démarcations internes entre des régions d''aspect colposcopique différent : une région centrale de modification de haut grade et une région périphérique de modification de bas grade.',2,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98701,987,1,'Vaisseaux fins/de calibre uniforme : position proche et uniforme',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98702,987,1,'Ponctuation et/ou mosaïque fine peu définie',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98703,987,1,'Vaisseaux au-delà de la limite de la zone de transformation',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98704,987,1,'Vaisseaux fins dans les lésions microcondylomateuses ou micropapillaires',0,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98705,987,1,'Absence de vaisseaux',1,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(98706,987,1,'Ponctuation ou mosaïque épaisse bien définie avec délimitation nette : position étendue et aléatoire',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99101,991,1,'Imprégnation positive à l''iode donnant une couleur brun acajou',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99102,991,1,'Imprégnation négative à l''iode d''une lésion insignifiante, par exemple coloration jaune par une lésion totalisant 3 points ou moins dans les trois premiers critères',0,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99103,991,1,'Zones au-delà de la limite de la zone de transformation : zones visibles à la colposcopie et manifestement iodo-négatives (une parakératose est souvent à l''origine de ces zones)',0,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99104,991,1,'Imprégnation partielle à l''iode : aspect tacheté versicolore',1,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99105,991,1,'Imprégnation négative à l''iode d''une lésion importante, par exemple coloration jaune par une lésion totalisant déjà 4 points ou plus dans les trois premiers critères',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,'Colposcopie inadéquate, ASIL, CIN-1',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99204,992,1,'Colposcopie inadéquate, ASC-H, CIN-1',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99205,992,1,'Colposcopie inadéquate, AGC, CIN-1',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99206,992,1,'CIN-1 persistante pendant 2 ans',NULL,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99207,992,1,'Néoplasie intra-épithéliale vaginale',NULL,7,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99208,992,1,'Néoplasie intra-épithéliale vulvaire',NULL,8,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99301,993,1,'Hyperplasie de la muqueuse cervicale',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99302,993,1,'Hyperplasie/excroissance cervicale',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99303,993,1,'Hyperplasie/excroissance vaginale',NULL,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99304,993,1,'Hyperplasie/excroissance vulvaire',NULL,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99305,993,1,'Hyperplasie/excroissance périnéale',NULL,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99401,994,1,'Première zone : longueur () largeur ()',NULL,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99402,994,1,'Deuxième zone : longueur () largeur ()',NULL,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(99403,994,1,'Troisième zone : longueur () largeur ()',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,'Aucun(e) ',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,'Terne, blanc laiteux (ni transparent, ni opaque)',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95204,952,1,'Brillant, blanc opaque',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95301,953,1,'Floues',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95302,953,1,'Nettes, mais irrégulières, satellites "géographiques" déchiquetés',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95303,953,1,'Nettes et régulières, différences de niveau de surface y compris "cernes"',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95401,954,1,'Fins, réguliers',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95402,954,1,'Absents',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95403,954,1,'Epais',2,4,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95404,954,1,'Atypique',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 quarts',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 quarts',2,5,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95506,955,1,'Endocervical',2,6,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95601,956,1,'Marron',0,1,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95602,956,1,'Jaune pâle',1,2,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95603,956,1,'Jaune partiel',1,3,0);
insert into Term(id,pid,sid,Name,Score,Seq,factory) values(95604,956,1,'Jaune moutarde',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;