Subversion Repositories Applications.referentiel

Rev

Rev 33 | Rev 38 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 33 Rev 37
Line 259... Line 259...
259
</POSITIONMARKERS>
259
</POSITIONMARKERS>
260
</SETTINGS>
260
</SETTINGS>
261
<METADATA>
261
<METADATA>
262
<REGIONS>
262
<REGIONS>
263
<REGION ID="27985" RegionName="Traitements" XPos="28" YPos="24" Width="691" Height="530" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Tables permettant de r\195\169aliser des traitments sur les donn\195\169es des r\195\169f\195\169rentiels." IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" />
263
<REGION ID="27985" RegionName="Traitements" XPos="28" YPos="24" Width="691" Height="530" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Tables permettant de r\195\169aliser des traitments sur les donn\195\169es des r\195\169f\195\169rentiels." IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" />
-
 
264
<REGION ID="28021" RegionName="Exemple BDNT" XPos="743" YPos="25" Width="668" Height="529" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" />
264
</REGIONS>
265
</REGIONS>
265
<TABLES>
266
<TABLES>
266
<TABLE ID="27977" Tablename="ref_traitement" PrevTableName="Table_01" XPos="87" YPos="74" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
267
<TABLE ID="27977" Tablename="ref_traitement" PrevTableName="Table_01" XPos="87" YPos="74" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
267
<COLUMNS>
268
<COLUMNS>
268
<COLUMN ID="27979" ColName="id_traitement" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Id auto incr\195\169ment\195\169 de la demande de traitement">
269
<COLUMN ID="27979" ColName="id_traitement" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Id auto incr\195\169ment\195\169 de la demande de traitement">
Line 409... Line 410...
409
<INDEXCOLUMN idColumn="28007" LengthParam="0" />
410
<INDEXCOLUMN idColumn="28007" LengthParam="0" />
410
</INDEXCOLUMNS>
411
</INDEXCOLUMNS>
411
</INDEX>
412
</INDEX>
412
</INDICES>
413
</INDICES>
413
</TABLE>
414
</TABLE>
-
 
415
<TABLE ID="28022" Tablename="bdnt_meta" PrevTableName="Table_04" XPos="768" YPos="61" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
-
 
416
<COLUMNS>
-
 
417
<COLUMN ID="28024" ColName="id_meta" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
-
 
418
<OPTIONSELECTED>
-
 
419
<OPTIONSELECT Value="1" />
-
 
420
<OPTIONSELECT Value="0" />
-
 
421
<OPTIONSELECT Value="0" />
-
 
422
</OPTIONSELECTED>
-
 
423
</COLUMN>
-
 
424
<COLUMN ID="28026" ColName="titre" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(128)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=" Le nom complet.">
-
 
425
<OPTIONSELECTED>
-
 
426
<OPTIONSELECT Value="0" />
-
 
427
<OPTIONSELECT Value="0" />
-
 
428
</OPTIONSELECTED>
-
 
429
</COLUMN>
-
 
430
<COLUMN ID="28027" ColName="code" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(16)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le code correspondant \195\160 l\aabr\195\169viation ou \195\160 l\aacronyme du titre.">
-
 
431
<OPTIONSELECTED>
-
 
432
<OPTIONSELECT Value="0" />
-
 
433
<OPTIONSELECT Value="0" />
-
 
434
</OPTIONSELECTED>
-
 
435
</COLUMN>
-
 
436
<COLUMN ID="28028" ColName="domaine_taxo" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom du groupe taxonomique dans lequel le r\195\169f\195\169rentiel s\ainscrit.">
-
 
437
<OPTIONSELECTED>
-
 
438
<OPTIONSELECT Value="0" />
-
 
439
<OPTIONSELECT Value="0" />
-
 
440
</OPTIONSELECTED>
-
 
441
</COLUMN>
-
 
442
<COLUMN ID="28029" ColName="domaine_geo" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom de la zone g\195\169ographique la plus large prise en compte par le r\195\169f\195\169rentiel.">
-
 
443
<OPTIONSELECTED>
-
 
444
<OPTIONSELECT Value="0" />
-
 
445
<OPTIONSELECT Value="0" />
-
 
446
</OPTIONSELECTED>
-
 
447
</COLUMN>
-
 
