Subversion Repositories eFlore/Applications.coel

Rev

Rev 274 | Rev 601 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
14 jpm 1
<?xml version="1.0" standalone="yes" ?>
2
<DBMODEL Version="4.0">
3
<SETTINGS>
584 jp_milcent 4
<GLOBALSETTINGS ModelName="coel" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="BDD_NOM : tb_coel" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="92.00" XPos="733" YPos="864" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="0" DefaultTableType="0" ActivateRefDefForNewRelations="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="nimbus sans l" CanvasWidth="4096" CanvasHeight="2842" />
14 jpm 5
<DATATYPEGROUPS>
6
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
7
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
8
<DATATYPEGROUP Name="String Types" Icon="3" />
9
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
10
<DATATYPEGROUP Name="User defined Types" Icon="5" />
11
<DATATYPEGROUP Name="Geographic Types" Icon="6" />
12
</DATATYPEGROUPS>
13
<DATATYPES>
14
<DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
15
<PARAMS>
16
<PARAM Name="length" />
17
</PARAMS>
18
<OPTIONS>
19
<OPTION Name="UNSIGNED" Default="1" />
20
<OPTION Name="ZEROFILL" Default="0" />
21
</OPTIONS>
22
</DATATYPE>
23
<DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
24
<PARAMS>
25
<PARAM Name="length" />
26
</PARAMS>
27
<OPTIONS>
28
<OPTION Name="UNSIGNED" Default="1" />
29
<OPTION Name="ZEROFILL" Default="0" />
30
</OPTIONS>
31
</DATATYPE>
32
<DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
33
<PARAMS>
34
<PARAM Name="length" />
35
</PARAMS>
36
<OPTIONS>
37
<OPTION Name="UNSIGNED" Default="1" />
38
<OPTION Name="ZEROFILL" Default="0" />
39
</OPTIONS>
40
</DATATYPE>
41
<DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
42
<PARAMS>
43
<PARAM Name="length" />
44
</PARAMS>
45
<OPTIONS>
46
<OPTION Name="UNSIGNED" Default="0" />
47
<OPTION Name="ZEROFILL" Default="0" />
48
</OPTIONS>
49
</DATATYPE>
50
<DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
51
<PARAMS>
52
<PARAM Name="length" />
53
</PARAMS>
54
<OPTIONS>
55
<OPTION Name="UNSIGNED" Default="1" />
56
<OPTION Name="ZEROFILL" Default="0" />
57
</OPTIONS>
58
</DATATYPE>
59
<DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
60
<PARAMS>
61
<PARAM Name="length" />
62
</PARAMS>
63
<OPTIONS>
64
<OPTION Name="UNSIGNED" Default="0" />
65
<OPTION Name="ZEROFILL" Default="0" />
66
</OPTIONS>
67
</DATATYPE>
68
<DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
69
<PARAMS>
70
<PARAM Name="precision" />
71
</PARAMS>
72
<OPTIONS>
73
<OPTION Name="ZEROFILL" Default="0" />
74
</OPTIONS>
75
</DATATYPE>
76
<DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
77
<PARAMS>
78
<PARAM Name="length" />
79
<PARAM Name="decimals" />
80
</PARAMS>
81
<OPTIONS>
82
<OPTION Name="ZEROFILL" Default="0" />
83
</OPTIONS>
84
</DATATYPE>
85
<DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
86
<PARAMS>
87
<PARAM Name="length" />
88
<PARAM Name="decimals" />
89
</PARAMS>
90
<OPTIONS>
91
<OPTION Name="ZEROFILL" Default="0" />
92
</OPTIONS>
93
</DATATYPE>
94
<DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
95
<PARAMS>
96
<PARAM Name="length" />
97
<PARAM Name="decimals" />
98
</PARAMS>
99
<OPTIONS>
100
<OPTION Name="ZEROFILL" Default="0" />
101
</OPTIONS>
102
</DATATYPE>
103
<DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
104
<PARAMS>
105
<PARAM Name="length" />
106
<PARAM Name="decimals" />
107
</PARAMS>
108
<OPTIONS>
109
<OPTION Name="ZEROFILL" Default="0" />
110
</OPTIONS>
111
</DATATYPE>
112
<DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
113
<PARAMS>
114
<PARAM Name="length" />
115
<PARAM Name="decimals" />
116
</PARAMS>
117
<OPTIONS>
118
<OPTION Name="ZEROFILL" Default="0" />
119
</OPTIONS>
120
</DATATYPE>
121
<DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
122
<PARAMS>
123
<PARAM Name="length" />
124
<PARAM Name="decimals" />
125
</PARAMS>
126
<OPTIONS>
127
<OPTION Name="ZEROFILL" Default="0" />
128
</OPTIONS>
129
</DATATYPE>
130
<DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
131
</DATATYPE>
132
<DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
133
</DATATYPE>
134
<DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
135
<PARAMS>
136
<PARAM Name="length" />
137
</PARAMS>
138
</DATATYPE>
139
<DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
140
</DATATYPE>
141
<DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
142
<PARAMS>
143
<PARAM Name="length" />
144
</PARAMS>
145
</DATATYPE>
146
<DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
147
<PARAMS>
148
<PARAM Name="length" />
149
</PARAMS>
150
<OPTIONS>
151
<OPTION Name="BINARY" Default="0" />
152
</OPTIONS>
153
</DATATYPE>
154
<DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
155
<PARAMS>
156
<PARAM Name="length" />
157
</PARAMS>
158
<OPTIONS>
159
<OPTION Name="BINARY" Default="0" />
160
</OPTIONS>
161
</DATATYPE>
162
<DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
163
</DATATYPE>
164
<DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
165
</DATATYPE>
166
<DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
167
</DATATYPE>
168
<DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
169
</DATATYPE>
170
<DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
171
</DATATYPE>
172
<DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
173
</DATATYPE>
174
<DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
175
</DATATYPE>
176
<DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
177
</DATATYPE>
178
<DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
179
</DATATYPE>
180
<DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
181
</DATATYPE>
182
<DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
183
<PARAMS>
184
<PARAM Name="values" />
185
</PARAMS>
186
</DATATYPE>
187
<DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
188
<PARAMS>
189
<PARAM Name="values" />
190
</PARAMS>
191
</DATATYPE>
192
<DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
193
<OPTIONS>
194
<OPTION Name="BINARY" Default="0" />
195
</OPTIONS>
196
</DATATYPE>
197
<DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
198
<OPTIONS>
199
<OPTION Name="BINARY" Default="0" />
200
</OPTIONS>
201
</DATATYPE>
202
<DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
203
<OPTIONS>
204
<OPTION Name="BINARY" Default="0" />
205
</OPTIONS>
206
</DATATYPE>
207
<DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
208
</DATATYPE>
209
<DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
210
</DATATYPE>
211
<DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
212
</DATATYPE>
213
<DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
214
</DATATYPE>
215
<DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
216
</DATATYPE>
217
<DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
218
</DATATYPE>
219
<DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
220
</DATATYPE>
221
</DATATYPES>
222
<COMMON_DATATYPES>
223
<COMMON_DATATYPE ID="5" />
224
<COMMON_DATATYPE ID="8" />
225
<COMMON_DATATYPE ID="20" />
226
<COMMON_DATATYPE ID="15" />
227
<COMMON_DATATYPE ID="22" />
228
<COMMON_DATATYPE ID="28" />
229
<COMMON_DATATYPE ID="26" />
230
<COMMON_DATATYPE ID="33" />
231
<COMMON_DATATYPE ID="34" />
232
<COMMON_DATATYPE ID="35" />
233
</COMMON_DATATYPES>
234
<TABLEPREFIXES>
20 jpm 235
<TABLEPREFIX Name="Defaut (pas de prefixe)" />
14 jpm 236
</TABLEPREFIXES>
237
<REGIONCOLORS>
238
<REGIONCOLOR Color="Red=#FFEEEC" />
239
<REGIONCOLOR Color="Yellow=#FEFDED" />
240
<REGIONCOLOR Color="Green=#EAFFE5" />
241
<REGIONCOLOR Color="Cyan=#ECFDFF" />
242
<REGIONCOLOR Color="Blue=#F0F1FE" />
243
<REGIONCOLOR Color="Magenta=#FFEBFA" />
76 jpm 244
<REGIONCOLOR Color="Orange=#FFD980" />
245
<REGIONCOLOR Color="Vert=#E6FFBF" />
14 jpm 246
</REGIONCOLORS>
247
<POSITIONMARKERS>
248
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
249
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
250
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
251
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
252
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
253
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
254
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
255
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
256
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
257
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
258
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
259
</POSITIONMARKERS>
260
</SETTINGS>
261
<METADATA>
262
<REGIONS>
207 jp_milcent 263
<REGION ID="21985" RegionName="Commentaire" XPos="790" YPos="2355" Width="694" Height="287" RegionColor="6" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module contenant les tables permettant de g\195\169rer les commentaires.\nAbreviation : CCM\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" />
264
<REGION ID="1443" RegionName="Collection" XPos="28" YPos="924" Width="741" Height="1421" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Collections.\nAbreviation : CC\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
265
<REGION ID="18416" RegionName="Structure" XPos="785" YPos="1386" Width="701" Height="959" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Structures.\nAbreviation : CS\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
266
<REGION ID="18417" RegionName="Personne" XPos="784" YPos="505" Width="700" Height="872" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Personnes.\nAbreviation : CP\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
267
<REGION ID="18447" RegionName="M\195\169tadonn\195\169e" XPos="20" YPos="16" Width="1464" Height="480" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des M\195\169tadonn\195\169es.\nAbreviation : CM\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
268
<REGION ID="21218" RegionName="Publication" XPos="24" YPos="2357" Width="747" Height="286" RegionColor="4" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Publications.\nAbreviation : CPU\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
168 jp_milcent 269
<REGION ID="21340" RegionName="Projet" XPos="28" YPos="504" Width="744" Height="410" RegionColor="5" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Projets.\nAbreviation : CPR\nAide : OK\nEtat: OK\nRevision : $Revision: 584 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" />
14 jpm 270
</REGIONS>
271
<TABLES>
42 jpm 272
<TABLE ID="1444" Tablename="coel_collection" PrevTableName="Table_01" XPos="36" YPos="1151" 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="Contient les informations sur les collections.INFO : cc_nom\n" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" >
14 jpm 273
<COLUMNS>
41 jpm 274
<COLUMN ID="1449" ColName="cc_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la collection.">
14 jpm 275
<OPTIONSELECTED>
276
<OPTIONSELECT Value="1" />
277
<OPTIONSELECT Value="0" />
278
</OPTIONSELECTED>
279
</COLUMN>
41 jpm 280
<COLUMN ID="21630" ColName="cc_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel les informations de la collection sont saisies.">
23 jpm 281
<OPTIONSELECTED>
282
<OPTIONSELECT Value="1" />
283
<OPTIONSELECT Value="0" />
284
</OPTIONSELECTED>
285
</COLUMN>
41 jpm 286
<COLUMN ID="21167" ColName="cc_ce_mere" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant de la collection parente. Si la collection courrante n\aa pas de parente laisser la valeur 0 par d\195\169faut.">
16 jpm 287
<OPTIONSELECTED>
288
<OPTIONSELECT Value="1" />
289
<OPTIONSELECT Value="0" />
290
</OPTIONSELECTED>
291
</COLUMN>
41 jpm 292
<COLUMN ID="20821" ColName="cc_ce_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant de la structure habritant physiquement la collection. Si c\aest un particulier, laisser la valeur 0 par d\195\169faut et utiliser la table liant les collections aux personnes.">
16 jpm 293
<OPTIONSELECTED>
294
<OPTIONSELECT Value="1" />
295
<OPTIONSELECT Value="0" />
296
</OPTIONSELECTED>
297
</COLUMN>
20 jpm 298
<COLUMN ID="21095" ColName="cc_guid" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant global unique de type LSID ou URI.">
299
<OPTIONSELECTED>
300
<OPTIONSELECT Value="0" />
301
</OPTIONSELECTED>
302
</COLUMN>
303
<COLUMN ID="21099" ColName="cc_truk_identifiant_alternatif" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres identifiants de la structure.">
304
<OPTIONSELECTED>
305
<OPTIONSELECT Value="0" />
306
</OPTIONSELECTED>
307
</COLUMN>
308
<COLUMN ID="21096" ColName="cc_truk_code" PrevColName="cc_truk_sigle_usage" Pos="8" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Code(s) de la collection.">
309
<OPTIONSELECTED>
310
<OPTIONSELECT Value="0" />
311
</OPTIONSELECTED>
312
</COLUMN>
313
<COLUMN ID="21100" ColName="cc_nom" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la collection dans la langue d\aorigine. Afficher vis \195\160 vis du public.">
314
<OPTIONSELECTED>
315
<OPTIONSELECT Value="0" />
316
</OPTIONSELECTED>
317
</COLUMN>
318
<COLUMN ID="21101" ColName="cc_truk_nom_alternatif" PrevColName="" Pos="11" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom alternatif de la collection.">
319
<OPTIONSELECTED>
320
</OPTIONSELECTED>
321
</COLUMN>
322
<COLUMN ID="21141" ColName="cc_description" PrevColName="" Pos="12" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description principale de la collection pour un large public.">
323
<OPTIONSELECTED>
324
</OPTIONSELECTED>
325
</COLUMN>
326
<COLUMN ID="21142" ColName="cc_description_specialiste" PrevColName="" Pos="13" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description de la collection pour un public de sp\195\169cialistes.">
327
<OPTIONSELECTED>
328
</OPTIONSELECTED>
329
</COLUMN>
330
<COLUMN ID="21187" ColName="cc_historique" PrevColName="" Pos="20" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Historique de la collection (acquisition, diff\195\169rentes interventions de restauration, de traitement ...).">
331
<OPTIONSELECTED>
332
</OPTIONSELECTED>
333
</COLUMN>
584 jp_milcent 334
<COLUMN ID="21182" ColName="cc_truk_url" PrevColName="cc_url" Pos="18" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) du site web ou de la page concernant la collection (WEB), d\aun web service (WS) ou d\aune page permettant d\aacc\195\168der \195\160 des informations sur les objets de la collection (OBJ).">
20 jpm 335
<OPTIONSELECTED>
336
</OPTIONSELECTED>
337
</COLUMN>
338
<COLUMN ID="21262" ColName="cc_truk_groupement_principe" PrevColName="cc_ce_truk_principe_groupe" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Principal but de groupement de la collection au niveau int\195\169lectuel plut\195\180t que physique.">
339
<OPTIONSELECTED>
340
<OPTIONSELECT Value="0" />
341
</OPTIONSELECTED>
342
</COLUMN>
343
<COLUMN ID="21265" ColName="cc_truk_groupement_but" PrevColName="" Pos="22" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Principal but de r\195\169alisation de la collection.">
344
<OPTIONSELECTED>
345
<OPTIONSELECT Value="1" />
346
<OPTIONSELECT Value="0" />
347
</OPTIONSELECTED>
348
</COLUMN>
76 jpm 349
<COLUMN ID="21146" ColName="cc_ce_type" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de la collection vis \195\160 vis du standard NCD.">
20 jpm 350
<OPTIONSELECTED>
351
<OPTIONSELECT Value="1" />
352
<OPTIONSELECT Value="0" />
353
</OPTIONSELECTED>
354
</COLUMN>
97 jpm 355
<COLUMN ID="21177" ColName="cc_ce_type_depot" PrevColName="" Pos="17" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de d\195\169p\195\180t de la collection.">
20 jpm 356
<OPTIONSELECTED>
97 jpm 357
<OPTIONSELECT Value="1" />
20 jpm 358
<OPTIONSELECT Value="0" />
359
</OPTIONSELECTED>
360
</COLUMN>
361
<COLUMN ID="21175" ColName="cc_cote" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="C\195\180te de la collection.">
362
<OPTIONSELECTED>
363
<OPTIONSELECT Value="0" />
364
</OPTIONSELECTED>
365
</COLUMN>
366
<COLUMN ID="21176" ColName="cc_dimenssion" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Dimenssion, taille de la collection sous forme de texte libre.">
367
<OPTIONSELECTED>
368
<OPTIONSELECT Value="0" />
369
</OPTIONSELECTED>
370
</COLUMN>
371
<COLUMN ID="21307" ColName="cc_condition_acces" PrevColName="" Pos="23" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Condition d\aacc\195\168s \195\160 la collection. Peut \195\170tre d\195\169finit par d\195\169faut par la structure.">
372
<OPTIONSELECTED>
373
</OPTIONSELECTED>
374
</COLUMN>
375
<COLUMN ID="21308" ColName="cc_condition_usage" PrevColName="" Pos="24" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Condition d\ausages de la collection. Peut \195\170tre d\195\169finit par d\195\169faut par la structure.">
376
<OPTIONSELECTED>
377
</OPTIONSELECTED>
378
</COLUMN>
379
<COLUMN ID="21183" ColName="cc_truk_couverture_vernaculaire" PrevColName="cc_truk_nature" Pos="19" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nature de la collection sous forme de nom(s) vernaculaire(s).">
380
<OPTIONSELECTED>
381
<OPTIONSELECT Value="0" />
382
</OPTIONSELECTED>
383
</COLUMN>
384
<COLUMN ID="21313" ColName="cc_truk_couverture_taxonomique" PrevColName="cc_couverture_taxonomique" Pos="25" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de famille ou de taxons sup\195\169rieurs pr\195\169sent dans la collection.">
385
<OPTIONSELECTED>
386
<OPTIONSELECT Value="0" />
387
</OPTIONSELECTED>
388
</COLUMN>
389
<COLUMN ID="21327" ColName="cc_truk_couverture_regne" PrevColName="" Pos="32" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste des r\195\168gnes couverts par la collection.">
390
<OPTIONSELECTED>
391
<OPTIONSELECT Value="0" />
392
</OPTIONSELECTED>
393
</COLUMN>
394
<COLUMN ID="21314" ColName="cc_truk_couverture_temporelle" PrevColName="cc_couverture_temporelle" Pos="26" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="P\195\169riode de temps couverte par la collection.">
395
<OPTIONSELECTED>
396
<OPTIONSELECT Value="0" />
397
</OPTIONSELECTED>
398
</COLUMN>
399
<COLUMN ID="21326" ColName="cc_truk_couverture_vie" PrevColName="cc_truk_couverture_periode_vie" Pos="31" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="P\195\169riode de temps durant laquelle le mat\195\169riel biologique \195\169tait en vie. Inclu les p\195\169riodes de temps pal\195\169ontologiques.">
400
<OPTIONSELECTED>
401
<OPTIONSELECT Value="0" />
402
</OPTIONSELECTED>
403
</COLUMN>
404
<COLUMN ID="20841" ColName="cc_truk_conservation_statut" PrevColName="cc_ce_etat" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer la date d\aune estimation s\195\169par\195\169e par un di\195\168se du statut estim\195\169 utilisant l\a\195\169chelle de McGinley. Plusieurs estimations seront s\195\169par\195\169s par un point virgule.">
405
<OPTIONSELECTED>
406
<OPTIONSELECT Value="0" />
407
</OPTIONSELECTED>
408
</COLUMN>
409
<COLUMN ID="21328" ColName="cc_truk_preservation" PrevColName="" Pos="33" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste indiquant les proc\195\169dures ou techniques de conservation utilis\195\169es pour les collections non vivantes.">
410
<OPTIONSELECTED>
411
<OPTIONSELECT Value="0" />
412
</OPTIONSELECTED>
413
</COLUMN>
76 jpm 414
<COLUMN ID="21335" ColName="cc_ce_developpement" PrevColName="" Pos="35" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Indique le changement potentiel dans la port\195\169e de la collection.">
20 jpm 415
<OPTIONSELECTED>
416
<OPTIONSELECT Value="0" />
417
</OPTIONSELECTED>
418
</COLUMN>
23 jpm 419
<COLUMN ID="21337" ColName="cc_truk_periode_constitution" PrevColName="cc_truk_periode_formation" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste de p\195\169riodes de temps durant laquelle la collection a \195\169t\195\169 assembl\195\169e.">
20 jpm 420
<OPTIONSELECTED>
421
<OPTIONSELECT Value="0" />
422
</OPTIONSELECTED>
423
</COLUMN>
23 jpm 424
<COLUMN ID="21338" ColName="cc_truk_couverture_lieu" PrevColName="" Pos="37" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste de lieux (continent, pays, region, d\195\169partement, commune, autres lieux historique ou texte libre) desquels le mat\195\169riel de la collection est originaire.">
20 jpm 425
<OPTIONSELECTED>
426
<OPTIONSELECT Value="0" />
427
</OPTIONSELECTED>
428
</COLUMN>
429
<COLUMN ID="21339" ColName="cc_truk_coordonnee" PrevColName="" Pos="38" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste de coordonn\195\169es d\195\169cimales des lieux d\aorigine du mat\195\169riel de la collection.">
430
<OPTIONSELECTED>
431
<OPTIONSELECT Value="0" />
432
</OPTIONSELECTED>
433
</COLUMN>
76 jpm 434
<COLUMN ID="21325" ColName="cc_ce_specimen_type" PrevColName="cc_mark_specimen_type" Pos="30" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Y-a-t\ail des \195\169chantillons-types?">
20 jpm 435
<OPTIONSELECTED>
23 jpm 436
<OPTIONSELECT Value="1" />
437
<OPTIONSELECT Value="0" />
20 jpm 438
</OPTIONSELECTED>
439
</COLUMN>
41 jpm 440
<COLUMN ID="21506" ColName="cc_specimen_type_nbre" PrevColName="" Pos="41" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nombre de sp\195\169cimen type pr\195\169sent dans la collection.">
23 jpm 441
<OPTIONSELECTED>
442
<OPTIONSELECT Value="1" />
443
<OPTIONSELECT Value="0" />
444
</OPTIONSELECTED>
445
</COLUMN>
41 jpm 446
<COLUMN ID="21507" ColName="cc_mark_speciment_type_nbre_precision" PrevColName="cc_ce_speciment_type_nbre_precision" Pos="41" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169cision sur le nombre de sp\195\169cimens types indiqu\195\169 (1 = exact, 0 = approximatif).">
23 jpm 447
<OPTIONSELECTED>
448
</OPTIONSELECTED>
449
</COLUMN>
76 jpm 450
<COLUMN ID="21508" ColName="cc_ce_specimen_type_classement" PrevColName="" Pos="42" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de classement des specimens types.">
23 jpm 451
<OPTIONSELECTED>
452
<OPTIONSELECT Value="1" />
453
<OPTIONSELECT Value="0" />
454
</OPTIONSELECTED>
455
</COLUMN>
22 jpm 456
<COLUMN ID="21345" ColName="cc_expedition_nom" PrevColName="" Pos="39" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de l\aexp\195\169dition durant laquelle le mat\195\169riel a \195\169t\195\169 collect\195\169.">
457
<OPTIONSELECTED>
458
<OPTIONSELECT Value="0" />
459
</OPTIONSELECTED>
460
</COLUMN>
20 jpm 461
<COLUMN ID="21323" ColName="cc_truk_digital_medium" PrevColName="" Pos="29" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pour les collections digitales, listes des types de support d\aenregistrement. Ex. : DVD-R.">
462
<OPTIONSELECTED>
463
<OPTIONSELECT Value="0" />
464
</OPTIONSELECTED>
465
</COLUMN>
466
<COLUMN ID="21322" ColName="cc_truk_digital_format" PrevColName="" Pos="28" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pour les collections digitales, listes des types MIME.">
467
<OPTIONSELECTED>
468
<OPTIONSELECT Value="0" />
469
</OPTIONSELECTED>
470
</COLUMN>
168 jp_milcent 471
<COLUMN ID="27933" ColName="cc_mark_public" PrevColName="" Pos="41" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) les donn\195\169es de cette collection sont publiques.">
472
<OPTIONSELECTED>
473
</OPTIONSELECTED>
474
</COLUMN>
76 jpm 475
<COLUMN ID="20839" ColName="cc_ce_meta" PrevColName="cc_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
16 jpm 476
<OPTIONSELECTED>
37 jpm 477
<OPTIONSELECT Value="1" />
478
<OPTIONSELECT Value="0" />
16 jpm 479
</OPTIONSELECTED>
480
</COLUMN>
14 jpm 481
</COLUMNS>
16 jpm 482
<RELATIONS_START>
483
<RELATION_START ID="20819" />
20 jpm 484
<RELATION_START ID="21108" />
485
<RELATION_START ID="21152" />
486
<RELATION_START ID="21223" />
23 jpm 487
<RELATION_START ID="21496" />
488
<RELATION_START ID="21498" />
76 jpm 489
<RELATION_START ID="22037" />
16 jpm 490
</RELATIONS_START>
491
<RELATIONS_END>
492
<RELATION_END ID="20817" />
493
<RELATION_END ID="20819" />
23 jpm 494
<RELATION_END ID="21628" />
76 jpm 495
<RELATION_END ID="22079" />
496
<RELATION_END ID="22158" />
497
<RELATION_END ID="22160" />
498
<RELATION_END ID="22162" />
499
<RELATION_END ID="22164" />
97 jpm 500
<RELATION_END ID="27872" />
16 jpm 501
</RELATIONS_END>
14 jpm 502
<INDICES>
503
<INDEX ID="1450" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
504
<INDEXCOLUMNS>
505
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
506
</INDEXCOLUMNS>
507
</INDEX>
508
</INDICES>
509
</TABLE>
76 jpm 510
<TABLE ID="1445" Tablename="coel_structure" PrevTableName="Table_02" XPos="806" YPos="1410" 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="Contient les informations sur les structures.\nINFO : cs_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="41" >
14 jpm 511
<COLUMNS>
55 jpm 512
<COLUMN ID="18411" ColName="cs_id_structure" PrevColName="idcoel_structure" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la structure.">
14 jpm 513
<OPTIONSELECTED>
514
<OPTIONSELECT Value="1" />
515
<OPTIONSELECT Value="0" />
516
</OPTIONSELECTED>
517
</COLUMN>
274 jp_milcent 518
<COLUMN ID="21627" ColName="cs_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant du projet dans lequel les informations de la structure sont saisies.">
23 jpm 519
<OPTIONSELECTED>
520
<OPTIONSELECT Value="1" />
521
<OPTIONSELECT Value="0" />
522
</OPTIONSELECTED>
523
</COLUMN>
82 jpm 524
<COLUMN ID="21165" ColName="cs_ce_mere" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant de la structure m\195\168re.">
16 jpm 525
<OPTIONSELECTED>
526
<OPTIONSELECT Value="1" />
527
<OPTIONSELECT Value="0" />
528
</OPTIONSELECTED>
529
</COLUMN>
20 jpm 530
<COLUMN ID="18555" ColName="cs_guid" PrevColName="cs_uri" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URI (LSID ou URL) de la structure. Dans le format RDF, cela sera utilis\195\169 comme URI des donn\195\169es de l\ainstitutions.">
16 jpm 531
<OPTIONSELECTED>
532
<OPTIONSELECT Value="0" />
533
</OPTIONSELECTED>
534
</COLUMN>
20 jpm 535
<COLUMN ID="18561" ColName="cs_truk_identifiant_alternatif" PrevColName="cs_identifiant_alternatif" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant alternatif. Par exemple, l\aacronyme de l\aIndex Herbariorum ou du MNHN. S\195\169parer les diff\195\169rentes valeurs par un point virgule \A;\A et le type d\aidentifiant de sa valeur par un di\195\168ze \A#\A. Exemple : IH#MPU;MNHN#163">
16 jpm 536
<OPTIONSELECTED>
537
<OPTIONSELECT Value="0" />
538
</OPTIONSELECTED>
539
</COLUMN>
540
<COLUMN ID="18556" ColName="cs_nom" PrevColName="cs_intitule" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom officiel de la structure dans sa langue d\aorigine.">
541
<OPTIONSELECTED>
542
<OPTIONSELECT Value="0" />
543
</OPTIONSELECTED>
544
</COLUMN>
20 jpm 545
<COLUMN ID="18557" ColName="cs_truk_nom_alternatif" PrevColName="cs_intitule_alternatif" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres noms de la structures. S\195\169parer les diff\195\169rentes valeurs par un point virgule \A;\A.">
16 jpm 546
<OPTIONSELECTED>
547
<OPTIONSELECT Value="0" />
548
</OPTIONSELECTED>
549
</COLUMN>
550
<COLUMN ID="18560" ColName="cs_description" PrevColName="" Pos="5" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description de la structure pour le public.">
551
<OPTIONSELECTED>
552
</OPTIONSELECTED>
553
</COLUMN>
55 jpm 554
<COLUMN ID="20789" ColName="cs_ce_type" PrevColName="cs_ce_statut" Pos="17" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du type de la structure vis \195\160 vis du standard NCD.">
16 jpm 555
<OPTIONSELECTED>
20 jpm 556
<OPTIONSELECT Value="1" />
16 jpm 557
<OPTIONSELECT Value="0" />
558
</OPTIONSELECTED>
559
</COLUMN>
170 jp_milcent 560
<COLUMN ID="21169" ColName="cs_ce_truk_type_prive" PrevColName="" Pos="24" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type priv\195\169 de structure.">
20 jpm 561
<OPTIONSELECTED>
562
<OPTIONSELECT Value="0" />
563
</OPTIONSELECTED>
564
</COLUMN>
170 jp_milcent 565
<COLUMN ID="21170" ColName="cs_ce_truk_type_public" PrevColName="" Pos="25" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type public de structure.">
20 jpm 566
<OPTIONSELECTED>
567
<OPTIONSELECT Value="0" />
568
</OPTIONSELECTED>
569
</COLUMN>
16 jpm 570
<COLUMN ID="20777" ColName="cs_adresse_01" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse principale.">
571
<OPTIONSELECTED>
572
<OPTIONSELECT Value="0" />
573
</OPTIONSELECTED>
574
</COLUMN>
575
<COLUMN ID="20778" ColName="cs_adresse_02" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Compl\195\169ment d\aadresse.">
576
<OPTIONSELECTED>
577
<OPTIONSELECT Value="0" />
578
</OPTIONSELECTED>
579
</COLUMN>
580
<COLUMN ID="20780" ColName="cs_date_fondation" PrevColName="" Pos="9" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de fondation de la structure.">
581
<OPTIONSELECTED>
582
</OPTIONSELECTED>
583
</COLUMN>
584
<COLUMN ID="20781" ColName="cs_code_postal" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(16)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Code postal.">
585
<OPTIONSELECTED>
586
<OPTIONSELECT Value="0" />
587
</OPTIONSELECTED>
588
</COLUMN>
589
<COLUMN ID="20782" ColName="cs_ville" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Ville.">
590
<OPTIONSELECTED>
591
<OPTIONSELECT Value="0" />
592
</OPTIONSELECTED>
593
</COLUMN>
584 jp_milcent 594
<COLUMN ID="20783" ColName="cs_ce_truk_region" PrevColName="cs_region" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom de la r\195\169gion (\195\169tat, province) o\195\185 est situ\195\169 la structure. Utiliser les noms du standard ISO-3166-2. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-2. ">
16 jpm 595
<OPTIONSELECTED>
596
<OPTIONSELECT Value="0" />
597
</OPTIONSELECTED>
598
</COLUMN>
584 jp_milcent 599
<COLUMN ID="20784" ColName="cs_ce_truk_pays" PrevColName="cs_pays" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom du pays de la structure. Utiliser les noms du standard ISO-3166-1. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-1.">
16 jpm 600
<OPTIONSELECTED>
601
<OPTIONSELECT Value="0" />
602
</OPTIONSELECTED>
603
</COLUMN>
99 jpm 604
<COLUMN ID="27881" ColName="cs_latitude" PrevColName="" Pos="27" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Latitude du local de la structure.">
605
<OPTIONSELECTED>
606
<OPTIONSELECT Value="0" />
607
</OPTIONSELECTED>
608
</COLUMN>
609
<COLUMN ID="27882" ColName="cs_longitude" PrevColName="" Pos="28" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Longitude du local de la structure.">
610
<OPTIONSELECTED>
611
<OPTIONSELECT Value="0" />
612
</OPTIONSELECTED>
613
</COLUMN>
584 jp_milcent 614
<COLUMN ID="20785" ColName="cs_truk_telephone" PrevColName="cs_telephone" Pos="14" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="T\195\169l\195\169phone(s) principaux de la structure (fixe, fax, portable...).">
16 jpm 615
<OPTIONSELECTED>
616
<OPTIONSELECT Value="0" />
617
</OPTIONSELECTED>
618
</COLUMN>
20 jpm 619
<COLUMN ID="20787" ColName="cs_courriel" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Courriel principal de contact de l\aorganisation ex : accueil@organisation.org, pas de mail individuel.">
16 jpm 620
<OPTIONSELECTED>
621
<OPTIONSELECT Value="0" />
622
</OPTIONSELECTED>
623
</COLUMN>
99 jpm 624
<COLUMN ID="21159" ColName="cs_truk_url" PrevColName="" Pos="22" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) du site web principal de la structure, du logo de la structure ou d\aune page web particuli\195\168re.">
20 jpm 625
<OPTIONSELECTED>
626
<OPTIONSELECT Value="0" />
627
</OPTIONSELECTED>
628
</COLUMN>
55 jpm 629
<COLUMN ID="20816" ColName="cs_nbre_personne" PrevColName="" Pos="19" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nombre de personne pr\195\169sentent dans la structure.">
16 jpm 630
<OPTIONSELECTED>
631
<OPTIONSELECT Value="1" />
632
<OPTIONSELECT Value="0" />
633
</OPTIONSELECTED>
634
</COLUMN>
20 jpm 635
<COLUMN ID="21310" ColName="cs_condition_acces" PrevColName="" Pos="26" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Conditions d\aacc\195\168s \195\160 la structure.">
636
<OPTIONSELECTED>
637
</OPTIONSELECTED>
638
</COLUMN>
639
<COLUMN ID="21311" ColName="cs_condition_usage" PrevColName="" Pos="27" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Conditions d\ausage g\195\169n\195\169rales des collections de la structure.">
640
<OPTIONSELECTED>
641
</OPTIONSELECTED>
642
</COLUMN>
168 jp_milcent 643
<COLUMN ID="27935" ColName="cs_mark_public" PrevColName="" Pos="28" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) les donn\195\169es de cette structure sont publiques.">
644
<OPTIONSELECTED>
645
</OPTIONSELECTED>
646
</COLUMN>
55 jpm 647
<COLUMN ID="20825" ColName="cs_ce_meta" PrevColName="cs_date_derniere_modif" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
16 jpm 648
<OPTIONSELECTED>
37 jpm 649
<OPTIONSELECT Value="1" />
650
<OPTIONSELECT Value="0" />
16 jpm 651
</OPTIONSELECTED>
652
</COLUMN>
14 jpm 653
</COLUMNS>
654
<RELATIONS_START>
655
<RELATION_START ID="18419" />
16 jpm 656
<RELATION_START ID="20817" />
657
<RELATION_START ID="20859" />
658
<RELATION_START ID="20861" />
20 jpm 659
<RELATION_START ID="21163" />
23 jpm 660
<RELATION_START ID="21616" />
99 jpm 661
<RELATION_START ID="27904" />
14 jpm 662
</RELATIONS_START>
16 jpm 663
<RELATIONS_END>
20 jpm 664
<RELATION_END ID="21163" />
23 jpm 665
<RELATION_END ID="21625" />
55 jpm 666
<RELATION_END ID="21957" />
667
<RELATION_END ID="21959" />
668
<RELATION_END ID="21961" />
669
<RELATION_END ID="21964" />
16 jpm 670
</RELATIONS_END>
14 jpm 671
<INDICES>
672
<INDEX ID="18412" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
673
<INDEXCOLUMNS>
674
<INDEXCOLUMN idColumn="18411" LengthParam="0" />
675
</INDEXCOLUMNS>
676
</INDEX>
677
</INDICES>
678
</TABLE>
76 jpm 679
<TABLE ID="1446" Tablename="coel_personne" PrevTableName="Table_03" XPos="1204" YPos="540" 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="Contient les informations sur les personnes.\nPar personne nous entendons \195\160 la fois les utilisateurs de l\aapplication mais aussi les personnes contacts, les botanistes collecteurs, auteurs...\nINFO : cp_fmt_nom_complet" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="68" >
14 jpm 680
<COLUMNS>
681
<COLUMN ID="1456" ColName="cp_id_personne" PrevColName="cco_id_contact" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun contact.">
682
<OPTIONSELECTED>
683
<OPTIONSELECT Value="1" />
684
<OPTIONSELECT Value="0" />
685
</OPTIONSELECTED>
686
</COLUMN>
76 jpm 687
<COLUMN ID="21624" ColName="cp_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet auquel la personne appartient. Exemple : utilisateur appli coel, HUH, IPNI...">
23 jpm 688
<OPTIONSELECTED>
689
<OPTIONSELECT Value="1" />
690
<OPTIONSELECT Value="0" />
691
</OPTIONSELECTED>
692
</COLUMN>
32 jpm 693
<COLUMN ID="1458" ColName="cp_fmt_nom_complet" PrevColName="cco_nom_complet" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom complet du contact format\195\169 pour l\aaffichage (le format peut \195\170tre diff\195\169rent en fonction du projet).">
14 jpm 694
<OPTIONSELECTED>
695
<OPTIONSELECT Value="0" />
696
</OPTIONSELECTED>
697
</COLUMN>
76 jpm 698
<COLUMN ID="1462" ColName="cp_ce_truk_prefix" PrevColName="cco_prefix" Pos="5" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Pr\195\169fixe du nom principal. Exemple : Dr., Prof., Mr., Lord, von...">
14 jpm 699
<OPTIONSELECTED>
700
<OPTIONSELECT Value="0" />
701
</OPTIONSELECTED>
702
</COLUMN>
32 jpm 703
<COLUMN ID="1460" ColName="cp_prenom" PrevColName="cco_prenom" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169nom principal (le plus connu, r\195\169pandu) de la personne. Un point virgule peut s\195\169parer le pr\195\169nom principal de pr\195\169noms secondaires \195\160 ne pas afficher dans le nom complet.">
14 jpm 704
<OPTIONSELECTED>
705
<OPTIONSELECT Value="0" />
706
</OPTIONSELECTED>
707
</COLUMN>
32 jpm 708
<COLUMN ID="1459" ColName="cp_nom" PrevColName="cco_nom" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer les lieux de r\195\169colte (code ISO des pays) s\195\169par\195\169s par des points virgules. Apr\195\168s chaque code ISO indiqu\195\169 les ann\195\169es de r\195\169colte s\195\169par\195\169es par des vigules ou des tirets pour les p\195\169riodes continues). Si le pays de r\195\169colte est inconnu utilis\195\169 un point d\ainterogration. Exemple : FR#1905-1908,1910;PS#1912.">
14 jpm 709
<OPTIONSELECTED>
710
<OPTIONSELECT Value="0" />
711
</OPTIONSELECTED>
712
</COLUMN>
76 jpm 713
<COLUMN ID="1463" ColName="cp_ce_truk_suffix" PrevColName="cco_suffix" Pos="6" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Suffixe du nom principal. Exemple : Jr, III.">
14 jpm 714
<OPTIONSELECTED>
715
<OPTIONSELECT Value="0" />
716
</OPTIONSELECTED>
717
</COLUMN>
32 jpm 718
<COLUMN ID="1461" ColName="cp_truk_nom_autre" PrevColName="cco_nom_complement" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom(s) complet alternatif et surnoms. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|Sharp, Aaron John;APN#9544-1|Sharp, Aaron John (\aJack\a)">
14 jpm 719
<OPTIONSELECTED>
720
<OPTIONSELECT Value="0" />
721
</OPTIONSELECTED>
722
</COLUMN>
20 jpm 723
<COLUMN ID="21132" ColName="cp_abreviation" PrevColName="" Pos="35" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abreviation retenu du nom.">
14 jpm 724
<OPTIONSELECTED>
725
<OPTIONSELECT Value="0" />
726
</OPTIONSELECTED>
727
</COLUMN>
32 jpm 728
<COLUMN ID="21133" ColName="cp_truk_abreviation_autre" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres abr\195\169viations du nom.">
14 jpm 729
<OPTIONSELECTED>
730
<OPTIONSELECT Value="0" />
731
</OPTIONSELECTED>
732
</COLUMN>
20 jpm 733
<COLUMN ID="21123" ColName="cp_naissance_date" PrevColName="cp_date_naissance" Pos="30" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de naissance de la personne.">
14 jpm 734
<OPTIONSELECTED>
20 jpm 735
</OPTIONSELECTED>
736
</COLUMN>
32 jpm 737
<COLUMN ID="21126" ColName="cp_naissance_lieu" PrevColName="" Pos="32" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lieu de naissance de la personne.">
20 jpm 738
<OPTIONSELECTED>
14 jpm 739
<OPTIONSELECT Value="0" />
740
</OPTIONSELECTED>
741
</COLUMN>
584 jp_milcent 742
<COLUMN ID="27943" ColName="cp_ce_deces" PrevColName="" Pos="40" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Permet de savoir si la personne est d\195\169c\195\169d\195\169e ou pas, ou que l\ainformation est ind\195\169termin\195\169e.">
743
<OPTIONSELECTED>
744
<OPTIONSELECT Value="1" />
745
<OPTIONSELECT Value="0" />
746
</OPTIONSELECTED>
747
</COLUMN>
20 jpm 748
<COLUMN ID="21124" ColName="cp_deces_date" PrevColName="cp_date_deces" Pos="31" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de d\195\169c\195\169s de la personne. Par d\195\169faut, si la personne n\aest pas d\195\169c\195\169d\195\169 le champ reste null. Si la personne est d\195\169c\195\169d\195\169e mais que l\aon ne connait pas la date mettre : 0000-00-00">
749
<OPTIONSELECTED>
750
</OPTIONSELECTED>
751
</COLUMN>
752
<COLUMN ID="21127" ColName="cp_deces_lieu" PrevColName="" Pos="33" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Lieu de d\195\169c\195\169s de la personne.">
753
<OPTIONSELECTED>
754
<OPTIONSELECT Value="0" />
755
</OPTIONSELECTED>
756
</COLUMN>
76 jpm 757
<COLUMN ID="21974" ColName="cp_ce_sexe" PrevColName="" Pos="38" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Indique si la personne est un homme ou une femme...">
74 jpm 758
<OPTIONSELECTED>
759
<OPTIONSELECT Value="1" />
760
<OPTIONSELECT Value="0" />
761
</OPTIONSELECTED>
762
</COLUMN>
67 jpm 763
<COLUMN ID="21968" ColName="cp_description" PrevColName="" Pos="35" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Informations diverses sur la personne.">
764
<OPTIONSELECTED>
765
</OPTIONSELECTED>
766
</COLUMN>
20 jpm 767
<COLUMN ID="21258" ColName="cp_biographie" PrevColName="" Pos="35" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Vie et renomm\195\169e (locale, r\195\169gionale, ...) de la personne.">
768
<OPTIONSELECTED>
769
</OPTIONSELECTED>
770
</COLUMN>
16 jpm 771
<COLUMN ID="18392" ColName="cp_adresse_01" PrevColName="cco_perso_adresse" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse de la personne.">
14 jpm 772
<OPTIONSELECTED>
773
<OPTIONSELECT Value="0" />
774
</OPTIONSELECTED>
775
</COLUMN>
16 jpm 776
<COLUMN ID="18391" ColName="cp_adresse_02" PrevColName="cco_perso_adresse_complement" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Compl\195\169ment d\aadresse personnelle.">
14 jpm 777
<OPTIONSELECTED>
778
<OPTIONSELECT Value="0" />
779
</OPTIONSELECTED>
780
</COLUMN>
584 jp_milcent 781
<COLUMN ID="18394" ColName="cp_ce_truk_region" PrevColName="cco_perso_region" Pos="15" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom de la r\195\169gion (\195\169tat, province) o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-2. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-2.">
14 jpm 782
<OPTIONSELECTED>
783
<OPTIONSELECT Value="0" />
784
</OPTIONSELECTED>
785
</COLUMN>
16 jpm 786
<COLUMN ID="18390" ColName="cp_bp" PrevColName="cco_perso_bp" Pos="11" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Boite postale de l\aadresse de la personne.">
14 jpm 787
<OPTIONSELECTED>
788
<OPTIONSELECT Value="0" />
789
</OPTIONSELECTED>
790
</COLUMN>
16 jpm 791
<COLUMN ID="18395" ColName="cp_code_postal" PrevColName="cco_perso_code_postal" Pos="16" idDatatype="20" DatatypeParams="(10)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Code postal (zip) personnel.">
14 jpm 792
<OPTIONSELECTED>
793
<OPTIONSELECT Value="0" />
794
</OPTIONSELECTED>
795
</COLUMN>
16 jpm 796
<COLUMN ID="18393" ColName="cp_ville" PrevColName="cco_perso_ville" Pos="14" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la localit\195\169 (ville) o\195\185 vit la personne.">
14 jpm 797
<OPTIONSELECTED>
798
<OPTIONSELECT Value="0" />
799
</OPTIONSELECTED>
800
</COLUMN>
584 jp_milcent 801
<COLUMN ID="18396" ColName="cp_ce_truk_pays" PrevColName="cco_perso_pays" Pos="17" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du pays o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-1. Sinon utiliser \AAUTRE\A pour stocker d\a\195\169ventuel valeur non pr\195\169sente dans ISO-3166-1.">
14 jpm 802
<OPTIONSELECTED>
803
<OPTIONSELECT Value="0" />
804
</OPTIONSELECTED>
805
</COLUMN>
584 jp_milcent 806
<COLUMN ID="18400" ColName="cp_truk_telephone" PrevColName="cco_perso_tel_complement" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro(s) de t\195\169l\195\169phone fixe (FIX), portable (GSM), Fax (FAX), pager (PAG)... personnels.">
14 jpm 807
<OPTIONSELECTED>
808
<OPTIONSELECT Value="0" />
809
</OPTIONSELECTED>
810
</COLUMN>
20 jpm 811
<COLUMN ID="18401" ColName="cp_truk_courriel" PrevColName="cco_perso_courriel" Pos="22" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse(s) de courriel personnel. Ajouter les adresses dans leur ordre d\aimportance.">
14 jpm 812
<OPTIONSELECTED>
813
<OPTIONSELECT Value="0" />
814
</OPTIONSELECTED>
815
</COLUMN>
20 jpm 816
<COLUMN ID="18402" ColName="cp_truk_url" PrevColName="cco_perso_url" Pos="23" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) de site web personnel. Ajouter les adresses dans leur ordre d\aimportance.">
14 jpm 817
<OPTIONSELECTED>
818
<OPTIONSELECT Value="0" />
819
</OPTIONSELECTED>
820
</COLUMN>
584 jp_milcent 821
<COLUMN ID="18403" ColName="cp_truk_logo" PrevColName="cco_perso_logo" Pos="24" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) des logo, avatar, portrait ou photo de la personne. Ajouter les URL(s) dans leur ordre d\aimportance.">
14 jpm 822
<OPTIONSELECTED>
823
<OPTIONSELECT Value="0" />
824
</OPTIONSELECTED>
825
</COLUMN>
76 jpm 826
<COLUMN ID="18436" ColName="cp_ce_truk_specialite" PrevColName="cp_bota_specialite" Pos="29" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Indiquer s\195\169parer par des points virgules \A;\A les sp\195\169cialit\195\169s naturalistes de la personne.">
14 jpm 827
<OPTIONSELECTED>
828
<OPTIONSELECT Value="0" />
829
</OPTIONSELECTED>
830
</COLUMN>
32 jpm 831
<COLUMN ID="21129" ColName="cp_truk_recolte" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer les lieux de r\195\169colte s\195\169par\195\169s par des points virgules. Indiquer le r\195\169f\195\169rentiel g\195\169ographique utilis\195\169 puis apr\195\168s un # mettre le code ou identitifiant de la zone g\195\169ographique. Apr\195\168s chaque code ISO un peut signe pipe | peut \195\170tre suivi des ann\195\169es de r\195\169colte s\195\169par\195\169es par des vigules ou des tirets pour les p\195\169riodes continues). Si le pays de r\195\169colte est inconnu utilis\195\169 un point d\ainterogration. Exemple : ISO-3166-1#FR|1905-1908,1910;ISO-3166-1#PS|1912;ISO-3166-2#FR-34|1917.">
14 jpm 832
<OPTIONSELECTED>
833
<OPTIONSELECT Value="0" />
834
</OPTIONSELECTED>
835
</COLUMN>
76 jpm 836
<COLUMN ID="21554" ColName="cp_ce_truk_role" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="R\195\180le g\195\169n\195\169rale de la personne vis \195\160 vis de l\aensemble des projets : superadmin, admin...">
23 jpm 837
<OPTIONSELECTED>
838
<OPTIONSELECT Value="0" />
839
</OPTIONSELECTED>
840
</COLUMN>
76 jpm 841
<COLUMN ID="18446" ColName="cp_mark_licence" PrevColName="cp_bool_licence" Pos="33" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique quand la valeur vaut 1 que l\autilisateur a accept\195\169 la licence d\autilisation de l\aapplication. ">
14 jpm 842
<OPTIONSELECTED>
20 jpm 843
</OPTIONSELECTED>
844
</COLUMN>
67 jpm 845
<COLUMN ID="21972" ColName="cp_parametre" PrevColName="" Pos="37" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Parametres de l\autilisateur vis \195\160 vis de l\aapplication.">
846
<OPTIONSELECTED>
847
</OPTIONSELECTED>
848
</COLUMN>
66 jpm 849
<COLUMN ID="21966" ColName="cp_session_id" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de session de la personne utilisatrice de l\aapplication.">
850
<OPTIONSELECTED>
851
<OPTIONSELECT Value="0" />
852
</OPTIONSELECTED>
853
</COLUMN>
20 jpm 854
<COLUMN ID="18438" ColName="cp_login" PrevColName="" Pos="31" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Login de la personne pour acc\195\169der \195\160 l\aapplication.">
855
<OPTIONSELECTED>
14 jpm 856
<OPTIONSELECT Value="0" />
857
</OPTIONSELECTED>
858
</COLUMN>
66 jpm 859
<COLUMN ID="18439" ColName="cp_mot_de_passe" PrevColName="" Pos="32" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mot de passe de la personne pour acc\195\169der \195\160 l\aapplication. Encod\195\169 par SHA1.">
14 jpm 860
<OPTIONSELECTED>
861
<OPTIONSELECT Value="0" />
862
</OPTIONSELECTED>
863
</COLUMN>
67 jpm 864
<COLUMN ID="21970" ColName="cp_ce_annuaire_tela" PrevColName="" Pos="36" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la personne dans l\aannuaire de Tela Botanica.">
865
<OPTIONSELECTED>
866
<OPTIONSELECT Value="1" />
867
<OPTIONSELECT Value="0" />
868
</OPTIONSELECTED>
869
</COLUMN>
168 jp_milcent 870
<COLUMN ID="27938" ColName="cp_mark_public" PrevColName="" Pos="39" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) les donn\195\169es de cette personne sont publiques.">
871
<OPTIONSELECTED>
872
</OPTIONSELECTED>
873
</COLUMN>
76 jpm 874
<COLUMN ID="18405" ColName="cp_ce_meta" PrevColName="cco_" Pos="26" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
14 jpm 875
<OPTIONSELECTED>
37 jpm 876
<OPTIONSELECT Value="1" />
877
<OPTIONSELECT Value="0" />
14 jpm 878
</OPTIONSELECTED>
879
</COLUMN>
16 jpm 880
</COLUMNS>
881
<RELATIONS_START>
882
<RELATION_START ID="18425" />
20 jpm 883
<RELATION_START ID="21110" />
884
<RELATION_START ID="21239" />
23 jpm 885
<RELATION_START ID="21563" />
24 jpm 886
<RELATION_START ID="21666" />
26 jpm 887
<RELATION_START ID="21789" />
16 jpm 888
</RELATIONS_START>
889
<RELATIONS_END>
23 jpm 890
<RELATION_END ID="21622" />
76 jpm 891
<RELATION_END ID="22062" />
892
<RELATION_END ID="22099" />
893
<RELATION_END ID="22101" />
894
<RELATION_END ID="22133" />
895
<RELATION_END ID="22135" />
896
<RELATION_END ID="22137" />
16 jpm 897
</RELATIONS_END>
898
<INDICES>
899
<INDEX ID="1457" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
900
<INDEXCOLUMNS>
901
<INDEXCOLUMN idColumn="1456" LengthParam="0" />
902
</INDEXCOLUMNS>
903
</INDEX>
904
</INDICES>
905
</TABLE>
76 jpm 906
<TABLE ID="1447" Tablename="coel_structure_a_personne" PrevTableName="Table_04" XPos="1203" YPos="1523" 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="Table de liaison permettant d\aindiquer la composition de la structure en personnel.\nElle permet d\aindiquer pour une personne vis \195\160 vis d\aune structure :\n - si elle est contact\n - les informations de la personne sp\195\169cifique \195\160 cette structure (ex. : t\195\169l\195\169phone du travail, fonction, service, statut...)." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="60" >
16 jpm 907
<COLUMNS>
37 jpm 908
<COLUMN ID="21568" ColName="csap_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure.">
14 jpm 909
<OPTIONSELECTED>
910
<OPTIONSELECT Value="1" />
911
<OPTIONSELECT Value="0" />
912
</OPTIONSELECTED>
913
</COLUMN>
24 jpm 914
<COLUMN ID="21567" ColName="csap_id_personne" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune personne.">
14 jpm 915
<OPTIONSELECTED>
16 jpm 916
<OPTIONSELECT Value="1" />
14 jpm 917
<OPTIONSELECT Value="0" />
918
</OPTIONSELECTED>
919
</COLUMN>
234 jp_milcent 920
<COLUMN ID="21609" ColName="csap_id_role" PrevColName="cspa_id_role" Pos="11" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="R\195\180le de la personne vis \195\160 vis de la structure.">
14 jpm 921
<OPTIONSELECTED>
23 jpm 922
<OPTIONSELECT Value="1" />
16 jpm 923
<OPTIONSELECT Value="0" />
14 jpm 924
</OPTIONSELECTED>
925
</COLUMN>
76 jpm 926
<COLUMN ID="18533" ColName="csap_ce_truk_fonction" PrevColName="csae_fonction" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Intitul\195\169 de la fonction de la personne dans son travail.">
14 jpm 927
<OPTIONSELECTED>
16 jpm 928
<OPTIONSELECT Value="0" />
929
</OPTIONSELECTED>
930
</COLUMN>
23 jpm 931
<COLUMN ID="18534" ColName="csap_service" PrevColName="csae_service" Pos="8" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du service ou d\195\169partement dans lequel la personne travaille.">
16 jpm 932
<OPTIONSELECTED>
933
<OPTIONSELECT Value="0" />
934
</OPTIONSELECTED>
935
</COLUMN>
76 jpm 936
<COLUMN ID="18537" ColName="csap_ce_truk_statut" PrevColName="csae_statut" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Statut(s) de la personne : salari\195\169, b\195\169n\195\169vole...">
16 jpm 937
<OPTIONSELECTED>
23 jpm 938
<OPTIONSELECT Value="0" />
16 jpm 939
</OPTIONSELECTED>
940
</COLUMN>
23 jpm 941
<COLUMN ID="18433" ColName="csap_mark_contact" PrevColName="csae_bool_contact" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Si la personne est un contact la valeur vaut 1 sinon c\aest 0.">
16 jpm 942
<OPTIONSELECTED>
23 jpm 943
</OPTIONSELECTED>
944
</COLUMN>
37 jpm 945
<COLUMN ID="18546" ColName="csap_bota_travail_hebdo_tps" PrevColName="csae_bota_travail_hebdo_tps" Pos="10" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de la derni\195\168re modification sur cet enregistrement.">
23 jpm 946
<OPTIONSELECTED>
14 jpm 947
<OPTIONSELECT Value="1" />
948
<OPTIONSELECT Value="0" />
949
</OPTIONSELECTED>
950
</COLUMN>
76 jpm 951
<COLUMN ID="18442" ColName="csap_ce_meta" PrevColName="csae_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
14 jpm 952
<OPTIONSELECTED>
37 jpm 953
<OPTIONSELECT Value="1" />
954
<OPTIONSELECT Value="0" />
16 jpm 955
</OPTIONSELECTED>
956
</COLUMN>
14 jpm 957
</COLUMNS>
16 jpm 958
<RELATIONS_END>
959
<RELATION_END ID="18419" />
960
<RELATION_END ID="18425" />
76 jpm 961
<RELATION_END ID="22073" />
962
<RELATION_END ID="22142" />
963
<RELATION_END ID="22144" />
234 jp_milcent 964
<RELATION_END ID="27941" />
16 jpm 965
</RELATIONS_END>
966
<INDICES>
967
<INDEX ID="20888" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
968
<INDEXCOLUMNS>
23 jpm 969
<INDEXCOLUMN idColumn="21568" LengthParam="0" />
970
<INDEXCOLUMN idColumn="21567" LengthParam="0" />
971
<INDEXCOLUMN idColumn="21609" LengthParam="0" />
16 jpm 972
</INDEXCOLUMNS>
973
</INDEX>
974
</INDICES>
975
</TABLE>
76 jpm 976
<TABLE ID="18452" Tablename="coel_meta_donnee" PrevTableName="Table_06" XPos="272" YPos="312" 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="Contient les champs suppl\195\169mentaires (non standard ou de sp\195\169cialisation) de la base de donn\195\169es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="30" >
16 jpm 977
<COLUMNS>
37 jpm 978
<COLUMN ID="18454" ColName="cmd_id_donnee" PrevColName="cmt_id_donnee" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la donn\195\169e.">
16 jpm 979
<OPTIONSELECTED>
980
<OPTIONSELECT Value="1" />
981
<OPTIONSELECT Value="0" />
982
</OPTIONSELECTED>
983
</COLUMN>
76 jpm 984
<COLUMN ID="21806" ColName="cmd_ce_table" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la table.">
16 jpm 985
<OPTIONSELECTED>
37 jpm 986
<OPTIONSELECT Value="1" />
16 jpm 987
<OPTIONSELECT Value="0" />
988
</OPTIONSELECTED>
989
</COLUMN>
37 jpm 990
<COLUMN ID="20804" ColName="cmd_ce_ligne" PrevColName="cmd_ce_identifiant" Pos="3" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la ligne \195\160 laquelle le champ dans la table d\aorigine appartient. Pour les tables \195\160 cl\195\169 primaire multi colonnes, bien respecter l\aordre des champs de la cl\195\169 et inscrire chaque valeur de cl\195\169 s\195\169par\195\169e par un tiret \A-\A.">
25 jpm 991
<OPTIONSELECTED>
992
<OPTIONSELECT Value="0" />
993
</OPTIONSELECTED>
994
</COLUMN>
37 jpm 995
<COLUMN ID="21797" ColName="cmd_ce_champ" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du champ.">
25 jpm 996
<OPTIONSELECTED>
37 jpm 997
<OPTIONSELECT Value="1" />
25 jpm 998
<OPTIONSELECT Value="0" />
999
</OPTIONSELECTED>
1000
</COLUMN>
37 jpm 1001
<COLUMN ID="18479" ColName="cmd_valeur" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur.">
1002
<OPTIONSELECTED>
1003
<OPTIONSELECT Value="0" />
1004
</OPTIONSELECTED>
1005
</COLUMN>
16 jpm 1006
</COLUMNS>
37 jpm 1007
<RELATIONS_END>
1008
<RELATION_END ID="18470" />
76 jpm 1009
<RELATION_END ID="22091" />
37 jpm 1010
</RELATIONS_END>
14 jpm 1011
<INDICES>
37 jpm 1012
<INDEX ID="18455" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1013
<INDEXCOLUMNS>
37 jpm 1014
<INDEXCOLUMN idColumn="18454" LengthParam="0" />
14 jpm 1015
</INDEXCOLUMNS>
1016
</INDEX>
1017
</INDICES>
1018
</TABLE>
76 jpm 1019
<TABLE ID="18456" Tablename="coel_meta_colonne" PrevTableName="Table_07" XPos="572" YPos="93" 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="Contient l\aensemble des champs des tables de la base de donn\195\169es.\nINFO : cmc_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" >
14 jpm 1020
<COLUMNS>
37 jpm 1021
<COLUMN ID="18458" ColName="cmc_id_champ" PrevColName="cmc_id_caracteristique" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant du nom du champ dans la table.">
14 jpm 1022
<OPTIONSELECTED>
1023
<OPTIONSELECT Value="1" />
1024
<OPTIONSELECT Value="0" />
1025
</OPTIONSELECTED>
1026
</COLUMN>
76 jpm 1027
<COLUMN ID="21832" ColName="cmc_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet.">
14 jpm 1028
<OPTIONSELECTED>
1029
<OPTIONSELECT Value="1" />
1030
<OPTIONSELECT Value="0" />
1031
</OPTIONSELECTED>
1032
</COLUMN>
76 jpm 1033
<COLUMN ID="21824" ColName="cmc_ce_liste" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la liste de valeur poss\195\169d\195\169e par cette colonne.">
14 jpm 1034
<OPTIONSELECTED>
1035
<OPTIONSELECT Value="1" />
1036
<OPTIONSELECT Value="0" />
1037
</OPTIONSELECTED>
1038
</COLUMN>
76 jpm 1039
<COLUMN ID="21800" ColName="cmc_ce_table" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la table \195\160 laquelle ce champ appartient.">
14 jpm 1040
<OPTIONSELECTED>
16 jpm 1041
<OPTIONSELECT Value="1" />
1042
<OPTIONSELECT Value="0" />
14 jpm 1043
</OPTIONSELECTED>
1044
</COLUMN>
37 jpm 1045
<COLUMN ID="18503" ColName="cmc_nom" PrevColName="cmc_intitule" Pos="2" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 du champ.">
14 jpm 1046
<OPTIONSELECTED>
16 jpm 1047
<OPTIONSELECT Value="0" />
14 jpm 1048
</OPTIONSELECTED>
1049
</COLUMN>
37 jpm 1050
<COLUMN ID="21732" ColName="cmc_abreviation" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation du champ.">
14 jpm 1051
<OPTIONSELECTED>
1052
<OPTIONSELECT Value="0" />
1053
</OPTIONSELECTED>
1054
</COLUMN>
37 jpm 1055
<COLUMN ID="21733" ColName="cmc_description" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description du champ.">
14 jpm 1056
<OPTIONSELECTED>
1057
<OPTIONSELECT Value="0" />
1058
</OPTIONSELECTED>
1059
</COLUMN>
76 jpm 1060
<COLUMN ID="21809" ColName="cmc_ce_format_sql" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du format SQL utilis\195\169 pour ce champ.">
16 jpm 1061
<OPTIONSELECTED>
25 jpm 1062
<OPTIONSELECT Value="1" />
16 jpm 1063
<OPTIONSELECT Value="0" />
1064
</OPTIONSELECTED>
1065
</COLUMN>
41 jpm 1066
<COLUMN ID="21810" ColName="cmc_taille" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Taille du format SQL du champ.">
25 jpm 1067
<OPTIONSELECTED>
1068
<OPTIONSELECT Value="0" />
1069
</OPTIONSELECTED>
1070
</COLUMN>
76 jpm 1071
<COLUMN ID="21835" ColName="cmc_ce_meta" PrevColName="cmc_ce_modifier_par" Pos="10" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
25 jpm 1072
<OPTIONSELECTED>
37 jpm 1073
<OPTIONSELECT Value="1" />
25 jpm 1074
<OPTIONSELECT Value="0" />
1075
</OPTIONSELECTED>
1076
</COLUMN>
14 jpm 1077
</COLUMNS>
16 jpm 1078
<RELATIONS_START>
1079
<RELATION_START ID="18470" />
1080
<RELATION_START ID="18504" />
1081
</RELATIONS_START>
14 jpm 1082
<RELATIONS_END>
37 jpm 1083
<RELATION_END ID="21822" />
1084
<RELATION_END ID="21830" />
1085
<RELATION_END ID="21863" />
76 jpm 1086
<RELATION_END ID="22087" />
1087
<RELATION_END ID="22089" />
14 jpm 1088
</RELATIONS_END>
1089
<INDICES>
16 jpm 1090
<INDEX ID="18459" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1091
<INDEXCOLUMNS>
16 jpm 1092
<INDEXCOLUMN idColumn="18458" LengthParam="0" />
14 jpm 1093
</INDEXCOLUMNS>
1094
</INDEX>
16 jpm 1095
</INDICES>
1096
</TABLE>
139 jpm 1097
<TABLE ID="18466" Tablename="coel_meta_liste_valeur" PrevTableName="Table_09" XPos="108" YPos="57" 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="Liste l\aensemble des valeurs des tables de type liste.\nUn champ contient des valeurs dans cette table quand il est de type \ALISTE\A.\nINFO : cmlv_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" >
16 jpm 1098
<COLUMNS>
37 jpm 1099
<COLUMN ID="18468" ColName="cmlv_id_valeur" PrevColName="cmv_id_valeur" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune valeur de liste. Notez que les listes sont des valeurs de la liste des listes.">
16 jpm 1100
<OPTIONSELECTED>
1101
<OPTIONSELECT Value="1" />
1102
<OPTIONSELECT Value="0" />
1103
</OPTIONSELECTED>
1104
</COLUMN>
37 jpm 1105
<COLUMN ID="21821" ColName="cmlv_ce_parent" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la cat\195\169gorie ou des informations sur la liste. Les listes ont pour parent la valeur 0 qui correspond \195\160 la liste des listes.">
16 jpm 1106
<OPTIONSELECTED>
1107
<OPTIONSELECT Value="1" />
1108
<OPTIONSELECT Value="0" />
1109
</OPTIONSELECTED>
1110
</COLUMN>
37 jpm 1111
<COLUMN ID="21818" ColName="cmlv_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet de la valeur.">
16 jpm 1112
<OPTIONSELECTED>
1113
<OPTIONSELECT Value="1" />
1114
<OPTIONSELECT Value="0" />
1115
</OPTIONSELECTED>
1116
</COLUMN>
42 jpm 1117
<COLUMN ID="21723" ColName="cmlv_nom" PrevColName="cmv_nom" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la valeur.">
16 jpm 1118
<OPTIONSELECTED>
1119
<OPTIONSELECT Value="0" />
1120
</OPTIONSELECTED>
1121
</COLUMN>
76 jpm 1122
<COLUMN ID="21724" ColName="cmlv_abreviation" PrevColName="cmv_abreviation" Pos="3" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation, code ou identifiant de la valeur.">
25 jpm 1123
<OPTIONSELECTED>
1124
<OPTIONSELECT Value="0" />
1125
</OPTIONSELECTED>
1126
</COLUMN>
37 jpm 1127
<COLUMN ID="21725" ColName="cmlv_description" PrevColName="cmv_description" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description de cette valeur.">
25 jpm 1128
<OPTIONSELECTED>
1129
<OPTIONSELECT Value="0" />
1130
</OPTIONSELECTED>
1131
</COLUMN>
76 jpm 1132
<COLUMN ID="21814" ColName="cmlv_ce_meta" PrevColName="cmlv_ce_modifier_par" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
25 jpm 1133
<OPTIONSELECTED>
37 jpm 1134
<OPTIONSELECT Value="1" />
25 jpm 1135
<OPTIONSELECT Value="0" />
1136
</OPTIONSELECTED>
1137
</COLUMN>
16 jpm 1138
</COLUMNS>
37 jpm 1139
<RELATIONS_START>
1140
<RELATION_START ID="21819" />
1141
<RELATION_START ID="21822" />
55 jpm 1142
<RELATION_START ID="21959" />
1143
<RELATION_START ID="21961" />
1144
<RELATION_START ID="21964" />
76 jpm 1145
<RELATION_START ID="22071" />
1146
<RELATION_START ID="22087" />
1147
<RELATION_START ID="22089" />
1148
<RELATION_START ID="22091" />
1149
<RELATION_START ID="22093" />
1150
<RELATION_START ID="22096" />
1151
<RELATION_START ID="22099" />
1152
<RELATION_START ID="22101" />
1153
<RELATION_START ID="22133" />
1154
<RELATION_START ID="22135" />
1155
<RELATION_START ID="22137" />
1156
<RELATION_START ID="22142" />
1157
<RELATION_START ID="22144" />
1158
<RELATION_START ID="22146" />
1159
<RELATION_START ID="22148" />
1160
<RELATION_START ID="22150" />
1161
<RELATION_START ID="22152" />
1162
<RELATION_START ID="22154" />
1163
<RELATION_START ID="22158" />
1164
<RELATION_START ID="22160" />
1165
<RELATION_START ID="22162" />
1166
<RELATION_START ID="22164" />
1167
<RELATION_START ID="22170" />
1168
<RELATION_START ID="22172" />
1169
<RELATION_START ID="22174" />
1170
<RELATION_START ID="22178" />
1171
<RELATION_START ID="22301" />
1172
<RELATION_START ID="22306" />
1173
<RELATION_START ID="22308" />
1174
<RELATION_START ID="22309" />
1175
<RELATION_START ID="22311" />
1176
<RELATION_START ID="22313" />
1177
<RELATION_START ID="22315" />
1178
<RELATION_START ID="22318" />
1179
<RELATION_START ID="22320" />
1180
<RELATION_START ID="22322" />
1181
<RELATION_START ID="22324" />
1182
<RELATION_START ID="22326" />
97 jpm 1183
<RELATION_START ID="27872" />
99 jpm 1184
<RELATION_START ID="27908" />
1185
<RELATION_START ID="27910" />
1186
<RELATION_START ID="27912" />
234 jp_milcent 1187
<RELATION_START ID="27941" />
37 jpm 1188
</RELATIONS_START>
16 jpm 1189
<RELATIONS_END>
37 jpm 1190
<RELATION_END ID="21816" />
1191
<RELATION_END ID="21819" />
1192
<RELATION_END ID="21861" />
16 jpm 1193
</RELATIONS_END>
1194
<INDICES>
1195
<INDEX ID="18469" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1196
<INDEXCOLUMNS>
1197
<INDEXCOLUMN idColumn="18468" LengthParam="0" />
1198
</INDEXCOLUMNS>
1199
</INDEX>
1200
</INDICES>
1201
</TABLE>
76 jpm 1202
<TABLE ID="18498" Tablename="coel_meta_historique_colonne" PrevTableName="Table_10" XPos="840" YPos="316" 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="Contient l\ahistorique des valeurs des champs pour les enregistrements des tables de la base de donn\195\169es.\n" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="39" >
16 jpm 1203
<COLUMNS>
37 jpm 1204
<COLUMN ID="18500" ColName="cmhc_id_historique_colonne" PrevColName="cmh_id_historisation" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de cet enregistrement historis\195\169.">
16 jpm 1205
<OPTIONSELECTED>
1206
<OPTIONSELECT Value="1" />
1207
<OPTIONSELECT Value="0" />
1208
</OPTIONSELECTED>
1209
</COLUMN>
76 jpm 1210
<COLUMN ID="21858" ColName="cmhc_ce_historique_ligne" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
16 jpm 1211
<OPTIONSELECTED>
1212
<OPTIONSELECT Value="1" />
1213
<OPTIONSELECT Value="0" />
1214
</OPTIONSELECTED>
1215
</COLUMN>
37 jpm 1216
<COLUMN ID="21795" ColName="cmhc_ce_champ" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du champ.">
16 jpm 1217
<OPTIONSELECTED>
1218
<OPTIONSELECT Value="1" />
1219
<OPTIONSELECT Value="0" />
1220
</OPTIONSELECTED>
1221
</COLUMN>
26 jpm 1222
<COLUMN ID="18513" ColName="cmhc_valeur" PrevColName="cmh_valeur" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur du champ pour cette ligne.">
16 jpm 1223
<OPTIONSELECTED>
1224
<OPTIONSELECT Value="0" />
1225
</OPTIONSELECTED>
1226
</COLUMN>
1227
</COLUMNS>
1228
<RELATIONS_END>
1229
<RELATION_END ID="18504" />
37 jpm 1230
<RELATION_END ID="21856" />
16 jpm 1231
</RELATIONS_END>
1232
<INDICES>
1233
<INDEX ID="18501" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1234
<INDEXCOLUMNS>
1235
<INDEXCOLUMN idColumn="18500" LengthParam="0" />
1236
</INDEXCOLUMNS>
1237
</INDEX>
1238
</INDICES>
1239
</TABLE>
76 jpm 1240
<TABLE ID="20850" Tablename="coel_structure_conservation" PrevTableName="Table_11" XPos="1170" YPos="1795" 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="Toutes les donn\195\169es sp\195\169cifiques \195\160 la conservation au sein d\aune structure." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="54" >
16 jpm 1241
<COLUMNS>
76 jpm 1242
<COLUMN ID="20978" ColName="csc_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure.">
16 jpm 1243
<OPTIONSELECTED>
1244
<OPTIONSELECT Value="1" />
1245
<OPTIONSELECT Value="0" />
1246
</OPTIONSELECTED>
1247
</COLUMN>
1248
<COLUMN ID="20869" ColName="csc_mark_formation" PrevColName="" Pos="1" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Le personnel s\aoccupant des collections botaniques a-t-il suivi des formations en conservation\194\160?">
1249
<OPTIONSELECTED>
1250
</OPTIONSELECTED>
1251
</COLUMN>
20 jpm 1252
<COLUMN ID="20871" ColName="csc_formation" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les formations en conservation suvi par le personnel.">
16 jpm 1253
<OPTIONSELECTED>
1254
<OPTIONSELECT Value="0" />
1255
</OPTIONSELECTED>
1256
</COLUMN>
1257
<COLUMN ID="20872" ColName="csc_mark_formation_interet" PrevColName="" Pos="3" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le personnel s\aoccupant des collections botaniques a-t-il suivi des formations en conservation\194\160?">
1258
<OPTIONSELECTED>
1259
</OPTIONSELECTED>
1260
</COLUMN>
20 jpm 1261
<COLUMN ID="20874" ColName="csc_truk_stockage_local" PrevColName="csc_ce_stockage_local" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Avez-vous des locaux sp\195\169cifiques de stockage des collections botaniques\194\160?">
16 jpm 1262
<OPTIONSELECTED>
20 jpm 1263
<OPTIONSELECT Value="0" />
1264
</OPTIONSELECTED>
1265
</COLUMN>
1266
<COLUMN ID="20912" ColName="csc_truk_stockage_meuble" PrevColName="csc_stockage_meuble" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Avez-vous des meubles sp\195\169cifiques au stockage des collections botaniques\194\160? ">
1267
<OPTIONSELECTED>
1268
<OPTIONSELECT Value="0" />
1269
</OPTIONSELECTED>
1270
</COLUMN>
1271
<COLUMN ID="20914" ColName="csc_truk_stockage_parametre" PrevColName="csc" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quels param\195\168tres ma\195\174trisez-vous ?">
1272
<OPTIONSELECTED>
1273
<OPTIONSELECT Value="0" />
1274
</OPTIONSELECTED>
1275
</COLUMN>
1276
<COLUMN ID="20952" ColName="csc_mark_collection_commune" PrevColName="" Pos="7" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Les collections botaniques sont-elles conserv\195\169es avec d\aautres collections dans les m\195\170mes locaux\194\160(probl\195\168me de conservation en commun) ? ">
1277
<OPTIONSELECTED>
1278
</OPTIONSELECTED>
1279
</COLUMN>
1280
<COLUMN ID="20954" ColName="csc_truk_collection_autre" PrevColName="csc_truk_collection_ature" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Actuellement, vos collections botaniques s\aaccroissent-elles de nouvelles acquisitions\194\160?">
1281
<OPTIONSELECTED>
1282
<OPTIONSELECT Value="0" />
1283
</OPTIONSELECTED>
1284
</COLUMN>
1285
<COLUMN ID="20960" ColName="csc_mark_acces_controle" PrevColName="" Pos="9" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="L\aacc\195\168s \195\160 vos collections botaniques est-il contr\195\180l\195\169 (ex.\194\160: manipulation r\195\169serv\195\169e \195\160 des personnes comp\195\169tentes)\194\160?">
1286
<OPTIONSELECTED>
1287
</OPTIONSELECTED>
1288
</COLUMN>
1289
<COLUMN ID="20961" ColName="csc_mark_restauration" PrevColName="" Pos="10" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Effectuez-vous actuellement des op\195\169rations de restauration ou de remise en \195\169tat de vos collections botaniques\194\160?">
1290
<OPTIONSELECTED>
1291
</OPTIONSELECTED>
1292
</COLUMN>
1293
<COLUMN ID="20963" ColName="csc_truk_restauration_operation" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les diff\195\169rentes op\195\169rations de restauration actuellement men\195\169es.">
1294
<OPTIONSELECTED>
1295
<OPTIONSELECT Value="0" />
1296
</OPTIONSELECTED>
1297
</COLUMN>
76 jpm 1298
<COLUMN ID="20964" ColName="csc_ce_materiel_conservation" PrevColName="" Pos="12" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Utilisez-vous du mat\195\169riel de conservation ?">
20 jpm 1299
<OPTIONSELECTED>
16 jpm 1300
<OPTIONSELECT Value="1" />
1301
<OPTIONSELECT Value="0" />
1302
</OPTIONSELECTED>
1303
</COLUMN>
20 jpm 1304
<COLUMN ID="20967" ColName="csc_truk_materiel_autre" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Le mat\195\169riel, dit de \Anon conservation\A utilis\195\169.">
16 jpm 1305
<OPTIONSELECTED>
1306
<OPTIONSELECT Value="0" />
1307
</OPTIONSELECTED>
1308
</COLUMN>
20 jpm 1309
<COLUMN ID="20969" ColName="csc_mark_traitement" PrevColName="" Pos="14" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\169alisez-vous actuellement des traitements globaux contre les insectes\194\160?">
1310
<OPTIONSELECTED>
1311
</OPTIONSELECTED>
1312
</COLUMN>
1313
<COLUMN ID="20970" ColName="csc_truk_traitement" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Traitements globaux contre les insectes.">
1314
<OPTIONSELECTED>
1315
<OPTIONSELECT Value="0" />
1316
</OPTIONSELECTED>
1317
</COLUMN>
1318
<COLUMN ID="20971" ColName="csc_mark_acquisition_collection" PrevColName="csc_mark_acquisition" Pos="16" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Actuellement, vos collections botaniques s\aaccroissent-elles de nouvelles acquisitions\194\160?">
1319
<OPTIONSELECTED>
1320
</OPTIONSELECTED>
1321
</COLUMN>
1322
<COLUMN ID="20973" ColName="csc_mark_acquisition_echantillon" PrevColName="" Pos="17" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Actuellement mettez-vous en herbier de nouveaux \195\169chantillons\194\160? ">
1323
<OPTIONSELECTED>
1324
</OPTIONSELECTED>
1325
</COLUMN>
1326
<COLUMN ID="20974" ColName="csc_mark_acquisition_traitement" PrevColName="" Pos="18" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Si oui, faites-vous un traitement contre les insectes avant l\aint\195\169gration dans vos collections\194\160?">
1327
<OPTIONSELECTED>
1328
</OPTIONSELECTED>
1329
</COLUMN>
1330
<COLUMN ID="20975" ColName="csc_truk_acquisition_traitement_poison" PrevColName="" Pos="19" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Traitement de type empoisonnement effectu\195\169 lors des des acquisitions.">
1331
<OPTIONSELECTED>
1332
<OPTIONSELECT Value="0" />
1333
</OPTIONSELECTED>
1334
</COLUMN>
1335
<COLUMN ID="20976" ColName="csc_truk_acquisition_traitement_insecte" PrevColName="" Pos="20" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Traitement de type d\195\169sinctisation effectu\195\169 lors des des acquisitions.">
1336
<OPTIONSELECTED>
1337
<OPTIONSELECT Value="0" />
1338
</OPTIONSELECTED>
1339
</COLUMN>
139 jpm 1340
<COLUMN ID="27914" ColName="csc_ce_meta" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
1341
<OPTIONSELECTED>
1342
<OPTIONSELECT Value="1" />
1343
<OPTIONSELECT Value="0" />
1344
</OPTIONSELECTED>
1345
</COLUMN>
16 jpm 1346
</COLUMNS>
1347
<RELATIONS_END>
1348
<RELATION_END ID="20859" />
76 jpm 1349
<RELATION_END ID="22146" />
139 jpm 1350
<RELATION_END ID="27921" />
16 jpm 1351
</RELATIONS_END>
1352
<INDICES>
20 jpm 1353
<INDEX ID="20979" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
16 jpm 1354
<INDEXCOLUMNS>
20 jpm 1355
<INDEXCOLUMN idColumn="20978" LengthParam="0" />
16 jpm 1356
</INDEXCOLUMNS>
1357
</INDEX>
1358
</INDICES>
1359
</TABLE>
139 jpm 1360
<TABLE ID="20854" Tablename="coel_structure_valorisation" PrevTableName="Table_12" XPos="827" YPos="2027" 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="Toutes les donn\195\169es sp\195\169cifiques \195\160 la valorisation au sein d\aune structure." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" >
16 jpm 1361
<COLUMNS>
76 jpm 1362
<COLUMN ID="20866" ColName="csv_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure.">
16 jpm 1363
<OPTIONSELECTED>
1364
<OPTIONSELECT Value="1" />
1365
<OPTIONSELECT Value="0" />
1366
</OPTIONSELECTED>
1367
</COLUMN>
20 jpm 1368
<COLUMN ID="20981" ColName="csv_mark_action" PrevColName="" Pos="1" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Avez-vous r\195\169alis\195\169 des actions de valorisation de vos collections botaniques\194\160ou avez-vous \195\169t\195\169 sollicit\195\169s pour la valorisation de ces collections ?">
1369
<OPTIONSELECTED>
1370
</OPTIONSELECTED>
1371
</COLUMN>
1372
<COLUMN ID="20982" ColName="csv_truk_action" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les actions de valorisation r\195\169alis\195\169es.">
1373
<OPTIONSELECTED>
1374
<OPTIONSELECT Value="0" />
1375
</OPTIONSELECTED>
1376
</COLUMN>
1377
<COLUMN ID="20983" ColName="csv_publication" PrevColName="" Pos="3" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quelques titres des ouvrages, articles scientifiques, ... ?">
1378
<OPTIONSELECTED>
1379
</OPTIONSELECTED>
1380
</COLUMN>
207 jp_milcent 1381
<COLUMN ID="20984" ColName="csv_collection_autre" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="L\aorganisme dispose-t-il d\aautres collections (permettant une valorisation pluridisciplinaire)\194\160?">
20 jpm 1382
<OPTIONSELECTED>
1383
<OPTIONSELECT Value="0" />
1384
</OPTIONSELECTED>
1385
</COLUMN>
1386
<COLUMN ID="20985" ColName="csv_mark_action_future" PrevColName="" Pos="5" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Envisagez-vous des actions de valorisation dans le cadre de votre politique culturelle\194\160?">
1387
<OPTIONSELECTED>
1388
</OPTIONSELECTED>
1389
</COLUMN>
1390
<COLUMN ID="20986" ColName="csv_action_future" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les actions de valorisation futures envisag\195\169es.">
1391
<OPTIONSELECTED>
1392
<OPTIONSELECT Value="0" />
1393
</OPTIONSELECTED>
1394
</COLUMN>
1395
<COLUMN ID="20987" ColName="csv_mark_recherche" PrevColName="" Pos="7" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Vos collections botaniques sont-elles utilis\195\169es pour des recherches scientifiques\194\160?">
1396
<OPTIONSELECTED>
1397
</OPTIONSELECTED>
1398
</COLUMN>
1399
<COLUMN ID="20988" ColName="csv_truk_recherche_provenance" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Si oui, par des chercheurs (professionnels ou amateurs ) de  quelle provenance\194\160?">
1400
<OPTIONSELECTED>
1401
<OPTIONSELECT Value="0" />
1402
</OPTIONSELECTED>
1403
</COLUMN>
1404
<COLUMN ID="20990" ColName="csv_truk_recherche_type" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Et pour quelles types de recherches\194\160? ">
1405
<OPTIONSELECTED>
1406
<OPTIONSELECT Value="0" />
1407
</OPTIONSELECTED>
1408
</COLUMN>
1409
<COLUMN ID="20992" ColName="csv_mark_acces_ss_motif" PrevColName="" Pos="10" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Peut-on consulter vos collections botaniques sans motif de recherches scientifiques ?">
1410
<OPTIONSELECTED>
1411
</OPTIONSELECTED>
1412
</COLUMN>
1413
<COLUMN ID="20993" ColName="csv_acces_ss_motif" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Si oui, quelles d\195\169marches doit-on faire pour les consulter\194\160?">
1414
<OPTIONSELECTED>
1415
<OPTIONSELECT Value="0" />
1416
</OPTIONSELECTED>
1417
</COLUMN>
139 jpm 1418
<COLUMN ID="20994" ColName="csv_mark_visite_avec_motif" PrevColName="csv_mark_visite_ss_motif" Pos="12" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Peut-on visiter vos collections botaniques en avec des objectifs de recherches scientifiques\194\160?">
20 jpm 1419
<OPTIONSELECTED>
1420
</OPTIONSELECTED>
1421
</COLUMN>
139 jpm 1422
<COLUMN ID="20995" ColName="csv_visite_avec_motif" PrevColName="csv_visite_ss_motif" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Si oui, quelles d\195\169marches doit-on faire pour les visiter\194\160?">
20 jpm 1423
<OPTIONSELECTED>
1424
<OPTIONSELECT Value="0" />
1425
</OPTIONSELECTED>
1426
</COLUMN>
139 jpm 1427
<COLUMN ID="27918" ColName="csv_ce_meta" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
1428
<OPTIONSELECTED>
1429
<OPTIONSELECT Value="1" />
1430
<OPTIONSELECT Value="0" />
1431
</OPTIONSELECTED>
1432
</COLUMN>
16 jpm 1433
</COLUMNS>
1434
<RELATIONS_END>
1435
<RELATION_END ID="20861" />
139 jpm 1436
<RELATION_END ID="27924" />
16 jpm 1437
</RELATIONS_END>
1438
<INDICES>
1439
<INDEX ID="20867" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1440
<INDEXCOLUMNS>
1441
<INDEXCOLUMN idColumn="20866" LengthParam="0" />
1442
</INDEXCOLUMNS>
1443
</INDEX>
1444
</INDICES>
1445
</TABLE>
76 jpm 1446
<TABLE ID="21104" Tablename="coel_collection_a_personne" PrevTableName="Table_14" XPos="473" YPos="1068" 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="Permet de lister les personnes en rapport avec une collection." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" >
20 jpm 1447
<COLUMNS>
76 jpm 1448
<COLUMN ID="21106" ColName="ccap_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection associ\195\169e \195\160 une personne.">
20 jpm 1449
<OPTIONSELECTED>
1450
<OPTIONSELECT Value="1" />
1451
<OPTIONSELECT Value="0" />
1452
</OPTIONSELECTED>
1453
</COLUMN>
1454
<COLUMN ID="21112" ColName="ccap_id_personne" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne associ\195\169e \195\160 une collection.">
1455
<OPTIONSELECTED>
1456
<OPTIONSELECT Value="1" />
1457
<OPTIONSELECT Value="0" />
1458
</OPTIONSELECTED>
1459
</COLUMN>
76 jpm 1460
<COLUMN ID="21139" ColName="ccap_id_role" PrevColName="ccap_ce_truk_role" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="R\195\180le(s) de la personne : auteur, collecteur... permet aussi de conna\195\174tre qui a les droits de modification sur la collection.">
20 jpm 1461
<OPTIONSELECTED>
1462
<OPTIONSELECT Value="0" />
1463
</OPTIONSELECTED>
1464
</COLUMN>
76 jpm 1465
<COLUMN ID="21115" ColName="ccap_ce_meta" PrevColName="ccap_date_derniere_modif" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
20 jpm 1466
<OPTIONSELECTED>
37 jpm 1467
<OPTIONSELECT Value="1" />
1468
<OPTIONSELECT Value="0" />
20 jpm 1469
</OPTIONSELECTED>
1470
</COLUMN>
1471
</COLUMNS>
1472
<RELATIONS_END>
1473
<RELATION_END ID="21108" />
1474
<RELATION_END ID="21110" />
76 jpm 1475
<RELATION_END ID="22077" />
1476
<RELATION_END ID="22154" />
20 jpm 1477
</RELATIONS_END>
1478
<INDICES>
1479
<INDEX ID="21107" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1480
<INDEXCOLUMNS>
1481
<INDEXCOLUMN idColumn="21106" LengthParam="0" />
1482
<INDEXCOLUMN idColumn="21112" LengthParam="0" />
23 jpm 1483
<INDEXCOLUMN idColumn="21139" LengthParam="0" />
20 jpm 1484
</INDEXCOLUMNS>
1485
</INDEX>
1486
</INDICES>
1487
</TABLE>
82 jpm 1488
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="443" YPos="1329" 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="Toutes les informations sp\195\169cialis\195\169es sur une collection de type : botanique" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
20 jpm 1489
<COLUMNS>
76 jpm 1490
<COLUMN ID="21150" ColName="ccb_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection botanique.">
20 jpm 1491
<OPTIONSELECTED>
1492
<OPTIONSELECT Value="1" />
1493
<OPTIONSELECT Value="0" />
1494
</OPTIONSELECTED>
1495
</COLUMN>
82 jpm 1496
<COLUMN ID="26508" ColName="ccb_ce_truk_type" PrevColName="" Pos="41" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de collection botanique.">
20 jpm 1497
<OPTIONSELECTED>
1498
<OPTIONSELECT Value="0" />
1499
</OPTIONSELECTED>
1500
</COLUMN>
23 jpm 1501
<COLUMN ID="21343" ColName="ccb_truk_unite_rangement" PrevColName="ccb_truk" Pos="2" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) unit\195\169 de rangement de la collection botanique. \\\nPour chaque type : indication du nombre d\aunit\195\169, de la pr\195\169cision du nom (exact, approximatif), des formats.">
22 jpm 1502
<OPTIONSELECTED>
1503
<OPTIONSELECT Value="0" />
1504
</OPTIONSELECTED>
1505
</COLUMN>
76 jpm 1506
<COLUMN ID="21348" ColName="ccb_ce_unite_rangement_etat" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="\195\137tat de la majorit\195\169 des unit\195\169s de rangements (\195\169tat des rubans, des poign\195\169es, des sangles, des cartons...).">
22 jpm 1507
<OPTIONSELECTED>
1508
<OPTIONSELECT Value="1" />
1509
<OPTIONSELECT Value="0" />
1510
</OPTIONSELECTED>
1511
</COLUMN>
76 jpm 1512
<COLUMN ID="21350" ColName="ccb_truk_unite_base" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) d\aunit\195\169 de base de la collection,\194\160 si diff\195\169rent de l\aunit\195\169 de rangement. \\  Ex. : si l\aunit\195\169 de rangement est un carton, l\aunit\195\169 de base peut \195\170tre  une enveloppe. \\  Pour chaque type : indication du nombre d\aunit\195\169, de la pr\195\169cision du nom (exact = 1, approximatif = 0), des formats (Lxl cm), du nombre de parts, de la pr\195\169cision sur le nombre de parts  (exact = 1, approximatif = 0), du nombre d\aesp\195\168ces, de la pr\195\169cision sur le nombre d\aesp\195\168ces (exact, approximatif).">
22 jpm 1513
<OPTIONSELECTED>
1514
<OPTIONSELECT Value="0" />
1515
</OPTIONSELECTED>
1516
</COLUMN>
1517
<COLUMN ID="21355" ColName="ccb_truk_conservation_papier_type" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) du papier de conservation.">
1518
<OPTIONSELECTED>
1519
<OPTIONSELECT Value="0" />
1520
</OPTIONSELECTED>
1521
</COLUMN>
1522
<COLUMN ID="21356" ColName="ccb_truk_conservation_methode" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de m\195\169thode de conservation.">
1523
<OPTIONSELECTED>
1524
<OPTIONSELECT Value="0" />
1525
</OPTIONSELECTED>
1526
</COLUMN>
76 jpm 1527
<COLUMN ID="21357" ColName="ccb_specimen_fixation_pourcent" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage de sp\195\169cimens fix\195\169s.">
22 jpm 1528
<OPTIONSELECTED>
1529
<OPTIONSELECT Value="1" />
1530
<OPTIONSELECT Value="0" />
1531
</OPTIONSELECTED>
1532
</COLUMN>
76 jpm 1533
<COLUMN ID="21358" ColName="ccb_etiquette_fixation_pourcent" PrevColName="" Pos="8" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage d\a\195\169tiquettes fix\195\169es.">
22 jpm 1534
<OPTIONSELECTED>
1535
<OPTIONSELECT Value="1" />
1536
<OPTIONSELECT Value="0" />
1537
</OPTIONSELECTED>
1538
</COLUMN>
1539
<COLUMN ID="21359" ColName="ccb_truk_specimen_fixation_methode" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de fixation des sp\195\169cimens.">
1540
<OPTIONSELECTED>
1541
<OPTIONSELECT Value="0" />
1542
</OPTIONSELECTED>
1543
</COLUMN>
1544
<COLUMN ID="21361" ColName="ccb_truk_etiquette_fixation_support" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de fixation des \195\169tiquettes fix\195\169es au support.">
1545
<OPTIONSELECTED>
1546
<OPTIONSELECT Value="0" />
1547
</OPTIONSELECTED>
1548
</COLUMN>
1549
<COLUMN ID="21362" ColName="ccb_truk_etiquette_fixation_specimen" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de fixation des \195\169tiquettes fix\195\169es au sp\195\169cimen.">
1550
<OPTIONSELECTED>
1551
<OPTIONSELECT Value="0" />
1552
</OPTIONSELECTED>
1553
</COLUMN>
1554
<COLUMN ID="21364" ColName="ccb_truk_etiquette_ecriture" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) d\a\195\169criture sur les \195\169tiquettes.">
1555
<OPTIONSELECTED>
1556
<OPTIONSELECT Value="0" />
1557
</OPTIONSELECTED>
1558
</COLUMN>
76 jpm 1559
<COLUMN ID="21365" ColName="ccb_ce_traitement" PrevColName="" Pos="13" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="La collection botanique semble-t-elle avoir \195\169t\195\169 empoisonn\195\169e ou d\195\169sinsectis\195\169e lors de sa r\195\169alisation ?">
22 jpm 1560
<OPTIONSELECTED>
1561
<OPTIONSELECT Value="1" />
1562
<OPTIONSELECT Value="0" />
1563
</OPTIONSELECTED>
1564
</COLUMN>
1565
<COLUMN ID="21366" ColName="ccb_truk_traitement_poison" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) d\aempoisonement de la collection.">
1566
<OPTIONSELECTED>
1567
<OPTIONSELECT Value="0" />
1568
</OPTIONSELECTED>
1569
</COLUMN>
97 jpm 1570
<COLUMN ID="21367" ColName="ccb_truk_traitement_insecte" PrevColName="ccb_truk_traitement_isecte" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de d\195\169sinctisation de la collection.">
22 jpm 1571
<OPTIONSELECTED>
1572
<OPTIONSELECT Value="0" />
1573
</OPTIONSELECTED>
1574
</COLUMN>
76 jpm 1575
<COLUMN ID="21368" ColName="ccb_ce_etat_general" PrevColName="" Pos="16" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="\195\137tat g\195\169n\195\169ral de la collection\194\160(grosses attaques d\ainsectes, pourriture, papier tr\195\168s fragile, etc... de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon \195\169tat).">
22 jpm 1576
<OPTIONSELECTED>
1577
<OPTIONSELECT Value="1" />
1578
<OPTIONSELECT Value="0" />
1579
</OPTIONSELECTED>
1580
</COLUMN>
1581
<COLUMN ID="21369" ColName="ccb_truk_degradation_specimen" PrevColName="" Pos="17" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de causes des d\195\169gradations des sp\195\169cimens not\195\169es de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon \195\169tat.">
1582
<OPTIONSELECTED>
1583
<OPTIONSELECT Value="0" />
1584
</OPTIONSELECTED>
1585
</COLUMN>
1586
<COLUMN ID="21370" ColName="ccb_truk_degradation_presentation" PrevColName="" Pos="18" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de causes des d\195\169gradations de la pr\195\169sentation not\195\169es de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon \195\169tat.">
1587
<OPTIONSELECTED>
1588
<OPTIONSELECT Value="0" />
1589
</OPTIONSELECTED>
1590
</COLUMN>
76 jpm 1591
<COLUMN ID="21371" ColName="ccb_ce_determination" PrevColName="" Pos="19" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Les \195\169chantillons sont-ils d\195\169terminables ? (de 1\194\160: quelques fragment de plantes \195\160 5 plantes enti\195\168res).">
22 jpm 1592
<OPTIONSELECTED>
1593
<OPTIONSELECT Value="1" />
1594
<OPTIONSELECT Value="0" />
1595
</OPTIONSELECTED>
1596
</COLUMN>
41 jpm 1597
<COLUMN ID="21944" ColName="ccb_truk_nature" PrevColName="" Pos="40" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nature de l\aherbier.">
1598
<OPTIONSELECTED>
1599
<OPTIONSELECT Value="0" />
1600
</OPTIONSELECTED>
1601
</COLUMN>
1602
<COLUMN ID="21945" ColName="ccb_specialite" PrevColName="" Pos="41" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Collection botanique sp\195\169cialis\195\169e (ex. herbier de c\195\169r\195\169ales...)">
1603
<OPTIONSELECTED>
1604
<OPTIONSELECT Value="0" />
1605
</OPTIONSELECTED>
1606
</COLUMN>
23 jpm 1607
<COLUMN ID="21471" ColName="ccb_recolte_date_debut" PrevColName="" Pos="20" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date extr\195\170me de d\195\169but de r\195\169colte.">
1608
<OPTIONSELECTED>
1609
</OPTIONSELECTED>
1610
</COLUMN>
76 jpm 1611
<COLUMN ID="22303" ColName="ccb_ce_recolte_date_debut_type" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de date extr\195\170me de d\195\169but de r\195\169colte.">
23 jpm 1612
<OPTIONSELECTED>
1613
<OPTIONSELECT Value="1" />
1614
<OPTIONSELECT Value="0" />
1615
</OPTIONSELECTED>
1616
</COLUMN>
1617
<COLUMN ID="21474" ColName="ccb_recolte_date_fin" PrevColName="" Pos="22" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date extr\195\170me de fin de r\195\169colte.">
1618
<OPTIONSELECTED>
1619
</OPTIONSELECTED>
1620
</COLUMN>
76 jpm 1621
<COLUMN ID="21475" ColName="ccb_ce_recolte_date_fin_type" PrevColName="" Pos="23" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Type de date extr\195\170me de fin de r\195\169colte.">
23 jpm 1622
<OPTIONSELECTED>
1623
<OPTIONSELECT Value="1" />
1624
<OPTIONSELECT Value="0" />
1625
</OPTIONSELECTED>
1626
</COLUMN>
1627
<COLUMN ID="21477" ColName="ccb_annotation_classement" PrevColName="ccb_classement" Pos="24" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer le type de classement ou des informations concernant un \195\169ventuel classement.">
1628
<OPTIONSELECTED>
1629
</OPTIONSELECTED>
1630
</COLUMN>
76 jpm 1631
<COLUMN ID="21478" ColName="ccb_ce_classement_etat" PrevColName="" Pos="25" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="\195\137tat du classement (de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon).">
23 jpm 1632
<OPTIONSELECTED>
1633
<OPTIONSELECT Value="1" />
1634
<OPTIONSELECT Value="0" />
1635
</OPTIONSELECTED>
1636
</COLUMN>
1637
<COLUMN ID="21479" ColName="ccb_truk_etiquette_renseignement" PrevColName="" Pos="26" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage pour chaque type de renseignements port\195\169s sur l\a\195\169tiquette\194\160ou sur la part.">
1638
<OPTIONSELECTED>
1639
<OPTIONSELECT Value="0" />
1640
</OPTIONSELECTED>
1641
</COLUMN>
76 jpm 1642
<COLUMN ID="21480" ColName="ccb_ce_precision_localite" PrevColName="" Pos="27" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Les localit\195\169s sont elles pr\195\169cises?">
23 jpm 1643
<OPTIONSELECTED>
1644
<OPTIONSELECT Value="1" />
1645
<OPTIONSELECT Value="0" />
1646
</OPTIONSELECTED>
1647
</COLUMN>
76 jpm 1648
<COLUMN ID="21481" ColName="ccb_ce_precision_date" PrevColName="" Pos="28" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Les dates sont elles pr\195\169cises?">
23 jpm 1649
<OPTIONSELECTED>
1650
<OPTIONSELECT Value="1" />
1651
<OPTIONSELECT Value="0" />
1652
</OPTIONSELECTED>
1653
</COLUMN>
1654
<COLUMN ID="21483" ColName="ccb_annotation_diverse" PrevColName="ccb_truk_annotation" Pos="29" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres annotations (dons, annotations personnelles, recettes, utilisations m\195\169dicales...).">
1655
<OPTIONSELECTED>
1656
</OPTIONSELECTED>
1657
</COLUMN>
76 jpm 1658
<COLUMN ID="21501" ColName="ccb_ce_collection_integre" PrevColName="" Pos="30" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="La collection observ\195\169e int\195\168gre-t-elle des collections botaniques ant\195\169rieures ?">
23 jpm 1659
<OPTIONSELECTED>
1660
<OPTIONSELECT Value="1" />
1661
<OPTIONSELECT Value="0" />
1662
</OPTIONSELECTED>
1663
</COLUMN>
76 jpm 1664
<COLUMN ID="21502" ColName="ccb_ce_collection_integre_info" PrevColName="ccb_collection_integre_info" Pos="31" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Les noms de ces collections sont-ils not\195\169s sur les \195\169tiquettes de chaque \195\169chantillon\194\160?">
23 jpm 1665
<OPTIONSELECTED>
1666
<OPTIONSELECT Value="1" />
1667
<OPTIONSELECT Value="0" />
1668
</OPTIONSELECTED>
1669
</COLUMN>
76 jpm 1670
<COLUMN ID="21514" ColName="ccb_ce_inventaire" PrevColName="" Pos="32" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Existe-t-il un inventaire de cette collection?">
23 jpm 1671
<OPTIONSELECTED>
1672
<OPTIONSELECT Value="1" />
1673
<OPTIONSELECT Value="0" />
1674
</OPTIONSELECTED>
1675
</COLUMN>
76 jpm 1676
<COLUMN ID="21515" ColName="ccb_ce_inventaire_auteur" PrevColName="" Pos="33" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="L\aauteur de la collection a-t-il particip\195\169 \195\160 cet inventaire?">
23 jpm 1677
<OPTIONSELECTED>
1678
<OPTIONSELECT Value="1" />
1679
<OPTIONSELECT Value="0" />
1680
</OPTIONSELECTED>
1681
</COLUMN>
76 jpm 1682
<COLUMN ID="21517" ColName="ccb_ce_inventaire_forme" PrevColName="" Pos="35" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Forme de l\ainventaire (mnauscrit, informatique...).">
23 jpm 1683
<OPTIONSELECTED>
1684
<OPTIONSELECT Value="1" />
1685
<OPTIONSELECT Value="0" />
1686
</OPTIONSELECTED>
1687
</COLUMN>
1688
<COLUMN ID="21516" ColName="ccb_inventaire_info" PrevColName="" Pos="34" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quelles informations retrouve-t-on?">
1689
<OPTIONSELECTED>
1690
</OPTIONSELECTED>
1691
</COLUMN>
76 jpm 1692
<COLUMN ID="21518" ColName="ccb_ce_truk_inventaire_digital" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Si inventaire digial, quel logiciel utilisez vous?">
23 jpm 1693
<OPTIONSELECTED>
1694
<OPTIONSELECT Value="0" />
1695
</OPTIONSELECTED>
1696
</COLUMN>
76 jpm 1697
<COLUMN ID="21519" ColName="ccb_inventaire_digital_pourcent" PrevColName="" Pos="37" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage de la documentation en base de donn\195\169es.">
23 jpm 1698
<OPTIONSELECTED>
1699
<OPTIONSELECT Value="1" />
1700
<OPTIONSELECT Value="0" />
1701
</OPTIONSELECTED>
1702
</COLUMN>
76 jpm 1703
<COLUMN ID="21520" ColName="ccb_ce_inventaire_etat" PrevColName="ccb_inventaire_etat" Pos="38" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="L\ainventaire est il complet ou partiel?">
23 jpm 1704
<OPTIONSELECTED>
1705
<OPTIONSELECT Value="1" />
1706
<OPTIONSELECT Value="0" />
1707
</OPTIONSELECTED>
1708
</COLUMN>
1709
<COLUMN ID="21521" ColName="ccb_inventaire_donnee_type" PrevColName="" Pos="39" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quels sont les \195\169l\195\169ments qui ont d\195\169j\195\160 \195\169t\195\169 inventori\195\169s (Ex. : familles, localit\195\169s...) ?">
1710
<OPTIONSELECTED>
1711
</OPTIONSELECTED>
1712
</COLUMN>
139 jpm 1713
<COLUMN ID="27920" ColName="ccb_ce_meta" PrevColName="" Pos="42" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
1714
<OPTIONSELECTED>
1715
<OPTIONSELECT Value="1" />
1716
<OPTIONSELECT Value="0" />
1717
</OPTIONSELECTED>
1718
</COLUMN>
20 jpm 1719
</COLUMNS>
1720
<RELATIONS_END>
1721
<RELATION_END ID="21152" />
76 jpm 1722
<RELATION_END ID="22170" />
1723
<RELATION_END ID="22172" />
1724
<RELATION_END ID="22174" />
1725
<RELATION_END ID="22178" />
1726
<RELATION_END ID="22301" />
1727
<RELATION_END ID="22306" />
1728
<RELATION_END ID="22308" />
1729
<RELATION_END ID="22309" />
1730
<RELATION_END ID="22311" />
1731
<RELATION_END ID="22313" />
1732
<RELATION_END ID="22315" />
1733
<RELATION_END ID="22318" />
1734
<RELATION_END ID="22320" />
1735
<RELATION_END ID="22322" />
1736
<RELATION_END ID="22324" />
1737
<RELATION_END ID="22326" />
139 jpm 1738
<RELATION_END ID="27927" />
20 jpm 1739
</RELATIONS_END>
1740
<INDICES>
1741
<INDEX ID="21151" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1742
<INDEXCOLUMNS>
1743
<INDEXCOLUMN idColumn="21150" LengthParam="0" />
1744
</INDEXCOLUMNS>
1745
</INDEX>
1746
</INDICES>
1747
</TABLE>
139 jpm 1748
<TABLE ID="21188" Tablename="coel_publication" PrevTableName="Table_15" XPos="98" YPos="2368" 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="Publication de type articles scientifiques, ouvrages ou sites web.\nINFO : cpu_fmt_nom_complet" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="76" >
20 jpm 1749
<COLUMNS>
76 jpm 1750
<COLUMN ID="21190" ColName="cpu_id_publication" PrevColName="cp_id_publication" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la publication.">
20 jpm 1751
<OPTIONSELECTED>
1752
<OPTIONSELECT Value="1" />
1753
<OPTIONSELECT Value="0" />
1754
</OPTIONSELECTED>
1755
</COLUMN>
76 jpm 1756
<COLUMN ID="21633" ColName="cpu_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel les donn\195\169es de cet enregistrement ont \195\169t\195\169 saisies.">
20 jpm 1757
<OPTIONSELECTED>
1758
<OPTIONSELECT Value="1" />
1759
<OPTIONSELECT Value="0" />
1760
</OPTIONSELECTED>
1761
</COLUMN>
234 jp_milcent 1762
<COLUMN ID="21955" ColName="cpu_fmt_nom_complet" PrevColName="cpu_fmt_nom" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la publication complet : fmt_auteur, date_parution(ann\195\169e). titre. Editeur (nom), collection, fascicule, indication_nvt. pages.">
42 jpm 1763
<OPTIONSELECTED>
1764
<OPTIONSELECT Value="0" />
1765
</OPTIONSELECTED>
1766
</COLUMN>
20 jpm 1767
<COLUMN ID="21305" ColName="cpu_uri" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URI de la publication qui peut \195\170tre un site web...">
1768
<OPTIONSELECTED>
1769
<OPTIONSELECT Value="0" />
1770
</OPTIONSELECTED>
1771
</COLUMN>
23 jpm 1772
<COLUMN ID="21205" ColName="cpu_fmt_auteur" PrevColName="cpu_truk_auteur" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient le nom format\195\169 de l\aintitul\195\169 auteur(s). Si plusieurs personnes sont auteurs, l\aintitul\195\169 est format\195\169 ici.">
20 jpm 1773
<OPTIONSELECTED>
1774
<OPTIONSELECT Value="0" />
1775
</OPTIONSELECTED>
1776
</COLUMN>
1777
<COLUMN ID="21193" ColName="cpu_titre" PrevColName="cp_titre" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Titre de l\aarticle ou de l\aouvrage.">
1778
<OPTIONSELECTED>
1779
<OPTIONSELECT Value="0" />
1780
</OPTIONSELECTED>
1781
</COLUMN>
86 jpm 1782
<COLUMN ID="26510" ColName="cpu_ce_truk_editeur" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure \195\169ditrice de la publication. S\ail n\aest pas renseignn\195\169 dans la table Structure, contient AUTRE# suivit du nom complet de la structure \195\169ditrice.">
20 jpm 1783
<OPTIONSELECTED>
1784
<OPTIONSELECT Value="0" />
1785
</OPTIONSELECTED>
1786
</COLUMN>
86 jpm 1787
<COLUMN ID="21198" ColName="cpu_collection" PrevColName="cpu_intitule_collection" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la collection, c\aest \195\160 dire de la revue.">
20 jpm 1788
<OPTIONSELECTED>
1789
<OPTIONSELECT Value="0" />
1790
</OPTIONSELECTED>
1791
</COLUMN>
1792
<COLUMN ID="21206" ColName="cpu_date_parution" PrevColName="" Pos="7" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de parution de la publication.">
1793
<OPTIONSELECTED>
1794
</OPTIONSELECTED>
1795
</COLUMN>
1796
<COLUMN ID="21211" ColName="cpu_indication_nvt" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indication du num\195\169ro, volume ou tome de la publication. Plut\195\180t utilis\195\169 pour les ouvrages et non les articles de revue.">
1797
<OPTIONSELECTED>
1798
<OPTIONSELECT Value="0" />
1799
</OPTIONSELECTED>
1800
</COLUMN>
23 jpm 1801
<COLUMN ID="21212" ColName="cpu_fascicule" PrevColName="cpu_titre_fascicule" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indication du titre du fascicule. Surtout utilis\195\169 pour les revues.">
20 jpm 1802
<OPTIONSELECTED>
1803
<OPTIONSELECT Value="0" />
1804
</OPTIONSELECTED>
1805
</COLUMN>
1806
<COLUMN ID="21213" ColName="cpu_truk_pages" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(25)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indication du nombre de pages (pour les ouvrages) ou des pages de d\195\169but et de fin pour un artcile. Dans le cas des ouvrages un nombre doit \195\170tre pr\195\169sent. Pour les articles deux nombres ou point d\aint\195\169rogation s\195\169par\195\169s par un tiret.">
1807
<OPTIONSELECTED>
1808
<OPTIONSELECT Value="0" />
1809
</OPTIONSELECTED>
1810
</COLUMN>
76 jpm 1811
<COLUMN ID="21215" ColName="cpu_ce_meta" PrevColName="cpu_date_derniere_modif" Pos="12" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
20 jpm 1812
<OPTIONSELECTED>
1813
<OPTIONSELECT Value="1" />
1814
<OPTIONSELECT Value="0" />
1815
</OPTIONSELECTED>
1816
</COLUMN>
1817
</COLUMNS>
1818
<RELATIONS_START>
1819
<RELATION_START ID="21226" />
1820
<RELATION_START ID="21241" />
1821
</RELATIONS_START>
1822
<RELATIONS_END>
23 jpm 1823
<RELATION_END ID="21616" />
1824
<RELATION_END ID="21631" />
76 jpm 1825
<RELATION_END ID="22083" />
20 jpm 1826
</RELATIONS_END>
1827
<INDICES>
1828
<INDEX ID="21191" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1829
<INDEXCOLUMNS>
1830
<INDEXCOLUMN idColumn="21190" LengthParam="0" />
1831
</INDEXCOLUMNS>
1832
</INDEX>
1833
</INDICES>
1834
</TABLE>
76 jpm 1835
<TABLE ID="21219" Tablename="coel_collection_a_publication" PrevTableName="Table_16" XPos="45" YPos="2181" 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="Permet de lister les publication li\195\169es \195\160 une collection." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" >
20 jpm 1836
<COLUMNS>
76 jpm 1837
<COLUMN ID="21225" ColName="ccapu_id_collection" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de collection.">
20 jpm 1838
<OPTIONSELECTED>
1839
<OPTIONSELECT Value="1" />
1840
<OPTIONSELECT Value="0" />
1841
</OPTIONSELECTED>
1842
</COLUMN>
76 jpm 1843
<COLUMN ID="21244" ColName="ccapu_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la publication.">
20 jpm 1844
<OPTIONSELECTED>
1845
<OPTIONSELECT Value="1" />
1846
<OPTIONSELECT Value="0" />
1847
</OPTIONSELECTED>
1848
</COLUMN>
1849
<COLUMN ID="21316" ColName="ccapu_mark_licence" PrevColName="" Pos="6" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Bool\195\169en indiquant si la publication indiqu\195\169 correspond aux droits de propri\195\169t\195\169s intellectuelles de la collection.">
1850
<OPTIONSELECTED>
1851
</OPTIONSELECTED>
1852
</COLUMN>
76 jpm 1853
<COLUMN ID="21232" ColName="ccapu_ce_meta" PrevColName="ccapu_date_derniere_modif" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
20 jpm 1854
<OPTIONSELECTED>
37 jpm 1855
<OPTIONSELECT Value="1" />
1856
<OPTIONSELECT Value="0" />
20 jpm 1857
</OPTIONSELECTED>
1858
</COLUMN>
1859
</COLUMNS>
1860
<RELATIONS_END>
1861
<RELATION_END ID="21223" />
1862
<RELATION_END ID="21226" />
76 jpm 1863
<RELATION_END ID="22081" />
20 jpm 1864
</RELATIONS_END>
1865
<INDICES>
1866
<INDEX ID="21222" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1867
<INDEXCOLUMNS>
1868
<INDEXCOLUMN idColumn="21225" LengthParam="0" />
1869
<INDEXCOLUMN idColumn="21244" LengthParam="0" />
1870
</INDEXCOLUMNS>
1871
</INDEX>
1872
</INDICES>
1873
</TABLE>
139 jpm 1874
<TABLE ID="21235" Tablename="coel_publication_a_personne" PrevTableName="Table_17" XPos="508" YPos="2404" 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="Permet de lister les publications d\aune personne." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="77" >
20 jpm 1875
<COLUMNS>
76 jpm 1876
<COLUMN ID="21571" ColName="cpuap_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune publication.">
20 jpm 1877
<OPTIONSELECTED>
1878
<OPTIONSELECT Value="1" />
1879
<OPTIONSELECT Value="0" />
1880
</OPTIONSELECTED>
1881
</COLUMN>
24 jpm 1882
<COLUMN ID="21572" ColName="cpuap_id_personne" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune personne.">
20 jpm 1883
<OPTIONSELECTED>
1884
<OPTIONSELECT Value="1" />
1885
<OPTIONSELECT Value="0" />
1886
</OPTIONSELECTED>
1887
</COLUMN>
76 jpm 1888
<COLUMN ID="21611" ColName="cpuap_id_role" PrevColName="cpupa_id_role" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="R\195\180le de la personne vis \195\160 vis de la publication : contributeur, auteur...">
20 jpm 1889
<OPTIONSELECTED>
23 jpm 1890
<OPTIONSELECT Value="1" />
20 jpm 1891
<OPTIONSELECT Value="0" />
1892
</OPTIONSELECTED>
1893
</COLUMN>
76 jpm 1894
<COLUMN ID="21247" ColName="cpuap_ce_truk_type" PrevColName="cpap_ce_truk_type" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Contient le type de r\195\169f\195\169rence bibliographique : n\195\169crologie, biographie, publication personnelle...">
20 jpm 1895
<OPTIONSELECTED>
1896
<OPTIONSELECT Value="0" />
1897
</OPTIONSELECTED>
1898
</COLUMN>
76 jpm 1899
<COLUMN ID="21249" ColName="cpuap_ce_meta" PrevColName="cpap_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
20 jpm 1900
<OPTIONSELECTED>
37 jpm 1901
<OPTIONSELECT Value="1" />
1902
<OPTIONSELECT Value="0" />
20 jpm 1903
</OPTIONSELECTED>
1904
</COLUMN>
1905
</COLUMNS>
1906
<RELATIONS_END>
1907
<RELATION_END ID="21239" />
1908
<RELATION_END ID="21241" />
76 jpm 1909
<RELATION_END ID="22085" />
1910
<RELATION_END ID="22148" />
1911
<RELATION_END ID="22150" />
20 jpm 1912
</RELATIONS_END>
1913
<INDICES>
1914
<INDEX ID="21238" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1915
<INDEXCOLUMNS>
23 jpm 1916
<INDEXCOLUMN idColumn="21571" LengthParam="0" />
1917
<INDEXCOLUMN idColumn="21572" LengthParam="0" />
1918
<INDEXCOLUMN idColumn="21611" LengthParam="0" />
20 jpm 1919
</INDEXCOLUMNS>
1920
</INDEX>
1921
</INDICES>
1922
</TABLE>
99 jpm 1923
<TABLE ID="21486" Tablename="coel_collection_a_relation" PrevTableName="Table_18" XPos="76" YPos="955" 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="Permet de lister les relations entre collection autre que hi\195\169rarchique." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" >
23 jpm 1924
<COLUMNS>
37 jpm 1925
<COLUMN ID="21660" ColName="ccar_id_collection_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1761.">
23 jpm 1926
<OPTIONSELECTED>
1927
<OPTIONSELECT Value="1" />
1928
<OPTIONSELECT Value="0" />
1929
</OPTIONSELECTED>
1930
</COLUMN>
37 jpm 1931
<COLUMN ID="21661" ColName="ccar_id_collection_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1762.">
23 jpm 1932
<OPTIONSELECTED>
1933
<OPTIONSELECT Value="1" />
1934
<OPTIONSELECT Value="0" />
1935
</OPTIONSELECTED>
1936
</COLUMN>
76 jpm 1937
<COLUMN ID="21491" ColName="ccar_id_relation" PrevColName="ccr_ce_relation" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Indentifiant du type de la relation.">
23 jpm 1938
<OPTIONSELECTED>
1939
<OPTIONSELECT Value="1" />
1940
<OPTIONSELECT Value="0" />
1941
</OPTIONSELECTED>
1942
</COLUMN>
76 jpm 1943
<COLUMN ID="21493" ColName="ccar_ce_meta" PrevColName="ccr_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
23 jpm 1944
<OPTIONSELECTED>
37 jpm 1945
<OPTIONSELECT Value="1" />
1946
<OPTIONSELECT Value="0" />
23 jpm 1947
</OPTIONSELECTED>
1948
</COLUMN>
1949
</COLUMNS>
1950
<RELATIONS_END>
1951
<RELATION_END ID="21496" />
1952
<RELATION_END ID="21498" />
76 jpm 1953
<RELATION_END ID="22075" />
1954
<RELATION_END ID="22152" />
23 jpm 1955
</RELATIONS_END>
1956
<INDICES>
1957
<INDEX ID="21489" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1958
<INDEXCOLUMNS>
1959
<INDEXCOLUMN idColumn="21660" LengthParam="0" />
1960
<INDEXCOLUMN idColumn="21661" LengthParam="0" />
24 jpm 1961
<INDEXCOLUMN idColumn="21491" LengthParam="0" />
23 jpm 1962
</INDEXCOLUMNS>
1963
</INDEX>
1964
</INDICES>
1965
</TABLE>
99 jpm 1966
<TABLE ID="21522" Tablename="coel_projet" PrevTableName="EFLORE_PROJET" XPos="57" YPos="541" 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="Contient les informations sur un projet de donn\195\169es.\nINFO : cpr_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
23 jpm 1967
<COLUMNS>
76 jpm 1968
<COLUMN ID="21523" ColName="cpr_id_projet" PrevColName="EPR_ID_PROJET" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun projet.">
23 jpm 1969
<OPTIONSELECTED>
1970
<OPTIONSELECT Value="0" />
1971
<OPTIONSELECT Value="0" />
1972
</OPTIONSELECTED>
1973
</COLUMN>
26 jpm 1974
<COLUMN ID="21526" ColName="cpr_nom" PrevColName="EPR_INTITULE_PROJET" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du projet.">
23 jpm 1975
<OPTIONSELECTED>
1976
<OPTIONSELECT Value="0" />
1977
</OPTIONSELECTED>
1978
</COLUMN>
24 jpm 1979
<COLUMN ID="21527" ColName="cpr_abreviation" PrevColName="EPR_ABREVIATION_PROJET" Pos="5" idDatatype="20" DatatypeParams="(40)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation du projet.">
23 jpm 1980
<OPTIONSELECTED>
1981
<OPTIONSELECT Value="0" />
1982
</OPTIONSELECTED>
1983
</COLUMN>
24 jpm 1984
<COLUMN ID="21528" ColName="cpr_resume" PrevColName="EPR_DESCRIPTION_PROJET" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\169sum\195\169 du projet.">
23 jpm 1985
<OPTIONSELECTED>
1986
<OPTIONSELECT Value="0" />
1987
</OPTIONSELECTED>
1988
</COLUMN>
24 jpm 1989
<COLUMN ID="21538" ColName="cpr_description" PrevColName="" Pos="6" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description d\195\169taill\195\169e du projet.">
23 jpm 1990
<OPTIONSELECTED>
1991
</OPTIONSELECTED>
1992
</COLUMN>
24 jpm 1993
<COLUMN ID="21529" ColName="cpr_url" PrevColName="EPR_LIEN_WEB" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL principal o\195\185 trouver des compl\195\169ments d\ainformation sur le projet.">
23 jpm 1994
<OPTIONSELECTED>
1995
<OPTIONSELECT Value="0" />
1996
</OPTIONSELECTED>
1997
</COLUMN>
99 jpm 1998
<COLUMN ID="27885" ColName="cpr_mot_cles" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Mots cl\195\169s correspondant au projet.">
1999
<OPTIONSELECTED>
2000
<OPTIONSELECT Value="0" />
2001
</OPTIONSELECTED>
2002
</COLUMN>
2003
<COLUMN ID="27886" ColName="cpr_citation" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indication sur la fa\195\167on de citer le projet pour r\195\169aliser une bibliographie.">
2004
<OPTIONSELECTED>
2005
<OPTIONSELECT Value="0" />
2006
</OPTIONSELECTED>
2007
</COLUMN>
2008
<COLUMN ID="27887" ColName="cpr_licence" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Url ou texte pr\195\169sentant la licence des donn\195\169es du projet.">
2009
<OPTIONSELECTED>
2010
<OPTIONSELECT Value="0" />
2011
</OPTIONSELECTED>
2012
</COLUMN>
2013
<COLUMN ID="27888" ColName="cpr_ce_langue" PrevColName="" Pos="12" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Langue principale des donn\195\169es du projet (selon l\aISO-639-1).">
2014
<OPTIONSELECTED>
2015
<OPTIONSELECT Value="1" />
2016
<OPTIONSELECT Value="0" />
2017
</OPTIONSELECTED>
2018
</COLUMN>
2019
<COLUMN ID="27889" ColName="cpr_indexation_heure" PrevColName="" Pos="13" idDatatype="17" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169f\195\169rence de l\aheure de d\195\169part pour les proc\195\169dures d\aindexation externe.">
2020
<OPTIONSELECTED>
2021
</OPTIONSELECTED>
2022
</COLUMN>
2023
<COLUMN ID="27890" ColName="cpr_ce_indexation_duree" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Dur\195\169e maximum acceptable pour une proc\195\169dure d\aindexation externe.">
2024
<OPTIONSELECTED>
2025
<OPTIONSELECT Value="1" />
2026
<OPTIONSELECT Value="0" />
2027
</OPTIONSELECTED>
2028
</COLUMN>
2029
<COLUMN ID="27891" ColName="cpr_ce_indexation_freq" PrevColName="" Pos="15" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Fr\195\169quence maximum acceptable pour une proc\195\169dure d\aindexation externe.">
2030
<OPTIONSELECTED>
2031
<OPTIONSELECT Value="1" />
2032
<OPTIONSELECT Value="0" />
2033
</OPTIONSELECTED>
2034
</COLUMN>
168 jp_milcent 2035
<COLUMN ID="26513" ColName="cpr_mark_public" PrevColName="cpr_autorisation" Pos="7" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) ce projet est public. Si oui, il peut \195\170tre publi\195\169 dans eFlore.">
2036
<OPTIONSELECTED>
2037
</OPTIONSELECTED>
2038
</COLUMN>
76 jpm 2039
<COLUMN ID="21539" ColName="cpr_ce_meta" PrevColName="cpr_date_derniere_modif" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
23 jpm 2040
<OPTIONSELECTED>
37 jpm 2041
<OPTIONSELECT Value="1" />
2042
<OPTIONSELECT Value="0" />
23 jpm 2043
</OPTIONSELECTED>
2044
</COLUMN>
2045
</COLUMNS>
2046
<RELATIONS_START>
2047
<RELATION_START ID="21560" />
2048
<RELATION_START ID="21622" />
2049
<RELATION_START ID="21625" />
2050
<RELATION_START ID="21628" />
2051
<RELATION_START ID="21631" />
2052
<RELATION_START ID="21650" />
37 jpm 2053
<RELATION_START ID="21816" />
2054
<RELATION_START ID="21830" />
76 jpm 2055
<RELATION_START ID="22018" />
99 jpm 2056
<RELATION_START ID="27902" />
23 jpm 2057
</RELATIONS_START>
76 jpm 2058
<RELATIONS_END>
2059
<RELATION_END ID="22066" />
99 jpm 2060
<RELATION_END ID="27908" />
2061
<RELATION_END ID="27910" />
2062
<RELATION_END ID="27912" />
76 jpm 2063
</RELATIONS_END>
23 jpm 2064
<INDICES>
2065
<INDEX ID="21532" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2066
<INDEXCOLUMNS>
2067
<INDEXCOLUMN idColumn="21523" LengthParam="0" />
2068
</INDEXCOLUMNS>
2069
</INDEX>
2070
</INDICES>
2071
</TABLE>
99 jpm 2072
<TABLE ID="21544" Tablename="coel_personne_a_relation" PrevTableName="Table_20" XPos="817" YPos="568" 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="Relation entre deux personnes vis \195\160 vis d\aun projet." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="69" >
23 jpm 2073
<COLUMNS>
76 jpm 2074
<COLUMN ID="21664" ColName="cpar_id_personne_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne n\194\1761.">
23 jpm 2075
<OPTIONSELECTED>
2076
<OPTIONSELECT Value="1" />
2077
<OPTIONSELECT Value="0" />
2078
</OPTIONSELECTED>
2079
</COLUMN>
76 jpm 2080
<COLUMN ID="21668" ColName="cpar_id_personne_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne n\194\1762.">
23 jpm 2081
<OPTIONSELECTED>
2082
<OPTIONSELECT Value="1" />
2083
<OPTIONSELECT Value="0" />
2084
</OPTIONSELECTED>
2085
</COLUMN>
76 jpm 2086
<COLUMN ID="21665" ColName="cpar_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel la relation entre les deux personnes s\a\195\169tablie.">
23 jpm 2087
<OPTIONSELECTED>
2088
<OPTIONSELECT Value="1" />
2089
<OPTIONSELECT Value="0" />
2090
</OPTIONSELECTED>
2091
</COLUMN>
76 jpm 2092
<COLUMN ID="21549" ColName="cpar_id_role" PrevColName="cpap_ce_role" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du r\195\180le ou de la valeur \195\169tablie entre les deux personnes.">
23 jpm 2093
<OPTIONSELECTED>
2094
<OPTIONSELECT Value="1" />
2095
<OPTIONSELECT Value="0" />
2096
</OPTIONSELECTED>
2097
</COLUMN>
76 jpm 2098
<COLUMN ID="21557" ColName="cpar_ce_meta" PrevColName="cpap_date_derniere_modif" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
23 jpm 2099
<OPTIONSELECTED>
37 jpm 2100
<OPTIONSELECT Value="1" />
2101
<OPTIONSELECT Value="0" />
23 jpm 2102
</OPTIONSELECTED>
2103
</COLUMN>
2104
</COLUMNS>
2105
<RELATIONS_END>
2106
<RELATION_END ID="21560" />
2107
<RELATION_END ID="21563" />
24 jpm 2108
<RELATION_END ID="21666" />
76 jpm 2109
<RELATION_END ID="22064" />
2110
<RELATION_END ID="22096" />
23 jpm 2111
</RELATIONS_END>
2112
<INDICES>
2113
<INDEX ID="21547" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2114
<INDEXCOLUMNS>
24 jpm 2115
<INDEXCOLUMN idColumn="21664" LengthParam="0" />
2116
<INDEXCOLUMN idColumn="21668" LengthParam="0" />
2117
<INDEXCOLUMN idColumn="21665" LengthParam="0" />
2118
<INDEXCOLUMN idColumn="21549" LengthParam="0" />
23 jpm 2119
</INDEXCOLUMNS>
2120
</INDEX>
2121
</INDICES>
2122
</TABLE>
99 jpm 2123
<TABLE ID="21634" Tablename="coel_projet_version" PrevTableName="eflore_projet_version" XPos="500" YPos="526" 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="Table contenant les informations sur la version d\aun projet.\nINFO : cprv_nom" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="11447" OrderPos="4" >
23 jpm 2124
<COLUMNS>
76 jpm 2125
<COLUMN ID="21635" ColName="cprv_id_version" PrevColName="eprv_id_version" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune version de projet.">
23 jpm 2126
<OPTIONSELECTED>
2127
<OPTIONSELECT Value="0" />
2128
<OPTIONSELECT Value="0" />
2129
</OPTIONSELECTED>
2130
</COLUMN>
76 jpm 2131
<COLUMN ID="21652" ColName="cprv_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet de la version.">
23 jpm 2132
<OPTIONSELECTED>
2133
<OPTIONSELECT Value="1" />
2134
<OPTIONSELECT Value="0" />
2135
</OPTIONSELECTED>
2136
</COLUMN>
2137
<COLUMN ID="21637" ColName="cprv_nom" PrevColName="eprv_nom" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom \195\169ventuel de la version.">
2138
<OPTIONSELECTED>
2139
<OPTIONSELECT Value="0" />
2140
</OPTIONSELECTED>
2141
</COLUMN>
2142
<COLUMN ID="21638" ColName="cprv_code" PrevColName="eprv_code" Pos="5" idDatatype="20" DatatypeParams="(25)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro ou code de la version.">
2143
<OPTIONSELECTED>
2144
<OPTIONSELECT Value="0" />
2145
</OPTIONSELECTED>
2146
</COLUMN>
2147
<COLUMN ID="21640" ColName="cprv_date_debut" PrevColName="eprv_date_debut" Pos="6" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="Date de d\195\169but de la version.">
2148
<OPTIONSELECTED>
2149
</OPTIONSELECTED>
2150
</COLUMN>
2151
<COLUMN ID="21641" ColName="cprv_date_fin" PrevColName="eprv_date_fin" Pos="7" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de fin de la version.">
2152
<OPTIONSELECTED>
2153
</OPTIONSELECTED>
2154
</COLUMN>
76 jpm 2155
<COLUMN ID="21644" ColName="cprv_ce_meta" PrevColName="eprv_date_derniere_modif" Pos="8" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
23 jpm 2156
<OPTIONSELECTED>
37 jpm 2157
<OPTIONSELECT Value="1" />
2158
<OPTIONSELECT Value="0" />
23 jpm 2159
</OPTIONSELECTED>
2160
</COLUMN>
26 jpm 2161
</COLUMNS>
2162
<RELATIONS_END>
2163
<RELATION_END ID="21650" />
76 jpm 2164
<RELATION_END ID="22068" />
26 jpm 2165
</RELATIONS_END>
2166
<INDICES>
2167
<INDEX ID="21648" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2168
<INDEXCOLUMNS>
2169
<INDEXCOLUMN idColumn="21635" LengthParam="0" />
2170
</INDEXCOLUMNS>
2171
</INDEX>
2172
</INDICES>
2173
</TABLE>
76 jpm 2174
<TABLE ID="21757" Tablename="coel_meta_historique_ligne" PrevTableName="Table_22" XPos="1161" YPos="132" 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="Contient les m\195\169tadonn\195\169es sur l\ahistorique des enregistrements des tables de la base de donn\195\169es.\nINFO : cmhl_date_modification" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="38" >
26 jpm 2175
<COLUMNS>
37 jpm 2176
<COLUMN ID="21759" ColName="cmhl_id_historique_ligne" PrevColName="cmhl_id_historisque_ligne" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de l\ahistorique des lignes.">
23 jpm 2177
<OPTIONSELECTED>
26 jpm 2178
<OPTIONSELECT Value="1" />
2179
<OPTIONSELECT Value="0" />
23 jpm 2180
</OPTIONSELECTED>
2181
</COLUMN>
76 jpm 2182
<COLUMN ID="21804" ColName="cmhl_ce_table" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la table.">
23 jpm 2183
<OPTIONSELECTED>
2184
<OPTIONSELECT Value="1" />
2185
<OPTIONSELECT Value="0" />
2186
</OPTIONSELECTED>
2187
</COLUMN>
37 jpm 2188
<COLUMN ID="21765" ColName="cmhl_cle_ligne" PrevColName="cmhl_ce_ligne" Pos="3" idDatatype="20" DatatypeParams="(64)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la ligne. Pour les tables \195\160 cl\195\169 primaire multi colonnes, bien respecter l\aordre des champs de la cl\195\169 et inscrire chaque valeur de cl\195\169 s\195\169par\195\169e par un tiret \A-\A.">
23 jpm 2189
<OPTIONSELECTED>
2190
<OPTIONSELECT Value="0" />
2191
</OPTIONSELECTED>
2192
</COLUMN>
37 jpm 2193
<COLUMN ID="21844" ColName="cmhl_enregistrement" PrevColName="" Pos="8" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient les donn\195\169es au format XML pour les enregistrements supprim\195\169s uniquement, sinon poss\195\168de la valeur NULL. Format XML : \kxml encoding=\AUTF-8\g\kligne\g\knom_du_champ_01\gvaleur_du_champ_01\k/nom_du_champ_01\g\knom_du_champ_02\gvaleur_du_champ_02\k/nom_du_champ_02\g...\k/ligne\g\k/xml\g.">
26 jpm 2194
<OPTIONSELECTED>
2195
</OPTIONSELECTED>
2196
</COLUMN>
37 jpm 2197
<COLUMN ID="21766" ColName="cmhl_date_modification" PrevColName="cmhl_date" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de modification de la ligne.">
2198
<OPTIONSELECTED>
2199
</OPTIONSELECTED>
2200
</COLUMN>
26 jpm 2201
<COLUMN ID="21767" ColName="cmhl_notes" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur la modification effectu\195\169e sur la ligne.">
2202
<OPTIONSELECTED>
2203
<OPTIONSELECT Value="0" />
2204
</OPTIONSELECTED>
2205
</COLUMN>
37 jpm 2206
<COLUMN ID="21769" ColName="cmhl_ce_modifier_par" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 cette modification sur la ligne.">
26 jpm 2207
<OPTIONSELECTED>
2208
<OPTIONSELECT Value="1" />
2209
<OPTIONSELECT Value="0" />
2210
</OPTIONSELECTED>
2211
</COLUMN>
76 jpm 2212
<COLUMN ID="21768" ColName="cmhl_ce_etat" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de l\a\195\169tat de la ligne.">
26 jpm 2213
<OPTIONSELECTED>
2214
<OPTIONSELECT Value="1" />
2215
<OPTIONSELECT Value="0" />
2216
</OPTIONSELECTED>
2217
</COLUMN>
37 jpm 2218
<COLUMN ID="21770" ColName="cmhl_ip" PrevColName="cmhl_ip_mac" Pos="7" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse IP (et MAC \195\169ventuellement) depuis laquelle la modification a eu lieu.">
26 jpm 2219
<OPTIONSELECTED>
2220
<OPTIONSELECT Value="0" />
2221
</OPTIONSELECTED>
2222
</COLUMN>
168 jp_milcent 2223
<COLUMN ID="27929" ColName="cmhl_session_id" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(40)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de session del \autilisateur.">
2224
<OPTIONSELECTED>
2225
<OPTIONSELECT Value="0" />
2226
</OPTIONSELECTED>
2227
</COLUMN>
23 jpm 2228
</COLUMNS>
37 jpm 2229
<RELATIONS_START>
2230
<RELATION_START ID="21856" />
2231
<RELATION_START ID="21861" />
2232
<RELATION_START ID="21863" />
55 jpm 2233
<RELATION_START ID="21957" />
76 jpm 2234
<RELATION_START ID="22016" />
2235
<RELATION_START ID="22043" />
2236
<RELATION_START ID="22062" />
2237
<RELATION_START ID="22064" />
2238
<RELATION_START ID="22066" />
2239
<RELATION_START ID="22068" />
2240
<RELATION_START ID="22073" />
2241
<RELATION_START ID="22075" />
2242
<RELATION_START ID="22077" />
2243
<RELATION_START ID="22079" />
2244
<RELATION_START ID="22081" />
2245
<RELATION_START ID="22083" />
2246
<RELATION_START ID="22085" />
99 jpm 2247
<RELATION_START ID="27906" />
139 jpm 2248
<RELATION_START ID="27921" />
2249
<RELATION_START ID="27924" />
2250
<RELATION_START ID="27927" />
37 jpm 2251
</RELATIONS_START>
23 jpm 2252
<RELATIONS_END>
26 jpm 2253
<RELATION_END ID="21789" />
76 jpm 2254
<RELATION_END ID="22071" />
2255
<RELATION_END ID="22093" />
23 jpm 2256
</RELATIONS_END>
2257
<INDICES>
26 jpm 2258
<INDEX ID="21760" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
23 jpm 2259
<INDEXCOLUMNS>
26 jpm 2260
<INDEXCOLUMN idColumn="21759" LengthParam="0" />
23 jpm 2261
</INDEXCOLUMNS>
2262
</INDEX>
2263
</INDICES>
2264
</TABLE>
76 jpm 2265
<TABLE ID="21986" Tablename="coel_commentaire" PrevTableName="Table_21" XPos="826" YPos="2390" 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="Contient les commentaires.\nINFO : ccm_titre" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="83" >
2266
<COLUMNS>
2267
<COLUMN ID="21989" ColName="ccm_id_commentaire" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun commentaire.">
2268
<OPTIONSELECTED>
2269
<OPTIONSELECT Value="1" />
2270
<OPTIONSELECT Value="0" />
2271
</OPTIONSELECTED>
2272
</COLUMN>
2273
<COLUMN ID="22031" ColName="ccm_ce_pere" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant du commentaire p\195\168re.">
2274
<OPTIONSELECTED>
2275
<OPTIONSELECT Value="1" />
2276
<OPTIONSELECT Value="0" />
2277
</OPTIONSELECTED>
2278
</COLUMN>
2279
<COLUMN ID="21991" ColName="ccm_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel le commentaire est fait.">
2280
<OPTIONSELECTED>
2281
<OPTIONSELECT Value="1" />
2282
<OPTIONSELECT Value="0" />
2283
</OPTIONSELECTED>
2284
</COLUMN>
2285
<COLUMN ID="21993" ColName="ccm_titre" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Titre du commentaire.">
2286
<OPTIONSELECTED>
2287
<OPTIONSELECT Value="0" />
2288
</OPTIONSELECTED>
2289
</COLUMN>
2290
<COLUMN ID="21994" ColName="ccm_texte" PrevColName="" Pos="3" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Texte du commentaire.">
2291
<OPTIONSELECTED>
2292
</OPTIONSELECTED>
2293
</COLUMN>
2294
<COLUMN ID="21996" ColName="ccm_ponderation" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pond\195\169ration du commentaire (importance). Valeur de 1 \195\160 10.">
2295
<OPTIONSELECTED>
2296
<OPTIONSELECT Value="1" />
2297
<OPTIONSELECT Value="0" />
2298
</OPTIONSELECTED>
2299
</COLUMN>
2300
<COLUMN ID="21997" ColName="ccm_ce_meta" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
2301
<OPTIONSELECTED>
2302
<OPTIONSELECT Value="1" />
2303
<OPTIONSELECT Value="0" />
2304
</OPTIONSELECTED>
2305
</COLUMN>
168 jp_milcent 2306
<COLUMN ID="27940" ColName="ccm_mark_public" PrevColName="" Pos="7" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si oui (=1) ou non (=0) ce commentaire est public .">
2307
<OPTIONSELECTED>
2308
</OPTIONSELECTED>
2309
</COLUMN>
76 jpm 2310
</COLUMNS>
2311
<RELATIONS_START>
2312
<RELATION_START ID="22035" />
2313
<RELATION_START ID="22039" />
2314
</RELATIONS_START>
2315
<RELATIONS_END>
2316
<RELATION_END ID="22016" />
2317
<RELATION_END ID="22018" />
2318
<RELATION_END ID="22035" />
2319
</RELATIONS_END>
2320
<INDICES>
2321
<INDEX ID="21990" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2322
<INDEXCOLUMNS>
2323
<INDEXCOLUMN idColumn="21989" LengthParam="0" />
2324
</INDEXCOLUMNS>
2325
</INDEX>
2326
</INDICES>
2327
</TABLE>
139 jpm 2328
<TABLE ID="22023" Tablename="coel_collection_a_commentaire" PrevTableName="Table_23" XPos="427" YPos="2183" 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="Permet de lister les commentaires / notes faits sur une collection." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" >
76 jpm 2329
<COLUMNS>
2330
<COLUMN ID="22025" ColName="ccac_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection.">
2331
<OPTIONSELECTED>
2332
<OPTIONSELECT Value="1" />
2333
<OPTIONSELECT Value="0" />
2334
</OPTIONSELECTED>
2335
</COLUMN>
2336
<COLUMN ID="22027" ColName="ccac_id_commentaire" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du commentaire.">
2337
<OPTIONSELECTED>
2338
<OPTIONSELECT Value="1" />
2339
<OPTIONSELECT Value="0" />
2340
</OPTIONSELECTED>
2341
</COLUMN>
78 jpm 2342
<COLUMN ID="22385" ColName="ccac_truk_type" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste des types de commentaires s\195\169par\195\169s par des points virgules.">
76 jpm 2343
<OPTIONSELECTED>
2344
<OPTIONSELECT Value="0" />
2345
</OPTIONSELECTED>
2346
</COLUMN>
2347
<COLUMN ID="22029" ColName="ccac_ce_meta" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.">
2348
<OPTIONSELECTED>
2349
<OPTIONSELECT Value="1" />
2350
<OPTIONSELECT Value="0" />
2351
</OPTIONSELECTED>
2352
</COLUMN>
2353
</COLUMNS>
2354
<RELATIONS_END>
2355
<RELATION_END ID="22037" />
2356
<RELATION_END ID="22039" />
2357
<RELATION_END ID="22043" />
2358
</RELATIONS_END>
2359
<INDICES>
2360
<INDEX ID="22026" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2361
<INDEXCOLUMNS>
2362
<INDEXCOLUMN idColumn="22025" LengthParam="0" />
2363
<INDEXCOLUMN idColumn="22027" LengthParam="0" />
2364
</INDEXCOLUMNS>
2365
</INDEX>
2366
</INDICES>
2367
</TABLE>
99 jpm 2368
<TABLE ID="27893" Tablename="coel_projet_a_structure" PrevTableName="Table_23" XPos="451" YPos="762" 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="126" >
2369
<COLUMNS>
2370
<COLUMN ID="27895" ColName="cpras_id_projet" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
2371
<OPTIONSELECTED>
2372
<OPTIONSELECT Value="1" />
2373
<OPTIONSELECT Value="0" />
2374
</OPTIONSELECTED>
2375
</COLUMN>
2376
<COLUMN ID="27897" ColName="cpras_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
2377
<OPTIONSELECTED>
2378
<OPTIONSELECT Value="1" />
2379
<OPTIONSELECT Value="0" />
2380
</OPTIONSELECTED>
2381
</COLUMN>
2382
<COLUMN ID="27900" ColName="cpras_truk_role" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
2383
<OPTIONSELECTED>
2384
<OPTIONSELECT Value="0" />
2385
</OPTIONSELECTED>
2386
</COLUMN>
2387
<COLUMN ID="27901" ColName="cpras_ce_meta" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
2388
<OPTIONSELECTED>
2389
<OPTIONSELECT Value="1" />
2390
<OPTIONSELECT Value="0" />
2391
</OPTIONSELECTED>
2392
</COLUMN>
2393
</COLUMNS>
2394
<RELATIONS_END>
2395
<RELATION_END ID="27902" />
2396
<RELATION_END ID="27904" />
2397
<RELATION_END ID="27906" />
2398
</RELATIONS_END>
2399
<INDICES>
2400
<INDEX ID="27896" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2401
<INDEXCOLUMNS>
2402
<INDEXCOLUMN idColumn="27895" LengthParam="0" />
2403
<INDEXCOLUMN idColumn="27897" LengthParam="0" />
2404
</INDEXCOLUMNS>
2405
</INDEX>
2406
</INDICES>
2407
</TABLE>
14 jpm 2408
</TABLES>
2409
<RELATIONS>
26 jpm 2410
<RELATION ID="18419" RelationName="fk_cs_csap" Kind="1" SrcTable="1445" DestTable="1447" FKFields="cs_id_structure=csap_id_structure\n" FKFieldsComments="Identifiant de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-9" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" 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="17" />
74 jpm 2411
<RELATION ID="18425" RelationName="fk_cp_csap" Kind="1" SrcTable="1446" DestTable="1447" FKFields="cp_id_personne=csap_id_personne\n" FKFieldsComments="Identifiant de la personne constituant l\a\195\169quipe d\aun service d\aune structure.\n" relDirection="3" MidOffset="6" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" 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="18" />
76 jpm 2412
<RELATION ID="18470" RelationName="fk_cmc_cmd" Kind="2" SrcTable="18456" DestTable="18452" FKFields="cmc_id_champ=cmd_ce_champ\n" FKFieldsComments="\n" relDirection="4" MidOffset="-6" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="57" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" 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="34" />
2413
<RELATION ID="18504" RelationName="fk_cmc_cmh" Kind="2" SrcTable="18456" DestTable="18498" FKFields="cmc_id_champ=cmhc_ce_champ\n" FKFieldsComments="\n" relDirection="2" MidOffset="5" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-49" CaptionOffsetY="-21" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" 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="43" />
2414
<RELATION ID="20817" RelationName="fk_cs_cc" Kind="2" SrcTable="1445" DestTable="1444" FKFields="cs_id_structure=cc_ce_structure\n" FKFieldsComments="\n" relDirection="4" MidOffset="201" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="5" CaptionOffsetY="1" StartIntervalOffsetX="-6" StartIntervalOffsetY="2" 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="45" />
2415
<RELATION ID="20819" RelationName="fk_cc_cc_parente" Kind="2" SrcTable="1444" DestTable="1444" FKFields="cc_id_collection=cc_ce_mere\n" FKFieldsComments="Identifiant de la collection parente.\n" relDirection="2" MidOffset="13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-17" CaptionOffsetY="2" StartIntervalOffsetX="9" StartIntervalOffsetY="-28" 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="46" />
2416
<RELATION ID="20859" RelationName="fk_cs_csc" Kind="4" SrcTable="1445" DestTable="20850" FKFields="cs_id_structure=csc_id_structure\n" FKFieldsComments="Identifiant de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="58" />
2417
<RELATION ID="20861" RelationName="fk_cs_csv" Kind="4" SrcTable="1445" DestTable="20854" FKFields="cs_id_structure=csv_id_structure\n" FKFieldsComments="Identifiant de la structure.\n" relDirection="3" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="59" />
2418
<RELATION ID="21108" RelationName="fk_cc_ccap" Kind="1" SrcTable="1444" DestTable="21104" FKFields="cc_id_collection=ccap_id_collection\n" FKFieldsComments="Identifiant de la collection associ\195\169 \195\160 une personne.\n" relDirection="2" MidOffset="21" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="-1" StartIntervalOffsetY="3" 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="57" />
2419
<RELATION ID="21110" RelationName="fk_cp_ccap" Kind="1" SrcTable="1446" DestTable="21104" FKFields="cp_id_personne=ccap_id_personne\n" FKFieldsComments="Identifiant de la personne associ\195\169 \195\160 une collection.\n" relDirection="4" MidOffset="-170" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="58" />
2420
<RELATION ID="21152" RelationName="fk_cc_ccb" Kind="4" SrcTable="1444" DestTable="21148" FKFields="cc_id_collection=ccb_id_collection\n" FKFieldsComments="Identifiant de la collection botanique.\n" relDirection="2" MidOffset="7" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="60" />
2421
<RELATION ID="21163" RelationName="fk_cs_cs_parente" Kind="2" SrcTable="1445" DestTable="1445" FKFields="cs_id_structure=cs_ce_mere\n" FKFieldsComments="Identifiant de la structure parente.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-35" CaptionOffsetY="-3" 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="62" />
2422
<RELATION ID="21223" RelationName="fk_cc_ccapu" Kind="1" SrcTable="1444" DestTable="21219" FKFields="cc_id_collection=ccapu_id_collection\n" FKFieldsComments="Identifiant de la collection ayant des publications.\n" relDirection="3" MidOffset="-3" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-49" CaptionOffsetY="-7" StartIntervalOffsetX="0" StartIntervalOffsetY="3" 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="66" />
2423
<RELATION ID="21226" RelationName="fk_cpu_ccapu" Kind="1" SrcTable="21188" DestTable="21219" FKFields="cpu_id_publication=ccapu_id_publication\n" FKFieldsComments="Identifiant de la publication traitant d\aune collection.\n" relDirection="1" MidOffset="31" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="25" CaptionOffsetY="-3" 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="67" />
2424
<RELATION ID="21239" RelationName="fk_cp_cpuap" Kind="1" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpuap_id_personne\n" FKFieldsComments="Identifiant de la personne ayant un rapport avec une publication.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="53" CaptionOffsetY="-20" StartIntervalOffsetX="99" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" />
2425
<RELATION ID="21241" RelationName="fk_cpu_cpuap" Kind="1" SrcTable="21188" DestTable="21235" FKFields="cpu_id_publication=cpuap_id_publication\n" FKFieldsComments="Identifiant de la publication li\195\169e \195\160 une personne.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-2" 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="72" />
2426
<RELATION ID="21496" RelationName="fk_cc_ccar_01" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_01\n" FKFieldsComments="Identifiant de la collection n\194\1761.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="39" CaptionOffsetY="-2" StartIntervalOffsetX="7" StartIntervalOffsetY="-2" EndIntervalOffsetX="6" EndIntervalOffsetY="3" 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="65" />
99 jpm 2427
<RELATION ID="21498" RelationName="fk_cc_ccar_02" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_02\n" FKFieldsComments="Identifiant de la collection n\194\1762.\n" relDirection="1" MidOffset="22" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-44" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="4" EndIntervalOffsetY="6" 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="66" />
2428
<RELATION ID="21560" RelationName="fk_cpr_cpar" Kind="1" SrcTable="21522" DestTable="21544" FKFields="cpr_id_projet=cpar_id_projet\n" FKFieldsComments="Identifiant du projet dans lequel la relation entre les deux personnes s\a\195\169tablie.\n" relDirection="2" MidOffset="215" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" CaptionOffsetY="-44" StartIntervalOffsetX="5" StartIntervalOffsetY="-27" 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="70" />
2429
<RELATION ID="21563" RelationName="fk_cp_cpar_01" Kind="1" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_id_personne_01\n" FKFieldsComments="Identifiant de la personne n\194\1761.\n" relDirection="4" MidOffset="13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="71" />
86 jpm 2430
<RELATION ID="21616" RelationName="fk_cs_cpu_editeur" Kind="2" SrcTable="1445" DestTable="21188" FKFields="cs_id_structure=cpu_ce_truk_editeur\n" FKFieldsComments="Identifiant de la structure \195\169ditrice de la publication. S\ail n\aest pas renseignn\195\169 dans la table Structure, contient AUTRE# suivit du nom complet de la structure \195\169ditrice.\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="-6" StartIntervalOffsetY="-29" EndIntervalOffsetX="8" EndIntervalOffsetY="11" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="72" />
76 jpm 2431
<RELATION ID="21622" RelationName="fk_cpr_cp" Kind="2" SrcTable="21522" DestTable="1446" FKFields="cpr_id_projet=cp_ce_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="73" />
95 jpm 2432
<RELATION ID="21625" RelationName="fk_cpr_cs" Kind="2" SrcTable="21522" DestTable="1445" FKFields="cpr_id_projet=cs_ce_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="74" />
76 jpm 2433
<RELATION ID="21628" RelationName="fk_cpr_cc" Kind="2" SrcTable="21522" DestTable="1444" FKFields="cpr_id_projet=cc_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" />
2434
<RELATION ID="21631" RelationName="fk_cpr_cpu" Kind="2" SrcTable="21522" DestTable="21188" FKFields="cpr_id_projet=cpu_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="76" />
99 jpm 2435
<RELATION ID="21650" RelationName="fk_cpr_cprv" Kind="2" SrcTable="21522" DestTable="21634" FKFields="cpr_id_projet=cprv_ce_projet\n" FKFieldsComments="Identifiant du projet de la version.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="43" CaptionOffsetY="-2" 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="78" />
2436
<RELATION ID="21666" RelationName="fk_cp_cpar_02" Kind="1" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_id_personne_02\n" FKFieldsComments="Identifiant de la personne n\194\1762.\n" relDirection="4" MidOffset="-46" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-2" CaptionOffsetY="-50" 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="72" />
76 jpm 2437
<RELATION ID="21789" RelationName="fk_cp_cmhl_modifier_par" Kind="2" SrcTable="1446" DestTable="21757" FKFields="cp_id_personne=cmhl_ce_modifier_par\n" FKFieldsComments="\n" relDirection="1" MidOffset="15" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-7" CaptionOffsetY="0" 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="79" />
99 jpm 2438
<RELATION ID="21816" RelationName="fk_cpr_cmlv" Kind="2" SrcTable="21522" DestTable="18466" FKFields="cpr_id_projet=cmlv_ce_projet\n" FKFieldsComments="\n" relDirection="1" MidOffset="146" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="58" />
76 jpm 2439
<RELATION ID="21819" RelationName="fk_cmlv_cmlv_parent" Kind="2" SrcTable="18466" DestTable="18466" FKFields="cmlv_id_valeur=cmlv_ce_parent\n" FKFieldsComments="\n" relDirection="2" MidOffset="4" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-75" CaptionOffsetY="-14" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="-24" EndIntervalOffsetY="-22" 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="59" />
2440
<RELATION ID="21822" RelationName="fk_cmlv_cmc_liste" Kind="2" SrcTable="18466" DestTable="18456" FKFields="cmlv_id_valeur=cmc_ce_liste\n" FKFieldsComments="\n" relDirection="2" MidOffset="-3" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="7" StartIntervalOffsetY="-32" 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="60" />
2441
<RELATION ID="21830" RelationName="fk_cpr_cmc" Kind="2" SrcTable="21522" DestTable="18456" FKFields="cpr_id_projet=cmc_ce_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="42" CaptionOffsetY="30" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="61" />
2442
<RELATION ID="21856" RelationName="fk_cmhl_cmhc" Kind="2" SrcTable="21757" DestTable="18498" FKFields="cmhl_id_historique_ligne=cmhc_ce_historique_ligne\n" FKFieldsComments="\n" relDirection="4" MidOffset="7" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="50" CaptionOffsetY="-3" 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="62" />
2443
<RELATION ID="21861" RelationName="fk_cmhl_cmlv_meta" Kind="2" SrcTable="21757" DestTable="18466" FKFields="cmhl_id_historique_ligne=cmlv_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="63" />
2444
<RELATION ID="21863" RelationName="fk_cmhl_cmc_meta" Kind="2" SrcTable="21757" DestTable="18456" FKFields="cmhl_id_historique_ligne=cmc_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
2445
<RELATION ID="21957" RelationName="fk_cmhl_cs" Kind="2" SrcTable="21757" DestTable="1445" FKFields="cmhl_id_historique_ligne=cs_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="64" />
2446
<RELATION ID="21959" RelationName="fk_cmlv_cs_type" Kind="2" SrcTable="18466" DestTable="1445" FKFields="cmlv_id_valeur=cs_ce_type\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-30" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="65" />
2447
<RELATION ID="21961" RelationName="fk_cmlv_cs_type_prive" Kind="2" SrcTable="18466" DestTable="1445" FKFields="cmlv_id_valeur=cs_ce_truk_type_prive\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-112" CaptionOffsetY="13" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="66" />
2448
<RELATION ID="21964" RelationName="fk_cmlv_cs_type_public" Kind="2" SrcTable="18466" DestTable="1445" FKFields="cmlv_id_valeur=cs_ce_truk_type_public\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="67" />
2449
<RELATION ID="22016" RelationName="fk_cmhl_ccm_meta" Kind="2" SrcTable="21757" DestTable="21986" FKFields="cmhl_id_historique_ligne=ccm_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="75" />
2450
<RELATION ID="22018" RelationName="fk_cpr_ccm" Kind="2" SrcTable="21522" DestTable="21986" FKFields="cpr_id_projet=ccm_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="76" />
2451
<RELATION ID="22035" RelationName="fk_ccm_ccm_pere" Kind="2" SrcTable="21986" DestTable="21986" FKFields="ccm_id_commentaire=ccm_ce_pere\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-71" CaptionOffsetY="-20" StartIntervalOffsetX="9" StartIntervalOffsetY="0" EndIntervalOffsetX="-20" EndIntervalOffsetY="-28" 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="73" />
2452
<RELATION ID="22037" RelationName="fk_cc_ccac" Kind="1" SrcTable="1444" DestTable="22023" FKFields="cc_id_collection=ccac_id_collection\n" FKFieldsComments="\n" relDirection="3" MidOffset="117" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="74" />
2453
<RELATION ID="22039" RelationName="fk_ccm_ccac" Kind="1" SrcTable="21986" DestTable="22023" FKFields="ccm_id_commentaire=ccac_id_commentaire\n" FKFieldsComments="\n" relDirection="4" MidOffset="36" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="75" />
2454
<RELATION ID="22043" RelationName="fk_cmhl_ccac_meta" Kind="2" SrcTable="21757" DestTable="22023" FKFields="cmhl_id_historique_ligne=ccac_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="77" />
2455
<RELATION ID="22062" RelationName="fk_cmhl_cp_meta" Kind="2" SrcTable="21757" DestTable="1446" FKFields="cmhl_id_historique_ligne=cp_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="78" />
99 jpm 2456
<RELATION ID="22064" RelationName="fk_cmhl_cpar_meta" Kind="2" SrcTable="21757" DestTable="21544" FKFields="cmhl_id_historique_ligne=cpar_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="79" />
76 jpm 2457
<RELATION ID="22066" RelationName="fk_cmhl_cpr_meta" Kind="2" SrcTable="21757" DestTable="21522" FKFields="cmhl_id_historique_ligne=cpr_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="80" />
2458
<RELATION ID="22068" RelationName="fk_cmhl_cprv_meta" Kind="2" SrcTable="21757" DestTable="21634" FKFields="cmhl_id_historique_ligne=cprv_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="81" />
2459
<RELATION ID="22071" RelationName="fk_cmlv_cmhl_val" Kind="2" SrcTable="18466" DestTable="21757" FKFields="cmlv_id_valeur=cmhl_ce_etat\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="82" />
2460
<RELATION ID="22073" RelationName="fk_cmhl_csap_meta" Kind="2" SrcTable="21757" DestTable="1447" FKFields="cmhl_id_historique_ligne=csap_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="82" />
2461
<RELATION ID="22075" RelationName="fk_cmhl_ccar_meta" Kind="2" SrcTable="21757" DestTable="21486" FKFields="cmhl_id_historique_ligne=ccar_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="83" />
2462
<RELATION ID="22077" RelationName="fk_cmhl_ccap_meta" Kind="2" SrcTable="21757" DestTable="21104" FKFields="cmhl_id_historique_ligne=ccap_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="84" />
99 jpm 2463
<RELATION ID="22079" RelationName="fk_cmhl_cc_meta" Kind="2" SrcTable="21757" DestTable="1444" FKFields="cmhl_id_historique_ligne=cc_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="5" CaptionOffsetY="-5" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="85" />
76 jpm 2464
<RELATION ID="22081" RelationName="fk_cmhl_ccapu_meta" Kind="2" SrcTable="21757" DestTable="21219" FKFields="cmhl_id_historique_ligne=ccapu_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="86" />
2465
<RELATION ID="22083" RelationName="fk_cmhl_cpu_meta" Kind="2" SrcTable="21757" DestTable="21188" FKFields="cmhl_id_historique_ligne=cpu_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="87" />
2466
<RELATION ID="22085" RelationName="fk_cmhl_cpuap_meta" Kind="2" SrcTable="21757" DestTable="21235" FKFields="cmhl_id_historique_ligne=cpuap_ce_meta\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="88" />
2467
<RELATION ID="22087" RelationName="fk_cmlv_cmc_table" Kind="2" SrcTable="18466" DestTable="18456" FKFields="cmlv_id_valeur=cmc_ce_table\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="89" />
2468
<RELATION ID="22089" RelationName="fk_cmlv_cmc_format_sql" Kind="2" SrcTable="18466" DestTable="18456" FKFields="cmlv_id_valeur=cmc_ce_format_sql\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="90" />
2469
<RELATION ID="22091" RelationName="fk_cmlv_cmd_table" Kind="2" SrcTable="18466" DestTable="18452" FKFields="cmlv_id_valeur=cmd_ce_table\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="91" />
2470
<RELATION ID="22093" RelationName="fk_cmlv_cmhl_table" Kind="2" SrcTable="18466" DestTable="21757" FKFields="cmlv_id_valeur=cmhl_ce_table\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="92" />
2471
<RELATION ID="22096" RelationName="fk_cmlv_cpar_role" Kind="1" SrcTable="18466" DestTable="21544" FKFields="cmlv_id_valeur=cpar_id_role\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="93" />
2472
<RELATION ID="22099" RelationName="fk_cmlv_cp_prefix" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_truk_prefix\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="94" />
2473
<RELATION ID="22101" RelationName="fk_cmlv_cp_suffix" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_truk_suffix\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="95" />
2474
<RELATION ID="22133" RelationName="fk_cmlv_cp_sexe" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_sexe\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="96" />
2475
<RELATION ID="22135" RelationName="fk_cmlv_cp_specialite" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_truk_specialite\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="97" />
2476
<RELATION ID="22137" RelationName="fk_cmlv_cp_role" Kind="2" SrcTable="18466" DestTable="1446" FKFields="cmlv_id_valeur=cp_ce_truk_role\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="98" />
139 jpm 2477
<RELATION ID="22142" RelationName="fk_cmlv_csap_fonction" Kind="2" SrcTable="18466" DestTable="1447" FKFields="cmlv_id_valeur=csap_ce_truk_fonction\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="99" />
2478
<RELATION ID="22144" RelationName="fk_cmlv_csap_statut" Kind="2" SrcTable="18466" DestTable="1447" FKFields="cmlv_id_valeur=csap_ce_truk_statut\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="32" CaptionOffsetY="5" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="100" />
76 jpm 2479
<RELATION ID="22146" RelationName="fk_cmlv_csc_materiel_conservation" Kind="2" SrcTable="18466" DestTable="20850" FKFields="cmlv_id_valeur=csc_ce_materiel_conservation\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="101" />
2480
<RELATION ID="22148" RelationName="fk_cmlv_cpuap_type" Kind="2" SrcTable="18466" DestTable="21235" FKFields="cmlv_id_valeur=cpuap_ce_truk_type\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="102" />
2481
<RELATION ID="22150" RelationName="fk_cmlv_cpuap_role" Kind="1" SrcTable="18466" DestTable="21235" FKFields="cmlv_id_valeur=cpuap_id_role\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="103" />
2482
<RELATION ID="22152" RelationName="fk_cmlv_ccar_relation" Kind="1" SrcTable="18466" DestTable="21486" FKFields="cmlv_id_valeur=ccar_id_relation\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="104" />
2483
<RELATION ID="22154" RelationName="fk_cmlv_ccap_role" Kind="1" SrcTable="18466" DestTable="21104" FKFields="cmlv_id_valeur=ccap_id_role\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="105" />
2484
<RELATION ID="22158" RelationName="fk_cmlv_cc_type" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_type\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="106" />
2485
<RELATION ID="22160" RelationName="fk_cmlv_cc_developpement" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_developpement\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="107" />
2486
<RELATION ID="22162" RelationName="fk_cmlv_cc_specimen_type" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_specimen_type\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="108" />
2487
<RELATION ID="22164" RelationName="fk_cmlv_cc_specimen_type_classement" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_specimen_type_classement\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="109" />
2488
<RELATION ID="22170" RelationName="fk_cmlv_ccb_unitte_rangement_etat" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_unite_rangement_etat\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="111" />
2489
<RELATION ID="22172" RelationName="fk_cmlv_ccb_traitement" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_traitement\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="112" />
2490
<RELATION ID="22174" RelationName="fk_cmlv_ccb_etat_general" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_etat_general\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="113" />
2491
<RELATION ID="22178" RelationName="fk_cmlv_ccb_determination" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_determination\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="114" />
2492
<RELATION ID="22301" RelationName="fk_cmlv_ccb_recolte_date_debut_type" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_recolte_date_debut_type\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="116" />
2493
<RELATION ID="22306" RelationName="fk_cmlv_ccb_recolte_date_fin_type" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_recolte_date_fin_type\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="117" />
2494
<RELATION ID="22308" RelationName="fk_cmlv_ccb_classement_etat" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_classement_etat\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="118" />
2495
<RELATION ID="22309" RelationName="fk_cmlv_ccb_precision_localite" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_precision_localite\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="118" />
2496
<RELATION ID="22311" RelationName="fk_cmlv_ccb_precision_date" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_precision_date\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="119" />
2497
<RELATION ID="22313" RelationName="fk_cmlv_ccb_collection_integre" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_collection_integre\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="120" />
2498
<RELATION ID="22315" RelationName="fk_cmlv_ccb_collection_integre_info" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_collection_integre_info\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="121" />
2499
<RELATION ID="22318" RelationName="fk_cmlv_ccb_inventaire" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_inventaire\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="122" />
2500
<RELATION ID="22320" RelationName="fk_cmlv_ccb_inventaire_auteur" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_inventaire_auteur\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="123" />
2501
<RELATION ID="22322" RelationName="fk_cmlv_ccb_inventaire_forme" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_inventaire_forme\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="124" />
2502
<RELATION ID="22324" RelationName="fk_cmlv_ccb_inventaire_digital" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_truk_inventaire_digital\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="125" />
2503
<RELATION ID="22326" RelationName="fk_cmlv_ccb_inventaire_etat" Kind="2" SrcTable="18466" DestTable="21148" FKFields="cmlv_id_valeur=ccb_ce_inventaire_etat\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="126" />
97 jpm 2504
<RELATION ID="27872" RelationName="fk_cmlv_cc_type_depot" Kind="2" SrcTable="18466" DestTable="1444" FKFields="cmlv_id_valeur=cc_ce_type_depot\n" FKFieldsComments="Type de d\195\169p\195\180t de la collection (pr\195\170t, d\195\169p\195\180t permanent...).\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="125" />
99 jpm 2505
<RELATION ID="27902" RelationName="fk_cpr_cpras" Kind="1" SrcTable="21522" DestTable="27893" FKFields="cpr_id_projet=cpras_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="18" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="127" />
2506
<RELATION ID="27904" RelationName="fk_cs_cpras" Kind="1" SrcTable="1445" DestTable="27893" FKFields="cs_id_structure=cpras_id_structure\n" FKFieldsComments="\n" relDirection="1" MidOffset="-150" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" 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="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="128" />
2507
<RELATION ID="27906" RelationName="fk_cmhl_cpras_meta" Kind="2" SrcTable="21757" DestTable="27893" FKFields="cmhl_id_historique_ligne=cpras_ce_meta\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="129" />
2508
<RELATION ID="27908" RelationName="fk_cmlv_cpr_langue" Kind="2" SrcTable="18466" DestTable="21522" FKFields="cmlv_id_valeur=cpr_ce_langue\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="130" />
2509
<RELATION ID="27910" RelationName="fk_cmlv_cpr_idx_duree" Kind="2" SrcTable="18466" DestTable="21522" FKFields="cmlv_id_valeur=cpr_ce_indexation_duree\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="131" />
2510
<RELATION ID="27912" RelationName="fk_cmlv_cpr_idx_freq" Kind="2" SrcTable="18466" DestTable="21522" FKFields="cmlv_id_valeur=cpr_ce_indexation_freq\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="132" />
139 jpm 2511
<RELATION ID="27921" RelationName="fk_cmhl_csc_meta" Kind="2" SrcTable="21757" DestTable="20850" FKFields="cmhl_id_historique_ligne=csc_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="133" />
2512
<RELATION ID="27924" RelationName="fk_cmhl_csv_meta" Kind="2" SrcTable="21757" DestTable="20854" FKFields="cmhl_id_historique_ligne=csv_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="134" />
2513
<RELATION ID="27927" RelationName="fk_cmhl_ccb_meta" Kind="2" SrcTable="21757" DestTable="21148" FKFields="cmhl_id_historique_ligne=ccb_ce_meta\n" FKFieldsComments="Identifiant des m\195\169tadonn\195\169es de cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="135" />
234 jp_milcent 2514
<RELATION ID="27941" RelationName="fk_cmlv_csap_role" Kind="1" SrcTable="18466" DestTable="1447" FKFields="cmlv_id_valeur=csap_id_role\n" FKFieldsComments="Identifiant du r\195\180le de la personne vis \195\160 vis de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="136" />
14 jpm 2515
</RELATIONS>
2516
<NOTES>
2517
</NOTES>
2518
<IMAGES>
2519
</IMAGES>
2520
</METADATA>
2521
<PLUGINDATA>
2522
<PLUGINDATARECORDS>
2523
</PLUGINDATARECORDS>
2524
</PLUGINDATA>
2525
<QUERYDATA>
2526
<QUERYRECORDS>
2527
</QUERYRECORDS>
2528
</QUERYDATA>
2529
<LINKEDMODELS>
2530
</LINKEDMODELS>
2531
</DBMODEL>