Subversion Repositories eFlore/Applications.coel

Rev

Rev 24 | Rev 26 | 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>
25 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="0" 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>
25 jpm 261
<REGION ID="21340" RegionName="Projet" XPos="28" YPos="504" Width="744" Height="410" RegionColor="5" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Projets.\nAbreviation : CPR\nAide : OK\nEtat: OK\nRevision : $Revision: 25 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" />
262
<REGION ID="21218" RegionName="Publication" XPos="24" YPos="2188" Width="744" Height="352" RegionColor="4" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Publications.\nAbreviation : CPU\nAide : OK\nEtat: OK\nRevision : $Revision: 25 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="60" />
263
<REGION ID="18447" RegionName="M\195\169tadonn\195\169es" XPos="20" YPos="16" Width="1528" Height="468" 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: 25 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" />
264
<REGION ID="18417" RegionName="Personne" XPos="784" YPos="512" Width="437" Height="973" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Personnes.\nAbreviation : CP\nAide : OK\nEtat: OK\nRevision : $Revision: 25 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" />
265
<REGION ID="18416" RegionName="Structure" XPos="785" YPos="1499" Width="720" Height="959" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Structures.\nAbreviation : CS\nAide : OK\nEtat: OK\nRevision : $Revision: 25 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" />
266
<REGION ID="1443" RegionName="Collection" XPos="28" YPos="924" Width="744" Height="1251" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Module de gestion des Collections.\nAbreviation : CC\nAide : OK\nEtat: OK\nRevision : $Revision: 25 $" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" />
14 jpm 267
</REGIONS>
268
<TABLES>
25 jpm 269
<TABLE ID="1444" Tablename="coel_collection" PrevTableName="Table_01" XPos="36" YPos="1152" 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="5" >
14 jpm 270
<COLUMNS>
20 jpm 271
<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 272
<OPTIONSELECTED>
273
<OPTIONSELECT Value="1" />
274
<OPTIONSELECT Value="0" />
275
</OPTIONSELECTED>
276
</COLUMN>
24 jpm 277
<COLUMN ID="21630" ColName="cc_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel les informations de la collection sont saisies.">
23 jpm 278
<OPTIONSELECTED>
279
<OPTIONSELECT Value="1" />
280
<OPTIONSELECT Value="0" />
281
</OPTIONSELECTED>
282
</COLUMN>
20 jpm 283
<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 284
<OPTIONSELECTED>
285
<OPTIONSELECT Value="1" />
286
<OPTIONSELECT Value="0" />
287
</OPTIONSELECTED>
288
</COLUMN>
20 jpm 289
<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 290
<OPTIONSELECTED>
291
<OPTIONSELECT Value="1" />
292
<OPTIONSELECT Value="0" />
293
</OPTIONSELECTED>
294
</COLUMN>
20 jpm 295
<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.">
296
<OPTIONSELECTED>
297
<OPTIONSELECT Value="0" />
298
</OPTIONSELECTED>
299
</COLUMN>
300
<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.">
301
<OPTIONSELECTED>
302
<OPTIONSELECT Value="0" />
303
</OPTIONSELECTED>
304
</COLUMN>
305
<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.">
306
<OPTIONSELECTED>
307
<OPTIONSELECT Value="0" />
308
</OPTIONSELECTED>
309
</COLUMN>
310
<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.">
311
<OPTIONSELECTED>
312
<OPTIONSELECT Value="0" />
313
</OPTIONSELECTED>
314
</COLUMN>
315
<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.">
316
<OPTIONSELECTED>
317
</OPTIONSELECTED>
318
</COLUMN>
319
<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.">
320
<OPTIONSELECTED>
321
</OPTIONSELECTED>
322
</COLUMN>
323
<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.">
324
<OPTIONSELECTED>
325
</OPTIONSELECTED>
326
</COLUMN>
327
<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 ...).">
328
<OPTIONSELECTED>
329
</OPTIONSELECTED>
330
</COLUMN>
331
<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.">
332
<OPTIONSELECTED>
333
<OPTIONSELECT Value="0" />
334
</OPTIONSELECTED>
335
</COLUMN>
336
<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.">
337
<OPTIONSELECTED>
338
<OPTIONSELECT Value="0" />
339
</OPTIONSELECTED>
340
</COLUMN>
341
<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.">
342
<OPTIONSELECTED>
343
<OPTIONSELECT Value="0" />
344
</OPTIONSELECTED>
345
</COLUMN>
346
<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.">
347
<OPTIONSELECTED>
348
<OPTIONSELECT Value="1" />
349
<OPTIONSELECT Value="0" />
350
</OPTIONSELECTED>
351
</COLUMN>
352
<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.">
353
<OPTIONSELECTED>
354
<OPTIONSELECT Value="1" />
355
<OPTIONSELECT Value="0" />
356
</OPTIONSELECTED>
357
</COLUMN>
358
<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.">
359
<OPTIONSELECTED>
360
<OPTIONSELECT Value="1" />
361
<OPTIONSELECT Value="0" />
362
</OPTIONSELECTED>
363
</COLUMN>
364
<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.">
365
<OPTIONSELECTED>
366
<OPTIONSELECT Value="0" />
367
</OPTIONSELECTED>
368
</COLUMN>
369
<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.">
370
<OPTIONSELECTED>
371
<OPTIONSELECT Value="0" />
372
</OPTIONSELECTED>
373
</COLUMN>
374
<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.">
375
<OPTIONSELECTED>
376
</OPTIONSELECTED>
377
</COLUMN>
378
<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.">
379
<OPTIONSELECTED>
380
</OPTIONSELECTED>
381
</COLUMN>
382
<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).">
383
<OPTIONSELECTED>
384
<OPTIONSELECT Value="0" />
385
</OPTIONSELECTED>
386
</COLUMN>
387
<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.">
388
<OPTIONSELECTED>
389
<OPTIONSELECT Value="0" />
390
</OPTIONSELECTED>
391
</COLUMN>
392
<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.">
393
<OPTIONSELECTED>
394
<OPTIONSELECT Value="0" />
395
</OPTIONSELECTED>
396
</COLUMN>
397
<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.">
398
<OPTIONSELECTED>
399
<OPTIONSELECT Value="0" />
400
</OPTIONSELECTED>
401
</COLUMN>
402
<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.">
403
<OPTIONSELECTED>
404
<OPTIONSELECT Value="0" />
405
</OPTIONSELECTED>
406
</COLUMN>
407
<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.">
408
<OPTIONSELECTED>
409
<OPTIONSELECT Value="0" />
410
</OPTIONSELECTED>
411
</COLUMN>
412
<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.">
413
<OPTIONSELECTED>
414
<OPTIONSELECT Value="0" />
415
</OPTIONSELECTED>
416
</COLUMN>
417
<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.">
418
<OPTIONSELECTED>
419
<OPTIONSELECT Value="0" />
420
</OPTIONSELECTED>
421
</COLUMN>
23 jpm 422
<COLUMN ID="21337" ColName="cc_truk_periode_constitution" PrevColName="cc_truk_periode_formation" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste de p\195\169riodes de temps durant laquelle la collection a \195\169t\195\169 assembl\195\169e.">
20 jpm 423
<OPTIONSELECTED>
424
<OPTIONSELECT Value="0" />
425
</OPTIONSELECTED>
426
</COLUMN>
23 jpm 427
<COLUMN ID="21338" ColName="cc_truk_couverture_lieu" PrevColName="" Pos="37" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Liste de lieux (continent, pays, region, d\195\169partement, commune, autres lieux historique ou texte libre) desquels le mat\195\169riel de la collection est originaire.">
20 jpm 428
<OPTIONSELECTED>
429
<OPTIONSELECT Value="0" />
430
</OPTIONSELECTED>
431
</COLUMN>
432
<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.">
433
<OPTIONSELECTED>
434
<OPTIONSELECT Value="0" />
435
</OPTIONSELECTED>
436
</COLUMN>
23 jpm 437
<COLUMN ID="21325" ColName="cc_ce_specimen_type" PrevColName="cc_mark_specimen_type" Pos="30" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Y-a-t\ail des \195\169chantillons-types?">
20 jpm 438
<OPTIONSELECTED>
23 jpm 439
<OPTIONSELECT Value="1" />
440
<OPTIONSELECT Value="0" />
20 jpm 441
</OPTIONSELECTED>
442
</COLUMN>
23 jpm 443
<COLUMN ID="21506" ColName="cc_specimen_type_nbre" PrevColName="" Pos="41" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nombre de sp\195\169cimen type pr\195\169sent dans la collection.">
444
<OPTIONSELECTED>
445
<OPTIONSELECT Value="1" />
446
<OPTIONSELECT Value="0" />
447
</OPTIONSELECTED>
448
</COLUMN>
449
<COLUMN ID="21507" ColName="cc_ce_speciment_type_nbre_precision" PrevColName="" Pos="41" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pr\195\169cision sur le nombre de sp\195\169cimens types indiqu\195\169 (exact, approximatif).">
450
<OPTIONSELECTED>
451
<OPTIONSELECT Value="1" />
452
<OPTIONSELECT Value="0" />
453
</OPTIONSELECTED>
454
</COLUMN>
455
<COLUMN ID="21508" ColName="cc_ce_specimen_type_classement" PrevColName="" Pos="42" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type de classement des specimens types.">
456
<OPTIONSELECTED>
457
<OPTIONSELECT Value="1" />
458
<OPTIONSELECT Value="0" />
459
</OPTIONSELECTED>
460
</COLUMN>
22 jpm 461
<COLUMN ID="21345" ColName="cc_expedition_nom" PrevColName="" Pos="39" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de l\aexp\195\169dition durant laquelle le mat\195\169riel a \195\169t\195\169 collect\195\169.">
462
<OPTIONSELECTED>
463
<OPTIONSELECT Value="0" />
464
</OPTIONSELECTED>
465
</COLUMN>
20 jpm 466
<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.">
467
<OPTIONSELECTED>
468
<OPTIONSELECT Value="0" />
469
</OPTIONSELECTED>
470
</COLUMN>
471
<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.">
472
<OPTIONSELECTED>
473
<OPTIONSELECT Value="0" />
474
</OPTIONSELECTED>
475
</COLUMN>
16 jpm 476
<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. ">
477
<OPTIONSELECTED>
478
<OPTIONSELECT Value="0" />
479
</OPTIONSELECTED>
480
</COLUMN>
481
<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.">
482
<OPTIONSELECTED>
483
</OPTIONSELECTED>
484
</COLUMN>
485
<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. ">
486
<OPTIONSELECTED>
487
<OPTIONSELECT Value="1" />
488
<OPTIONSELECT Value="0" />
489
</OPTIONSELECTED>
490
</COLUMN>
20 jpm 491
<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 492
<OPTIONSELECTED>
493
<OPTIONSELECT Value="1" />
494
<OPTIONSELECT Value="0" />
495
</OPTIONSELECTED>
496
</COLUMN>
14 jpm 497
</COLUMNS>
16 jpm 498
<RELATIONS_START>
499
<RELATION_START ID="20819" />
20 jpm 500
<RELATION_START ID="21108" />
501
<RELATION_START ID="21152" />
502
<RELATION_START ID="21223" />
23 jpm 503
<RELATION_START ID="21496" />
504
<RELATION_START ID="21498" />
16 jpm 505
</RELATIONS_START>
506
<RELATIONS_END>
507
<RELATION_END ID="20817" />
508
<RELATION_END ID="20819" />
509
<RELATION_END ID="20842" />
23 jpm 510
<RELATION_END ID="21628" />
16 jpm 511
</RELATIONS_END>
14 jpm 512
<INDICES>
513
<INDEX ID="1450" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
514
<INDEXCOLUMNS>
515
<INDEXCOLUMN idColumn="1449" LengthParam="0" />
516
</INDEXCOLUMNS>
517
</INDEX>
518
</INDICES>
519
</TABLE>
25 jpm 520
<TABLE ID="1445" Tablename="coel_structure" PrevTableName="Table_02" XPos="805" YPos="1523" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur les structures." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="37" >
14 jpm 521
<COLUMNS>
16 jpm 522
<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 523
<OPTIONSELECTED>
524
<OPTIONSELECT Value="1" />
525
<OPTIONSELECT Value="0" />
526
</OPTIONSELECTED>
527
</COLUMN>
24 jpm 528
<COLUMN ID="21627" ColName="cs_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel les informations de la structure sont saisies.">
23 jpm 529
<OPTIONSELECTED>
530
<OPTIONSELECT Value="1" />
531
<OPTIONSELECT Value="0" />
532
</OPTIONSELECTED>
533
</COLUMN>
24 jpm 534
<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="Identifiant de la structure m\195\168re.">
16 jpm 535
<OPTIONSELECTED>
536
<OPTIONSELECT Value="1" />
537
<OPTIONSELECT Value="0" />
538
</OPTIONSELECTED>
539
</COLUMN>
20 jpm 540
<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 541
<OPTIONSELECTED>
542
<OPTIONSELECT Value="0" />
543
</OPTIONSELECTED>
544
</COLUMN>
20 jpm 545
<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 546
<OPTIONSELECTED>
547
<OPTIONSELECT Value="0" />
548
</OPTIONSELECTED>
549
</COLUMN>
550
<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.">
551
<OPTIONSELECTED>
552
<OPTIONSELECT Value="0" />
553
</OPTIONSELECTED>
554
</COLUMN>
20 jpm 555
<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 556
<OPTIONSELECTED>
557
<OPTIONSELECT Value="0" />
558
</OPTIONSELECTED>
559
</COLUMN>
560
<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.">
561
<OPTIONSELECTED>
562
</OPTIONSELECTED>
563
</COLUMN>
20 jpm 564
<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 565
<OPTIONSELECTED>
20 jpm 566
<OPTIONSELECT Value="1" />
16 jpm 567
<OPTIONSELECT Value="0" />
568
</OPTIONSELECTED>
569
</COLUMN>
20 jpm 570
<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.">
571
<OPTIONSELECTED>
572
<OPTIONSELECT Value="1" />
573
<OPTIONSELECT Value="0" />
574
</OPTIONSELECTED>
575
</COLUMN>
576
<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.">
577
<OPTIONSELECTED>
578
<OPTIONSELECT Value="1" />
579
<OPTIONSELECT Value="0" />
580
</OPTIONSELECTED>
581
</COLUMN>
16 jpm 582
<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.">
583
<OPTIONSELECTED>
584
<OPTIONSELECT Value="0" />
585
</OPTIONSELECTED>
586
</COLUMN>
587
<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.">
588
<OPTIONSELECTED>
589
<OPTIONSELECT Value="0" />
590
</OPTIONSELECTED>
591
</COLUMN>
592
<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.">
593
<OPTIONSELECTED>
594
</OPTIONSELECTED>
595
</COLUMN>
596
<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.">
597
<OPTIONSELECTED>
598
<OPTIONSELECT Value="0" />
599
</OPTIONSELECTED>
600
</COLUMN>
601
<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.">
602
<OPTIONSELECTED>
603
<OPTIONSELECT Value="0" />
604
</OPTIONSELECTED>
605
</COLUMN>
606
<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.">
607
<OPTIONSELECTED>
608
<OPTIONSELECT Value="0" />
609
</OPTIONSELECTED>
610
</COLUMN>
611
<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.">
612
<OPTIONSELECTED>
613
<OPTIONSELECT Value="0" />
614
</OPTIONSELECTED>
615
</COLUMN>
616
<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.">
617
<OPTIONSELECTED>
618
<OPTIONSELECT Value="0" />
619
</OPTIONSELECTED>
620
</COLUMN>
621
<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.">
622
<OPTIONSELECTED>
623
<OPTIONSELECT Value="0" />
624
</OPTIONSELECTED>
625
</COLUMN>
20 jpm 626
<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 627
<OPTIONSELECTED>
628
<OPTIONSELECT Value="0" />
629
</OPTIONSELECTED>
630
</COLUMN>
20 jpm 631
<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.">
632
<OPTIONSELECTED>
633
<OPTIONSELECT Value="0" />
634
</OPTIONSELECTED>
635
</COLUMN>
16 jpm 636
<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.">
637
<OPTIONSELECTED>
638
<OPTIONSELECT Value="1" />
639
<OPTIONSELECT Value="0" />
640
</OPTIONSELECTED>
641
</COLUMN>
20 jpm 642
<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.">
643
<OPTIONSELECTED>
644
</OPTIONSELECTED>
645
</COLUMN>
646
<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.">
647
<OPTIONSELECTED>
648
</OPTIONSELECTED>
649
</COLUMN>
16 jpm 650
<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.">
651
<OPTIONSELECTED>
652
<OPTIONSELECT Value="0" />
653
</OPTIONSELECTED>
654
</COLUMN>
655
<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.">
656
<OPTIONSELECTED>
657
</OPTIONSELECTED>
658
</COLUMN>
659
<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. ">
660
<OPTIONSELECTED>
661
<OPTIONSELECT Value="1" />
662
<OPTIONSELECT Value="0" />
663
</OPTIONSELECTED>
664
</COLUMN>
665
<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. ">
666
<OPTIONSELECTED>
667
<OPTIONSELECT Value="1" />
668
<OPTIONSELECT Value="0" />
669
</OPTIONSELECTED>
670
</COLUMN>
14 jpm 671
</COLUMNS>
672
<RELATIONS_START>
673
<RELATION_START ID="18419" />
16 jpm 674
<RELATION_START ID="20817" />
675
<RELATION_START ID="20859" />
676
<RELATION_START ID="20861" />
20 jpm 677
<RELATION_START ID="21163" />
23 jpm 678
<RELATION_START ID="21616" />
14 jpm 679
</RELATIONS_START>
16 jpm 680
<RELATIONS_END>
681
<RELATION_END ID="20830" />
20 jpm 682
<RELATION_END ID="21163" />
23 jpm 683
<RELATION_END ID="21625" />
16 jpm 684
</RELATIONS_END>
14 jpm 685
<INDICES>
686
<INDEX ID="18412" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
687
<INDEXCOLUMNS>
688
<INDEXCOLUMN idColumn="18411" LengthParam="0" />
689
</INDEXCOLUMNS>
690
</INDEX>
691
</INDICES>
692
</TABLE>
25 jpm 693
<TABLE ID="1446" Tablename="coel_personne" PrevTableName="Table_03" XPos="848" YPos="820" 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="64" >
14 jpm 694
<COLUMNS>
695
<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.">
696
<OPTIONSELECTED>
697
<OPTIONSELECT Value="1" />
698
<OPTIONSELECT Value="0" />
699
</OPTIONSELECTED>
700
</COLUMN>
24 jpm 701
<COLUMN ID="21624" ColName="cp_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet auquel la personne appartient. Exemple : utilisateur appli coel, HUH, IPNI...">
23 jpm 702
<OPTIONSELECTED>
703
<OPTIONSELECT Value="1" />
704
<OPTIONSELECT Value="0" />
705
</OPTIONSELECTED>
706
</COLUMN>
20 jpm 707
<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 708
<OPTIONSELECTED>
709
<OPTIONSELECT Value="0" />
710
</OPTIONSELECTED>
711
</COLUMN>
20 jpm 712
<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 713
<OPTIONSELECTED>
714
<OPTIONSELECT Value="0" />
715
</OPTIONSELECTED>
716
</COLUMN>
20 jpm 717
<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 718
<OPTIONSELECTED>
719
<OPTIONSELECT Value="0" />
720
</OPTIONSELECTED>
721
</COLUMN>
20 jpm 722
<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 723
<OPTIONSELECTED>
724
<OPTIONSELECT Value="0" />
725
</OPTIONSELECTED>
726
</COLUMN>
20 jpm 727
<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 728
<OPTIONSELECTED>
729
<OPTIONSELECT Value="0" />
730
</OPTIONSELECTED>
731
</COLUMN>
20 jpm 732
<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 733
<OPTIONSELECTED>
734
<OPTIONSELECT Value="0" />
735
</OPTIONSELECTED>
736
</COLUMN>
20 jpm 737
<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 738
<OPTIONSELECTED>
739
<OPTIONSELECT Value="0" />
740
</OPTIONSELECTED>
741
</COLUMN>
20 jpm 742
<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 743
<OPTIONSELECTED>
744
<OPTIONSELECT Value="0" />
745
</OPTIONSELECTED>
746
</COLUMN>
20 jpm 747
<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 748
<OPTIONSELECTED>
20 jpm 749
</OPTIONSELECTED>
750
</COLUMN>
751
<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">
752
<OPTIONSELECTED>
14 jpm 753
<OPTIONSELECT Value="0" />
754
</OPTIONSELECTED>
755
</COLUMN>
20 jpm 756
<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">
757
<OPTIONSELECTED>
758
</OPTIONSELECTED>
759
</COLUMN>
760
<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.">
761
<OPTIONSELECTED>
762
<OPTIONSELECT Value="0" />
763
</OPTIONSELECTED>
764
</COLUMN>
765
<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.">
766
<OPTIONSELECTED>
767
</OPTIONSELECTED>
768
</COLUMN>
16 jpm 769
<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 770
<OPTIONSELECTED>
771
<OPTIONSELECT Value="0" />
772
</OPTIONSELECTED>
773
</COLUMN>
16 jpm 774
<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 775
<OPTIONSELECTED>
776
<OPTIONSELECT Value="0" />
777
</OPTIONSELECTED>
778
</COLUMN>
16 jpm 779
<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 780
<OPTIONSELECTED>
781
<OPTIONSELECT Value="0" />
782
</OPTIONSELECTED>
783
</COLUMN>
16 jpm 784
<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 785
<OPTIONSELECTED>
786
<OPTIONSELECT Value="0" />
787
</OPTIONSELECTED>
788
</COLUMN>
16 jpm 789
<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 790
<OPTIONSELECTED>
791
<OPTIONSELECT Value="0" />
792
</OPTIONSELECTED>
793
</COLUMN>
16 jpm 794
<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 795
<OPTIONSELECTED>
796
<OPTIONSELECT Value="0" />
797
</OPTIONSELECTED>
798
</COLUMN>
16 jpm 799
<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 800
<OPTIONSELECTED>
801
<OPTIONSELECT Value="0" />
802
</OPTIONSELECTED>
803
</COLUMN>
20 jpm 804
<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 805
<OPTIONSELECTED>
806
<OPTIONSELECT Value="0" />
807
</OPTIONSELECTED>
808
</COLUMN>
20 jpm 809
<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 810
<OPTIONSELECTED>
811
<OPTIONSELECT Value="0" />
812
</OPTIONSELECTED>
813
</COLUMN>
20 jpm 814
<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 815
<OPTIONSELECTED>
816
<OPTIONSELECT Value="0" />
817
</OPTIONSELECTED>
818
</COLUMN>
20 jpm 819
<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 820
<OPTIONSELECTED>
821
<OPTIONSELECT Value="0" />
822
</OPTIONSELECTED>
823
</COLUMN>
20 jpm 824
<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 825
<OPTIONSELECTED>
826
<OPTIONSELECT Value="0" />
827
</OPTIONSELECTED>
828
</COLUMN>
20 jpm 829
<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 830
<OPTIONSELECTED>
831
<OPTIONSELECT Value="0" />
832
</OPTIONSELECTED>
833
</COLUMN>
20 jpm 834
<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 835
<OPTIONSELECTED>
836
<OPTIONSELECT Value="0" />
837
</OPTIONSELECTED>
838
</COLUMN>
23 jpm 839
<COLUMN ID="21554" ColName="cp_ce_truk_role" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le g\195\169n\195\169rale de la personne vis \195\160 vis de l\aensemble des projets : superadmin, admin...">
840
<OPTIONSELECTED>
841
<OPTIONSELECT Value="0" />
842
</OPTIONSELECTED>
843
</COLUMN>
20 jpm 844
<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 845
<OPTIONSELECTED>
20 jpm 846
</OPTIONSELECTED>
847
</COLUMN>
848
<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.">
849
<OPTIONSELECTED>
14 jpm 850
<OPTIONSELECT Value="0" />
851
</OPTIONSELECTED>
852
</COLUMN>
20 jpm 853
<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 854
<OPTIONSELECTED>
855
<OPTIONSELECT Value="0" />
856
</OPTIONSELECTED>
857
</COLUMN>
16 jpm 858
<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 859
<OPTIONSELECTED>
860
<OPTIONSELECT Value="0" />
861
</OPTIONSELECTED>
862
</COLUMN>
20 jpm 863
<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 864
<OPTIONSELECTED>
16 jpm 865
</OPTIONSELECTED>
866
</COLUMN>
867
<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.">
868
<OPTIONSELECTED>
869
<OPTIONSELECT Value="1" />
14 jpm 870
<OPTIONSELECT Value="0" />
871
</OPTIONSELECTED>
872
</COLUMN>
16 jpm 873
<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 874
<OPTIONSELECTED>
875
<OPTIONSELECT Value="1" />
876
<OPTIONSELECT Value="0" />
877
</OPTIONSELECTED>
878
</COLUMN>
16 jpm 879
</COLUMNS>
880
<RELATIONS_START>
881
<RELATION_START ID="18425" />
882
<RELATION_START ID="20828" />
883
<RELATION_START ID="20830" />
884
<RELATION_START ID="20834" />
885
<RELATION_START ID="20842" />
886
<RELATION_START ID="20844" />
20 jpm 887
<RELATION_START ID="21110" />
888
<RELATION_START ID="21118" />
889
<RELATION_START ID="21239" />
890
<RELATION_START ID="21252" />
891
<RELATION_START ID="21254" />
23 jpm 892
<RELATION_START ID="21563" />
24 jpm 893
<RELATION_START ID="21666" />
25 jpm 894
<RELATION_START ID="21742" />
895
<RELATION_START ID="21744" />
896
<RELATION_START ID="21746" />
897
<RELATION_START ID="21747" />
898
<RELATION_START ID="21749" />
16 jpm 899
</RELATIONS_START>
900
<RELATIONS_END>
901
<RELATION_END ID="20834" />
23 jpm 902
<RELATION_END ID="21622" />
16 jpm 903
</RELATIONS_END>
904
<INDICES>
905
<INDEX ID="1457" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
906
<INDEXCOLUMNS>
907
<INDEXCOLUMN idColumn="1456" LengthParam="0" />
908
</INDEXCOLUMNS>
909
</INDEX>
910
</INDICES>
911
</TABLE>
25 jpm 912
<TABLE ID="1447" Tablename="coel_structure_a_personne" PrevTableName="Table_04" XPos="1200" YPos="1646" 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="56" >
16 jpm 913
<COLUMNS>
24 jpm 914
<COLUMN ID="21568" ColName="csap_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 915
<OPTIONSELECTED>
916
<OPTIONSELECT Value="1" />
917
<OPTIONSELECT Value="0" />
918
</OPTIONSELECTED>
919
</COLUMN>
24 jpm 920
<COLUMN ID="21567" ColName="csap_id_personne" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune personne.">
14 jpm 921
<OPTIONSELECTED>
16 jpm 922
<OPTIONSELECT Value="1" />
14 jpm 923
<OPTIONSELECT Value="0" />
924
</OPTIONSELECTED>
925
</COLUMN>
23 jpm 926
<COLUMN ID="21609" ColName="cspa_id_role" PrevColName="" Pos="11" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le de la personne vis \195\160 vis de la structure.">
14 jpm 927
<OPTIONSELECTED>
23 jpm 928
<OPTIONSELECT Value="1" />
16 jpm 929
<OPTIONSELECT Value="0" />
14 jpm 930
</OPTIONSELECTED>
931
</COLUMN>
23 jpm 932
<COLUMN ID="18533" ColName="csap_ce_truk_fonction" PrevColName="csae_fonction" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la fonction de la personne dans son travail.">
14 jpm 933
<OPTIONSELECTED>
16 jpm 934
<OPTIONSELECT Value="0" />
935
</OPTIONSELECTED>
936
</COLUMN>
23 jpm 937
<COLUMN ID="18534" ColName="csap_service" PrevColName="csae_service" Pos="8" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du service ou d\195\169partement dans lequel la personne travaille.">
16 jpm 938
<OPTIONSELECTED>
939
<OPTIONSELECT Value="0" />
940
</OPTIONSELECTED>
941
</COLUMN>
23 jpm 942
<COLUMN ID="18537" ColName="csap_ce_truk_statut" PrevColName="csae_statut" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Statut(s) de la personne : salari\195\169, b\195\169n\195\169vole...">
16 jpm 943
<OPTIONSELECTED>
23 jpm 944
<OPTIONSELECT Value="0" />
16 jpm 945
</OPTIONSELECTED>
946
</COLUMN>
23 jpm 947
<COLUMN ID="18433" ColName="csap_mark_contact" PrevColName="csae_bool_contact" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Si la personne est un contact la valeur vaut 1 sinon c\aest 0.">
16 jpm 948
<OPTIONSELECTED>
23 jpm 949
</OPTIONSELECTED>
950
</COLUMN>
951
<COLUMN ID="18546" ColName="csap_bota_travail_hebdo_tps" PrevColName="csae_bota_travail_hebdo_tps" 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.">
952
<OPTIONSELECTED>
14 jpm 953
<OPTIONSELECT Value="1" />
954
<OPTIONSELECT Value="0" />
955
</OPTIONSELECTED>
956
</COLUMN>
23 jpm 957
<COLUMN ID="18441" ColName="csap_notes" PrevColName="csae_notes" 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 958
<OPTIONSELECTED>
16 jpm 959
<OPTIONSELECT Value="0" />
960
</OPTIONSELECTED>
961
</COLUMN>
23 jpm 962
<COLUMN ID="18442" ColName="csap_date_derniere_modif" PrevColName="csae_date_derniere_modif" 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.">
16 jpm 963
<OPTIONSELECTED>
964
</OPTIONSELECTED>
965
</COLUMN>
24 jpm 966
<COLUMN ID="21569" ColName="csap_ce_modifier_par" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" 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.">
16 jpm 967
<OPTIONSELECTED>
14 jpm 968
<OPTIONSELECT Value="1" />
969
<OPTIONSELECT Value="0" />
970
</OPTIONSELECTED>
971
</COLUMN>
23 jpm 972
<COLUMN ID="18444" ColName="csap_ce_etat" PrevColName="csae_ce_etat" 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.">
16 jpm 973
<OPTIONSELECTED>
974
<OPTIONSELECT Value="1" />
975
<OPTIONSELECT Value="0" />
976
</OPTIONSELECTED>
977
</COLUMN>
14 jpm 978
</COLUMNS>
16 jpm 979
<RELATIONS_END>
980
<RELATION_END ID="18419" />
981
<RELATION_END ID="18425" />
982
<RELATION_END ID="20828" />
983
</RELATIONS_END>
984
<INDICES>
985
<INDEX ID="20888" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
986
<INDEXCOLUMNS>
23 jpm 987
<INDEXCOLUMN idColumn="21568" LengthParam="0" />
988
<INDEXCOLUMN idColumn="21567" LengthParam="0" />
989
<INDEXCOLUMN idColumn="21609" LengthParam="0" />
16 jpm 990
</INDEXCOLUMNS>
991
</INDEX>
992
</INDICES>
993
</TABLE>
25 jpm 994
<TABLE ID="18448" Tablename="coel_meta_table" PrevTableName="Table_05" XPos="815" YPos="37" 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="23" >
16 jpm 995
<COLUMNS>
25 jpm 996
<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="Identifiant de la table">
16 jpm 997
<OPTIONSELECTED>
998
<OPTIONSELECT Value="1" />
999
<OPTIONSELECT Value="0" />
1000
</OPTIONSELECTED>
1001
</COLUMN>
25 jpm 1002
<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="Nom del a table.">
16 jpm 1003
<OPTIONSELECTED>
1004
<OPTIONSELECT Value="0" />
1005
</OPTIONSELECTED>
1006
</COLUMN>
25 jpm 1007
<COLUMN ID="21735" ColName="cmt_abreviation" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abreviation de la table.">
1008
<OPTIONSELECTED>
1009
<OPTIONSELECT Value="0" />
1010
</OPTIONSELECTED>
1011
</COLUMN>
1012
<COLUMN ID="21736" ColName="cmt_description" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description de la table.">
1013
<OPTIONSELECTED>
1014
<OPTIONSELECT Value="0" />
1015
</OPTIONSELECTED>
1016
</COLUMN>
16 jpm 1017
</COLUMNS>
14 jpm 1018
<RELATIONS_START>
16 jpm 1019
<RELATION_START ID="20806" />
1020
<RELATION_START ID="20808" />
25 jpm 1021
<RELATION_START ID="21737" />
14 jpm 1022
</RELATIONS_START>
1023
<INDICES>
16 jpm 1024
<INDEX ID="18451" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1025
<INDEXCOLUMNS>
16 jpm 1026
<INDEXCOLUMN idColumn="18450" LengthParam="0" />
14 jpm 1027
</INDEXCOLUMNS>
1028
</INDEX>
1029
</INDICES>
1030
</TABLE>
25 jpm 1031
<TABLE ID="18452" Tablename="coel_meta_donnee" PrevTableName="Table_06" XPos="418" YPos="287" 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="28" >
14 jpm 1032
<COLUMNS>
16 jpm 1033
<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 1034
<OPTIONSELECTED>
1035
<OPTIONSELECT Value="1" />
1036
<OPTIONSELECT Value="0" />
1037
</OPTIONSELECTED>
1038
</COLUMN>
16 jpm 1039
<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 1040
<OPTIONSELECTED>
1041
<OPTIONSELECT Value="1" />
1042
<OPTIONSELECT Value="0" />
1043
</OPTIONSELECTED>
1044
</COLUMN>
16 jpm 1045
<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 1046
<OPTIONSELECTED>
1047
<OPTIONSELECT Value="1" />
1048
<OPTIONSELECT Value="0" />
1049
</OPTIONSELECTED>
1050
</COLUMN>
16 jpm 1051
<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 1052
<OPTIONSELECTED>
16 jpm 1053
<OPTIONSELECT Value="1" />
1054
<OPTIONSELECT Value="0" />
14 jpm 1055
</OPTIONSELECTED>
1056
</COLUMN>
16 jpm 1057
<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 1058
<OPTIONSELECTED>
16 jpm 1059
<OPTIONSELECT Value="0" />
14 jpm 1060
</OPTIONSELECTED>
1061
</COLUMN>
16 jpm 1062
</COLUMNS>
1063
<RELATIONS_END>
1064
<RELATION_END ID="18470" />
1065
<RELATION_END ID="20806" />
1066
</RELATIONS_END>
1067
<INDICES>
1068
<INDEX ID="18455" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1069
<INDEXCOLUMNS>
1070
<INDEXCOLUMN idColumn="18454" LengthParam="0" />
1071
</INDEXCOLUMNS>
1072
</INDEX>
1073
</INDICES>
1074
</TABLE>
25 jpm 1075
<TABLE ID="18456" Tablename="coel_meta_caracteristique" PrevTableName="Table_07" XPos="431" YPos="69" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient l\aensemble des caract\195\169ristique de la base de donn\195\169es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" >
16 jpm 1076
<COLUMNS>
25 jpm 1077
<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, c\aest \195\160 dire le nom du champ dans la table.">
14 jpm 1078
<OPTIONSELECTED>
1079
<OPTIONSELECT Value="1" />
1080
<OPTIONSELECT Value="0" />
1081
</OPTIONSELECTED>
1082
</COLUMN>
25 jpm 1083
<COLUMN ID="21739" ColName="cmc_ce_table" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la table de la caract\195\169ristique.">
14 jpm 1084
<OPTIONSELECTED>
1085
<OPTIONSELECT Value="1" />
1086
<OPTIONSELECT Value="0" />
1087
</OPTIONSELECTED>
1088
</COLUMN>
25 jpm 1089
<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="Identifiant du type SQL du champ.">
16 jpm 1090
<OPTIONSELECTED>
25 jpm 1091
<OPTIONSELECT Value="1" />
16 jpm 1092
<OPTIONSELECT Value="0" />
1093
</OPTIONSELECTED>
1094
</COLUMN>
25 jpm 1095
<COLUMN ID="18503" ColName="cmc_nom" PrevColName="cmc_intitule" Pos="2" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la caract\195\169ristique.">
1096
<OPTIONSELECTED>
1097
<OPTIONSELECT Value="0" />
1098
</OPTIONSELECTED>
1099
</COLUMN>
1100
<COLUMN ID="21732" ColName="cmc_abreviation" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation de la caract\195\169ristique.">
1101
<OPTIONSELECTED>
1102
<OPTIONSELECT Value="0" />
1103
</OPTIONSELECTED>
1104
</COLUMN>
1105
<COLUMN ID="21733" ColName="cmc_description" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description de la caract\195\169ristique.">
1106
<OPTIONSELECTED>
1107
<OPTIONSELECT Value="0" />
1108
</OPTIONSELECTED>
1109
</COLUMN>
14 jpm 1110
</COLUMNS>
16 jpm 1111
<RELATIONS_START>
1112
<RELATION_START ID="18470" />
1113
<RELATION_START ID="18494" />
1114
<RELATION_START ID="18504" />
1115
</RELATIONS_START>
14 jpm 1116
<RELATIONS_END>
16 jpm 1117
<RELATION_END ID="18490" />
25 jpm 1118
<RELATION_END ID="21737" />
14 jpm 1119
</RELATIONS_END>
1120
<INDICES>
16 jpm 1121
<INDEX ID="18459" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1122
<INDEXCOLUMNS>
16 jpm 1123
<INDEXCOLUMN idColumn="18458" LengthParam="0" />
14 jpm 1124
</INDEXCOLUMNS>
1125
</INDEX>
16 jpm 1126
<INDEX ID="18492" IndexName="coel_meta_caracteristique_FKIndex1" IndexKind="1" FKRefDef_Obj_id="18490">
14 jpm 1127
<INDEXCOLUMNS>
16 jpm 1128
<INDEXCOLUMN idColumn="18493" LengthParam="0" />
14 jpm 1129
</INDEXCOLUMNS>
1130
</INDEX>
16 jpm 1131
</INDICES>
1132
</TABLE>
25 jpm 1133
<TABLE ID="18462" Tablename="coel_meta_type" PrevTableName="Table_08" XPos="100" YPos="53" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Liste l\aensemble des types de format de champs SQL." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" >
16 jpm 1134
<COLUMNS>
25 jpm 1135
<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="Identifiant du type de champ.">
16 jpm 1136
<OPTIONSELECTED>
1137
<OPTIONSELECT Value="1" />
1138
<OPTIONSELECT Value="0" />
1139
</OPTIONSELECTED>
1140
</COLUMN>
25 jpm 1141
<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="Type SQL du champ. Ex. : VARCHAR, INTEGER, BOOL...">
16 jpm 1142
<OPTIONSELECTED>
1143
<OPTIONSELECT Value="0" />
1144
</OPTIONSELECTED>
1145
</COLUMN>
25 jpm 1146
<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="Nombre entier indiquant la taille du type sql.">
16 jpm 1147
<OPTIONSELECTED>
1148
<OPTIONSELECT Value="1" />
1149
<OPTIONSELECT Value="0" />
1150
</OPTIONSELECTED>
1151
</COLUMN>
1152
</COLUMNS>
1153
<RELATIONS_START>
1154
<RELATION_START ID="18490" />
1155
</RELATIONS_START>
1156
<INDICES>
1157
<INDEX ID="18465" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
14 jpm 1158
<INDEXCOLUMNS>
16 jpm 1159
<INDEXCOLUMN idColumn="18464" LengthParam="0" />
14 jpm 1160
</INDEXCOLUMNS>
1161
</INDEX>
1162
</INDICES>
1163
</TABLE>
25 jpm 1164
<TABLE ID="18466" Tablename="coel_meta_valeur" PrevTableName="Table_09" XPos="34" YPos="173" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Liste l\aensemble des valeurs des tables de type liste." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" >
16 jpm 1165
<COLUMNS>
25 jpm 1166
<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="Identifiant de la valeur possible du champ.">
16 jpm 1167
<OPTIONSELECTED>
1168
<OPTIONSELECT Value="1" />
1169
<OPTIONSELECT Value="0" />
1170
</OPTIONSELECTED>
1171
</COLUMN>
25 jpm 1172
<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="Identifiant de la caract\195\169rique \195\160 laquelle cette valeur appartient.">
16 jpm 1173
<OPTIONSELECTED>
1174
<OPTIONSELECT Value="1" />
1175
<OPTIONSELECT Value="0" />
1176
</OPTIONSELECTED>
1177
</COLUMN>
25 jpm 1178
<COLUMN ID="21723" ColName="cmv_nom" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom de la valeur.">
1179
<OPTIONSELECTED>
1180
<OPTIONSELECT Value="0" />
1181
</OPTIONSELECTED>
1182
</COLUMN>
1183
<COLUMN ID="21724" ColName="cmv_abreviation" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation du nom de la valeur.">
1184
<OPTIONSELECTED>
1185
<OPTIONSELECT Value="0" />
1186
</OPTIONSELECTED>
1187
</COLUMN>
1188
<COLUMN ID="21725" ColName="cmv_description" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description de cette valeur.">
1189
<OPTIONSELECTED>
1190
<OPTIONSELECT Value="0" />
1191
</OPTIONSELECTED>
1192
</COLUMN>
16 jpm 1193
</COLUMNS>
1194
<RELATIONS_END>
1195
<RELATION_END ID="18494" />
1196
</RELATIONS_END>
1197
<INDICES>
1198
<INDEX ID="18469" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1199
<INDEXCOLUMNS>
1200
<INDEXCOLUMN idColumn="18468" LengthParam="0" />
1201
</INDEXCOLUMNS>
1202
</INDEX>
1203
<INDEX ID="18496" IndexName="coel_meta_valeur_FKIndex1" IndexKind="1" FKRefDef_Obj_id="18494">
1204
<INDEXCOLUMNS>
1205
<INDEXCOLUMN idColumn="18497" LengthParam="0" />
1206
</INDEXCOLUMNS>
1207
</INDEX>
1208
</INDICES>
1209
</TABLE>
25 jpm 1210
<TABLE ID="18498" Tablename="coel_meta_historisation" PrevTableName="Table_10" XPos="809" YPos="212" 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="36" >
16 jpm 1211
<COLUMNS>
1212
<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.">
1213
<OPTIONSELECTED>
1214
<OPTIONSELECT Value="1" />
1215
<OPTIONSELECT Value="0" />
1216
</OPTIONSELECTED>
1217
</COLUMN>
1218
<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="">
1219
<OPTIONSELECTED>
1220
<OPTIONSELECT Value="1" />
1221
<OPTIONSELECT Value="0" />
1222
</OPTIONSELECTED>
1223
</COLUMN>
1224
<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="">
1225
<OPTIONSELECTED>
1226
<OPTIONSELECT Value="1" />
1227
<OPTIONSELECT Value="0" />
1228
</OPTIONSELECTED>
1229
</COLUMN>
1230
<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.">
1231
<OPTIONSELECTED>
1232
<OPTIONSELECT Value="1" />
1233
<OPTIONSELECT Value="0" />
1234
</OPTIONSELECTED>
1235
</COLUMN>
1236
<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.">
1237
<OPTIONSELECTED>
1238
<OPTIONSELECT Value="0" />
1239
</OPTIONSELECTED>
1240
</COLUMN>
1241
<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.">
1242
<OPTIONSELECTED>
1243
</OPTIONSELECTED>
1244
</COLUMN>
25 jpm 1245
<COLUMN ID="18517" ColName="cmh_ce_etat" PrevColName="cmh_mode" Pos="7" idDatatype="5" DatatypeParams="(11)" 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.">
16 jpm 1246
<OPTIONSELECTED>
1247
<OPTIONSELECT Value="1" />
1248
<OPTIONSELECT Value="0" />
1249
</OPTIONSELECTED>
1250
</COLUMN>
25 jpm 1251
<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="">
16 jpm 1252
<OPTIONSELECTED>
25 jpm 1253
<OPTIONSELECT Value="1" />
16 jpm 1254
<OPTIONSELECT Value="0" />
1255
</OPTIONSELECTED>
1256
</COLUMN>
1257
<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.">
1258
<OPTIONSELECTED>
1259
<OPTIONSELECT Value="0" />
1260
</OPTIONSELECTED>
1261
</COLUMN>
25 jpm 1262
<COLUMN ID="21756" ColName="cmh_notes" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Notes sur la modification effectu\195\169e.">
1263
<OPTIONSELECTED>
1264
<OPTIONSELECT Value="0" />
1265
</OPTIONSELECTED>
1266
</COLUMN>
16 jpm 1267
</COLUMNS>
1268
<RELATIONS_END>
1269
<RELATION_END ID="18504" />
1270
<RELATION_END ID="20808" />
1271
<RELATION_END ID="20844" />
1272
</RELATIONS_END>
1273
<INDICES>
1274
<INDEX ID="18501" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1275
<INDEXCOLUMNS>
1276
<INDEXCOLUMN idColumn="18500" LengthParam="0" />
1277
</INDEXCOLUMNS>
1278
</INDEX>
1279
<INDEX ID="18523" IndexName="coel_meta_historisation_FKIndex1" IndexKind="1" FKRefDef_Obj_id="18504">
1280
<INDEXCOLUMNS>
1281
<INDEXCOLUMN idColumn="18526" LengthParam="0" />
1282
</INDEXCOLUMNS>
1283
</INDEX>
1284
</INDICES>
1285
</TABLE>
25 jpm 1286
<TABLE ID="20850" Tablename="coel_structure_conservation" PrevTableName="Table_11" XPos="1187" YPos="1938" 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="50" >
16 jpm 1287
<COLUMNS>
20 jpm 1288
<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 1289
<OPTIONSELECTED>
1290
<OPTIONSELECT Value="1" />
1291
<OPTIONSELECT Value="0" />
1292
</OPTIONSELECTED>
1293
</COLUMN>
1294
<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?">
1295
<OPTIONSELECTED>
1296
</OPTIONSELECTED>
1297
</COLUMN>
20 jpm 1298
<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 1299
<OPTIONSELECTED>
1300
<OPTIONSELECT Value="0" />
1301
</OPTIONSELECTED>
1302
</COLUMN>
1303
<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?">
1304
<OPTIONSELECTED>
1305
</OPTIONSELECTED>
1306
</COLUMN>
20 jpm 1307
<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 1308
<OPTIONSELECTED>
20 jpm 1309
<OPTIONSELECT Value="0" />
1310
</OPTIONSELECTED>
1311
</COLUMN>
1312
<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? ">
1313
<OPTIONSELECTED>
1314
<OPTIONSELECT Value="0" />
1315
</OPTIONSELECTED>
1316
</COLUMN>
1317
<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 ?">
1318
<OPTIONSELECTED>
1319
<OPTIONSELECT Value="0" />
1320
</OPTIONSELECTED>
1321
</COLUMN>
1322
<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) ? ">
1323
<OPTIONSELECTED>
1324
</OPTIONSELECTED>
1325
</COLUMN>
1326
<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?">
1327
<OPTIONSELECTED>
1328
<OPTIONSELECT Value="0" />
1329
</OPTIONSELECTED>
1330
</COLUMN>
1331
<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?">
1332
<OPTIONSELECTED>
1333
</OPTIONSELECTED>
1334
</COLUMN>
1335
<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?">
1336
<OPTIONSELECTED>
1337
</OPTIONSELECTED>
1338
</COLUMN>
1339
<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.">
1340
<OPTIONSELECTED>
1341
<OPTIONSELECT Value="0" />
1342
</OPTIONSELECTED>
1343
</COLUMN>
1344
<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 ?">
1345
<OPTIONSELECTED>
16 jpm 1346
<OPTIONSELECT Value="1" />
1347
<OPTIONSELECT Value="0" />
1348
</OPTIONSELECTED>
1349
</COLUMN>
20 jpm 1350
<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 1351
<OPTIONSELECTED>
1352
<OPTIONSELECT Value="0" />
1353
</OPTIONSELECTED>
1354
</COLUMN>
20 jpm 1355
<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?">
1356
<OPTIONSELECTED>
1357
</OPTIONSELECTED>
1358
</COLUMN>
1359
<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.">
1360
<OPTIONSELECTED>
1361
<OPTIONSELECT Value="0" />
1362
</OPTIONSELECTED>
1363
</COLUMN>
1364
<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?">
1365
<OPTIONSELECTED>
1366
</OPTIONSELECTED>
1367
</COLUMN>
1368
<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? ">
1369
<OPTIONSELECTED>
1370
</OPTIONSELECTED>
1371
</COLUMN>
1372
<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?">
1373
<OPTIONSELECTED>
1374
</OPTIONSELECTED>
1375
</COLUMN>
1376
<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.">
1377
<OPTIONSELECTED>
1378
<OPTIONSELECT Value="0" />
1379
</OPTIONSELECTED>
1380
</COLUMN>
1381
<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.">
1382
<OPTIONSELECTED>
1383
<OPTIONSELECT Value="0" />
1384
</OPTIONSELECTED>
1385
</COLUMN>
16 jpm 1386
</COLUMNS>
1387
<RELATIONS_END>
1388
<RELATION_END ID="20859" />
1389
</RELATIONS_END>
1390
<INDICES>
20 jpm 1391
<INDEX ID="20979" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
16 jpm 1392
<INDEXCOLUMNS>
20 jpm 1393
<INDEXCOLUMN idColumn="20978" LengthParam="0" />
16 jpm 1394
</INDEXCOLUMNS>
1395
</INDEX>
1396
</INDICES>
1397
</TABLE>
25 jpm 1398
<TABLE ID="20854" Tablename="coel_structure_valorisation" PrevTableName="Table_12" XPos="827" YPos="2139" 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="38" >
16 jpm 1399
<COLUMNS>
20 jpm 1400
<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 1401
<OPTIONSELECTED>
1402
<OPTIONSELECT Value="1" />
1403
<OPTIONSELECT Value="0" />
1404
</OPTIONSELECTED>
1405
</COLUMN>
20 jpm 1406
<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 ?">
1407
<OPTIONSELECTED>
1408
</OPTIONSELECTED>
1409
</COLUMN>
1410
<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.">
1411
<OPTIONSELECTED>
1412
<OPTIONSELECT Value="0" />
1413
</OPTIONSELECTED>
1414
</COLUMN>
1415
<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, ... ?">
1416
<OPTIONSELECTED>
1417
</OPTIONSELECTED>
1418
</COLUMN>
1419
<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?">
1420
<OPTIONSELECTED>
1421
<OPTIONSELECT Value="1" />
1422
<OPTIONSELECT Value="0" />
1423
</OPTIONSELECTED>
1424
</COLUMN>
1425
<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?">
1426
<OPTIONSELECTED>
1427
</OPTIONSELECTED>
1428
</COLUMN>
1429
<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.">
1430
<OPTIONSELECTED>
1431
<OPTIONSELECT Value="0" />
1432
</OPTIONSELECTED>
1433
</COLUMN>
1434
<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?">
1435
<OPTIONSELECTED>
1436
</OPTIONSELECTED>
1437
</COLUMN>
1438
<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?">
1439
<OPTIONSELECTED>
1440
<OPTIONSELECT Value="0" />
1441
</OPTIONSELECTED>
1442
</COLUMN>
1443
<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? ">
1444
<OPTIONSELECTED>
1445
<OPTIONSELECT Value="0" />
1446
</OPTIONSELECTED>
1447
</COLUMN>
1448
<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 ?">
1449
<OPTIONSELECTED>
1450
</OPTIONSELECTED>
1451
</COLUMN>
1452
<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?">
1453
<OPTIONSELECTED>
1454
<OPTIONSELECT Value="0" />
1455
</OPTIONSELECTED>
1456
</COLUMN>
1457
<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?">
1458
<OPTIONSELECTED>
1459
</OPTIONSELECTED>
1460
</COLUMN>
1461
<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?">
1462
<OPTIONSELECTED>
1463
<OPTIONSELECT Value="0" />
1464
</OPTIONSELECTED>
1465
</COLUMN>
16 jpm 1466
</COLUMNS>
1467
<RELATIONS_END>
1468
<RELATION_END ID="20861" />
1469
</RELATIONS_END>
1470
<INDICES>
1471
<INDEX ID="20867" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1472
<INDEXCOLUMNS>
1473
<INDEXCOLUMN idColumn="20866" LengthParam="0" />
1474
</INDEXCOLUMNS>
1475
</INDEX>
1476
</INDICES>
1477
</TABLE>
25 jpm 1478
<TABLE ID="21104" Tablename="coel_collection_a_personne" PrevTableName="Table_14" XPos="408" YPos="932" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Permet de lister les personnes en rapport avec une collection." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" >
20 jpm 1479
<COLUMNS>
23 jpm 1480
<COLUMN ID="21106" ColName="ccap_id_collection" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection associ\195\169e \195\160 une personne.">
20 jpm 1481
<OPTIONSELECTED>
1482
<OPTIONSELECT Value="1" />
1483
<OPTIONSELECT Value="0" />
1484
</OPTIONSELECTED>
1485
</COLUMN>
1486
<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.">
1487
<OPTIONSELECTED>
1488
<OPTIONSELECT Value="1" />
1489
<OPTIONSELECT Value="0" />
1490
</OPTIONSELECTED>
1491
</COLUMN>
23 jpm 1492
<COLUMN ID="21139" ColName="ccap_id_role" PrevColName="ccap_ce_truk_role" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le(s) de la personne : auteur, collecteur... permet aussi de conna\195\174tre qui a les droits de modification sur la collection.">
20 jpm 1493
<OPTIONSELECTED>
1494
<OPTIONSELECT Value="0" />
1495
</OPTIONSELECTED>
1496
</COLUMN>
1497
<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. ">
1498
<OPTIONSELECTED>
1499
<OPTIONSELECT Value="0" />
1500
</OPTIONSELECTED>
1501
</COLUMN>
1502
<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. ">
1503
<OPTIONSELECTED>
1504
</OPTIONSELECTED>
1505
</COLUMN>
1506
<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.">
1507
<OPTIONSELECTED>
1508
<OPTIONSELECT Value="1" />
1509
<OPTIONSELECT Value="0" />
1510
</OPTIONSELECTED>
1511
</COLUMN>
1512
<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.">
1513
<OPTIONSELECTED>
1514
<OPTIONSELECT Value="1" />
1515
<OPTIONSELECT Value="0" />
1516
</OPTIONSELECTED>
1517
</COLUMN>
1518
</COLUMNS>
1519
<RELATIONS_END>
1520
<RELATION_END ID="21108" />
1521
<RELATION_END ID="21110" />
1522
<RELATION_END ID="21118" />
1523
</RELATIONS_END>
1524
<INDICES>
1525
<INDEX ID="21107" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1526
<INDEXCOLUMNS>
1527
<INDEXCOLUMN idColumn="21106" LengthParam="0" />
1528
<INDEXCOLUMN idColumn="21112" LengthParam="0" />
23 jpm 1529
<INDEXCOLUMN idColumn="21139" LengthParam="0" />
20 jpm 1530
</INDEXCOLUMNS>
1531
</INDEX>
1532
</INDICES>
1533
</TABLE>
25 jpm 1534
<TABLE ID="21148" Tablename="coel_collection_botanique" PrevTableName="Table_14" XPos="421" YPos="1161" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Toutes les informations sp\195\169cialis\195\169es sur une collection de type : botanique" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
20 jpm 1535
<COLUMNS>
1536
<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.">
1537
<OPTIONSELECTED>
1538
<OPTIONSELECT Value="1" />
1539
<OPTIONSELECT Value="0" />
1540
</OPTIONSELECTED>
1541
</COLUMN>
1542
<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.">
1543
<OPTIONSELECTED>
1544
<OPTIONSELECT Value="1" />
1545
<OPTIONSELECT Value="0" />
1546
</OPTIONSELECTED>
1547
</COLUMN>
23 jpm 1548
<COLUMN ID="21343" ColName="ccb_truk_unite_rangement" PrevColName="ccb_truk" Pos="2" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) unit\195\169 de rangement de la collection botanique. \\\nPour chaque type : indication du nombre d\aunit\195\169, de la pr\195\169cision du nom (exact, approximatif), des formats.">
22 jpm 1549
<OPTIONSELECTED>
1550
<OPTIONSELECT Value="0" />
1551
</OPTIONSELECTED>
1552
</COLUMN>
1553
<COLUMN ID="21348" ColName="ccb_ce_unite_rangement_etat" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de la majorit\195\169 des unit\195\169s de rangements (\195\169tat des rubans, des poign\195\169es, des sangles, des cartons...).">
1554
<OPTIONSELECTED>
1555
<OPTIONSELECT Value="1" />
1556
<OPTIONSELECT Value="0" />
1557
</OPTIONSELECTED>
1558
</COLUMN>
23 jpm 1559
<COLUMN ID="21350" ColName="ccb_truk_unite_base" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(510)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) d\aunit\195\169 de base de la collection,\194\160 si diff\195\169rent de l\aunit\195\169 de rangement. \\\nEx. : si l\aunit\195\169 de rangement est un carton, l\aunit\195\169 de base peut \195\170tre  une enveloppe. \\\nPour chaque type : indication du nombre d\aunit\195\169, de la pr\195\169cision du nom (exact, approximatif), des formats, du nombre de parts, de la pr\195\169cision sur le nombre de parts  (exact, approximatif), du nombre d\aesp\195\168ces, de la pr\195\169cision sur le nombre d\aesp\195\168ces (exact, approximatif).">
22 jpm 1560
<OPTIONSELECTED>
1561
<OPTIONSELECT Value="0" />
1562
</OPTIONSELECTED>
1563
</COLUMN>
1564
<COLUMN ID="21355" ColName="ccb_truk_conservation_papier_type" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) du papier de conservation.">
1565
<OPTIONSELECTED>
1566
<OPTIONSELECT Value="0" />
1567
</OPTIONSELECTED>
1568
</COLUMN>
1569
<COLUMN ID="21356" ColName="ccb_truk_conservation_methode" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de m\195\169thode de conservation.">
1570
<OPTIONSELECTED>
1571
<OPTIONSELECT Value="0" />
1572
</OPTIONSELECTED>
1573
</COLUMN>
1574
<COLUMN ID="21357" ColName="ccb_specimen_fixation_pourcent" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage de sp\195\169cimens fix\195\169s.">
1575
<OPTIONSELECTED>
1576
<OPTIONSELECT Value="1" />
1577
<OPTIONSELECT Value="0" />
1578
</OPTIONSELECTED>
1579
</COLUMN>
1580
<COLUMN ID="21358" ColName="ccb_etiquette_fixation_pourcent" PrevColName="" Pos="8" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage d\a\195\169tiquettes fix\195\169es.">
1581
<OPTIONSELECTED>
1582
<OPTIONSELECT Value="1" />
1583
<OPTIONSELECT Value="0" />
1584
</OPTIONSELECTED>
1585
</COLUMN>
1586
<COLUMN ID="21359" ColName="ccb_truk_specimen_fixation_methode" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de fixation des sp\195\169cimens.">
1587
<OPTIONSELECTED>
1588
<OPTIONSELECT Value="0" />
1589
</OPTIONSELECTED>
1590
</COLUMN>
1591
<COLUMN ID="21361" ColName="ccb_truk_etiquette_fixation_support" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de fixation des \195\169tiquettes fix\195\169es au support.">
1592
<OPTIONSELECTED>
1593
<OPTIONSELECT Value="0" />
1594
</OPTIONSELECTED>
1595
</COLUMN>
1596
<COLUMN ID="21362" ColName="ccb_truk_etiquette_fixation_specimen" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de fixation des \195\169tiquettes fix\195\169es au sp\195\169cimen.">
1597
<OPTIONSELECTED>
1598
<OPTIONSELECT Value="0" />
1599
</OPTIONSELECTED>
1600
</COLUMN>
1601
<COLUMN ID="21364" ColName="ccb_truk_etiquette_ecriture" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) d\a\195\169criture sur les \195\169tiquettes.">
1602
<OPTIONSELECTED>
1603
<OPTIONSELECT Value="0" />
1604
</OPTIONSELECTED>
1605
</COLUMN>
1606
<COLUMN ID="21365" ColName="ccb_ce_traitement" PrevColName="" Pos="13" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="La collection botanique semble-t-elle avoir \195\169t\195\169 empoisonn\195\169e ou d\195\169sinsectis\195\169e lors de sa r\195\169alisation ?">
1607
<OPTIONSELECTED>
1608
<OPTIONSELECT Value="1" />
1609
<OPTIONSELECT Value="0" />
1610
</OPTIONSELECTED>
1611
</COLUMN>
1612
<COLUMN ID="21366" ColName="ccb_truk_traitement_poison" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) d\aempoisonement de la collection.">
1613
<OPTIONSELECTED>
1614
<OPTIONSELECT Value="0" />
1615
</OPTIONSELECTED>
1616
</COLUMN>
1617
<COLUMN ID="21367" ColName="ccb_truk_traitement_isecte" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de d\195\169sinctisation de la collection.">
1618
<OPTIONSELECTED>
1619
<OPTIONSELECT Value="0" />
1620
</OPTIONSELECTED>
1621
</COLUMN>
1622
<COLUMN ID="21368" ColName="ccb_ce_etat_general" PrevColName="" Pos="16" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat g\195\169n\195\169ral de la collection\194\160(grosses attaques d\ainsectes, pourriture, papier tr\195\168s fragile, etc... de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon \195\169tat).">
1623
<OPTIONSELECTED>
1624
<OPTIONSELECT Value="1" />
1625
<OPTIONSELECT Value="0" />
1626
</OPTIONSELECTED>
1627
</COLUMN>
1628
<COLUMN ID="21369" ColName="ccb_truk_degradation_specimen" PrevColName="" Pos="17" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de causes des d\195\169gradations des sp\195\169cimens not\195\169es de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon \195\169tat.">
1629
<OPTIONSELECTED>
1630
<OPTIONSELECT Value="0" />
1631
</OPTIONSELECTED>
1632
</COLUMN>
1633
<COLUMN ID="21370" ColName="ccb_truk_degradation_presentation" PrevColName="" Pos="18" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type(s) de causes des d\195\169gradations de la pr\195\169sentation not\195\169es de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon \195\169tat.">
1634
<OPTIONSELECTED>
1635
<OPTIONSELECT Value="0" />
1636
</OPTIONSELECTED>
1637
</COLUMN>
1638
<COLUMN ID="21371" ColName="ccb_ce_determination" PrevColName="" Pos="19" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les \195\169chantillons sont-ils d\195\169terminables ? (de 1\194\160: quelques fragment de plantes \195\160 5 plantes enti\195\168res).">
1639
<OPTIONSELECTED>
1640
<OPTIONSELECT Value="1" />
1641
<OPTIONSELECT Value="0" />
1642
</OPTIONSELECTED>
1643
</COLUMN>
23 jpm 1644
<COLUMN ID="21471" ColName="ccb_recolte_date_debut" PrevColName="" Pos="20" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date extr\195\170me de d\195\169but de r\195\169colte.">
1645
<OPTIONSELECTED>
1646
</OPTIONSELECTED>
1647
</COLUMN>
1648
<COLUMN ID="21472" ColName="ccb_ce_recolte_date_debut_type" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type de date extr\195\170me de d\195\169but de r\195\169colte.">
1649
<OPTIONSELECTED>
1650
<OPTIONSELECT Value="1" />
1651
<OPTIONSELECT Value="0" />
1652
</OPTIONSELECTED>
1653
</COLUMN>
1654
<COLUMN ID="21474" ColName="ccb_recolte_date_fin" PrevColName="" Pos="22" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date extr\195\170me de fin de r\195\169colte.">
1655
<OPTIONSELECTED>
1656
</OPTIONSELECTED>
1657
</COLUMN>
1658
<COLUMN ID="21475" ColName="ccb_ce_recolte_date_fin_type" PrevColName="" Pos="23" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Type de date extr\195\170me de fin de r\195\169colte.">
1659
<OPTIONSELECTED>
1660
<OPTIONSELECT Value="1" />
1661
<OPTIONSELECT Value="0" />
1662
</OPTIONSELECTED>
1663
</COLUMN>
1664
<COLUMN ID="21477" ColName="ccb_annotation_classement" PrevColName="ccb_classement" Pos="24" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indiquer le type de classement ou des informations concernant un \195\169ventuel classement.">
1665
<OPTIONSELECTED>
1666
</OPTIONSELECTED>
1667
</COLUMN>
1668
<COLUMN ID="21478" ColName="ccb_ce_classement_etat" PrevColName="" Pos="25" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat du classement (de 1 tr\195\168s mauvais \195\160 5 tr\195\168s bon).">
1669
<OPTIONSELECTED>
1670
<OPTIONSELECT Value="1" />
1671
<OPTIONSELECT Value="0" />
1672
</OPTIONSELECTED>
1673
</COLUMN>
1674
<COLUMN ID="21479" ColName="ccb_truk_etiquette_renseignement" PrevColName="" Pos="26" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage pour chaque type de renseignements port\195\169s sur l\a\195\169tiquette\194\160ou sur la part.">
1675
<OPTIONSELECTED>
1676
<OPTIONSELECT Value="0" />
1677
</OPTIONSELECTED>
1678
</COLUMN>
1679
<COLUMN ID="21480" ColName="ccb_ce_precision_localite" PrevColName="" Pos="27" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les localit\195\169s sont elles pr\195\169cises?">
1680
<OPTIONSELECTED>
1681
<OPTIONSELECT Value="1" />
1682
<OPTIONSELECT Value="0" />
1683
</OPTIONSELECTED>
1684
</COLUMN>
1685
<COLUMN ID="21481" ColName="ccb_ce_precision_date" PrevColName="" Pos="28" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les dates sont elles pr\195\169cises?">
1686
<OPTIONSELECTED>
1687
<OPTIONSELECT Value="1" />
1688
<OPTIONSELECT Value="0" />
1689
</OPTIONSELECTED>
1690
</COLUMN>
1691
<COLUMN ID="21483" ColName="ccb_annotation_diverse" PrevColName="ccb_truk_annotation" Pos="29" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Autres annotations (dons, annotations personnelles, recettes, utilisations m\195\169dicales...).">
1692
<OPTIONSELECTED>
1693
</OPTIONSELECTED>
1694
</COLUMN>
1695
<COLUMN ID="21501" ColName="ccb_ce_collection_integre" PrevColName="" Pos="30" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="La collection observ\195\169e int\195\168gre-t-elle des collections botaniques ant\195\169rieures ?">
1696
<OPTIONSELECTED>
1697
<OPTIONSELECT Value="1" />
1698
<OPTIONSELECT Value="0" />
1699
</OPTIONSELECTED>
1700
</COLUMN>
1701
<COLUMN ID="21502" ColName="ccb_ce_collection_integre_info" PrevColName="ccb_collection_integre_info" Pos="31" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Les noms de ces collections sont-ils not\195\169s sur les \195\169tiquettes de chaque \195\169chantillon\194\160?">
1702
<OPTIONSELECTED>
1703
<OPTIONSELECT Value="1" />
1704
<OPTIONSELECT Value="0" />
1705
</OPTIONSELECTED>
1706
</COLUMN>
1707
<COLUMN ID="21514" ColName="ccb_ce_inventaire" PrevColName="" Pos="32" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Existe-t-il un inventaire de cette collection?">
1708
<OPTIONSELECTED>
1709
<OPTIONSELECT Value="1" />
1710
<OPTIONSELECT Value="0" />
1711
</OPTIONSELECTED>
1712
</COLUMN>
1713
<COLUMN ID="21515" ColName="ccb_ce_inventaire_auteur" PrevColName="" Pos="33" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="L\aauteur de la collection a-t-il particip\195\169 \195\160 cet inventaire?">
1714
<OPTIONSELECTED>
1715
<OPTIONSELECT Value="1" />
1716
<OPTIONSELECT Value="0" />
1717
</OPTIONSELECTED>
1718
</COLUMN>
1719
<COLUMN ID="21517" ColName="ccb_ce_inventaire_forme" PrevColName="" Pos="35" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Forme de l\ainventaire (mnauscrit, informatique...).">
1720
<OPTIONSELECTED>
1721
<OPTIONSELECT Value="1" />
1722
<OPTIONSELECT Value="0" />
1723
</OPTIONSELECTED>
1724
</COLUMN>
1725
<COLUMN ID="21516" ColName="ccb_inventaire_info" PrevColName="" Pos="34" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quelles informations retrouve-t-on?">
1726
<OPTIONSELECTED>
1727
</OPTIONSELECTED>
1728
</COLUMN>
1729
<COLUMN ID="21518" ColName="ccb_ce_truk_inventaire_digital" PrevColName="" Pos="36" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Si inventaire digial, quel logiciel utilisez vous?">
1730
<OPTIONSELECTED>
1731
<OPTIONSELECT Value="0" />
1732
</OPTIONSELECTED>
1733
</COLUMN>
1734
<COLUMN ID="21519" ColName="ccb_inventaire_digital_pourcent" PrevColName="" Pos="37" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Pourcentage de la documentation en base de donn\195\169es.">
1735
<OPTIONSELECTED>
1736
<OPTIONSELECT Value="1" />
1737
<OPTIONSELECT Value="0" />
1738
</OPTIONSELECTED>
1739
</COLUMN>
1740
<COLUMN ID="21520" ColName="ccb_ce_inventaire_etat" PrevColName="ccb_inventaire_etat" Pos="38" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="L\ainventaire est il complet ou partiel?">
1741
<OPTIONSELECTED>
1742
<OPTIONSELECT Value="1" />
1743
<OPTIONSELECT Value="0" />
1744
</OPTIONSELECTED>
1745
</COLUMN>
1746
<COLUMN ID="21521" ColName="ccb_inventaire_donnee_type" PrevColName="" Pos="39" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Quels sont les \195\169l\195\169ments qui ont d\195\169j\195\160 \195\169t\195\169 inventori\195\169s (Ex. : familles, localit\195\169s...) ?">
1747
<OPTIONSELECTED>
1748
</OPTIONSELECTED>
1749
</COLUMN>
20 jpm 1750
</COLUMNS>
1751
<RELATIONS_END>
1752
<RELATION_END ID="21152" />
1753
</RELATIONS_END>
1754
<INDICES>
1755
<INDEX ID="21151" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1756
<INDEXCOLUMNS>
1757
<INDEXCOLUMN idColumn="21150" LengthParam="0" />
1758
</INDEXCOLUMNS>
1759
</INDEX>
1760
</INDICES>
1761
</TABLE>
25 jpm 1762
<TABLE ID="21188" Tablename="coel_publication" PrevTableName="Table_15" XPos="60" YPos="2220" 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="72" >
20 jpm 1763
<COLUMNS>
1764
<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.">
1765
<OPTIONSELECTED>
1766
<OPTIONSELECT Value="1" />
1767
<OPTIONSELECT Value="0" />
1768
</OPTIONSELECTED>
1769
</COLUMN>
24 jpm 1770
<COLUMN ID="21633" ColName="cpu_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel les donn\195\169es de cet enregistrement ont \195\169t\195\169 saisies.">
20 jpm 1771
<OPTIONSELECTED>
1772
<OPTIONSELECT Value="1" />
1773
<OPTIONSELECT Value="0" />
1774
</OPTIONSELECTED>
1775
</COLUMN>
1776
<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...">
1777
<OPTIONSELECTED>
1778
<OPTIONSELECT Value="0" />
1779
</OPTIONSELECTED>
1780
</COLUMN>
23 jpm 1781
<COLUMN ID="21205" ColName="cpu_fmt_auteur" PrevColName="cpu_truk_auteur" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient le nom format\195\169 de l\aintitul\195\169 auteur(s). Si plusieurs personnes sont auteurs, l\aintitul\195\169 est format\195\169 ici.">
20 jpm 1782
<OPTIONSELECTED>
1783
<OPTIONSELECT Value="0" />
1784
</OPTIONSELECTED>
1785
</COLUMN>
1786
<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.">
1787
<OPTIONSELECTED>
1788
<OPTIONSELECT Value="0" />
1789
</OPTIONSELECTED>
1790
</COLUMN>
23 jpm 1791
<COLUMN ID="21198" ColName="cpu_collection" PrevColName="cpu_intitule_collection" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Intitul\195\169 de la collection, c\aest \195\160 dire de la revue.">
20 jpm 1792
<OPTIONSELECTED>
1793
<OPTIONSELECT Value="0" />
1794
</OPTIONSELECTED>
1795
</COLUMN>
23 jpm 1796
<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="1" DefaultValue="0" Comments="Identifiant de la structure \195\169ditrice.">
20 jpm 1797
<OPTIONSELECTED>
1798
<OPTIONSELECT Value="1" />
1799
<OPTIONSELECT Value="0" />
1800
</OPTIONSELECTED>
1801
</COLUMN>
1802
<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.">
1803
<OPTIONSELECTED>
1804
<OPTIONSELECT Value="0" />
1805
</OPTIONSELECTED>
1806
</COLUMN>
1807
<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.">
1808
<OPTIONSELECTED>
1809
</OPTIONSELECTED>
1810
</COLUMN>
1811
<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.">
1812
<OPTIONSELECTED>
1813
<OPTIONSELECT Value="0" />
1814
</OPTIONSELECTED>
1815
</COLUMN>
23 jpm 1816
<COLUMN ID="21212" ColName="cpu_fascicule" PrevColName="cpu_titre_fascicule" Pos="9" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indication du titre du fascicule. Surtout utilis\195\169 pour les revues.">
20 jpm 1817
<OPTIONSELECTED>
1818
<OPTIONSELECT Value="0" />
1819
</OPTIONSELECTED>
1820
</COLUMN>
1821
<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.">
1822
<OPTIONSELECTED>
1823
<OPTIONSELECT Value="0" />
1824
</OPTIONSELECTED>
1825
</COLUMN>
1826
<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. ">
1827
<OPTIONSELECTED>
1828
<OPTIONSELECT Value="0" />
1829
</OPTIONSELECTED>
1830
</COLUMN>
1831
<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. ">
1832
<OPTIONSELECTED>
1833
<OPTIONSELECT Value="1" />
1834
<OPTIONSELECT Value="0" />
1835
</OPTIONSELECTED>
1836
</COLUMN>
1837
<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.">
1838
<OPTIONSELECTED>
1839
<OPTIONSELECT Value="1" />
1840
<OPTIONSELECT Value="0" />
1841
</OPTIONSELECTED>
1842
</COLUMN>
1843
<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. ">
1844
<OPTIONSELECTED>
1845
<OPTIONSELECT Value="1" />
1846
<OPTIONSELECT Value="0" />
1847
</OPTIONSELECTED>
1848
</COLUMN>
1849
</COLUMNS>
1850
<RELATIONS_START>
1851
<RELATION_START ID="21226" />
1852
<RELATION_START ID="21241" />
1853
</RELATIONS_START>
1854
<RELATIONS_END>
1855
<RELATION_END ID="21254" />
23 jpm 1856
<RELATION_END ID="21616" />
1857
<RELATION_END ID="21631" />
20 jpm 1858
</RELATIONS_END>
1859
<INDICES>
1860
<INDEX ID="21191" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1861
<INDEXCOLUMNS>
1862
<INDEXCOLUMN idColumn="21190" LengthParam="0" />
1863
</INDEXCOLUMNS>
1864
</INDEX>
1865
</INDICES>
1866
</TABLE>
25 jpm 1867
<TABLE ID="21219" Tablename="coel_collection_a_publication" PrevTableName="Table_16" XPos="56" YPos="1982" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Permet de lister les publication li\195\169es \195\160 une collection." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" >
20 jpm 1868
<COLUMNS>
24 jpm 1869
<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="Identifiant de collection.">
20 jpm 1870
<OPTIONSELECTED>
1871
<OPTIONSELECT Value="1" />
1872
<OPTIONSELECT Value="0" />
1873
</OPTIONSELECTED>
1874
</COLUMN>
24 jpm 1875
<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="Identifiant de la publication.">
20 jpm 1876
<OPTIONSELECTED>
1877
<OPTIONSELECT Value="1" />
1878
<OPTIONSELECT Value="0" />
1879
</OPTIONSELECTED>
1880
</COLUMN>
1881
<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.">
1882
<OPTIONSELECTED>
1883
</OPTIONSELECTED>
1884
</COLUMN>
24 jpm 1885
<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="Notes sur l\aenregistrement. Information sur les modification effectu\195\169es. Permet de recr\195\169er l\ahitorique des modifications.">
20 jpm 1886
<OPTIONSELECTED>
1887
<OPTIONSELECT Value="0" />
1888
</OPTIONSELECTED>
1889
</COLUMN>
24 jpm 1890
<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="Date de la derni\195\168re modification sur cet enregistrement.">
20 jpm 1891
<OPTIONSELECTED>
1892
</OPTIONSELECTED>
1893
</COLUMN>
25 jpm 1894
<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="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.">
20 jpm 1895
<OPTIONSELECTED>
1896
<OPTIONSELECT Value="1" />
1897
<OPTIONSELECT Value="0" />
1898
</OPTIONSELECTED>
1899
</COLUMN>
24 jpm 1900
<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="\195\137tat de l\aenregistrement.">
20 jpm 1901
<OPTIONSELECTED>
1902
<OPTIONSELECT Value="1" />
1903
<OPTIONSELECT Value="0" />
1904
</OPTIONSELECTED>
1905
</COLUMN>
1906
</COLUMNS>
1907
<RELATIONS_END>
1908
<RELATION_END ID="21223" />
1909
<RELATION_END ID="21226" />
25 jpm 1910
<RELATION_END ID="21749" />
20 jpm 1911
</RELATIONS_END>
1912
<INDICES>
1913
<INDEX ID="21222" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1914
<INDEXCOLUMNS>
1915
<INDEXCOLUMN idColumn="21225" LengthParam="0" />
1916
<INDEXCOLUMN idColumn="21244" LengthParam="0" />
1917
</INDEXCOLUMNS>
1918
</INDEX>
1919
</INDICES>
1920
</TABLE>
25 jpm 1921
<TABLE ID="21235" Tablename="coel_publication_a_personne" PrevTableName="Table_17" XPos="420" YPos="2260" 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="73" >
20 jpm 1922
<COLUMNS>
24 jpm 1923
<COLUMN ID="21571" ColName="cpuap_id_publication" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune publication.">
20 jpm 1924
<OPTIONSELECTED>
1925
<OPTIONSELECT Value="1" />
1926
<OPTIONSELECT Value="0" />
1927
</OPTIONSELECTED>
1928
</COLUMN>
24 jpm 1929
<COLUMN ID="21572" ColName="cpuap_id_personne" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant d\aune personne.">
20 jpm 1930
<OPTIONSELECTED>
1931
<OPTIONSELECT Value="1" />
1932
<OPTIONSELECT Value="0" />
1933
</OPTIONSELECTED>
1934
</COLUMN>
23 jpm 1935
<COLUMN ID="21611" ColName="cpupa_id_role" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\180le de la personne vis \195\160 vis de la publication : contributeur, auteur...">
20 jpm 1936
<OPTIONSELECTED>
23 jpm 1937
<OPTIONSELECT Value="1" />
20 jpm 1938
<OPTIONSELECT Value="0" />
1939
</OPTIONSELECTED>
1940
</COLUMN>
23 jpm 1941
<COLUMN ID="21247" ColName="cpuap_ce_truk_type" PrevColName="cpap_ce_truk_type" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Contient le type de r\195\169f\195\169rence bibliographique : n\195\169crologie, biographie, publication personnelle...">
20 jpm 1942
<OPTIONSELECTED>
1943
<OPTIONSELECT Value="0" />
1944
</OPTIONSELECTED>
1945
</COLUMN>
23 jpm 1946
<COLUMN ID="21248" ColName="cpuap_notes" PrevColName="cpap_notes" 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. ">
20 jpm 1947
<OPTIONSELECTED>
23 jpm 1948
<OPTIONSELECT Value="0" />
20 jpm 1949
</OPTIONSELECTED>
1950
</COLUMN>
23 jpm 1951
<COLUMN ID="21249" ColName="cpuap_date_derniere_modif" PrevColName="cpap_date_derniere_modif" 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.">
20 jpm 1952
<OPTIONSELECTED>
23 jpm 1953
</OPTIONSELECTED>
1954
</COLUMN>
24 jpm 1955
<COLUMN ID="21573" ColName="cpuap_ce_modifier_par" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.">
23 jpm 1956
<OPTIONSELECTED>
20 jpm 1957
<OPTIONSELECT Value="1" />
1958
<OPTIONSELECT Value="0" />
1959
</OPTIONSELECTED>
1960
</COLUMN>
23 jpm 1961
<COLUMN ID="21251" ColName="cpuap_ce_etat" PrevColName="cpap_ce_etat" 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.">
20 jpm 1962
<OPTIONSELECTED>
1963
<OPTIONSELECT Value="1" />
1964
<OPTIONSELECT Value="0" />
1965
</OPTIONSELECTED>
1966
</COLUMN>
1967
</COLUMNS>
1968
<RELATIONS_END>
1969
<RELATION_END ID="21239" />
1970
<RELATION_END ID="21241" />
1971
<RELATION_END ID="21252" />
1972
</RELATIONS_END>
1973
<INDICES>
1974
<INDEX ID="21238" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
1975
<INDEXCOLUMNS>
23 jpm 1976
<INDEXCOLUMN idColumn="21571" LengthParam="0" />
1977
<INDEXCOLUMN idColumn="21572" LengthParam="0" />
1978
<INDEXCOLUMN idColumn="21611" LengthParam="0" />
20 jpm 1979
</INDEXCOLUMNS>
1980
</INDEX>
1981
</INDICES>
1982
</TABLE>
25 jpm 1983
<TABLE ID="21486" Tablename="coel_collection_a_relation" PrevTableName="Table_18" XPos="92" YPos="928" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Permet de lister les relations entre collection autre que hi\195\169rarchique." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" >
23 jpm 1984
<COLUMNS>
24 jpm 1985
<COLUMN ID="21660" ColName="ccar_id_collection_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1761.">
23 jpm 1986
<OPTIONSELECTED>
1987
<OPTIONSELECT Value="1" />
1988
<OPTIONSELECT Value="0" />
1989
</OPTIONSELECTED>
1990
</COLUMN>
24 jpm 1991
<COLUMN ID="21661" ColName="ccar_id_collection_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la collection n\194\1762.">
23 jpm 1992
<OPTIONSELECTED>
1993
<OPTIONSELECT Value="1" />
1994
<OPTIONSELECT Value="0" />
1995
</OPTIONSELECTED>
1996
</COLUMN>
24 jpm 1997
<COLUMN ID="21491" ColName="ccar_id_relation" PrevColName="ccr_ce_relation" Pos="2" idDatatype="5" DatatypeParams="(3)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Indentifiant du type de la relation.">
23 jpm 1998
<OPTIONSELECTED>
1999
<OPTIONSELECT Value="1" />
2000
<OPTIONSELECT Value="0" />
2001
</OPTIONSELECTED>
2002
</COLUMN>
24 jpm 2003
<COLUMN ID="21492" ColName="ccar_notes" PrevColName="ccr_notes" 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. ">
23 jpm 2004
<OPTIONSELECTED>
2005
<OPTIONSELECT Value="0" />
2006
</OPTIONSELECTED>
2007
</COLUMN>
24 jpm 2008
<COLUMN ID="21493" ColName="ccar_date_derniere_modif" PrevColName="ccr_date_derniere_modif" 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.">
23 jpm 2009
<OPTIONSELECTED>
2010
</OPTIONSELECTED>
2011
</COLUMN>
25 jpm 2012
<COLUMN ID="21494" ColName="ccar_ce_modifier_par" PrevColName="ccr_ce_modifier_par" 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.">
23 jpm 2013
<OPTIONSELECTED>
2014
<OPTIONSELECT Value="1" />
2015
<OPTIONSELECT Value="0" />
2016
</OPTIONSELECTED>
2017
</COLUMN>
24 jpm 2018
<COLUMN ID="21495" ColName="ccar_ce_etat" PrevColName="ccr_ce_etat" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de l\aenregistrement.">
23 jpm 2019
<OPTIONSELECTED>
2020
<OPTIONSELECT Value="1" />
2021
<OPTIONSELECT Value="0" />
2022
</OPTIONSELECTED>
2023
</COLUMN>
2024
</COLUMNS>
2025
<RELATIONS_END>
2026
<RELATION_END ID="21496" />
2027
<RELATION_END ID="21498" />
25 jpm 2028
<RELATION_END ID="21747" />
23 jpm 2029
</RELATIONS_END>
2030
<INDICES>
2031
<INDEX ID="21489" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2032
<INDEXCOLUMNS>
2033
<INDEXCOLUMN idColumn="21660" LengthParam="0" />
2034
<INDEXCOLUMN idColumn="21661" LengthParam="0" />
24 jpm 2035
<INDEXCOLUMN idColumn="21491" LengthParam="0" />
23 jpm 2036
</INDEXCOLUMNS>
2037
</INDEX>
2038
</INDICES>
2039
</TABLE>
25 jpm 2040
<TABLE ID="21522" Tablename="coel_projet" PrevTableName="EFLORE_PROJET" XPos="36" YPos="532" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Contient les informations sur un projet de donn\195\169es." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
23 jpm 2041
<COLUMNS>
24 jpm 2042
<COLUMN ID="21523" ColName="cpr_id_projet" PrevColName="EPR_ID_PROJET" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aun projet.">
23 jpm 2043
<OPTIONSELECTED>
2044
<OPTIONSELECT Value="0" />
2045
<OPTIONSELECT Value="0" />
2046
</OPTIONSELECTED>
2047
</COLUMN>
24 jpm 2048
<COLUMN ID="21526" ColName="cpr_nom" PrevColName="EPR_INTITULE_PROJET" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du projet.">
23 jpm 2049
<OPTIONSELECTED>
2050
<OPTIONSELECT Value="0" />
2051
</OPTIONSELECTED>
2052
</COLUMN>
24 jpm 2053
<COLUMN ID="21527" ColName="cpr_abreviation" PrevColName="EPR_ABREVIATION_PROJET" Pos="5" idDatatype="20" DatatypeParams="(40)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Abr\195\169viation du projet.">
23 jpm 2054
<OPTIONSELECTED>
2055
<OPTIONSELECT Value="0" />
2056
</OPTIONSELECTED>
2057
</COLUMN>
24 jpm 2058
<COLUMN ID="21528" ColName="cpr_resume" PrevColName="EPR_DESCRIPTION_PROJET" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="R\195\169sum\195\169 du projet.">
23 jpm 2059
<OPTIONSELECTED>
2060
<OPTIONSELECT Value="0" />
2061
</OPTIONSELECTED>
2062
</COLUMN>
24 jpm 2063
<COLUMN ID="21538" ColName="cpr_description" PrevColName="" Pos="6" idDatatype="28" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description d\195\169taill\195\169e du projet.">
23 jpm 2064
<OPTIONSELECTED>
2065
</OPTIONSELECTED>
2066
</COLUMN>
24 jpm 2067
<COLUMN ID="21529" ColName="cpr_url" PrevColName="EPR_LIEN_WEB" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="URL principal o\195\185 trouver des compl\195\169ments d\ainformation sur le projet.">
23 jpm 2068
<OPTIONSELECTED>
2069
<OPTIONSELECT Value="0" />
2070
</OPTIONSELECTED>
2071
</COLUMN>
24 jpm 2072
<COLUMN ID="21530" ColName="cpr_notes" PrevColName="EPR_NOTES_PROJET" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" 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. ">
23 jpm 2073
<OPTIONSELECTED>
2074
<OPTIONSELECT Value="0" />
2075
</OPTIONSELECTED>
2076
</COLUMN>
24 jpm 2077
<COLUMN ID="21539" ColName="cpr_date_derniere_modif" PrevColName="" Pos="7" 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. ">
23 jpm 2078
<OPTIONSELECTED>
2079
</OPTIONSELECTED>
2080
</COLUMN>
25 jpm 2081
<COLUMN ID="21540" ColName="cpr_ce_modifier_par" PrevColName="" Pos="8" 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.">
23 jpm 2082
<OPTIONSELECTED>
2083
<OPTIONSELECT Value="1" />
2084
<OPTIONSELECT Value="0" />
2085
</OPTIONSELECTED>
2086
</COLUMN>
24 jpm 2087
<COLUMN ID="21541" ColName="cpr_ce_etat" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de l\aenregistrement.">
23 jpm 2088
<OPTIONSELECTED>
2089
<OPTIONSELECT Value="1" />
2090
<OPTIONSELECT Value="0" />
2091
</OPTIONSELECTED>
2092
</COLUMN>
2093
</COLUMNS>
2094
<RELATIONS_START>
2095
<RELATION_START ID="21560" />
2096
<RELATION_START ID="21622" />
2097
<RELATION_START ID="21625" />
2098
<RELATION_START ID="21628" />
2099
<RELATION_START ID="21631" />
2100
<RELATION_START ID="21650" />
2101
</RELATIONS_START>
25 jpm 2102
<RELATIONS_END>
2103
<RELATION_END ID="21744" />
2104
</RELATIONS_END>
23 jpm 2105
<INDICES>
2106
<INDEX ID="21532" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2107
<INDEXCOLUMNS>
2108
<INDEXCOLUMN idColumn="21523" LengthParam="0" />
2109
</INDEXCOLUMNS>
2110
</INDEX>
2111
<INDEX ID="21533" IndexName="EFLORE_PROJET_PK" IndexKind="1" FKRefDef_Obj_id="-1">
2112
<INDEXCOLUMNS>
2113
<INDEXCOLUMN idColumn="21523" LengthParam="0" />
2114
</INDEXCOLUMNS>
2115
</INDEX>
2116
</INDICES>
2117
</TABLE>
25 jpm 2118
<TABLE ID="21544" Tablename="coel_personne_a_relation" PrevTableName="Table_20" XPos="852" YPos="544" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Relation entre deux personnes vis \195\160 vis d\aun projet." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="65" >
23 jpm 2119
<COLUMNS>
24 jpm 2120
<COLUMN ID="21664" ColName="cpar_id_personne_01" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne n\194\1761.">
23 jpm 2121
<OPTIONSELECTED>
2122
<OPTIONSELECT Value="1" />
2123
<OPTIONSELECT Value="0" />
2124
</OPTIONSELECTED>
2125
</COLUMN>
24 jpm 2126
<COLUMN ID="21668" ColName="cpar_id_personne_02" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la personne n\194\1762.">
23 jpm 2127
<OPTIONSELECTED>
2128
<OPTIONSELECT Value="1" />
2129
<OPTIONSELECT Value="0" />
2130
</OPTIONSELECTED>
2131
</COLUMN>
24 jpm 2132
<COLUMN ID="21665" ColName="cpar_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet dans lequel la relation entre les deux personnes s\a\195\169tablie.">
23 jpm 2133
<OPTIONSELECTED>
2134
<OPTIONSELECT Value="1" />
2135
<OPTIONSELECT Value="0" />
2136
</OPTIONSELECTED>
2137
</COLUMN>
24 jpm 2138
<COLUMN ID="21549" ColName="cpar_id_role" PrevColName="cpap_ce_role" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du r\195\180le ou de la valeur \195\169tablie entre les deux personnes.">
23 jpm 2139
<OPTIONSELECTED>
2140
<OPTIONSELECT Value="1" />
2141
<OPTIONSELECT Value="0" />
2142
</OPTIONSELECTED>
2143
</COLUMN>
24 jpm 2144
<COLUMN ID="21556" ColName="cpar_notes" PrevColName="cpap_notes" 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.">
23 jpm 2145
<OPTIONSELECTED>
2146
<OPTIONSELECT Value="0" />
2147
</OPTIONSELECTED>
2148
</COLUMN>
24 jpm 2149
<COLUMN ID="21557" ColName="cpar_date_derniere_modif" PrevColName="cpap_date_derniere_modif" 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.">
23 jpm 2150
<OPTIONSELECTED>
2151
</OPTIONSELECTED>
2152
</COLUMN>
25 jpm 2153
<COLUMN ID="21558" ColName="cpar_ce_modifier_par" PrevColName="cpap_ce_modifier_par" 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.">
23 jpm 2154
<OPTIONSELECTED>
2155
<OPTIONSELECT Value="1" />
2156
<OPTIONSELECT Value="0" />
2157
</OPTIONSELECTED>
2158
</COLUMN>
24 jpm 2159
<COLUMN ID="21559" ColName="cpar_ce_etat" PrevColName="cpap_ce_etat" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\195\137tat de l\aenregistrement.">
23 jpm 2160
<OPTIONSELECTED>
2161
<OPTIONSELECT Value="1" />
2162
<OPTIONSELECT Value="0" />
2163
</OPTIONSELECTED>
2164
</COLUMN>
2165
</COLUMNS>
2166
<RELATIONS_END>
2167
<RELATION_END ID="21560" />
2168
<RELATION_END ID="21563" />
24 jpm 2169
<RELATION_END ID="21666" />
25 jpm 2170
<RELATION_END ID="21746" />
23 jpm 2171
</RELATIONS_END>
2172
<INDICES>
2173
<INDEX ID="21547" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2174
<INDEXCOLUMNS>
24 jpm 2175
<INDEXCOLUMN idColumn="21664" LengthParam="0" />
2176
<INDEXCOLUMN idColumn="21668" LengthParam="0" />
2177
<INDEXCOLUMN idColumn="21665" LengthParam="0" />
2178
<INDEXCOLUMN idColumn="21549" LengthParam="0" />
23 jpm 2179
</INDEXCOLUMNS>
2180
</INDEX>
2181
</INDICES>
2182
</TABLE>
25 jpm 2183
<TABLE ID="21634" Tablename="coel_projet_version" PrevTableName="eflore_projet_version" XPos="364" YPos="672" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="Table contenant les informations sur la version d\aun projet." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="11447" OrderPos="4" >
23 jpm 2184
<COLUMNS>
2185
<COLUMN ID="21635" ColName="cprv_id_version" PrevColName="eprv_id_version" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant d\aune version de projet.">
2186
<OPTIONSELECTED>
2187
<OPTIONSELECT Value="0" />
2188
<OPTIONSELECT Value="0" />
2189
</OPTIONSELECTED>
2190
</COLUMN>
24 jpm 2191
<COLUMN ID="21652" ColName="cprv_ce_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant du projet de la version.">
23 jpm 2192
<OPTIONSELECTED>
2193
<OPTIONSELECT Value="1" />
2194
<OPTIONSELECT Value="0" />
2195
</OPTIONSELECTED>
2196
</COLUMN>
2197
<COLUMN ID="21637" ColName="cprv_nom" PrevColName="eprv_nom" Pos="11" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom \195\169ventuel de la version.">
2198
<OPTIONSELECTED>
2199
<OPTIONSELECT Value="0" />
2200
</OPTIONSELECTED>
2201
</COLUMN>
2202
<COLUMN ID="21638" ColName="cprv_code" PrevColName="eprv_code" Pos="5" idDatatype="20" DatatypeParams="(25)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Num\195\169ro ou code de la version.">
2203
<OPTIONSELECTED>
2204
<OPTIONSELECT Value="0" />
2205
</OPTIONSELECTED>
2206
</COLUMN>
2207
<COLUMN ID="21640" ColName="cprv_date_debut" PrevColName="eprv_date_debut" Pos="6" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="Date de d\195\169but de la version.">
2208
<OPTIONSELECTED>
2209
</OPTIONSELECTED>
2210
</COLUMN>
2211
<COLUMN ID="21641" ColName="cprv_date_fin" PrevColName="eprv_date_fin" Pos="7" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Date de fin de la version.">
2212
<OPTIONSELECTED>
2213
</OPTIONSELECTED>
2214
</COLUMN>
2215
<COLUMN ID="21642" ColName="cprv_mark_consultable" PrevColName="eprv_mark_consultable" Pos="12" idDatatype="5" DatatypeParams="(1)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="Indique si oui (=1) ou non (=0) cette version est consultable en ligne.">
2216
<OPTIONSELECTED>
2217
<OPTIONSELECT Value="1" />
2218
<OPTIONSELECT Value="0" />
2219
</OPTIONSELECTED>
2220
</COLUMN>
24 jpm 2221
<COLUMN ID="21643" ColName="cprv_notes" PrevColName="eprv_notes" Pos="8" idDatatype="28" DatatypeParams="" Width="0" Prec="0" 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.">
23 jpm 2222
<OPTIONSELECTED>
2223
</OPTIONSELECTED>
2224
</COLUMN>
24 jpm 2225
<COLUMN ID="21644" ColName="cprv_date_derniere_modif" PrevColName="eprv_date_derniere_modif" Pos="8" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="Date de derni\195\168re modification de cet enregistrement.">
23 jpm 2226
<OPTIONSELECTED>
2227
</OPTIONSELECTED>
2228
</COLUMN>
25 jpm 2229
<COLUMN ID="21645" ColName="cprv_ce_modifier_par" PrevColName="eprv_ce_modifier_par" Pos="9" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="0" Comments="Identifiant de l\autilisateur ayant modifi\195\169 en dernier cet enregistrement.">
23 jpm 2230
<OPTIONSELECTED>
2231
<OPTIONSELECT Value="1" />
2232
<OPTIONSELECT Value="0" />
2233
</OPTIONSELECTED>
2234
</COLUMN>
2235
<COLUMN ID="21646" ColName="cprv_ce_etat" PrevColName="eprv_ce_etat" Pos="10" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Identifiant de l\a\195\169tat de cet enregistrement.">
2236
<OPTIONSELECTED>
2237
<OPTIONSELECT Value="1" />
2238
<OPTIONSELECT Value="0" />
2239
</OPTIONSELECTED>
2240
</COLUMN>
2241
</COLUMNS>
2242
<RELATIONS_END>
2243
<RELATION_END ID="21650" />
25 jpm 2244
<RELATION_END ID="21742" />
23 jpm 2245
</RELATIONS_END>
2246
<INDICES>
2247
<INDEX ID="21648" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
2248
<INDEXCOLUMNS>
2249
<INDEXCOLUMN idColumn="21635" LengthParam="0" />
2250
</INDEXCOLUMNS>
2251
</INDEX>
2252
</INDICES>
2253
</TABLE>
14 jpm 2254
</TABLES>
2255
<RELATIONS>
23 jpm 2256
<RELATION ID="18419" RelationName="fk_cs_csap" Kind="1" SrcTable="1445" DestTable="1447" FKFields="cs_id_structure=csap_id_structure\n" FKFieldsComments="Identifiant de la structure.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-1" CaptionOffsetY="-1" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" />
25 jpm 2257
<RELATION ID="18425" RelationName="fk_cp_csap" Kind="1" SrcTable="1446" DestTable="1447" FKFields="cp_id_personne=csap_id_personne\n" FKFieldsComments="Identifiant de la personne constituant l\a\195\169quipe d\aun service d\aune structure.\n" relDirection="3" MidOffset="-68" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="18" />
23 jpm 2258
<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="32" />
25 jpm 2259
<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="-24" CaptionOffsetY="11" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="-7" EndIntervalOffsetY="4" 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="34" />
2260
<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="2" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-44" CaptionOffsetY="-41" StartIntervalOffsetX="-6" StartIntervalOffsetY="-26" 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="35" />
2261
<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="5" CaptionOffsetY="-48" 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="39" />
2262
<RELATION ID="20806" RelationName="fk_cmt_cmd" Kind="2" SrcTable="18448" DestTable="18452" FKFields="cmt_id_table=cmd_ce_table\n" FKFieldsComments="Afin d\aaugmenter les performance l\aidentifiant de la table est aussi indiquer dans la table des donn\195\169es.\n" relDirection="4" MidOffset="46" 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" />
2263
<RELATION ID="20808" RelationName="fk_cmt_cmh" Kind="2" SrcTable="18448" DestTable="18498" FKFields="cmt_id_table=cmh_ce_table\n" FKFieldsComments="Afin d\aaugmenter les performances l\aidentifiant de la table est aussi r\195\169percut\195\169 dans la table d\ahistorisation.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-50" CaptionOffsetY="-23" 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="40" />
2264
<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="204" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="13" CaptionOffsetY="-48" 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="41" />
24 jpm 2265
<RELATION ID="20819" RelationName="fk_cc_cc_parente" Kind="2" SrcTable="1444" DestTable="1444" FKFields="cc_id_collection=cc_ce_mere\n" FKFieldsComments="Identifiant de la collection parente.\n" relDirection="2" MidOffset="13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-63" CaptionOffsetY="-22" StartIntervalOffsetX="9" StartIntervalOffsetY="-28" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" />
25 jpm 2266
<RELATION ID="20828" RelationName="fk_cp_csae_modifier_par" Kind="2" SrcTable="1446" DestTable="1447" FKFields="cp_id_personne=csap_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant effectu\195\169 la derni\195\168re modification sur cet enregistrement.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="43" />
2267
<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="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="44" />
2268
<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="5" CaptionOffsetY="-2" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="45" />
23 jpm 2269
<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="46" />
25 jpm 2270
<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="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-99" CaptionOffsetY="50" 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="47" />
23 jpm 2271
<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="54" />
2272
<RELATION ID="20861" RelationName="fk_cs_csv" Kind="4" SrcTable="1445" DestTable="20854" FKFields="cs_id_structure=csv_id_structure\n" FKFieldsComments="Identifiant de la structure.\n" relDirection="3" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="55" />
25 jpm 2273
<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="1" MidOffset="9" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="-1" StartIntervalOffsetY="3" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="53" />
23 jpm 2274
<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="54" />
2275
<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="55" />
2276
<RELATION ID="21152" RelationName="fk_cc_ccb" Kind="4" SrcTable="1444" DestTable="21148" FKFields="cc_id_collection=ccb_id_collection\n" FKFieldsComments="Identifiant de la collection botanique.\n" relDirection="2" MidOffset="7" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="56" />
2277
<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="58" />
25 jpm 2278
<RELATION ID="21223" RelationName="fk_cc_ccapu" Kind="1" SrcTable="1444" DestTable="21219" FKFields="cc_id_collection=ccapu_id_collection\n" FKFieldsComments="Identifiant de la collection ayant des publications.\n" relDirection="3" MidOffset="-3" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="51" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="3" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="62" />
23 jpm 2279
<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="6" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="25" CaptionOffsetY="-3" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="63" />
25 jpm 2280
<RELATION ID="21239" RelationName="fk_cp_cpuap" Kind="1" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpuap_id_personne\n" FKFieldsComments="Identifiant de la personne ayant un rapport avec une publication.\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="53" CaptionOffsetY="-20" StartIntervalOffsetX="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="67" />
23 jpm 2281
<RELATION ID="21241" RelationName="fk_cpu_cpuap" Kind="1" SrcTable="21188" DestTable="21235" FKFields="cpu_id_publication=cpuap_id_publication\n" FKFieldsComments="Identifiant de la publication li\195\169e \195\160 une personne.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="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="68" />
25 jpm 2282
<RELATION ID="21252" RelationName="fk_cp_cpuap_modifier_par" Kind="2" SrcTable="1446" DestTable="21235" FKFields="cp_id_personne=cpuap_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="69" />
2283
<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="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="70" />
24 jpm 2284
<RELATION ID="21496" RelationName="fk_cc_ccar_01" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_01\n" FKFieldsComments="Identifiant de la collection n\194\1761.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="50" CaptionOffsetY="-10" StartIntervalOffsetX="7" StartIntervalOffsetY="-2" EndIntervalOffsetX="6" EndIntervalOffsetY="3" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="61" />
2285
<RELATION ID="21498" RelationName="fk_cc_ccar_02" Kind="1" SrcTable="1444" DestTable="21486" FKFields="cc_id_collection=ccar_id_collection_02\n" FKFieldsComments="Identifiant de la collection n\194\1762.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-19" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="4" EndIntervalOffsetY="6" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="62" />
2286
<RELATION ID="21560" RelationName="fk_cpr_cpar" Kind="1" SrcTable="21522" DestTable="21544" FKFields="cpr_id_projet=cpar_id_projet\n" FKFieldsComments="Identifiant du projet dans lequel la relation entre les deux personnes s\a\195\169tablie.\n" relDirection="2" MidOffset="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="66" />
2287
<RELATION ID="21563" RelationName="fk_cp_cpar_01" Kind="1" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_id_personne_01\n" FKFieldsComments="Identifiant de la personne n\194\1761.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="55" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="67" />
25 jpm 2288
<RELATION ID="21616" RelationName="fk_cs_cpu_editeur" Kind="2" SrcTable="1445" DestTable="21188" FKFields="cs_id_structure=cpu_ce_editeur\n" FKFieldsComments="Identifiant de la structure \195\169ditrice de la publication.\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="73" StartIntervalOffsetY="-38" 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="68" />
23 jpm 2289
<RELATION ID="21622" RelationName="fk_cpr_cp" Kind="2" SrcTable="21522" DestTable="1446" FKFields="cpr_id_projet=cp_ce_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="69" />
2290
<RELATION ID="21625" RelationName="fk_cpr_cs" Kind="2" SrcTable="21522" DestTable="1445" FKFields="cpr_id_projet=cs_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="70" />
25 jpm 2291
<RELATION ID="21628" RelationName="fk_cpr_cc" Kind="2" SrcTable="21522" DestTable="1444" FKFields="cpr_id_projet=cc_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="71" />
23 jpm 2292
<RELATION ID="21631" RelationName="fk_cpr_cpu" Kind="2" SrcTable="21522" DestTable="21188" FKFields="cpr_id_projet=cpu_ce_projet\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="72" />
24 jpm 2293
<RELATION ID="21650" RelationName="fk_cpr_cprv" Kind="2" SrcTable="21522" DestTable="21634" FKFields="cpr_id_projet=cprv_ce_projet\n" FKFieldsComments="Identifiant du projet de la version.\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="74" />
2294
<RELATION ID="21666" RelationName="fk_cp_cpar_02" Kind="1" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_id_personne_02\n" FKFieldsComments="Identifiant de la personne n\194\1762.\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-56" CaptionOffsetY="-24" 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="68" />
25 jpm 2295
<RELATION ID="21737" RelationName="fk_cmt_cmc" Kind="2" SrcTable="18448" DestTable="18456" FKFields="cmt_id_table=cmc_ce_table\n" FKFieldsComments="Identifiant de la table \195\160 laquelle la caract\195\169ristique appartient.\n" relDirection="4" MidOffset="-16" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-48" CaptionOffsetY="-23" 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="68" />
2296
<RELATION ID="21742" RelationName="fk_cp_cprv_modifier_par" Kind="2" SrcTable="1446" DestTable="21634" FKFields="cp_id_personne=cprv_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant modifier l\aenregistrement.\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="69" />
2297
<RELATION ID="21744" RelationName="fk_cp_cpr_modifier_par" Kind="2" SrcTable="1446" DestTable="21522" FKFields="cp_id_personne=cpr_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant modifier l\aenregistrement.\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="70" />
2298
<RELATION ID="21746" RelationName="fk_cp_cpar_modifier_par" Kind="2" SrcTable="1446" DestTable="21544" FKFields="cp_id_personne=cpar_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant modifier l\aenregistrement.\n" relDirection="1" 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="71" />
2299
<RELATION ID="21747" RelationName="fk_cp_ccar_modifier_par" Kind="2" SrcTable="1446" DestTable="21486" FKFields="cp_id_personne=ccar_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant modifier l\aenregistrement.\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="72" />
2300
<RELATION ID="21749" RelationName="fk_cp_ccapu_modifier_par" Kind="2" SrcTable="1446" DestTable="21219" FKFields="cp_id_personne=ccapu_ce_modifier_par\n" FKFieldsComments="Identifiant de la personne ayant modifier l\aenregistrement.\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="73" />
14 jpm 2301
</RELATIONS>
2302
<NOTES>
2303
</NOTES>
2304
<IMAGES>
2305
</IMAGES>
2306
</METADATA>
2307
<PLUGINDATA>
2308
<PLUGINDATARECORDS>
2309
</PLUGINDATARECORDS>
2310
</PLUGINDATA>
2311
<QUERYDATA>
2312
<QUERYRECORDS>
2313
</QUERYRECORDS>
2314
</QUERYDATA>
2315
<LINKEDMODELS>
2316
</LINKEDMODELS>
2317
</DBMODEL>