448
<COLUMN ID="28030" ColName="domaine_nom" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(8)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation d\aun ou plusieurs codes de nomenclature utilis\195\169 dans ce r\195\169f\195\169rentiel. Liste des codes : CINB, CINPC.">
-
 
449
<OPTIONSELECTED>
-
 
450
<OPTIONSELECT Value="0" />
-
 
451
<OPTIONSELECT Value="0" />
-
 
452
</OPTIONSELECTED>
-
 
453
</COLUMN>
-
 
454
<COLUMN ID="28031" ColName="classification" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(128)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom de la classification retenue Cl.">
-
 
455
<OPTIONSELECTED>
-
 
456
<OPTIONSELECT Value="0" />
-
 
457
<OPTIONSELECT Value="0" />
-
 
458
</OPTIONSELECTED>
-
 
459
</COLUMN>
-
 
460
<COLUMN ID="28032" ColName="version" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(8)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro de version du r\195\169f\195\169rentiel sous la forme : version majeure.version mineure.">
-
 
461
<OPTIONSELECTED>
-
 
462
<OPTIONSELECT Value="0" />
-
 
463
<OPTIONSELECT Value="0" />
-
 
464
</OPTIONSELECTED>
-
 
465
</COLUMN>
-
 
466
<COLUMN ID="28033" ColName="coordinateur" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Informations sur le coordinateur du r\195\169f\195\169rentiel sous la forme : Pr\195\169nom1 NOM1 (Organisation1) \kcourriel1\g">
-
 
467
<OPTIONSELECTED>
-
 
468
<OPTIONSELECT Value="0" />
-
 
469
<OPTIONSELECT Value="0" />
-
 
470
</OPTIONSELECTED>
-
 
471
</COLUMN>
-
 
472
<COLUMN ID="28034" ColName="auteur" PrevColName="" Pos="9" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste des auteurs du r\195\169f\195\169rentiel sous la forme : Pr\195\169nom1 NOM1 (Organisation1) \kcourriel1\g, Pr\195\169nom2 NOM2 (Organisation2) \kcourriel2\g">
-
 
473
<OPTIONSELECTED>
-
 
474
</OPTIONSELECTED>
-
 
475
</COLUMN>
-
 
476
<COLUMN ID="28035" ColName="contributeur" PrevColName="" Pos="10" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste des contributeurs au r\195\169f\195\169rentiel sous la forme : Pr\195\169nom1 NOM1 (Organisation1) \kcourriel1\g, Pr\195\169nom2 NOM2 (Organisation2) \kcourriel2\g">
-
 
477
<OPTIONSELECTED>
-
 
478
</OPTIONSELECTED>
-
 
479
</COLUMN>
-
 
480
<COLUMN ID="28036" ColName="date_production" PrevColName="" Pos="11" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date correspondant \195\160 la derni\195\168re modification effectu\195\169e par le groupe de travail sur la version courante. Format : AAAA-MM-JJ">
-
 
481
<OPTIONSELECTED>
-
 
482
</OPTIONSELECTED>
-
 
483
</COLUMN>
-
 
484
<COLUMN ID="28037" ColName="date_validation" PrevColName="" Pos="12" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date correspondant \195\160 la validation par le SINP de la version courante. Format : AAAA-MM-JJ">
-
 
485
<OPTIONSELECTED>
-
 
486
</OPTIONSELECTED>
-
 
487
</COLUMN>
-
 
488
<COLUMN ID="28038" ColName="source" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Un permalien indiquant la page o\195\185 l\aon peut t\195\169l\195\169charger la pr\195\169sente version">
-
 
489
<OPTIONSELECTED>
-
 
490
<OPTIONSELECT Value="0" />
-
 
491
<OPTIONSELECT Value="0" />
-
 
492
</OPTIONSELECTED>
-
 
493
</COLUMN>
-
 
494
<COLUMN ID="28039" ColName="contact" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Une adresse de courriel o\195\185 il est possible de poser des questions, faire des remarques...">
-
 
495
<OPTIONSELECTED>
-
 
496
<OPTIONSELECT Value="0" />
-
 
497
<OPTIONSELECT Value="0" />
-
 
498
</OPTIONSELECTED>
-
 
499
</COLUMN>
-
 
500
<COLUMN ID="28040" ColName="editeur" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nom de l\aorganisation dans le cadre de laquelle le r\195\169f\195\169rentiel a \195\169t\195\169 produit">
-
 
