Subversion Repositories eFlore/Applications.coel

Rev

Rev 16 | 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>
16 jpm 4
<GLOBALSETTINGS ModelName="coel" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="672" 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" />
244
</REGIONCOLORS>
245
<POSITIONMARKERS>
246
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
247
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
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
</POSITIONMARKERS>
258
</SETTINGS>
259
<METADATA>
260
<REGIONS>
20 jpm 261
<REGION ID="1443" RegionName="Collection" XPos="19" YPos="764" Width="681" Height="922" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Collections.\nAbreviation : CC\nAide : en cours...\nEtat: en cours...\nRevision : $Revision: 20 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
262
<REGION ID="18416" RegionName="Structure" XPos="706" YPos="766" Width="718" Height="919" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Structures.\nAbreviation : CS\nAide : en cours...\nEtat: en cours...\nRevision : $Revision: 20 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" />
263
<REGION ID="18417" RegionName="Personne" XPos="1438" YPos="765" Width="407" Height="920" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Personnes.\nAbreviation : CP\nAide : OK\nEtat: OK\nRevision : $Revision: 20 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" />
264
<REGION ID="18447" RegionName="M\195\169tadonn\195\169es" XPos="20" YPos="16" Width="1023" Height="736" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des M\195\169tadonn\195\169es.\nAbreviation : CM\nAide : en cours...\nEtat: en cours...\nRevision : $Revision: 20 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="12" />
265
<REGION ID="21218" RegionName="Publication" XPos="19" YPos="1695" Width="421" Height="353" RegionColor="4" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Publications.\nAbreviation : CPU\nAide : en cours...\nEtat: en cours...\nRevision : $Revision: 20 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="44" />
14 jpm 266
</REGIONS>
267
<TABLES>
20 jpm 268
<TABLE ID="1444" Tablename="coel_collection" PrevTableName="Table_01" XPos="38" YPos="788" 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." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
14 jpm 269
<COLUMNS>
20 jpm 270
<COLUMN ID="1449" ColName="cc_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la collection.">
14 jpm 271
<OPTIONSELECTED>
272
<OPTIONSELECT Value="1" />
273
<OPTIONSELECT Value="0" />
274
</OPTIONSELECTED>
275
</COLUMN>
20 jpm 276
<COLUMN ID="21167" ColName="cc_ce_mere" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" 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 277
<OPTIONSELECTED>
278
<OPTIONSELECT Value="1" />
279
<OPTIONSELECT Value="0" />
280
</OPTIONSELECTED>
281
</COLUMN>
20 jpm 282
<COLUMN ID="20821" ColName="cc_ce_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" 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 283
<OPTIONSELECTED>
284
<OPTIONSELECT Value="1" />
285
<OPTIONSELECT Value="0" />
286
</OPTIONSELECTED>
287
</COLUMN>
20 jpm 288
<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.">
289
<OPTIONSELECTED>
290
<OPTIONSELECT Value="0" />
291
</OPTIONSELECTED>
292
</COLUMN>
293
<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.">
294
<OPTIONSELECTED>
295
<OPTIONSELECT Value="0" />
296
</OPTIONSELECTED>
297
</COLUMN>
298
<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.">
299
<OPTIONSELECTED>
300
<OPTIONSELECT Value="0" />
301
</OPTIONSELECTED>
302
</COLUMN>
303
<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.">
304
<OPTIONSELECTED>
305
<OPTIONSELECT Value="0" />
306
</OPTIONSELECTED>
307
</COLUMN>
308
<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.">
309
<OPTIONSELECTED>
310
</OPTIONSELECTED>
311
</COLUMN>
312
<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.">
313
<OPTIONSELECTED>
314
</OPTIONSELECTED>
315
</COLUMN>
316
<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.">
317
<OPTIONSELECTED>
318
</OPTIONSELECTED>
319
</COLUMN>
320
<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 ...).">
321
<OPTIONSELECTED>
322
</OPTIONSELECTED>
323
</COLUMN>
324
<COLUMN ID="21182" ColName="cc_truk_url" PrevColName="cc_url" Pos="18" idDatatype="20" DatatypeParams="(255)" 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.">
325
<OPTIONSELECTED>
326
<OPTIONSELECT Value="0" />
327
</OPTIONSELECTED>
328
</COLUMN>
329
<COLUMN ID="21333" ColName="cc_truk_url_objet" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL(s) indiquant un web service ou une page permettant d\aacc\195\168der \195\160 des informations sur les objets de la collection.">
330
<OPTIONSELECTED>
331
<OPTIONSELECT Value="0" />
332
</OPTIONSELECTED>
333
</COLUMN>
334
<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.">
335
<OPTIONSELECTED>
336
<OPTIONSELECT Value="0" />
337
</OPTIONSELECTED>
338
</COLUMN>
339
<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.">
340
<OPTIONSELECTED>
341
<OPTIONSELECT Value="1" />
342
<OPTIONSELECT Value="0" />
343
</OPTIONSELECTED>
344
</COLUMN>
345
<COLUMN ID="21146" ColName="cc_ce_type" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type de la collection vis \195\160 vis du standard NCD.">
346
<OPTIONSELECTED>
347
<OPTIONSELECT Value="1" />
348
<OPTIONSELECT Value="0" />
349
</OPTIONSELECTED>
350
</COLUMN>
351
<COLUMN ID="21177" ColName="cc_truk_type_depot" PrevColName="cc_ce_type_depot" Pos="17" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de d\195\169p\195\180t de la collection.">
352
<OPTIONSELECTED>
353
<OPTIONSELECT Value="1" />
354
<OPTIONSELECT Value="0" />
355
</OPTIONSELECTED>
356
</COLUMN>
357
<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.">
358
<OPTIONSELECTED>
359
<OPTIONSELECT Value="0" />
360
</OPTIONSELECTED>
361
</COLUMN>
362
<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.">
363
<OPTIONSELECTED>
364
<OPTIONSELECT Value="0" />
365
</OPTIONSELECTED>
366
</COLUMN>
367
<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.">
368
<OPTIONSELECTED>
369
</OPTIONSELECTED>
370
</COLUMN>
371
<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.">
372
<OPTIONSELECTED>
373
</OPTIONSELECTED>
374
</COLUMN>
375
<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).">
376
<OPTIONSELECTED>
377
<OPTIONSELECT Value="0" />
378
</OPTIONSELECTED>
379
</COLUMN>
380
<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.">
381
<OPTIONSELECTED>
382
<OPTIONSELECT Value="0" />
383
</OPTIONSELECTED>
384
</COLUMN>
385
<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.">
386
<OPTIONSELECTED>
387
<OPTIONSELECT Value="0" />
388
</OPTIONSELECTED>
389
</COLUMN>
390
<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.">
391
<OPTIONSELECTED>
392
<OPTIONSELECT Value="0" />
393
</OPTIONSELECTED>
394
</COLUMN>
395
<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.">
396
<OPTIONSELECTED>
397
<OPTIONSELECT Value="0" />
398
</OPTIONSELECTED>
399
</COLUMN>
400
<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.">
401
<OPTIONSELECTED>
402
<OPTIONSELECT Value="0" />
403
</OPTIONSELECTED>
404
</COLUMN>
405
<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.">
406
<OPTIONSELECTED>
407
<OPTIONSELECT Value="0" />
408
</OPTIONSELECTED>
409
</COLUMN>
410
<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="0" DefaultValue="" Comments="Indique le changement potentiel dans la port\195\169e de la collection.">
411
<OPTIONSELECTED>
412
<OPTIONSELECT Value="0" />
413
</OPTIONSELECTED>
414
</COLUMN>
415
<COLUMN ID="21337" ColName="cc_truk_periode_formation" PrevColName="" 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.">
416
<OPTIONSELECTED>
417
<OPTIONSELECT Value="0" />
418
</OPTIONSELECTED>
419
</COLUMN>
420
<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 desquels le mat\195\169riel de la collection est originaire.">
421
<OPTIONSELECTED>
422
<OPTIONSELECT Value="0" />
423
</OPTIONSELECTED>
424
</COLUMN>
425
<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.">
426
<OPTIONSELECTED>
427
<OPTIONSELECT Value="0" />
428
</OPTIONSELECTED>
429
</COLUMN>
430
<COLUMN ID="21325" ColName="cc_mark_specimen_type" PrevColName="" Pos="30" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indique si oui ou non la collection contient des sp\195\169cimens types.">
431
<OPTIONSELECTED>
432
</OPTIONSELECTED>
433
</COLUMN>
434
<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.">
435
<OPTIONSELECTED>
436
<OPTIONSELECT Value="0" />
437
</OPTIONSELECTED>
438
</COLUMN>
439
<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.">
440
<OPTIONSELECTED>
441
<OPTIONSELECT Value="0" />
442
</OPTIONSELECTED>
443
</COLUMN>
16 jpm 444
<COLUMN ID="20838" ColName="cc_notes" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications. ">
445
<OPTIONSELECTED>
446
<OPTIONSELECT Value="0" />
447
</OPTIONSELECTED>
448
</COLUMN>
449
<COLUMN ID="20839" ColName="cc_date_derniere_modif" PrevColName="" Pos="4" idDatatype="15" 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.">
450
<OPTIONSELECTED>
451
</OPTIONSELECTED>
452
</COLUMN>
453
<COLUMN ID="20840" ColName="cc_ce_modifier_par" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement. ">
454
<OPTIONSELECTED>
455
<OPTIONSELECT Value="1" />
456
<OPTIONSELECT Value="0" />
457
</OPTIONSELECTED>
458
</COLUMN>
20 jpm 459
<COLUMN ID="21320" ColName="cc_ce_etat" PrevColName="" Pos="27" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de l\aenregistrement.">
16 jpm 460
<OPTIONSELECTED>
461
<OPTIONSELECT Value="1" />
462
<OPTIONSELECT Value="0" />
463
</OPTIONSELECTED>
464
</COLUMN>
14 jpm 465
</COLUMNS>
16 jpm 466
<RELATIONS_START>
467
<RELATION_START ID="20819" />
20 jpm 468
<RELATION_START ID="21108" />
469
<RELATION_START ID="21152" />
470
<RELATION_START ID="21223" />
16 jpm 471
</RELATIONS_START>
472
<RELATIONS_END>
473
<RELATION_END ID="20817" />
474
<RELATION_END ID="20819" />
475
<RELATION_END ID="20842" />
476
</RELATIONS_END>
14 jpm 477
<INDICES>
478
<INDEX ID="1450" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
479
<INDEXCOLUMNS>
480
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
481
</INDEXCOLUMNS>
482
</INDEX>
483
</INDICES>
484
</TABLE>
20 jpm 485
<TABLE ID="1445" Tablename="coel_structure" PrevTableName="Table_02" XPos="726" YPos="790" 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." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" >
14 jpm 486
<COLUMNS>
16 jpm 487
<COLUMN ID="18411" ColName="cs_id_structure" PrevColName="idcoel_structure" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la structure.">
14 jpm 488
<OPTIONSELECTED>
489
<OPTIONSELECT Value="1" />
490
<OPTIONSELECT Value="0" />
491
</OPTIONSELECTED>
492
</COLUMN>
20 jpm 493
<COLUMN ID="21165" ColName="cs_ce_mere" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
16 jpm 494
<OPTIONSELECTED>
495
<OPTIONSELECT Value="1" />
496
<OPTIONSELECT Value="0" />
497
</OPTIONSELECTED>
498
</COLUMN>
20 jpm 499
<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 500
<OPTIONSELECTED>
501
<OPTIONSELECT Value="0" />
502
</OPTIONSELECTED>
503
</COLUMN>
20 jpm 504
<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 505
<OPTIONSELECTED>
506
<OPTIONSELECT Value="0" />
507
</OPTIONSELECTED>
508
</COLUMN>
509
<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.">
510
<OPTIONSELECTED>
511
<OPTIONSELECT Value="0" />
512
</OPTIONSELECTED>
513
</COLUMN>
20 jpm 514
<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 515
<OPTIONSELECTED>
516
<OPTIONSELECT Value="0" />
517
</OPTIONSELECTED>
518
</COLUMN>
519
<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.">
520
<OPTIONSELECTED>
521
</OPTIONSELECTED>
522
</COLUMN>
20 jpm 523
<COLUMN ID="20789" ColName="cs_ce_type" PrevColName="cs_ce_statut" Pos="17" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du type de la structure vis \195\160 vis du standard NCD.">
16 jpm 524
<OPTIONSELECTED>
20 jpm 525
<OPTIONSELECT Value="1" />
16 jpm 526
<OPTIONSELECT Value="0" />
527
</OPTIONSELECTED>
528
</COLUMN>
20 jpm 529
<COLUMN ID="21169" ColName="cs_ce_truk_type_prive" PrevColName="" Pos="24" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Type priv\195\169 de structure.">
530
<OPTIONSELECTED>
531
<OPTIONSELECT Value="1" />
532
<OPTIONSELECT Value="0" />
533
</OPTIONSELECTED>
534
</COLUMN>
535
<COLUMN ID="21170" ColName="cs_ce_truk_type_public" PrevColName="" Pos="25" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Type public de structure.">
536
<OPTIONSELECTED>
537
<OPTIONSELECT Value="1" />
538
<OPTIONSELECT Value="0" />
539
</OPTIONSELECTED>
540
</COLUMN>
16 jpm 541
<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.">
542
<OPTIONSELECTED>
543
<OPTIONSELECT Value="0" />
544
</OPTIONSELECTED>
545
</COLUMN>
546
<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.">
547
<OPTIONSELECTED>
548
<OPTIONSELECT Value="0" />
549
</OPTIONSELECTED>
550
</COLUMN>
551
<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.">
552
<OPTIONSELECTED>
553
</OPTIONSELECTED>
554
</COLUMN>
555
<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.">
556
<OPTIONSELECTED>
557
<OPTIONSELECT Value="0" />
558
</OPTIONSELECTED>
559
</COLUMN>
560
<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.">
561
<OPTIONSELECTED>
562
<OPTIONSELECT Value="0" />
563
</OPTIONSELECTED>
564
</COLUMN>
565
<COLUMN ID="20783" ColName="cs_region" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="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.">
566
<OPTIONSELECTED>
567
<OPTIONSELECT Value="0" />
568
</OPTIONSELECTED>
569
</COLUMN>
570
<COLUMN ID="20784" ColName="cs_pays" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pays de la structure. Utiliser les noms du standard ISO-3166-1.">
571
<OPTIONSELECTED>
572
<OPTIONSELECT Value="0" />
573
</OPTIONSELECTED>
574
</COLUMN>
575
<COLUMN ID="20785" ColName="cs_telephone" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="T\195\169l\195\169phone principale de la structure.">
576
<OPTIONSELECTED>
577
<OPTIONSELECT Value="0" />
578
</OPTIONSELECTED>
579
</COLUMN>
580
<COLUMN ID="20786" ColName="cs_fax" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Fax de la structure.">
581
<OPTIONSELECTED>
582
<OPTIONSELECT Value="0" />
583
</OPTIONSELECTED>
584
</COLUMN>
20 jpm 585
<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 586
<OPTIONSELECTED>
587
<OPTIONSELECT Value="0" />
588
</OPTIONSELECTED>
589
</COLUMN>
20 jpm 590
<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 du site web principal de la structure ou de page web particuli\195\168re.">
591
<OPTIONSELECTED>
592
<OPTIONSELECT Value="0" />
593
</OPTIONSELECTED>
594
</COLUMN>
16 jpm 595
<COLUMN ID="20816" ColName="cs_nbre_personne" PrevColName="" Pos="19" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nombre de personne pr\195\169sentent dans la structure.">
596
<OPTIONSELECTED>
597
<OPTIONSELECT Value="1" />
598
<OPTIONSELECT Value="0" />
599
</OPTIONSELECTED>
600
</COLUMN>
20 jpm 601
<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.">
602
<OPTIONSELECTED>
603
</OPTIONSELECTED>
604
</COLUMN>
605
<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.">
606
<OPTIONSELECTED>
607
</OPTIONSELECTED>
608
</COLUMN>
16 jpm 609
<COLUMN ID="20824" ColName="cs_notes" PrevColName="" Pos="20" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications.">
610
<OPTIONSELECTED>
611
<OPTIONSELECT Value="0" />
612
</OPTIONSELECTED>
613
</COLUMN>
614
<COLUMN ID="20825" ColName="cs_date_derniere_modif" PrevColName="" Pos="21" idDatatype="15" 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.">
615
<OPTIONSELECTED>
616
</OPTIONSELECTED>
617
</COLUMN>
618
<COLUMN ID="20826" ColName="cs_ce_modifier_par" PrevColName="" Pos="22" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement. ">
619
<OPTIONSELECTED>
620
<OPTIONSELECT Value="1" />
621
<OPTIONSELECT Value="0" />
622
</OPTIONSELECTED>
623
</COLUMN>
624
<COLUMN ID="20827" ColName="cs_ce_etat" PrevColName="" Pos="23" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de cet enregistrement. ">
625
<OPTIONSELECTED>
626
<OPTIONSELECT Value="1" />
627
<OPTIONSELECT Value="0" />
628
</OPTIONSELECTED>
629
</COLUMN>
14 jpm 630
</COLUMNS>
631
<RELATIONS_START>
632
<RELATION_START ID="18419" />
16 jpm 633
<RELATION_START ID="20817" />
634
<RELATION_START ID="20859" />
635
<RELATION_START ID="20861" />
20 jpm 636
<RELATION_START ID="21163" />
14 jpm 637
</RELATIONS_START>
16 jpm 638
<RELATIONS_END>
639
<RELATION_END ID="20830" />
20 jpm 640
<RELATION_END ID="21163" />
16 jpm 641
</RELATIONS_END>
14 jpm 642
<INDICES>
643
<INDEX ID="18412" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
644
<INDEXCOLUMNS>
645
<INDEXCOLUMN idColumn="18411" LengthParam="0" />
646
</INDEXCOLUMNS>
647
</INDEX>
648
</INDICES>
649
</TABLE>
20 jpm 650
<TABLE ID="1446" Tablename="coel_personne" PrevTableName="Table_03" XPos="1545" YPos="781" 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..." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" >
14 jpm 651
<COLUMNS>
652
<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.">
653
<OPTIONSELECTED>
654
<OPTIONSELECT Value="1" />
655
<OPTIONSELECT Value="0" />
656
</OPTIONSELECTED>
657
</COLUMN>
20 jpm 658
<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 avec : pr\195\169fixe+\A \A+Pr\195\169nom+\A \A+NOM+\A \A+suffixe">
14 jpm 659
<OPTIONSELECTED>
660
<OPTIONSELECT Value="0" />
661
</OPTIONSELECTED>
662
</COLUMN>
20 jpm 663
<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="0" DefaultValue="" Comments="Pr\195\169fixe du nom principal. Exemple : Dr, Mr.">
14 jpm 664
<OPTIONSELECTED>
665
<OPTIONSELECT Value="0" />
666
</OPTIONSELECTED>
667
</COLUMN>
20 jpm 668
<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 virgul 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 669
<OPTIONSELECTED>
670
<OPTIONSELECT Value="0" />
671
</OPTIONSELECTED>
672
</COLUMN>
20 jpm 673
<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="Nom de famille principal (le plus connu, r\195\169pandu). Un point virgule peut s\195\169parer le nom principal de noms secondaires \195\160 ne pas afficher dans le nom complet.">
14 jpm 674
<OPTIONSELECTED>
675
<OPTIONSELECT Value="0" />
676
</OPTIONSELECTED>
677
</COLUMN>
20 jpm 678
<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="0" DefaultValue="" Comments="Suffixe du nom principal. Exemple : Jr, III.">
14 jpm 679
<OPTIONSELECTED>
680
<OPTIONSELECT Value="0" />
681
</OPTIONSELECTED>
682
</COLUMN>
20 jpm 683
<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. 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 684
<OPTIONSELECTED>
685
<OPTIONSELECT Value="0" />
686
</OPTIONSELECTED>
687
</COLUMN>
20 jpm 688
<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 689
<OPTIONSELECTED>
690
<OPTIONSELECT Value="0" />
691
</OPTIONSELECTED>
692
</COLUMN>
20 jpm 693
<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. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|A. J. Sharp;APN#9544-1|Sharp">
14 jpm 694
<OPTIONSELECTED>
695
<OPTIONSELECT Value="0" />
696
</OPTIONSELECTED>
697
</COLUMN>
20 jpm 698
<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 699
<OPTIONSELECTED>
20 jpm 700
</OPTIONSELECTED>
701
</COLUMN>
702
<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="Autres abr\195\169viations du nom. Pour les valeurs, s\195\169parez l\aidentifiant de l\aabreviation par un symbole pipe \A|\A. Exemple: HUH#105714|A. J. Sharp;APN#9544-1|Sharp;BP#?|Sharp">
703
<OPTIONSELECTED>
14 jpm 704
<OPTIONSELECT Value="0" />
705
</OPTIONSELECTED>
706
</COLUMN>
20 jpm 707
<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">
708
<OPTIONSELECTED>
709
</OPTIONSELECTED>
710
</COLUMN>
711
<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.">
712
<OPTIONSELECTED>
713
<OPTIONSELECT Value="0" />
714
</OPTIONSELECTED>
715
</COLUMN>
716
<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.">
717
<OPTIONSELECTED>
718
</OPTIONSELECTED>
719
</COLUMN>
720
<COLUMN ID="1465" ColName="cp_ce_truk_role" PrevColName="cco_role" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le(s) de la personne : observateur, collecteur...">
721
<OPTIONSELECTED>
722
<OPTIONSELECT Value="0" />
723
</OPTIONSELECTED>
724
</COLUMN>
16 jpm 725
<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 726
<OPTIONSELECTED>
727
<OPTIONSELECT Value="0" />
728
</OPTIONSELECTED>
729
</COLUMN>
16 jpm 730
<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 731
<OPTIONSELECTED>
732
<OPTIONSELECT Value="0" />
733
</OPTIONSELECTED>
734
</COLUMN>
16 jpm 735
<COLUMN ID="18394" ColName="cp_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="Nom de la r\195\169gion (\195\169tat, province) o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-2.">
14 jpm 736
<OPTIONSELECTED>
737
<OPTIONSELECT Value="0" />
738
</OPTIONSELECTED>
739
</COLUMN>
16 jpm 740
<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 741
<OPTIONSELECTED>
742
<OPTIONSELECT Value="0" />
743
</OPTIONSELECTED>
744
</COLUMN>
16 jpm 745
<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 746
<OPTIONSELECTED>
747
<OPTIONSELECT Value="0" />
748
</OPTIONSELECTED>
749
</COLUMN>
16 jpm 750
<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 751
<OPTIONSELECTED>
752
<OPTIONSELECT Value="0" />
753
</OPTIONSELECTED>
754
</COLUMN>
16 jpm 755
<COLUMN ID="18396" ColName="cp_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="Nom du pays o\195\185 vit la personne. Utiliser les noms du standard ISO-3166-1.">
14 jpm 756
<OPTIONSELECTED>
757
<OPTIONSELECT Value="0" />
758
</OPTIONSELECTED>
759
</COLUMN>
20 jpm 760
<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, pager... personnels compl\195\169mentaires.">
14 jpm 761
<OPTIONSELECTED>
762
<OPTIONSELECT Value="0" />
763
</OPTIONSELECTED>
764
</COLUMN>
20 jpm 765
<COLUMN ID="21173" ColName="cp_truk_fax" PrevColName="" Pos="34" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro(s) de fax.">
14 jpm 766
<OPTIONSELECTED>
767
<OPTIONSELECT Value="0" />
768
</OPTIONSELECTED>
769
</COLUMN>
20 jpm 770
<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 771
<OPTIONSELECTED>
772
<OPTIONSELECT Value="0" />
773
</OPTIONSELECTED>
774
</COLUMN>
20 jpm 775
<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 776
<OPTIONSELECTED>
777
<OPTIONSELECT Value="0" />
778
</OPTIONSELECTED>
779
</COLUMN>
20 jpm 780
<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) de logo personnel. Ajouter les adresses dans leur ordre d\aimportance.">
14 jpm 781
<OPTIONSELECTED>
782
<OPTIONSELECT Value="0" />
783
</OPTIONSELECTED>
784
</COLUMN>
20 jpm 785
<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="0" DefaultValue="" Comments="Indiquer s\195\169parer par des points virgules \A;\A les sp\195\169cialit\195\169s naturalistes de la personne.">
14 jpm 786
<OPTIONSELECTED>
787
<OPTIONSELECT Value="0" />
788
</OPTIONSELECTED>
789
</COLUMN>
20 jpm 790
<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 (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 791
<OPTIONSELECTED>
792
<OPTIONSELECT Value="0" />
793
</OPTIONSELECTED>
794
</COLUMN>
20 jpm 795
<COLUMN ID="18446" ColName="cp_bool_licence" PrevColName="" 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 796
<OPTIONSELECTED>
20 jpm 797
</OPTIONSELECTED>
798
</COLUMN>
799
<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.">
800
<OPTIONSELECTED>
14 jpm 801
<OPTIONSELECT Value="0" />
802
</OPTIONSELECTED>
803
</COLUMN>
20 jpm 804
<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.">
14 jpm 805
<OPTIONSELECTED>
806
<OPTIONSELECT Value="0" />
807
</OPTIONSELECTED>
808
</COLUMN>
16 jpm 809
<COLUMN ID="18404" ColName="cp_notes" PrevColName="cco_notes" Pos="25" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications.">
14 jpm 810
<OPTIONSELECTED>
811
<OPTIONSELECT Value="0" />
812
</OPTIONSELECTED>
813
</COLUMN>
20 jpm 814
<COLUMN ID="18405" ColName="cp_date_derniere_modif" PrevColName="cco_" Pos="26" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="Date de la derni\195\168re modification sur cet enregistrement.">
14 jpm 815
<OPTIONSELECTED>
16 jpm 816
</OPTIONSELECTED>
817
</COLUMN>
818
<COLUMN ID="18407" ColName="cp_ce_modifier_par" PrevColName="cco_ce_modifier_par" Pos="27" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.">
819
<OPTIONSELECTED>
820
<OPTIONSELECT Value="1" />
14 jpm 821
<OPTIONSELECT Value="0" />
822
</OPTIONSELECTED>
823
</COLUMN>
16 jpm 824
<COLUMN ID="18408" ColName="cp_ce_etat" PrevColName="cco_ce_etat" Pos="28" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de cet enregistrement.">
14 jpm 825
<OPTIONSELECTED>
826
<OPTIONSELECT Value="1" />
827
<OPTIONSELECT Value="0" />
828
</OPTIONSELECTED>
829
</COLUMN>
16 jpm 830
</COLUMNS>
831
<RELATIONS_START>
832
<RELATION_START ID="18425" />
833
<RELATION_START ID="20828" />
834
<RELATION_START ID="20830" />
835
<RELATION_START ID="20834" />
836
<RELATION_START ID="20842" />
837
<RELATION_START ID="20844" />
20 jpm 838
<RELATION_START ID="21110" />
839
<RELATION_START ID="21118" />
840
<RELATION_START ID="21194" />
841
<RELATION_START ID="21239" />
842
<RELATION_START ID="21252" />
843
<RELATION_START ID="21254" />
16 jpm 844
</RELATIONS_START>
845
<RELATIONS_END>
846
<RELATION_END ID="20834" />
847
</RELATIONS_END>
848
<INDICES>
849
<INDEX ID="1457" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
850
<INDEXCOLUMNS>
851
<INDEXCOLUMN idColumn="1456" LengthParam="0" />
852
</INDEXCOLUMNS>
853
</INDEX>
854
</INDICES>
855
</TABLE>
20 jpm 856
<TABLE ID="1447" Tablename="coel_structure_a_equipe" PrevTableName="Table_04" XPos="1134" YPos="894" 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="40" >
16 jpm 857
<COLUMNS>
858
<COLUMN ID="20886" ColName="csae_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure.">
14 jpm 859
<OPTIONSELECTED>
860
<OPTIONSELECT Value="1" />
861
<OPTIONSELECT Value="0" />
862
</OPTIONSELECTED>
863
</COLUMN>
16 jpm 864
<COLUMN ID="20887" ColName="csae_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.">
14 jpm 865
<OPTIONSELECTED>
16 jpm 866
<OPTIONSELECT Value="1" />
14 jpm 867
<OPTIONSELECT Value="0" />
868
</OPTIONSELECTED>
869
</COLUMN>
20 jpm 870
<COLUMN ID="18533" ColName="csae_ce_truk_fonction" PrevColName="csae_fonction" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la fonction de la personne dans son travail.">
14 jpm 871
<OPTIONSELECTED>
16 jpm 872
<OPTIONSELECT Value="0" />
14 jpm 873
</OPTIONSELECTED>
874
</COLUMN>
16 jpm 875
<COLUMN ID="18534" ColName="csae_service" PrevColName="" 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.">
14 jpm 876
<OPTIONSELECTED>
16 jpm 877
<OPTIONSELECT Value="0" />
878
</OPTIONSELECTED>
879
</COLUMN>
20 jpm 880
<COLUMN ID="18537" ColName="csae_ce_truk_statut" PrevColName="csae_statut" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Statut(s) de la personne : salari\195\169, b\195\169n\195\169vole... S\195\169parer chaque valeur par un point virgule \A;\A.">
16 jpm 881
<OPTIONSELECTED>
882
<OPTIONSELECT Value="0" />
883
</OPTIONSELECTED>
884
</COLUMN>
885
<COLUMN ID="18433" ColName="csae_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.">
886
<OPTIONSELECTED>
887
</OPTIONSELECTED>
888
</COLUMN>
889
<COLUMN ID="18546" ColName="csae_bota_travail_hebdo_tps" PrevColName="" Pos="10" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Temps de travail hebdomadaire de la personne dans la structure botanique. Ce champ est \195\160 but statistique et n\aapparaitra pas en ligne.">
890
<OPTIONSELECTED>
14 jpm 891
<OPTIONSELECT Value="1" />
892
<OPTIONSELECT Value="0" />
893
</OPTIONSELECTED>
894
</COLUMN>
16 jpm 895
<COLUMN ID="18441" ColName="csae_notes" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications. ">
14 jpm 896
<OPTIONSELECTED>
16 jpm 897
<OPTIONSELECT Value="0" />
898
</OPTIONSELECTED>
899
</COLUMN>
900
<COLUMN ID="18442" ColName="csae_date_derniere_modif" PrevColName="" Pos="4" idDatatype="15" 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.">
901
<OPTIONSELECTED>
902
</OPTIONSELECTED>
903
</COLUMN>
904
<COLUMN ID="18443" ColName="csae_ce_modifier_par" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement. ">
905
<OPTIONSELECTED>
14 jpm 906
<OPTIONSELECT Value="1" />
907
<OPTIONSELECT Value="0" />
908
</OPTIONSELECTED>
909
</COLUMN>
16 jpm 910
<COLUMN ID="18444" ColName="csae_ce_etat" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de cet enregistrement.">
911
<OPTIONSELECTED>
912
<OPTIONSELECT Value="1" />
913
<OPTIONSELECT Value="0" />
914
</OPTIONSELECTED>
915
</COLUMN>
14 jpm 916
</COLUMNS>
16 jpm 917
<RELATIONS_END>
918
<RELATION_END ID="18419" />
919
<RELATION_END ID="18425" />
920
<RELATION_END ID="20828" />
921
</RELATIONS_END>
922
<INDICES>
923
<INDEX ID="20888" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
924
<INDEXCOLUMNS>
925
<INDEXCOLUMN idColumn="20886" LengthParam="0" />
926
<INDEXCOLUMN idColumn="20887" LengthParam="0" />
927
</INDEXCOLUMNS>
928
</INDEX>
929
</INDICES>
930
</TABLE>
20 jpm 931
<TABLE ID="18448" Tablename="coel_meta_table" PrevTableName="Table_05" XPos="764" YPos="140" 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="13" >
16 jpm 932
<COLUMNS>
933
<COLUMN ID="18450" ColName="cmt_id_table" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
934
<OPTIONSELECTED>
935
<OPTIONSELECT Value="1" />
936
<OPTIONSELECT Value="0" />
937
</OPTIONSELECTED>
938
</COLUMN>
939
<COLUMN ID="18485" ColName="cmt_nom" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
940
<OPTIONSELECTED>
941
<OPTIONSELECT Value="0" />
942
</OPTIONSELECTED>
943
</COLUMN>
944
</COLUMNS>
14 jpm 945
<RELATIONS_START>
16 jpm 946
<RELATION_START ID="20806" />
947
<RELATION_START ID="20808" />
14 jpm 948
</RELATIONS_START>
949
<INDICES>
16 jpm 950
<INDEX ID="18451" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 951
<INDEXCOLUMNS>
16 jpm 952
<INDEXCOLUMN idColumn="18450" LengthParam="0" />
14 jpm 953
</INDEXCOLUMNS>
954
</INDEX>
955
</INDICES>
956
</TABLE>
20 jpm 957
<TABLE ID="18452" Tablename="coel_meta_donnee" PrevTableName="Table_06" XPos="332" YPos="400" 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="14" >
14 jpm 958
<COLUMNS>
16 jpm 959
<COLUMN ID="18454" ColName="cmd_id_donnee" PrevColName="cmt_id_donnee" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
14 jpm 960
<OPTIONSELECTED>
961
<OPTIONSELECT Value="1" />
962
<OPTIONSELECT Value="0" />
963
</OPTIONSELECTED>
964
</COLUMN>
16 jpm 965
<COLUMN ID="20811" ColName="cmd_ce_table" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
14 jpm 966
<OPTIONSELECTED>
967
<OPTIONSELECT Value="1" />
968
<OPTIONSELECT Value="0" />
969
</OPTIONSELECTED>
970
</COLUMN>
16 jpm 971
<COLUMN ID="20800" ColName="cmd_ce_caracteristique" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
14 jpm 972
<OPTIONSELECTED>
973
<OPTIONSELECT Value="1" />
974
<OPTIONSELECT Value="0" />
975
</OPTIONSELECTED>
976
</COLUMN>
16 jpm 977
<COLUMN ID="20804" ColName="cmd_ce_identifiant" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
14 jpm 978
<OPTIONSELECTED>
16 jpm 979
<OPTIONSELECT Value="1" />
980
<OPTIONSELECT Value="0" />
14 jpm 981
</OPTIONSELECTED>
982
</COLUMN>
16 jpm 983
<COLUMN ID="18479" ColName="cmd_valeur" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
14 jpm 984
<OPTIONSELECTED>
16 jpm 985
<OPTIONSELECT Value="0" />
14 jpm 986
</OPTIONSELECTED>
987
</COLUMN>
16 jpm 988
</COLUMNS>
989
<RELATIONS_END>
990
<RELATION_END ID="18470" />
991
<RELATION_END ID="20806" />
992
</RELATIONS_END>
993
<INDICES>
994
<INDEX ID="18455" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
995
<INDEXCOLUMNS>
996
<INDEXCOLUMN idColumn="18454" LengthParam="0" />
997
</INDEXCOLUMNS>
998
</INDEX>
999
</INDICES>
1000
</TABLE>
20 jpm 1001
<TABLE ID="18456" Tablename="coel_meta_caracteristique" PrevTableName="Table_07" XPos="348" YPos="140" 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="15" >
16 jpm 1002
<COLUMNS>
1003
<COLUMN ID="18458" ColName="cmc_id_caracteristique" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la caract\195\169ristique.">
14 jpm 1004
<OPTIONSELECTED>
1005
<OPTIONSELECT Value="1" />
1006
<OPTIONSELECT Value="0" />
1007
</OPTIONSELECTED>
1008
</COLUMN>
16 jpm 1009
<COLUMN ID="18493" ColName="cmc_ce_type" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
14 jpm 1010
<OPTIONSELECTED>
1011
<OPTIONSELECT Value="1" />
1012
<OPTIONSELECT Value="0" />
1013
</OPTIONSELECTED>
1014
</COLUMN>
16 jpm 1015
<COLUMN ID="18503" ColName="cmc_intitule" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la caract\195\169ristique.">
1016
<OPTIONSELECTED>
1017
<OPTIONSELECT Value="0" />
1018
</OPTIONSELECTED>
1019
</COLUMN>
14 jpm 1020
</COLUMNS>
16 jpm 1021
<RELATIONS_START>
1022
<RELATION_START ID="18470" />
1023
<RELATION_START ID="18494" />
1024
<RELATION_START ID="18504" />
1025
</RELATIONS_START>
14 jpm 1026
<RELATIONS_END>
16 jpm 1027
<RELATION_END ID="18490" />
14 jpm 1028
</RELATIONS_END>
1029
<INDICES>
16 jpm 1030
<INDEX ID="18459" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1031
<INDEXCOLUMNS>
16 jpm 1032
<INDEXCOLUMN idColumn="18458" LengthParam="0" />
14 jpm 1033
</INDEXCOLUMNS>
1034
</INDEX>
16 jpm 1035
<INDEX ID="18492" IndexName="coel_meta_caracteristique_FKIndex1" IndexKind="1" FKRefDef_Obj_id="18490">
14 jpm 1036
<INDEXCOLUMNS>
16 jpm 1037
<INDEXCOLUMN idColumn="18493" LengthParam="0" />
14 jpm 1038
</INDEXCOLUMNS>
1039
</INDEX>
16 jpm 1040
</INDICES>
1041
</TABLE>
20 jpm 1042
<TABLE ID="18462" Tablename="coel_meta_type" PrevTableName="Table_08" XPos="112" YPos="44" 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="16" >
16 jpm 1043
<COLUMNS>
1044
<COLUMN ID="18464" ColName="cmty_id_type" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
1045
<OPTIONSELECTED>
1046
<OPTIONSELECT Value="1" />
1047
<OPTIONSELECT Value="0" />
1048
</OPTIONSELECTED>
1049
</COLUMN>
1050
<COLUMN ID="18488" ColName="cmty_sql_type" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(32)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
1051
<OPTIONSELECTED>
1052
<OPTIONSELECT Value="0" />
1053
</OPTIONSELECTED>
1054
</COLUMN>
1055
<COLUMN ID="18489" ColName="cmty_longueur" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
1056
<OPTIONSELECTED>
1057
<OPTIONSELECT Value="1" />
1058
<OPTIONSELECT Value="0" />
1059
</OPTIONSELECTED>
1060
</COLUMN>
1061
</COLUMNS>
1062
<RELATIONS_START>
1063
<RELATION_START ID="18490" />
1064
</RELATIONS_START>
1065
<INDICES>
1066
<INDEX ID="18465" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1067
<INDEXCOLUMNS>
16 jpm 1068
<INDEXCOLUMN idColumn="18464" LengthParam="0" />
14 jpm 1069
</INDEXCOLUMNS>
1070
</INDEX>
1071
</INDICES>
1072
</TABLE>
20 jpm 1073
<TABLE ID="18466" Tablename="coel_meta_valeur" PrevTableName="Table_09" XPos="44" YPos="248" 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="17" >
16 jpm 1074
<COLUMNS>
1075
<COLUMN ID="18468" ColName="cmv_id_valeur" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
1076
<OPTIONSELECTED>
1077
<OPTIONSELECT Value="1" />
1078
<OPTIONSELECT Value="0" />
1079
</OPTIONSELECTED>
1080
</COLUMN>
1081
<COLUMN ID="18497" ColName="cmv_ce_caracteristique" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
1082
<OPTIONSELECTED>
1083
<OPTIONSELECT Value="1" />
1084
<OPTIONSELECT Value="0" />
1085
</OPTIONSELECTED>
1086
</COLUMN>
1087
</COLUMNS>
1088
<RELATIONS_END>
1089
<RELATION_END ID="18494" />
1090
</RELATIONS_END>
1091
<INDICES>
1092
<INDEX ID="18469" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1093
<INDEXCOLUMNS>
1094
<INDEXCOLUMN idColumn="18468" LengthParam="0" />
1095
</INDEXCOLUMNS>
1096
</INDEX>
1097
<INDEX ID="18496" IndexName="coel_meta_valeur_FKIndex1" IndexKind="1" FKRefDef_Obj_id="18494">
1098
<INDEXCOLUMNS>
1099
<INDEXCOLUMN idColumn="18497" LengthParam="0" />
1100
</INDEXCOLUMNS>
1101
</INDEX>
1102
</INDICES>
1103
</TABLE>
20 jpm 1104
<TABLE ID="18498" Tablename="coel_meta_historisation" PrevTableName="Table_10" XPos="720" YPos="412" 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="22" >
16 jpm 1105
<COLUMNS>
1106
<COLUMN ID="18500" ColName="cmh_id_historisation" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de cet enregistrement historis\195\169.">
1107
<OPTIONSELECTED>
1108
<OPTIONSELECT Value="1" />
1109
<OPTIONSELECT Value="0" />
1110
</OPTIONSELECTED>
1111
</COLUMN>
1112
<COLUMN ID="20810" ColName="cmh_ce_table" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
1113
<OPTIONSELECTED>
1114
<OPTIONSELECT Value="1" />
1115
<OPTIONSELECT Value="0" />
1116
</OPTIONSELECTED>
1117
</COLUMN>
1118
<COLUMN ID="18526" ColName="cmh_ce_caracteristique" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
1119
<OPTIONSELECTED>
1120
<OPTIONSELECT Value="1" />
1121
<OPTIONSELECT Value="0" />
1122
</OPTIONSELECTED>
1123
</COLUMN>
1124
<COLUMN ID="18514" ColName="cmh_ce_identifiant" PrevColName="cmh_id_donnee" Pos="4" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant de cette donn\195\169es dans la table d\aorigine.">
1125
<OPTIONSELECTED>
1126
<OPTIONSELECT Value="1" />
1127
<OPTIONSELECT Value="0" />
1128
</OPTIONSELECTED>
1129
</COLUMN>
1130
<COLUMN ID="18513" ColName="cmh_valeur" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Valeur de la colonne.">
1131
<OPTIONSELECTED>
1132
<OPTIONSELECT Value="0" />
1133
</OPTIONSELECTED>
1134
</COLUMN>
1135
<COLUMN ID="18515" ColName="cmh_date" PrevColName="" Pos="5" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date et heure de la modification de l\aenregistrement.">
1136
<OPTIONSELECTED>
1137
</OPTIONSELECTED>
1138
</COLUMN>
1139
<COLUMN ID="20846" ColName="cmh_ce_modifier_par" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
1140
<OPTIONSELECTED>
1141
<OPTIONSELECT Value="1" />
1142
<OPTIONSELECT Value="0" />
1143
</OPTIONSELECTED>
1144
</COLUMN>
1145
<COLUMN ID="18517" ColName="cmh_ce_etat" PrevColName="cmh_mode" Pos="7" idDatatype="20" DatatypeParams="(1)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant indiquant le mode de mise \195\160 jour. Ici cela devrait toujours \195\170tre de la modification.">
1146
<OPTIONSELECTED>
1147
<OPTIONSELECT Value="0" />
1148
</OPTIONSELECTED>
1149
</COLUMN>
1150
<COLUMN ID="18518" ColName="cmh_ip_mac" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Adresse ip \195\160 l\aorigine de la modification.">
1151
<OPTIONSELECTED>
1152
<OPTIONSELECT Value="0" />
1153
</OPTIONSELECTED>
1154
</COLUMN>
1155
</COLUMNS>
1156
<RELATIONS_END>
1157
<RELATION_END ID="18504" />
1158
<RELATION_END ID="20808" />
1159
<RELATION_END ID="20844" />
1160
</RELATIONS_END>
1161
<INDICES>
1162
<INDEX ID="18501" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1163
<INDEXCOLUMNS>
1164
<INDEXCOLUMN idColumn="18500" LengthParam="0" />
1165
</INDEXCOLUMNS>
1166
</INDEX>
1167
<INDEX ID="18523" IndexName="coel_meta_historisation_FKIndex1" IndexKind="1" FKRefDef_Obj_id="18504">
1168
<INDEXCOLUMNS>
1169
<INDEXCOLUMN idColumn="18526" LengthParam="0" />
1170
</INDEXCOLUMNS>
1171
</INDEX>
1172
</INDICES>
1173
</TABLE>
20 jpm 1174
<TABLE ID="20850" Tablename="coel_structure_conservation" PrevTableName="Table_11" XPos="1053" YPos="1278" 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="34" >
16 jpm 1175
<COLUMNS>
20 jpm 1176
<COLUMN ID="20978" ColName="csc_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure.">
16 jpm 1177
<OPTIONSELECTED>
1178
<OPTIONSELECT Value="1" />
1179
<OPTIONSELECT Value="0" />
1180
</OPTIONSELECTED>
1181
</COLUMN>
1182
<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?">
1183
<OPTIONSELECTED>
1184
</OPTIONSELECTED>
1185
</COLUMN>
20 jpm 1186
<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 1187
<OPTIONSELECTED>
1188
<OPTIONSELECT Value="0" />
1189
</OPTIONSELECTED>
1190
</COLUMN>
1191
<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?">
1192
<OPTIONSELECTED>
1193
</OPTIONSELECTED>
1194
</COLUMN>
20 jpm 1195
<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 1196
<OPTIONSELECTED>
20 jpm 1197
<OPTIONSELECT Value="0" />
1198
</OPTIONSELECTED>
1199
</COLUMN>
1200
<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? ">
1201
<OPTIONSELECTED>
1202
<OPTIONSELECT Value="0" />
1203
</OPTIONSELECTED>
1204
</COLUMN>
1205
<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 ?">
1206
<OPTIONSELECTED>
1207
<OPTIONSELECT Value="0" />
1208
</OPTIONSELECTED>
1209
</COLUMN>
1210
<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) ? ">
1211
<OPTIONSELECTED>
1212
</OPTIONSELECTED>
1213
</COLUMN>
1214
<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?">
1215
<OPTIONSELECTED>
1216
<OPTIONSELECT Value="0" />
1217
</OPTIONSELECTED>
1218
</COLUMN>
1219
<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?">
1220
<OPTIONSELECTED>
1221
</OPTIONSELECTED>
1222
</COLUMN>
1223
<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?">
1224
<OPTIONSELECTED>
1225
</OPTIONSELECTED>
1226
</COLUMN>
1227
<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.">
1228
<OPTIONSELECTED>
1229
<OPTIONSELECT Value="0" />
1230
</OPTIONSELECTED>
1231
</COLUMN>
1232
<COLUMN ID="20964" ColName="csc_ce_materiel_conservation" PrevColName="" Pos="12" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Utilisez-vous du mat\195\169riel de conservation ?">
1233
<OPTIONSELECTED>
16 jpm 1234
<OPTIONSELECT Value="1" />
1235
<OPTIONSELECT Value="0" />
1236
</OPTIONSELECTED>
1237
</COLUMN>
20 jpm 1238
<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 1239
<OPTIONSELECTED>
1240
<OPTIONSELECT Value="0" />
1241
</OPTIONSELECTED>
1242
</COLUMN>
20 jpm 1243
<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?">
1244
<OPTIONSELECTED>
1245
</OPTIONSELECTED>
1246
</COLUMN>
1247
<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.">
1248
<OPTIONSELECTED>
1249
<OPTIONSELECT Value="0" />
1250
</OPTIONSELECTED>
1251
</COLUMN>
1252
<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?">
1253
<OPTIONSELECTED>
1254
</OPTIONSELECTED>
1255
</COLUMN>
1256
<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? ">
1257
<OPTIONSELECTED>
1258
</OPTIONSELECTED>
1259
</COLUMN>
1260
<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?">
1261
<OPTIONSELECTED>
1262
</OPTIONSELECTED>
1263
</COLUMN>
1264
<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.">
1265
<OPTIONSELECTED>
1266
<OPTIONSELECT Value="0" />
1267
</OPTIONSELECTED>
1268
</COLUMN>
1269
<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.">
1270
<OPTIONSELECTED>
1271
<OPTIONSELECT Value="0" />
1272
</OPTIONSELECTED>
1273
</COLUMN>
16 jpm 1274
</COLUMNS>
1275
<RELATIONS_END>
1276
<RELATION_END ID="20859" />
1277
</RELATIONS_END>
1278
<INDICES>
20 jpm 1279
<INDEX ID="20979" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
16 jpm 1280
<INDEXCOLUMNS>
20 jpm 1281
<INDEXCOLUMN idColumn="20978" LengthParam="0" />
16 jpm 1282
</INDEXCOLUMNS>
1283
</INDEX>
1284
</INDICES>
1285
</TABLE>
20 jpm 1286
<TABLE ID="20854" Tablename="coel_structure_valorisation" PrevTableName="Table_12" XPos="713" YPos="1332" 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="37" >
16 jpm 1287
<COLUMNS>
20 jpm 1288
<COLUMN ID="20866" ColName="csv_id_structure" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la structure.">
16 jpm 1289
<OPTIONSELECTED>
1290
<OPTIONSELECT Value="1" />
1291
<OPTIONSELECT Value="0" />
1292
</OPTIONSELECTED>
1293
</COLUMN>
20 jpm 1294
<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 ?">
1295
<OPTIONSELECTED>
1296
</OPTIONSELECTED>
1297
</COLUMN>
1298
<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.">
1299
<OPTIONSELECTED>
1300
<OPTIONSELECT Value="0" />
1301
</OPTIONSELECTED>
1302
</COLUMN>
1303
<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, ... ?">
1304
<OPTIONSELECTED>
1305
</OPTIONSELECTED>
1306
</COLUMN>
1307
<COLUMN ID="20984" ColName="csv_collection_autre" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" 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?">
1308
<OPTIONSELECTED>
1309
<OPTIONSELECT Value="1" />
1310
<OPTIONSELECT Value="0" />
1311
</OPTIONSELECTED>
1312
</COLUMN>
1313
<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?">
1314
<OPTIONSELECTED>
1315
</OPTIONSELECTED>
1316
</COLUMN>
1317
<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.">
1318
<OPTIONSELECTED>
1319
<OPTIONSELECT Value="0" />
1320
</OPTIONSELECTED>
1321
</COLUMN>
1322
<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?">
1323
<OPTIONSELECTED>
1324
</OPTIONSELECTED>
1325
</COLUMN>
1326
<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?">
1327
<OPTIONSELECTED>
1328
<OPTIONSELECT Value="0" />
1329
</OPTIONSELECTED>
1330
</COLUMN>
1331
<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? ">
1332
<OPTIONSELECTED>
1333
<OPTIONSELECT Value="0" />
1334
</OPTIONSELECTED>
1335
</COLUMN>
1336
<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 ?">
1337
<OPTIONSELECTED>
1338
</OPTIONSELECTED>
1339
</COLUMN>
1340
<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?">
1341
<OPTIONSELECTED>
1342
<OPTIONSELECT Value="0" />
1343
</OPTIONSELECTED>
1344
</COLUMN>
1345
<COLUMN ID="20994" ColName="csv_mark_visite_ss_motif" PrevColName="" 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 dehors d\aobjectif de recherches scientifiques\194\160?">
1346
<OPTIONSELECTED>
1347
</OPTIONSELECTED>
1348
</COLUMN>
1349
<COLUMN ID="20995" ColName="csv_visite_ss_motif" PrevColName="" 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?">
1350
<OPTIONSELECTED>
1351
<OPTIONSELECT Value="0" />
1352
</OPTIONSELECTED>
1353
</COLUMN>
16 jpm 1354
</COLUMNS>
1355
<RELATIONS_END>
1356
<RELATION_END ID="20861" />
1357
</RELATIONS_END>
1358
<INDICES>
1359
<INDEX ID="20867" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1360
<INDEXCOLUMNS>
1361
<INDEXCOLUMN idColumn="20866" LengthParam="0" />
1362
</INDEXCOLUMNS>
1363
</INDEX>
1364
</INDICES>
1365
</TABLE>
20 jpm 1366
<TABLE ID="21104" Tablename="coel_collection_a_personne" PrevTableName="Table_14" XPos="399" YPos="1526" 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="5" >
1367
<COLUMNS>
1368
<COLUMN ID="21106" ColName="ccap_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection associ\195\169e \195\160 une personne.">
1369
<OPTIONSELECTED>
1370
<OPTIONSELECT Value="1" />
1371
<OPTIONSELECT Value="0" />
1372
</OPTIONSELECTED>
1373
</COLUMN>
1374
<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.">
1375
<OPTIONSELECTED>
1376
<OPTIONSELECT Value="1" />
1377
<OPTIONSELECT Value="0" />
1378
</OPTIONSELECTED>
1379
</COLUMN>
1380
<COLUMN ID="21139" ColName="ccap_ce_truk_role" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le(s) de la personne : auteur, collecteur...">
1381
<OPTIONSELECTED>
1382
<OPTIONSELECT Value="0" />
1383
</OPTIONSELECTED>
1384
</COLUMN>
1385
<COLUMN ID="21114" ColName="ccap_notes" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications. ">
1386
<OPTIONSELECTED>
1387
<OPTIONSELECT Value="0" />
1388
</OPTIONSELECTED>
1389
</COLUMN>
1390
<COLUMN ID="21115" ColName="ccap_date_derniere_modif" PrevColName="" Pos="3" idDatatype="15" 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. ">
1391
<OPTIONSELECTED>
1392
</OPTIONSELECTED>
1393
</COLUMN>
1394
<COLUMN ID="21116" ColName="ccap_ce_modifier_par" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.">
1395
<OPTIONSELECTED>
1396
<OPTIONSELECT Value="1" />
1397
<OPTIONSELECT Value="0" />
1398
</OPTIONSELECTED>
1399
</COLUMN>
1400
<COLUMN ID="21117" ColName="ccap_ce_etat" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de cet enregistrement.">
1401
<OPTIONSELECTED>
1402
<OPTIONSELECT Value="1" />
1403
<OPTIONSELECT Value="0" />
1404
</OPTIONSELECTED>
1405
</COLUMN>
1406
</COLUMNS>
1407
<RELATIONS_END>
1408
<RELATION_END ID="21108" />
1409
<RELATION_END ID="21110" />
1410
<RELATION_END ID="21118" />
1411
</RELATIONS_END>
1412
<INDICES>
1413
<INDEX ID="21107" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1414
<INDEXCOLUMNS>
1415
<INDEXCOLUMN idColumn="21106" LengthParam="0" />
1416
<INDEXCOLUMN idColumn="21112" LengthParam="0" />
1417
</INDEXCOLUMNS>
1418
</INDEX>
1419
</INDICES>
1420
</TABLE>
1421
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="417" YPos="1260" 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="39" >
1422
<COLUMNS>
1423
<COLUMN ID="21150" ColName="ccb_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection botanique.">
1424
<OPTIONSELECTED>
1425
<OPTIONSELECT Value="1" />
1426
<OPTIONSELECT Value="0" />
1427
</OPTIONSELECTED>
1428
</COLUMN>
1429
<COLUMN ID="21156" ColName="ccb_ce_truk_type" PrevColName="ccb_ce_type" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) pr\195\169cis de collection botanique.">
1430
<OPTIONSELECTED>
1431
<OPTIONSELECT Value="1" />
1432
<OPTIONSELECT Value="0" />
1433
</OPTIONSELECTED>
1434
</COLUMN>
1435
</COLUMNS>
1436
<RELATIONS_END>
1437
<RELATION_END ID="21152" />
1438
</RELATIONS_END>
1439
<INDICES>
1440
<INDEX ID="21151" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1441
<INDEXCOLUMNS>
1442
<INDEXCOLUMN idColumn="21150" LengthParam="0" />
1443
</INDEXCOLUMNS>
1444
</INDEX>
1445
</INDICES>
1446
</TABLE>
1447
<TABLE ID="21188" Tablename="coel_publication" PrevTableName="Table_15" XPos="56" YPos="1729" 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." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" >
1448
<COLUMNS>
1449
<COLUMN ID="21190" ColName="cpu_id_publication" PrevColName="cp_id_publication" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant de la publication.">
1450
<OPTIONSELECTED>
1451
<OPTIONSELECT Value="1" />
1452
<OPTIONSELECT Value="0" />
1453
</OPTIONSELECTED>
1454
</COLUMN>
1455
<COLUMN ID="21196" ColName="cpu_ce_auteur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant de la personne auteur de cette publication.">
1456
<OPTIONSELECTED>
1457
<OPTIONSELECT Value="1" />
1458
<OPTIONSELECT Value="0" />
1459
</OPTIONSELECTED>
1460
</COLUMN>
1461
<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...">
1462
<OPTIONSELECTED>
1463
<OPTIONSELECT Value="0" />
1464
</OPTIONSELECTED>
1465
</COLUMN>
1466
<COLUMN ID="21205" ColName="cpu_truk_auteur" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient le nom de la personne (= auteur) s\ail n\aest pas renseign\195\169e par cpu_ce_auteur. Si cpu_ce_auteur est diff\195\169rent de 0 alors il contient le nom complet de la personne.">
1467
<OPTIONSELECTED>
1468
<OPTIONSELECT Value="0" />
1469
</OPTIONSELECTED>
1470
</COLUMN>
1471
<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.">
1472
<OPTIONSELECTED>
1473
<OPTIONSELECT Value="0" />
1474
</OPTIONSELECTED>
1475
</COLUMN>
1476
<COLUMN ID="21198" ColName="cpu_intitule_collection" PrevColName="" 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.">
1477
<OPTIONSELECTED>
1478
<OPTIONSELECT Value="0" />
1479
</OPTIONSELECTED>
1480
</COLUMN>
1481
<COLUMN ID="21203" ColName="cpu_ce_editeur" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Identifiant de la structure \195\169ditrice.">
1482
<OPTIONSELECTED>
1483
<OPTIONSELECT Value="1" />
1484
<OPTIONSELECT Value="0" />
1485
</OPTIONSELECTED>
1486
</COLUMN>
1487
<COLUMN ID="21204" ColName="cpu_truk_editeur" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient le nom de l\a\195\169diteur s\ail n\aest pas renseign\195\169e par cpu_ce_editeur. Si cpu_ce_editeur est diff\195\169rent de 0 alors il contient le nom complet de la structure \195\169ditrice.">
1488
<OPTIONSELECTED>
1489
<OPTIONSELECT Value="0" />
1490
</OPTIONSELECTED>
1491
</COLUMN>
1492
<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.">
1493
<OPTIONSELECTED>
1494
</OPTIONSELECTED>
1495
</COLUMN>
1496
<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.">
1497
<OPTIONSELECTED>
1498
<OPTIONSELECT Value="0" />
1499
</OPTIONSELECTED>
1500
</COLUMN>
1501
<COLUMN ID="21212" ColName="cpu_titre_fascicule" PrevColName="" 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.">
1502
<OPTIONSELECTED>
1503
<OPTIONSELECT Value="0" />
1504
</OPTIONSELECTED>
1505
</COLUMN>
1506
<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.">
1507
<OPTIONSELECTED>
1508
<OPTIONSELECT Value="0" />
1509
</OPTIONSELECTED>
1510
</COLUMN>
1511
<COLUMN ID="21214" ColName="cpu_notes" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications. ">
1512
<OPTIONSELECTED>
1513
<OPTIONSELECT Value="0" />
1514
</OPTIONSELECTED>
1515
</COLUMN>
1516
<COLUMN ID="21215" ColName="cpu_date_derniere_modif" PrevColName="" Pos="12" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de la derni\195\168re modification sur cet enregistrement. ">
1517
<OPTIONSELECTED>
1518
<OPTIONSELECT Value="1" />
1519
<OPTIONSELECT Value="0" />
1520
</OPTIONSELECTED>
1521
</COLUMN>
1522
<COLUMN ID="21216" ColName="cpu_ce_modifier_par" PrevColName="" Pos="13" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.">
1523
<OPTIONSELECTED>
1524
<OPTIONSELECT Value="1" />
1525
<OPTIONSELECT Value="0" />
1526
</OPTIONSELECTED>
1527
</COLUMN>
1528
<COLUMN ID="21217" ColName="cpu_ce_etat" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de cet enregistrement. ">
1529
<OPTIONSELECTED>
1530
<OPTIONSELECT Value="1" />
1531
<OPTIONSELECT Value="0" />
1532
</OPTIONSELECTED>
1533
</COLUMN>
1534
</COLUMNS>
1535
<RELATIONS_START>
1536
<RELATION_START ID="21226" />
1537
<RELATION_START ID="21241" />
1538
</RELATIONS_START>
1539
<RELATIONS_END>
1540
<RELATION_END ID="21194" />
1541
<RELATION_END ID="21254" />
1542
</RELATIONS_END>
1543
<INDICES>
1544
<INDEX ID="21191" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1545
<INDEXCOLUMNS>
1546
<INDEXCOLUMN idColumn="21190" LengthParam="0" />
1547
</INDEXCOLUMNS>
1548
</INDEX>
1549
</INDICES>
1550
</TABLE>
1551
<TABLE ID="21219" Tablename="coel_collection_a_publication" PrevTableName="Table_16" XPos="55" YPos="1528" 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="45" >
1552
<COLUMNS>
1553
<COLUMN ID="21225" ColName="ccapu_id_collection" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
1554
<OPTIONSELECTED>
1555
<OPTIONSELECT Value="1" />
1556
<OPTIONSELECT Value="0" />
1557
</OPTIONSELECTED>
1558
</COLUMN>
1559
<COLUMN ID="21244" ColName="ccapu_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
1560
<OPTIONSELECTED>
1561
<OPTIONSELECT Value="1" />
1562
<OPTIONSELECT Value="0" />
1563
</OPTIONSELECTED>
1564
</COLUMN>
1565
<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.">
1566
<OPTIONSELECTED>
1567
</OPTIONSELECTED>
1568
</COLUMN>
1569
<COLUMN ID="21231" ColName="ccapu_notes" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
1570
<OPTIONSELECTED>
1571
<OPTIONSELECT Value="0" />
1572
</OPTIONSELECTED>
1573
</COLUMN>
1574
<COLUMN ID="21232" ColName="ccapu_date_derniere_modif" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
1575
<OPTIONSELECTED>
1576
</OPTIONSELECTED>
1577
</COLUMN>
1578
<COLUMN ID="21233" ColName="ccapu_ce_modifier_par" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
1579
<OPTIONSELECTED>
1580
<OPTIONSELECT Value="1" />
1581
<OPTIONSELECT Value="0" />
1582
</OPTIONSELECTED>
1583
</COLUMN>
1584
<COLUMN ID="21234" ColName="ccapu_ce_etat" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
1585
<OPTIONSELECTED>
1586
<OPTIONSELECT Value="1" />
1587
<OPTIONSELECT Value="0" />
1588
</OPTIONSELECTED>
1589
</COLUMN>
1590
</COLUMNS>
1591
<RELATIONS_END>
1592
<RELATION_END ID="21223" />
1593
<RELATION_END ID="21226" />
1594
</RELATIONS_END>
1595
<INDICES>
1596
<INDEX ID="21222" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1597
<INDEXCOLUMNS>
1598
<INDEXCOLUMN idColumn="21225" LengthParam="0" />
1599
<INDEXCOLUMN idColumn="21244" LengthParam="0" />
1600
</INDEXCOLUMNS>
1601
</INDEX>
1602
</INDICES>
1603
</TABLE>
1604
<TABLE ID="21235" Tablename="coel_personne_a_publication" PrevTableName="Table_17" XPos="1547" YPos="1493" 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="48" >
1605
<COLUMNS>
1606
<COLUMN ID="21237" ColName="cpap_id_personne" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne.">
1607
<OPTIONSELECTED>
1608
<OPTIONSELECT Value="1" />
1609
<OPTIONSELECT Value="0" />
1610
</OPTIONSELECTED>
1611
</COLUMN>
1612
<COLUMN ID="21243" ColName="cpap_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la publication.">
1613
<OPTIONSELECTED>
1614
<OPTIONSELECT Value="1" />
1615
<OPTIONSELECT Value="0" />
1616
</OPTIONSELECTED>
1617
</COLUMN>
1618
<COLUMN ID="21247" ColName="cpap_ce_truk_type" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient le type de r\195\169f\195\169rence bibliographique : n\195\169crologie, biographie, publication personnelle...">
1619
<OPTIONSELECTED>
1620
<OPTIONSELECT Value="0" />
1621
</OPTIONSELECTED>
1622
</COLUMN>
1623
<COLUMN ID="21248" ColName="cpap_notes" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications. ">
1624
<OPTIONSELECTED>
1625
<OPTIONSELECT Value="0" />
1626
</OPTIONSELECTED>
1627
</COLUMN>
1628
<COLUMN ID="21249" ColName="cpap_date_derniere_modif" PrevColName="" Pos="4" idDatatype="15" 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.">
1629
<OPTIONSELECTED>
1630
</OPTIONSELECTED>
1631
</COLUMN>
1632
<COLUMN ID="21250" ColName="cpap_ce_modifier_par" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement. ">
1633
<OPTIONSELECTED>
1634
<OPTIONSELECT Value="1" />
1635
<OPTIONSELECT Value="0" />
1636
</OPTIONSELECTED>
1637
</COLUMN>
1638
<COLUMN ID="21251" ColName="cpap_ce_etat" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de cet enregistrement.">
1639
<OPTIONSELECTED>
1640
<OPTIONSELECT Value="1" />
1641
<OPTIONSELECT Value="0" />
1642
</OPTIONSELECTED>
1643
</COLUMN>
1644
</COLUMNS>
1645
<RELATIONS_END>
1646
<RELATION_END ID="21239" />
1647
<RELATION_END ID="21241" />
1648
<RELATION_END ID="21252" />
1649
</RELATIONS_END>
1650
<INDICES>
1651
<INDEX ID="21238" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1652
<INDEXCOLUMNS>
1653
<INDEXCOLUMN idColumn="21237" LengthParam="0" />
1654
<INDEXCOLUMN idColumn="21243" LengthParam="0" />
1655
</INDEXCOLUMNS>
1656
</INDEX>
1657
</INDICES>
1658
</TABLE>
14 jpm 1659
</TABLES>
1660
<RELATIONS>
20 jpm 1661
<RELATION ID="18419" RelationName="fk_cs_csae" Kind="1" SrcTable="1445" DestTable="1447" FKFields="cs_id_structure=csae_id_structure\n" FKFieldsComments="Identifiant de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="2" CaptionOffsetY="-44" 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="10" />
1662
<RELATION ID="18425" RelationName="fk_cp_csae" Kind="1" SrcTable="1446" DestTable="1447" FKFields="cp_id_personne=csae_id_personne\n" FKFieldsComments="Identifiant de la personne constituant l\a\195\169quipe d\aun service d\aune structure.\n" relDirection="4" MidOffset="0" 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="11" />
1663
<RELATION ID="18470" RelationName="fk_cmc_cmd" Kind="2" SrcTable="18456" DestTable="18452" FKFields="cmc_id_caracteristique=cmd_ce_caracteristique\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-53" CaptionOffsetY="-24" 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" />
1664
<RELATION ID="18490" RelationName="fk_cmty_cmc" Kind="2" SrcTable="18462" DestTable="18456" FKFields="cmty_id_type=cmc_ce_type\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-62" CaptionOffsetY="-20" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="18492" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" />
1665
<RELATION ID="18494" RelationName="fk_cmc_cmv" Kind="2" SrcTable="18456" DestTable="18466" FKFields="cmc_id_caracteristique=cmv_ce_caracteristique\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-51" 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="18496" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" />
1666
<RELATION ID="18504" RelationName="fk_cmc_cmh" Kind="2" SrcTable="18456" DestTable="18498" FKFields="cmc_id_caracteristique=cmh_ce_caracteristique\n" FKFieldsComments="Identifiant de la caract\195\169ristique.\n" relDirection="2" MidOffset="0" 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="18523" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" />
1667
<RELATION ID="20806" RelationName="fk_cmt_cmd" Kind="2" SrcTable="18448" DestTable="18452" FKFields="cmt_id_table=cmd_ce_table\n" FKFieldsComments="\n" relDirection="4" MidOffset="25" 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="23" />
1668
<RELATION ID="20808" RelationName="fk_cmt_cmh" Kind="2" SrcTable="18448" DestTable="18498" FKFields="cmt_id_table=cmh_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="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="24" />
1669
<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="37" 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="25" />
1670
<RELATION ID="20819" RelationName="fk_cc_cc_parente" Kind="2" SrcTable="1444" DestTable="1444" FKFields="cc_id_collection=cc_ce_mere\n" FKFieldsComments="\n" relDirection="2" MidOffset="23" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-4" 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="26" />
1671
<RELATION ID="20828" RelationName="fk_cp_csae_modifier_par" Kind="2" SrcTable="1446" DestTable="1447" FKFields="cp_id_personne=csae_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.\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="27" />
1672
<RELATION ID="20830" RelationName="fk_cp_cs_modifier_par" Kind="2" SrcTable="1446" DestTable="1445" FKFields="cp_id_personne=cs_ce_modifier_par\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="28" />
1673
<RELATION ID="20834" RelationName="fk_cp_cp_modifier_par" Kind="2" SrcTable="1446" DestTable="1446" FKFields="cp_id_personne=cp_ce_modifier_par\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="29" />
1674
<RELATION ID="20842" RelationName="fk_cp_cc_modifier_par" Kind="2" SrcTable="1446" DestTable="1444" FKFields="cp_id_personne=cc_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.\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="30" />
1675
<RELATION ID="20844" RelationName="fk_cp_cmh_modifier_par" Kind="2" SrcTable="1446" DestTable="18498" FKFields="cp_id_personne=cmh_ce_modifier_par\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="31" />
1676
<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="38" />
1677
<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="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="39" />
1678
<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="3" MidOffset="5" 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="37" />
1679
<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="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="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="38" />
1680
<RELATION ID="21118" RelationName="fk_cp_ccap_modifier_par" Kind="2" SrcTable="1446" DestTable="21104" FKFields="cp_id_personne=ccap_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.\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="39" />
1681
<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="5" 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="40" />
1682
<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="42" />
1683
<RELATION ID="21194" RelationName="fk_cp_cpu" Kind="2" SrcTable="1446" DestTable="21188" FKFields="cp_id_personne=cpu_ce_auteur\n" FKFieldsComments="Identifiant de l\aauteur de la publication.\n" relDirection="4" 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="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="43" />
1684
<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="12" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="59" CaptionOffsetY="-19" 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="46" />
1685
<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="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="90" CaptionOffsetY="-13" 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="47" />
1686
<RELATION ID="21239" RelationName="fk_cp_cpap" Kind="1" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpap_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="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="49" />
1687
<RELATION ID="21241" RelationName="fk_cpu_cpap" Kind="1" SrcTable="21188" DestTable="21235" FKFields="cpu_id_publication=cpap_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="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="50" />
1688
<RELATION ID="21252" RelationName="fk_cp_cpap_modifier_par" Kind="2" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpap_ce_modifier_par\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="51" />
1689
<RELATION ID="21254" RelationName="fk_cp_cpu_modifier_par" Kind="2" SrcTable="1446" DestTable="21188" FKFields="cp_id_personne=cpu_ce_modifier_par\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="52" />
14 jpm 1690
</RELATIONS>
1691
<NOTES>
1692
</NOTES>
1693
<IMAGES>
1694
</IMAGES>
1695
</METADATA>
1696
<PLUGINDATA>
1697
<PLUGINDATARECORDS>
1698
</PLUGINDATARECORDS>
1699
</PLUGINDATA>
1700
<QUERYDATA>
1701
<QUERYRECORDS>
1702
</QUERYRECORDS>
1703
</QUERYDATA>
1704
<LINKEDMODELS>
1705
</LINKEDMODELS>
1706
</DBMODEL>