501
<OPTIONSELECTED>
-
 
502
<OPTIONSELECT Value="0" />
-
 
503
<OPTIONSELECT Value="0" />
-
 
504
</OPTIONSELECTED>
-
 
505
</COLUMN>
-
 
506
<COLUMN ID="28041" ColName="droit" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mention l\195\169gale (copyright)">
-
 
507
<OPTIONSELECTED>
-
 
508
<OPTIONSELECT Value="0" />
-
 
509
<OPTIONSELECT Value="0" />
-
 
510
</OPTIONSELECTED>
-
 
511
</COLUMN>
-
 
512
<COLUMN ID="28042" ColName="licence" PrevColName="" Pos="17" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL de la licence du document">
-
 
513
<OPTIONSELECTED>
-
 
514
<OPTIONSELECT Value="0" />
-
 
515
<OPTIONSELECT Value="0" />
-
 
516
</OPTIONSELECTED>
-
 
517
</COLUMN>
-
 
518
<COLUMN ID="28043" ColName="referencement" PrevColName="" Pos="18" idDatatype="20" DatatypeParams="(256)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indique comment d\195\169signer le r\195\169f\195\169rentiel dans une bibliographie par exemple">
-
 
519
<OPTIONSELECTED>
-
 
520
<OPTIONSELECT Value="0" />
-
 
521
<OPTIONSELECT Value="0" />
-
 
522
</OPTIONSELECTED>
-
 
523
</COLUMN>
-
 
524
<COLUMN ID="28044" ColName="stat_combinaison" PrevColName="" Pos="19" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nombre de combinaisons nomenclaturales">
-
 
525
<OPTIONSELECTED>
-
 
526
<OPTIONSELECT Value="1" />
-
 
527
<OPTIONSELECT Value="0" />
-
 
528
<OPTIONSELECT Value="0" />
-
 
529
</OPTIONSELECTED>
-
 
530
</COLUMN>
-
 
531
<COLUMN ID="28045" ColName="stat_taxon" PrevColName="" Pos="20" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nombre de noms retenus (taxons)">
-
 
532
<OPTIONSELECTED>
-
 
533
<OPTIONSELECT Value="1" />
-
 
534
<OPTIONSELECT Value="0" />
-
 
535
<OPTIONSELECT Value="0" />
-
 
536
</OPTIONSELECTED>
-
 
537
</COLUMN>
-
 
538
<COLUMN ID="28046" ColName="stat_modification" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le nombre de lignes modifi\195\169es par rapport \195\160 la version pr\195\169c\195\169dente.">
-
 
539
<OPTIONSELECTED>
-
 
540
<OPTIONSELECT Value="1" />
-
 
541
<OPTIONSELECT Value="0" />
-
 
542
<OPTIONSELECT Value="0" />
-
 
543
</OPTIONSELECTED>
-
 
544
</COLUMN>
-
 
545
<COLUMN ID="28047" ColName="signature" PrevColName="" Pos="22" idDatatype="20" DatatypeParams="(32)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Signature md5 du fichier du r\195\169f\195\169rentiel">
-
 
546
<OPTIONSELECTED>
-
 
547
<OPTIONSELECT Value="0" />
-
 
548
<OPTIONSELECT Value="0" />
-
 
549
</OPTIONSELECTED>
-
 
550
</COLUMN>
-
 
551
</COLUMNS>
-
 
552
<INDICES>
-
 
553
<INDEX ID="28025" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
-
 
554
<INDEXCOLUMNS>
-
 
555
<INDEXCOLUMN idColumn="28024" LengthParam="0" />
-
 
556
</INDEXCOLUMNS>
-
 
557
</INDEX>
-
 
558
</INDICES>
-
 
559
</TABLE>
414
</TABLES>
560
</TABLES>
415
<RELATIONS>
561
<RELATIONS>
416
<RELATION ID="27995" RelationName="fk_rt_rr" Kind="2" SrcTable="27977" DestTable="27986" FKFields="id_traitement=ce_traitement\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-36" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" />
562
<RELATION ID="27995" RelationName="fk_rt_rr" Kind="2" SrcTable="27977" DestTable="27986" FKFields="id_traitement=ce_traitement\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-36" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" />
417
</RELATIONS>
563
</RELATIONS>
418
<NOTES>
564
<NOTES>