| 24 |
jpm |
1 |
<?xml version="1.0" standalone="yes" ?>
|
|
|
2 |
<DBMODEL Version="4.0">
|
|
|
3 |
<SETTINGS>
|
| 27 |
jpm |
4 |
<GLOBALSETTINGS ModelName="herbiers" 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="Localhost:tela_prod_herbiers" 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" />
|
| 24 |
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>
|
|
|
235 |
<TABLEPREFIX Name="Defaut (pas de prefixe)" />
|
|
|
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>
|
|
|
261 |
<REGION ID="21326" RegionName="Personne" XPos="16" YPos="8" Width="719" Height="504" RegionColor="4" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="41" />
|
|
|
262 |
<REGION ID="21318" RegionName="Droit" XPos="748" YPos="328" Width="719" Height="184" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="38" />
|
|
|
263 |
<REGION ID="21317" RegionName="Projet" XPos="34" YPos="561" Width="386" Height="183" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="37" />
|
|
|
264 |
<REGION ID="21316" RegionName="Collection" XPos="19" YPos="1163" Width="1264" Height="722" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="36" />
|
|
|
265 |
<REGION ID="21315" RegionName="Structure" XPos="18" YPos="526" Width="1018" Height="625" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="35" />
|
|
|
266 |
<REGION ID="21410" RegionName="Projet" XPos="749" YPos="8" Width="718" Height="307" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="57" />
|
|
|
267 |
</REGIONS>
|
|
|
268 |
<TABLES>
|
|
|
269 |
<TABLE ID="21113" Tablename="EFLORE_DROIT" PrevTableName="" XPos="1183" YPos="386" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
|
|
|
270 |
<COLUMNS>
|
|
|
271 |
<COLUMN ID="21135" ColName="ED_ID_DROIT" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
272 |
<OPTIONSELECTED>
|
|
|
273 |
<OPTIONSELECT Value="0" />
|
|
|
274 |
<OPTIONSELECT Value="0" />
|
|
|
275 |
</OPTIONSELECTED>
|
|
|
276 |
</COLUMN>
|
|
|
277 |
<COLUMN ID="21136" ColName="ED_INTITULE_DROIT" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(50)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
278 |
<OPTIONSELECTED>
|
|
|
279 |
<OPTIONSELECT Value="0" />
|
|
|
280 |
</OPTIONSELECTED>
|
|
|
281 |
</COLUMN>
|
|
|
282 |
<COLUMN ID="21137" ColName="ED_DESCRIPTION_DROIT" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
283 |
<OPTIONSELECTED>
|
|
|
284 |
<OPTIONSELECT Value="0" />
|
|
|
285 |
</OPTIONSELECTED>
|
|
|
286 |
</COLUMN>
|
|
|
287 |
</COLUMNS>
|
|
|
288 |
<RELATIONS_START>
|
|
|
289 |
<RELATION_START ID="21289" />
|
|
|
290 |
</RELATIONS_START>
|
|
|
291 |
<INDICES>
|
|
|
292 |
<INDEX ID="21138" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
293 |
<INDEXCOLUMNS>
|
|
|
294 |
<INDEXCOLUMN idColumn="21135" LengthParam="0" />
|
|
|
295 |
</INDEXCOLUMNS>
|
|
|
296 |
</INDEX>
|
|
|
297 |
<INDEX ID="21139" IndexName="EFLORE_DROIT_PK" IndexKind="1" FKRefDef_Obj_id="-1">
|
|
|
298 |
<INDEXCOLUMNS>
|
|
|
299 |
<INDEXCOLUMN idColumn="21135" LengthParam="0" />
|
|
|
300 |
</INDEXCOLUMNS>
|
|
|
301 |
</INDEX>
|
|
|
302 |
</INDICES>
|
|
|
303 |
</TABLE>
|
|
|
304 |
<TABLE ID="21114" Tablename="EFLORE_DROIT_POSSEDER" PrevTableName="" XPos="815" YPos="385" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >
|
|
|
305 |
<COLUMNS>
|
|
|
306 |
<COLUMN ID="21140" ColName="EDP_ID_UTILISATEUR" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
307 |
<OPTIONSELECTED>
|
|
|
308 |
<OPTIONSELECT Value="0" />
|
|
|
309 |
<OPTIONSELECT Value="0" />
|
|
|
310 |
</OPTIONSELECTED>
|
|
|
311 |
</COLUMN>
|
|
|
312 |
<COLUMN ID="21141" ColName="EDP_ID_PROJET" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
313 |
<OPTIONSELECTED>
|
|
|
314 |
<OPTIONSELECT Value="0" />
|
|
|
315 |
<OPTIONSELECT Value="0" />
|
|
|
316 |
</OPTIONSELECTED>
|
|
|
317 |
</COLUMN>
|
|
|
318 |
<COLUMN ID="21142" ColName="EDP_ID_DROIT" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
319 |
<OPTIONSELECTED>
|
|
|
320 |
<OPTIONSELECT Value="0" />
|
|
|
321 |
<OPTIONSELECT Value="0" />
|
|
|
322 |
</OPTIONSELECTED>
|
|
|
323 |
</COLUMN>
|
|
|
324 |
</COLUMNS>
|
|
|
325 |
<RELATIONS_END>
|
|
|
326 |
<RELATION_END ID="21289" />
|
|
|
327 |
<RELATION_END ID="21291" />
|
|
|
328 |
<RELATION_END ID="21384" />
|
|
|
329 |
</RELATIONS_END>
|
|
|
330 |
<INDICES>
|
|
|
331 |
<INDEX ID="21143" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
332 |
<INDEXCOLUMNS>
|
|
|
333 |
<INDEXCOLUMN idColumn="21140" LengthParam="0" />
|
|
|
334 |
<INDEXCOLUMN idColumn="21141" LengthParam="0" />
|
|
|
335 |
<INDEXCOLUMN idColumn="21142" LengthParam="0" />
|
|
|
336 |
</INDEXCOLUMNS>
|
|
|
337 |
</INDEX>
|
|
|
338 |
</INDICES>
|
|
|
339 |
</TABLE>
|
|
|
340 |
<TABLE ID="21115" Tablename="EFLORE_PROJET" PrevTableName="" XPos="795" YPos="36" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" >
|
|
|
341 |
<COLUMNS>
|
|
|
342 |
<COLUMN ID="21144" ColName="EPR_ID_PROJET" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
343 |
<OPTIONSELECTED>
|
|
|
344 |
<OPTIONSELECT Value="0" />
|
|
|
345 |
<OPTIONSELECT Value="0" />
|
|
|
346 |
</OPTIONSELECTED>
|
|
|
347 |
</COLUMN>
|
|
|
348 |
<COLUMN ID="21145" ColName="EPR_CE_TYPE_PROJET_ORIGINE" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
349 |
<OPTIONSELECTED>
|
|
|
350 |
<OPTIONSELECT Value="0" />
|
|
|
351 |
<OPTIONSELECT Value="0" />
|
|
|
352 |
</OPTIONSELECTED>
|
|
|
353 |
</COLUMN>
|
|
|
354 |
<COLUMN ID="21146" ColName="EPR_CE_OUVRAGE_SOURCE" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
355 |
<OPTIONSELECTED>
|
|
|
356 |
<OPTIONSELECT Value="0" />
|
|
|
357 |
<OPTIONSELECT Value="0" />
|
|
|
358 |
</OPTIONSELECTED>
|
|
|
359 |
</COLUMN>
|
|
|
360 |
<COLUMN ID="21147" ColName="EPR_INTITULE_PROJET" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
361 |
<OPTIONSELECTED>
|
|
|
362 |
<OPTIONSELECT Value="0" />
|
|
|
363 |
</OPTIONSELECTED>
|
|
|
364 |
</COLUMN>
|
|
|
365 |
<COLUMN ID="21148" ColName="EPR_ABREVIATION_PROJET" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(40)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
366 |
<OPTIONSELECTED>
|
|
|
367 |
<OPTIONSELECT Value="0" />
|
|
|
368 |
</OPTIONSELECTED>
|
|
|
369 |
</COLUMN>
|
|
|
370 |
<COLUMN ID="21149" ColName="EPR_DESCRIPTION_PROJET" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
371 |
<OPTIONSELECTED>
|
|
|
372 |
<OPTIONSELECT Value="0" />
|
|
|
373 |
</OPTIONSELECTED>
|
|
|
374 |
</COLUMN>
|
|
|
375 |
<COLUMN ID="21150" ColName="EPR_LIEN_WEB" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
376 |
<OPTIONSELECTED>
|
|
|
377 |
<OPTIONSELECT Value="0" />
|
|
|
378 |
</OPTIONSELECTED>
|
|
|
379 |
</COLUMN>
|
|
|
380 |
<COLUMN ID="21151" ColName="EPR_NOTES_PROJET" PrevColName="" Pos="8" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
381 |
<OPTIONSELECTED>
|
|
|
382 |
</OPTIONSELECTED>
|
|
|
383 |
</COLUMN>
|
|
|
384 |
</COLUMNS>
|
|
|
385 |
<RELATIONS_START>
|
|
|
386 |
<RELATION_START ID="21291" />
|
|
|
387 |
</RELATIONS_START>
|
|
|
388 |
<INDICES>
|
|
|
389 |
<INDEX ID="21152" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
390 |
<INDEXCOLUMNS>
|
|
|
391 |
<INDEXCOLUMN idColumn="21144" LengthParam="0" />
|
|
|
392 |
</INDEXCOLUMNS>
|
|
|
393 |
</INDEX>
|
|
|
394 |
<INDEX ID="21153" IndexName="EFLORE_PROJET_PK" IndexKind="1" FKRefDef_Obj_id="-1">
|
|
|
395 |
<INDEXCOLUMNS>
|
|
|
396 |
<INDEXCOLUMN idColumn="21144" LengthParam="0" />
|
|
|
397 |
</INDEXCOLUMNS>
|
|
|
398 |
</INDEX>
|
|
|
399 |
<INDEX ID="21154" IndexName="POSSEDER_TYPE_PROJET_FK" IndexKind="1" FKRefDef_Obj_id="-1">
|
|
|
400 |
<INDEXCOLUMNS>
|
|
|
401 |
<INDEXCOLUMN idColumn="21145" LengthParam="0" />
|
|
|
402 |
</INDEXCOLUMNS>
|
|
|
403 |
</INDEX>
|
|
|
404 |
<INDEX ID="21155" IndexName="ETRE_BASE_SUR_OUVRAGE_FK" IndexKind="1" FKRefDef_Obj_id="-1">
|
|
|
405 |
<INDEXCOLUMNS>
|
|
|
406 |
<INDEXCOLUMN idColumn="21146" LengthParam="0" />
|
|
|
407 |
</INDEXCOLUMNS>
|
|
|
408 |
</INDEX>
|
|
|
409 |
</INDICES>
|
|
|
410 |
</TABLE>
|
| 27 |
jpm |
411 |
<TABLE ID="21116" Tablename="HERBIERS_ADMINISTRER" PrevTableName="" XPos="76" YPos="353" 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="5" >
|
| 24 |
jpm |
412 |
<COLUMNS>
|
|
|
413 |
<COLUMN ID="21156" ColName="HA_ID_ANNUAIRE" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
414 |
<OPTIONSELECTED>
|
|
|
415 |
<OPTIONSELECT Value="1" />
|
|
|
416 |
<OPTIONSELECT Value="0" />
|
|
|
417 |
</OPTIONSELECTED>
|
|
|
418 |
</COLUMN>
|
|
|
419 |
<COLUMN ID="21157" ColName="HA_ID_ORG" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
420 |
<OPTIONSELECTED>
|
|
|
421 |
<OPTIONSELECT Value="1" />
|
|
|
422 |
<OPTIONSELECT Value="0" />
|
|
|
423 |
</OPTIONSELECTED>
|
|
|
424 |
</COLUMN>
|
|
|
425 |
</COLUMNS>
|
|
|
426 |
<RELATIONS_END>
|
|
|
427 |
<RELATION_END ID="21321" />
|
|
|
428 |
<RELATION_END ID="21390" />
|
|
|
429 |
</RELATIONS_END>
|
|
|
430 |
<INDICES>
|
|
|
431 |
<INDEX ID="21320" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
432 |
<INDEXCOLUMNS>
|
|
|
433 |
<INDEXCOLUMN idColumn="21156" LengthParam="0" />
|
|
|
434 |
<INDEXCOLUMN idColumn="21157" LengthParam="0" />
|
|
|
435 |
</INDEXCOLUMNS>
|
|
|
436 |
</INDEX>
|
|
|
437 |
</INDICES>
|
|
|
438 |
</TABLE>
|
|
|
439 |
<TABLE ID="21117" Tablename="HERBIERS_A_UN_TYPE" PrevTableName="" XPos="325" YPos="1417" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" >
|
|
|
440 |
<COLUMNS>
|
|
|
441 |
<COLUMN ID="21158" ColName="ID_INDIC" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
442 |
<OPTIONSELECTED>
|
|
|
443 |
<OPTIONSELECT Value="0" />
|
|
|
444 |
<OPTIONSELECT Value="0" />
|
|
|
445 |
</OPTIONSELECTED>
|
|
|
446 |
</COLUMN>
|
|
|
447 |
<COLUMN ID="21159" ColName="ID_TYPE" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
448 |
<OPTIONSELECTED>
|
|
|
449 |
<OPTIONSELECT Value="0" />
|
|
|
450 |
<OPTIONSELECT Value="0" />
|
|
|
451 |
</OPTIONSELECTED>
|
|
|
452 |
</COLUMN>
|
|
|
453 |
</COLUMNS>
|
|
|
454 |
<RELATIONS_END>
|
|
|
455 |
<RELATION_END ID="21293" />
|
|
|
456 |
<RELATION_END ID="21294" />
|
|
|
457 |
</RELATIONS_END>
|
|
|
458 |
<INDICES>
|
|
|
459 |
<INDEX ID="21160" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
460 |
<INDEXCOLUMNS>
|
|
|
461 |
<INDEXCOLUMN idColumn="21158" LengthParam="0" />
|
|
|
462 |
<INDEXCOLUMN idColumn="21159" LengthParam="0" />
|
|
|
463 |
</INDEXCOLUMNS>
|
|
|
464 |
</INDEX>
|
|
|
465 |
</INDICES>
|
|
|
466 |
</TABLE>
|
|
|
467 |
<TABLE ID="21118" Tablename="HERBIERS_COLLECTION" PrevTableName="" XPos="597" YPos="1215" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" >
|
|
|
468 |
<COLUMNS>
|
|
|
469 |
<COLUMN ID="21161" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
470 |
<OPTIONSELECTED>
|
|
|
471 |
<OPTIONSELECT Value="0" />
|
|
|
472 |
<OPTIONSELECT Value="0" />
|
|
|
473 |
</OPTIONSELECTED>
|
|
|
474 |
</COLUMN>
|
|
|
475 |
<COLUMN ID="21162" ColName="PARENT_ID" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
476 |
<OPTIONSELECTED>
|
|
|
477 |
<OPTIONSELECT Value="0" />
|
|
|
478 |
<OPTIONSELECT Value="0" />
|
|
|
479 |
</OPTIONSELECTED>
|
|
|
480 |
</COLUMN>
|
|
|
481 |
<COLUMN ID="21163" ColName="LEVEL" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
482 |
<OPTIONSELECTED>
|
|
|
483 |
<OPTIONSELECT Value="0" />
|
|
|
484 |
</OPTIONSELECTED>
|
|
|
485 |
</COLUMN>
|
|
|
486 |
<COLUMN ID="21164" ColName="COLLECTION_CODE" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(64)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
487 |
<OPTIONSELECTED>
|
|
|
488 |
<OPTIONSELECT Value="0" />
|
|
|
489 |
</OPTIONSELECTED>
|
|
|
490 |
</COLUMN>
|
|
|
491 |
<COLUMN ID="21165" ColName="NOM_COLLECTION" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
492 |
<OPTIONSELECTED>
|
|
|
493 |
<OPTIONSELECT Value="0" />
|
|
|
494 |
</OPTIONSELECTED>
|
|
|
495 |
</COLUMN>
|
|
|
496 |
<COLUMN ID="21166" ColName="DESCRIPTION" PrevColName="" Pos="6" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
497 |
<OPTIONSELECTED>
|
|
|
498 |
</OPTIONSELECTED>
|
|
|
499 |
</COLUMN>
|
|
|
500 |
<COLUMN ID="21167" ColName="STATUT" PrevColName="" Pos="7" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="1" Comments="">
|
|
|
501 |
<OPTIONSELECTED>
|
|
|
502 |
<OPTIONSELECT Value="1" />
|
|
|
503 |
<OPTIONSELECT Value="0" />
|
|
|
504 |
</OPTIONSELECTED>
|
|
|
505 |
</COLUMN>
|
|
|
506 |
<COLUMN ID="21168" ColName="URL" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
507 |
<OPTIONSELECTED>
|
|
|
508 |
<OPTIONSELECT Value="0" />
|
|
|
509 |
</OPTIONSELECTED>
|
|
|
510 |
</COLUMN>
|
|
|
511 |
<COLUMN ID="21169" ColName="INCLUDED_TYPE" PrevColName="" Pos="9" idDatatype="1" DatatypeParams="(4)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
512 |
<OPTIONSELECTED>
|
|
|
513 |
<OPTIONSELECT Value="0" />
|
|
|
514 |
<OPTIONSELECT Value="0" />
|
|
|
515 |
</OPTIONSELECTED>
|
|
|
516 |
</COLUMN>
|
|
|
517 |
<COLUMN ID="21170" ColName="STRENGTH" PrevColName="" Pos="10" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
518 |
<OPTIONSELECTED>
|
|
|
519 |
</OPTIONSELECTED>
|
|
|
520 |
</COLUMN>
|
|
|
521 |
<COLUMN ID="21171" ColName="PURPOSE" PrevColName="" Pos="11" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
522 |
<OPTIONSELECTED>
|
|
|
523 |
</OPTIONSELECTED>
|
|
|
524 |
</COLUMN>
|
|
|
525 |
<COLUMN ID="21172" ColName="NUM_ORGANISATION" PrevColName="" Pos="12" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
526 |
<OPTIONSELECTED>
|
|
|
527 |
<OPTIONSELECT Value="0" />
|
|
|
528 |
<OPTIONSELECT Value="0" />
|
|
|
529 |
</OPTIONSELECTED>
|
|
|
530 |
</COLUMN>
|
|
|
531 |
<COLUMN ID="21173" ColName="NUM_SPECIMENS" PrevColName="" Pos="13" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
532 |
<OPTIONSELECTED>
|
|
|
533 |
<OPTIONSELECT Value="0" />
|
|
|
534 |
<OPTIONSELECT Value="0" />
|
|
|
535 |
</OPTIONSELECTED>
|
|
|
536 |
</COLUMN>
|
|
|
537 |
<COLUMN ID="21174" ColName="NUM_SPECIES" PrevColName="" Pos="14" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
538 |
<OPTIONSELECTED>
|
|
|
539 |
<OPTIONSELECT Value="0" />
|
|
|
540 |
<OPTIONSELECT Value="0" />
|
|
|
541 |
</OPTIONSELECTED>
|
|
|
542 |
</COLUMN>
|
|
|
543 |
<COLUMN ID="21175" ColName="DOC_STATE" PrevColName="" Pos="15" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
544 |
<OPTIONSELECTED>
|
|
|
545 |
</OPTIONSELECTED>
|
|
|
546 |
</COLUMN>
|
|
|
547 |
<COLUMN ID="21176" ColName="PERCENT_DATABASED" PrevColName="" Pos="16" idDatatype="2" DatatypeParams="(6)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
548 |
<OPTIONSELECTED>
|
|
|
549 |
<OPTIONSELECT Value="0" />
|
|
|
550 |
<OPTIONSELECT Value="0" />
|
|
|
551 |
</OPTIONSELECTED>
|
|
|
552 |
</COLUMN>
|
|
|
553 |
<COLUMN ID="21177" ColName="BIOCASE_URL" PrevColName="" Pos="17" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
554 |
<OPTIONSELECTED>
|
|
|
555 |
<OPTIONSELECT Value="0" />
|
|
|
556 |
</OPTIONSELECTED>
|
|
|
557 |
</COLUMN>
|
|
|
558 |
<COLUMN ID="21178" ColName="ACCESS_RESTRICTION" PrevColName="" Pos="18" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
559 |
<OPTIONSELECTED>
|
|
|
560 |
</OPTIONSELECTED>
|
|
|
561 |
</COLUMN>
|
|
|
562 |
<COLUMN ID="21179" ColName="USAGE_RESTRICTION" PrevColName="" Pos="19" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
563 |
<OPTIONSELECTED>
|
|
|
564 |
</OPTIONSELECTED>
|
|
|
565 |
</COLUMN>
|
|
|
566 |
<COLUMN ID="21180" ColName="COLLECTION_ACTIVITY" PrevColName="" Pos="20" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
567 |
<OPTIONSELECTED>
|
|
|
568 |
<OPTIONSELECT Value="0" />
|
|
|
569 |
</OPTIONSELECTED>
|
|
|
570 |
</COLUMN>
|
|
|
571 |
<COLUMN ID="21181" ColName="COLLECTION_FOCUS" PrevColName="" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
572 |
<OPTIONSELECTED>
|
|
|
573 |
<OPTIONSELECT Value="0" />
|
|
|
574 |
</OPTIONSELECTED>
|
|
|
575 |
</COLUMN>
|
|
|
576 |
<COLUMN ID="21182" ColName="NOTES" PrevColName="" Pos="22" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
577 |
<OPTIONSELECTED>
|
|
|
578 |
</OPTIONSELECTED>
|
|
|
579 |
</COLUMN>
|
|
|
580 |
<COLUMN ID="21183" ColName="COLLECTION_CLASS" PrevColName="" Pos="23" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="">
|
|
|
581 |
<OPTIONSELECTED>
|
|
|
582 |
<OPTIONSELECT Value="1" />
|
|
|
583 |
<OPTIONSELECT Value="0" />
|
|
|
584 |
</OPTIONSELECTED>
|
|
|
585 |
</COLUMN>
|
|
|
586 |
<COLUMN ID="21184" ColName="COLLECTEURS" PrevColName="" Pos="24" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
587 |
<OPTIONSELECTED>
|
|
|
588 |
</OPTIONSELECTED>
|
|
|
589 |
</COLUMN>
|
|
|
590 |
<COLUMN ID="21185" ColName="DATE_DEBUT" PrevColName="" Pos="25" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
|
|
|
591 |
<OPTIONSELECTED>
|
|
|
592 |
</OPTIONSELECTED>
|
|
|
593 |
</COLUMN>
|
|
|
594 |
<COLUMN ID="21186" ColName="DATE_FIN" PrevColName="" Pos="26" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
|
|
|
595 |
<OPTIONSELECTED>
|
|
|
596 |
</OPTIONSELECTED>
|
|
|
597 |
</COLUMN>
|
|
|
598 |
<COLUMN ID="21187" ColName="DATE_DEBUT_CARAC" PrevColName="" Pos="27" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="1" Comments="">
|
|
|
599 |
<OPTIONSELECTED>
|
|
|
600 |
<OPTIONSELECT Value="1" />
|
|
|
601 |
<OPTIONSELECT Value="0" />
|
|
|
602 |
</OPTIONSELECTED>
|
|
|
603 |
</COLUMN>
|
|
|
604 |
<COLUMN ID="21188" ColName="DATE_FIN_CARAC" PrevColName="" Pos="28" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="1" Comments="">
|
|
|
605 |
<OPTIONSELECTED>
|
|
|
606 |
<OPTIONSELECT Value="1" />
|
|
|
607 |
<OPTIONSELECT Value="0" />
|
|
|
608 |
</OPTIONSELECTED>
|
|
|
609 |
</COLUMN>
|
|
|
610 |
<COLUMN ID="21189" ColName="PREC_SPECIMENS" PrevColName="" Pos="29" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="3" Comments="">
|
|
|
611 |
<OPTIONSELECTED>
|
|
|
612 |
<OPTIONSELECT Value="1" />
|
|
|
613 |
<OPTIONSELECT Value="0" />
|
|
|
614 |
</OPTIONSELECTED>
|
|
|
615 |
</COLUMN>
|
|
|
616 |
<COLUMN ID="21190" ColName="PREC_SPECIES" PrevColName="" Pos="30" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="3" Comments="">
|
|
|
617 |
<OPTIONSELECTED>
|
|
|
618 |
<OPTIONSELECT Value="1" />
|
|
|
619 |
<OPTIONSELECT Value="0" />
|
|
|
620 |
</OPTIONSELECTED>
|
|
|
621 |
</COLUMN>
|
|
|
622 |
<COLUMN ID="21191" ColName="ETAT_SPECIMENS" PrevColName="" Pos="31" idDatatype="31" DatatypeParams="(\a1\a,\a2\a,\a3\a,\a4\a)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="">
|
|
|
623 |
<OPTIONSELECTED>
|
|
|
624 |
</OPTIONSELECTED>
|
|
|
625 |
</COLUMN>
|
|
|
626 |
<COLUMN ID="21192" ColName="ETAT_CLASSEMENT" PrevColName="" Pos="32" idDatatype="31" DatatypeParams="(\a1\a,\a2\a,\a3\a,\a4\a)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="">
|
|
|
627 |
<OPTIONSELECTED>
|
|
|
628 |
</OPTIONSELECTED>
|
|
|
629 |
</COLUMN>
|
|
|
630 |
<COLUMN ID="21193" ColName="ETAT_PRESENTATION" PrevColName="" Pos="33" idDatatype="31" DatatypeParams="(\a1\a,\a2\a,\a3\a,\a4\a)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="">
|
|
|
631 |
<OPTIONSELECTED>
|
|
|
632 |
</OPTIONSELECTED>
|
|
|
633 |
</COLUMN>
|
|
|
634 |
<COLUMN ID="21194" ColName="MODE_CLASSEMENT" PrevColName="" Pos="34" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
635 |
<OPTIONSELECTED>
|
|
|
636 |
</OPTIONSELECTED>
|
|
|
637 |
</COLUMN>
|
|
|
638 |
<COLUMN ID="21195" ColName="DATE_DERNIERE_MODIF" PrevColName="" Pos="35" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="">
|
|
|
639 |
<OPTIONSELECTED>
|
|
|
640 |
</OPTIONSELECTED>
|
|
|
641 |
</COLUMN>
|
|
|
642 |
<COLUMN ID="21196" ColName="CE_MODIFIER_PAR" PrevColName="" Pos="36" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
643 |
<OPTIONSELECTED>
|
|
|
644 |
<OPTIONSELECT Value="0" />
|
|
|
645 |
<OPTIONSELECT Value="0" />
|
|
|
646 |
</OPTIONSELECTED>
|
|
|
647 |
</COLUMN>
|
|
|
648 |
</COLUMNS>
|
|
|
649 |
<RELATIONS_START>
|
|
|
650 |
<RELATION_START ID="21296" />
|
|
|
651 |
<RELATION_START ID="21324" />
|
|
|
652 |
<RELATION_START ID="21387" />
|
|
|
653 |
</RELATIONS_START>
|
|
|
654 |
<RELATIONS_END>
|
|
|
655 |
<RELATION_END ID="21297" />
|
|
|
656 |
<RELATION_END ID="21299" />
|
|
|
657 |
<RELATION_END ID="21324" />
|
|
|
658 |
<RELATION_END ID="21388" />
|
|
|
659 |
<RELATION_END ID="21392" />
|
|
|
660 |
<RELATION_END ID="21396" />
|
|
|
661 |
<RELATION_END ID="21406" />
|
|
|
662 |
<RELATION_END ID="21408" />
|
|
|
663 |
</RELATIONS_END>
|
|
|
664 |
<INDICES>
|
|
|
665 |
<INDEX ID="21197" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
666 |
<INDEXCOLUMNS>
|
|
|
667 |
<INDEXCOLUMN idColumn="21161" LengthParam="0" />
|
|
|
668 |
</INDEXCOLUMNS>
|
|
|
669 |
</INDEX>
|
|
|
670 |
</INDICES>
|
|
|
671 |
</TABLE>
|
|
|
672 |
<TABLE ID="21119" Tablename="HERBIERS_COLL_STATUT" PrevTableName="" XPos="972" YPos="1744" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
|
|
|
673 |
<COLUMNS>
|
|
|
674 |
<COLUMN ID="21198" ColName="ID_COLL_STATUT" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
675 |
<OPTIONSELECTED>
|
|
|
676 |
<OPTIONSELECT Value="1" />
|
|
|
677 |
<OPTIONSELECT Value="0" />
|
|
|
678 |
</OPTIONSELECTED>
|
|
|
679 |
</COLUMN>
|
|
|
680 |
<COLUMN ID="21199" ColName="LABEL" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
681 |
<OPTIONSELECTED>
|
|
|
682 |
<OPTIONSELECT Value="0" />
|
|
|
683 |
</OPTIONSELECTED>
|
|
|
684 |
</COLUMN>
|
|
|
685 |
</COLUMNS>
|
|
|
686 |
<RELATIONS_START>
|
|
|
687 |
<RELATION_START ID="21388" />
|
|
|
688 |
</RELATIONS_START>
|
|
|
689 |
<INDICES>
|
|
|
690 |
<INDEX ID="21200" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
691 |
<INDEXCOLUMNS>
|
|
|
692 |
<INDEXCOLUMN idColumn="21198" LengthParam="0" />
|
|
|
693 |
</INDEXCOLUMNS>
|
|
|
694 |
</INDEX>
|
|
|
695 |
</INDICES>
|
|
|
696 |
</TABLE>
|
|
|
697 |
<TABLE ID="21120" Tablename="HERBIERS_COORDONNE" PrevTableName="" XPos="23" YPos="142" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" >
|
|
|
698 |
<COLUMNS>
|
|
|
699 |
<COLUMN ID="21201" ColName="HC_ID_COORDINATEUR" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
700 |
<OPTIONSELECTED>
|
|
|
701 |
<OPTIONSELECT Value="1" />
|
|
|
702 |
<OPTIONSELECT Value="0" />
|
|
|
703 |
</OPTIONSELECTED>
|
|
|
704 |
</COLUMN>
|
|
|
705 |
<COLUMN ID="21202" ColName="HC_ID_REDACTEUR" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
706 |
<OPTIONSELECTED>
|
|
|
707 |
<OPTIONSELECT Value="1" />
|
|
|
708 |
<OPTIONSELECT Value="0" />
|
|
|
709 |
</OPTIONSELECTED>
|
|
|
710 |
</COLUMN>
|
|
|
711 |
</COLUMNS>
|
|
|
712 |
<RELATIONS_END>
|
|
|
713 |
<RELATION_END ID="21402" />
|
|
|
714 |
<RELATION_END ID="21404" />
|
|
|
715 |
</RELATIONS_END>
|
|
|
716 |
<INDICES>
|
|
|
717 |
<INDEX ID="21203" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
718 |
<INDEXCOLUMNS>
|
|
|
719 |
<INDEXCOLUMN idColumn="21201" LengthParam="0" />
|
|
|
720 |
<INDEXCOLUMN idColumn="21202" LengthParam="0" />
|
|
|
721 |
</INDEXCOLUMNS>
|
|
|
722 |
</INDEX>
|
|
|
723 |
</INDICES>
|
|
|
724 |
</TABLE>
|
|
|
725 |
<TABLE ID="21121" Tablename="HERBIERS_DATE_DEBUT_CARAC" PrevTableName="" XPos="971" YPos="1585" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="10" >
|
|
|
726 |
<COLUMNS>
|
|
|
727 |
<COLUMN ID="21204" ColName="ID_DATE_CARAC" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
728 |
<OPTIONSELECTED>
|
|
|
729 |
<OPTIONSELECT Value="1" />
|
|
|
730 |
<OPTIONSELECT Value="0" />
|
|
|
731 |
</OPTIONSELECTED>
|
|
|
732 |
</COLUMN>
|
|
|
733 |
<COLUMN ID="21205" ColName="LABEL_DATE_DEBUT_CARAC" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
734 |
<OPTIONSELECTED>
|
|
|
735 |
<OPTIONSELECT Value="0" />
|
|
|
736 |
</OPTIONSELECTED>
|
|
|
737 |
</COLUMN>
|
|
|
738 |
</COLUMNS>
|
|
|
739 |
<RELATIONS_START>
|
|
|
740 |
<RELATION_START ID="21297" />
|
|
|
741 |
</RELATIONS_START>
|
|
|
742 |
<INDICES>
|
|
|
743 |
<INDEX ID="21206" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
744 |
<INDEXCOLUMNS>
|
|
|
745 |
<INDEXCOLUMN idColumn="21204" LengthParam="0" />
|
|
|
746 |
</INDEXCOLUMNS>
|
|
|
747 |
</INDEX>
|
|
|
748 |
</INDICES>
|
|
|
749 |
</TABLE>
|
|
|
750 |
<TABLE ID="21122" Tablename="HERBIERS_DATE_FIN_CARAC" PrevTableName="" XPos="972" YPos="1663" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="11" >
|
|
|
751 |
<COLUMNS>
|
|
|
752 |
<COLUMN ID="21207" ColName="ID_DATE_CARAC" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
753 |
<OPTIONSELECTED>
|
|
|
754 |
<OPTIONSELECT Value="1" />
|
|
|
755 |
<OPTIONSELECT Value="0" />
|
|
|
756 |
</OPTIONSELECTED>
|
|
|
757 |
</COLUMN>
|
|
|
758 |
<COLUMN ID="21208" ColName="LABEL_DATE_FIN_CARAC" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
759 |
<OPTIONSELECTED>
|
|
|
760 |
<OPTIONSELECT Value="0" />
|
|
|
761 |
</OPTIONSELECTED>
|
|
|
762 |
</COLUMN>
|
|
|
763 |
</COLUMNS>
|
|
|
764 |
<RELATIONS_START>
|
|
|
765 |
<RELATION_START ID="21299" />
|
|
|
766 |
</RELATIONS_START>
|
|
|
767 |
<INDICES>
|
|
|
768 |
<INDEX ID="21209" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
769 |
<INDEXCOLUMNS>
|
|
|
770 |
<INDEXCOLUMN idColumn="21207" LengthParam="0" />
|
|
|
771 |
</INDEXCOLUMNS>
|
|
|
772 |
</INDEX>
|
|
|
773 |
</INDICES>
|
|
|
774 |
</TABLE>
|
|
|
775 |
<TABLE ID="21123" Tablename="HERBIERS_DENOMBREMENT_CARAC_SC" PrevTableName="" XPos="996" YPos="1427" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="12" >
|
|
|
776 |
<COLUMNS>
|
|
|
777 |
<COLUMN ID="21210" ColName="HDC_ID" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
778 |
<OPTIONSELECTED>
|
|
|
779 |
<OPTIONSELECT Value="1" />
|
|
|
780 |
<OPTIONSELECT Value="0" />
|
|
|
781 |
</OPTIONSELECTED>
|
|
|
782 |
</COLUMN>
|
|
|
783 |
<COLUMN ID="21211" ColName="HDC_LABEL" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
784 |
<OPTIONSELECTED>
|
|
|
785 |
<OPTIONSELECT Value="0" />
|
|
|
786 |
</OPTIONSELECTED>
|
|
|
787 |
</COLUMN>
|
|
|
788 |
</COLUMNS>
|
|
|
789 |
<RELATIONS_START>
|
|
|
790 |
<RELATION_START ID="21408" />
|
|
|
791 |
</RELATIONS_START>
|
|
|
792 |
<INDICES>
|
|
|
793 |
<INDEX ID="21212" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
794 |
<INDEXCOLUMNS>
|
|
|
795 |
<INDEXCOLUMN idColumn="21210" LengthParam="0" />
|
|
|
796 |
</INDEXCOLUMNS>
|
|
|
797 |
</INDEX>
|
|
|
798 |
</INDICES>
|
|
|
799 |
</TABLE>
|
|
|
800 |
<TABLE ID="21124" Tablename="HERBIERS_DENOMBREMENT_CARAC_SP" PrevTableName="" XPos="971" YPos="1504" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" >
|
|
|
801 |
<COLUMNS>
|
|
|
802 |
<COLUMN ID="21213" ColName="HDC_ID" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
803 |
<OPTIONSELECTED>
|
|
|
804 |
<OPTIONSELECT Value="1" />
|
|
|
805 |
<OPTIONSELECT Value="0" />
|
|
|
806 |
</OPTIONSELECTED>
|
|
|
807 |
</COLUMN>
|
|
|
808 |
<COLUMN ID="21214" ColName="HDC_LABEL" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
809 |
<OPTIONSELECTED>
|
|
|
810 |
<OPTIONSELECT Value="0" />
|
|
|
811 |
</OPTIONSELECTED>
|
|
|
812 |
</COLUMN>
|
|
|
813 |
</COLUMNS>
|
|
|
814 |
<RELATIONS_START>
|
|
|
815 |
<RELATION_START ID="21406" />
|
|
|
816 |
</RELATIONS_START>
|
|
|
817 |
<INDICES>
|
|
|
818 |
<INDEX ID="21215" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
819 |
<INDEXCOLUMNS>
|
|
|
820 |
<INDEXCOLUMN idColumn="21213" LengthParam="0" />
|
|
|
821 |
</INDEXCOLUMNS>
|
|
|
822 |
</INDEX>
|
|
|
823 |
</INDICES>
|
|
|
824 |
</TABLE>
|
|
|
825 |
<TABLE ID="21125" Tablename="HERBIERS_INDIC" PrevTableName="" XPos="344" YPos="1249" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="14" >
|
|
|
826 |
<COLUMNS>
|
|
|
827 |
<COLUMN ID="21216" ColName="ID_INDIC" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
828 |
<OPTIONSELECTED>
|
|
|
829 |
<OPTIONSELECT Value="0" />
|
|
|
830 |
<OPTIONSELECT Value="0" />
|
|
|
831 |
</OPTIONSELECTED>
|
|
|
832 |
</COLUMN>
|
|
|
833 |
<COLUMN ID="21217" ColName="ID" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
834 |
<OPTIONSELECTED>
|
|
|
835 |
<OPTIONSELECT Value="0" />
|
|
|
836 |
<OPTIONSELECT Value="0" />
|
|
|
837 |
</OPTIONSELECTED>
|
|
|
838 |
</COLUMN>
|
|
|
839 |
<COLUMN ID="21218" ColName="REM_INDIC" PrevColName="" Pos="3" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
840 |
<OPTIONSELECTED>
|
|
|
841 |
</OPTIONSELECTED>
|
|
|
842 |
</COLUMN>
|
|
|
843 |
<COLUMN ID="21219" ColName="MAJ_INDIC" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
844 |
<OPTIONSELECTED>
|
|
|
845 |
<OPTIONSELECT Value="0" />
|
|
|
846 |
<OPTIONSELECT Value="0" />
|
|
|
847 |
</OPTIONSELECTED>
|
|
|
848 |
</COLUMN>
|
|
|
849 |
<COLUMN ID="21220" ColName="TXT_INDIC" PrevColName="" Pos="5" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
850 |
<OPTIONSELECTED>
|
|
|
851 |
</OPTIONSELECTED>
|
|
|
852 |
</COLUMN>
|
|
|
853 |
</COLUMNS>
|
|
|
854 |
<RELATIONS_START>
|
|
|
855 |
<RELATION_START ID="21294" />
|
|
|
856 |
<RELATION_START ID="21295" />
|
|
|
857 |
</RELATIONS_START>
|
|
|
858 |
<RELATIONS_END>
|
|
|
859 |
<RELATION_END ID="21296" />
|
|
|
860 |
</RELATIONS_END>
|
|
|
861 |
<INDICES>
|
|
|
862 |
<INDEX ID="21221" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
863 |
<INDEXCOLUMNS>
|
|
|
864 |
<INDEXCOLUMN idColumn="21216" LengthParam="0" />
|
|
|
865 |
</INDEXCOLUMNS>
|
|
|
866 |
</INDEX>
|
|
|
867 |
</INDICES>
|
|
|
868 |
</TABLE>
|
|
|
869 |
<TABLE ID="21126" Tablename="HERBIERS_INDIC_HISTORIQUE" PrevTableName="" XPos="27" YPos="1243" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" >
|
|
|
870 |
<COLUMNS>
|
|
|
871 |
<COLUMN ID="21222" ColName="ID_INDIC_HIST" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
872 |
<OPTIONSELECTED>
|
|
|
873 |
<OPTIONSELECT Value="1" />
|
|
|
874 |
<OPTIONSELECT Value="0" />
|
|
|
875 |
</OPTIONSELECTED>
|
|
|
876 |
</COLUMN>
|
|
|
877 |
<COLUMN ID="21223" ColName="ID_INDIC" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
878 |
<OPTIONSELECTED>
|
|
|
879 |
<OPTIONSELECT Value="1" />
|
|
|
880 |
<OPTIONSELECT Value="0" />
|
|
|
881 |
</OPTIONSELECTED>
|
|
|
882 |
</COLUMN>
|
|
|
883 |
<COLUMN ID="21224" ColName="DATE_INDIC" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
884 |
<OPTIONSELECTED>
|
|
|
885 |
<OPTIONSELECT Value="1" />
|
|
|
886 |
<OPTIONSELECT Value="0" />
|
|
|
887 |
</OPTIONSELECTED>
|
|
|
888 |
</COLUMN>
|
|
|
889 |
<COLUMN ID="21225" ColName="ID_INDICATEUR" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
890 |
<OPTIONSELECTED>
|
|
|
891 |
<OPTIONSELECT Value="1" />
|
|
|
892 |
<OPTIONSELECT Value="0" />
|
|
|
893 |
</OPTIONSELECTED>
|
|
|
894 |
</COLUMN>
|
|
|
895 |
</COLUMNS>
|
|
|
896 |
<RELATIONS_END>
|
|
|
897 |
<RELATION_END ID="21295" />
|
|
|
898 |
<RELATION_END ID="21394" />
|
|
|
899 |
</RELATIONS_END>
|
|
|
900 |
<INDICES>
|
|
|
901 |
<INDEX ID="21226" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
902 |
<INDEXCOLUMNS>
|
|
|
903 |
<INDEXCOLUMN idColumn="21222" LengthParam="0" />
|
|
|
904 |
</INDEXCOLUMNS>
|
|
|
905 |
</INDEX>
|
|
|
906 |
</INDICES>
|
|
|
907 |
</TABLE>
|
|
|
908 |
<TABLE ID="21127" Tablename="HERBIERS_ORGANISATION" PrevTableName="" XPos="95" YPos="726" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" >
|
|
|
909 |
<COLUMNS>
|
|
|
910 |
<COLUMN ID="21227" ColName="ID_ORG" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
911 |
<OPTIONSELECTED>
|
|
|
912 |
<OPTIONSELECT Value="0" />
|
|
|
913 |
<OPTIONSELECT Value="0" />
|
|
|
914 |
</OPTIONSELECTED>
|
|
|
915 |
</COLUMN>
|
|
|
916 |
<COLUMN ID="21228" ColName="NUM_COLLECTION" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
917 |
<OPTIONSELECTED>
|
|
|
918 |
<OPTIONSELECT Value="0" />
|
|
|
919 |
<OPTIONSELECT Value="0" />
|
|
|
920 |
</OPTIONSELECTED>
|
|
|
921 |
</COLUMN>
|
|
|
922 |
<COLUMN ID="21229" ColName="ADRESS_TEXT" PrevColName="" Pos="3" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
923 |
<OPTIONSELECTED>
|
|
|
924 |
</OPTIONSELECTED>
|
|
|
925 |
</COLUMN>
|
|
|
926 |
<COLUMN ID="21230" ColName="INSTITUTION_NAME" PrevColName="" Pos="4" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
927 |
<OPTIONSELECTED>
|
|
|
928 |
</OPTIONSELECTED>
|
|
|
929 |
</COLUMN>
|
|
|
930 |
<COLUMN ID="21231" ColName="ADRESS_LINE" PrevColName="" Pos="5" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
931 |
<OPTIONSELECTED>
|
|
|
932 |
</OPTIONSELECTED>
|
|
|
933 |
</COLUMN>
|
|
|
934 |
<COLUMN ID="21232" ColName="TOWN" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
935 |
<OPTIONSELECTED>
|
|
|
936 |
<OPTIONSELECT Value="0" />
|
|
|
937 |
</OPTIONSELECTED>
|
|
|
938 |
</COLUMN>
|
|
|
939 |
<COLUMN ID="21233" ColName="REGION" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
940 |
<OPTIONSELECTED>
|
|
|
941 |
<OPTIONSELECT Value="0" />
|
|
|
942 |
</OPTIONSELECTED>
|
|
|
943 |
</COLUMN>
|
|
|
944 |
<COLUMN ID="21313" ColName="COUNTRY_CODE" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(5)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
945 |
<OPTIONSELECTED>
|
|
|
946 |
<OPTIONSELECT Value="0" />
|
|
|
947 |
</OPTIONSELECTED>
|
|
|
948 |
</COLUMN>
|
|
|
949 |
<COLUMN ID="21235" ColName="ZIP" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(16)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
950 |
<OPTIONSELECTED>
|
|
|
951 |
<OPTIONSELECT Value="0" />
|
|
|
952 |
</OPTIONSELECTED>
|
|
|
953 |
</COLUMN>
|
|
|
954 |
<COLUMN ID="21236" ColName="TEL" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(64)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
955 |
<OPTIONSELECTED>
|
|
|
956 |
<OPTIONSELECT Value="0" />
|
|
|
957 |
</OPTIONSELECTED>
|
|
|
958 |
</COLUMN>
|
|
|
959 |
<COLUMN ID="21237" ColName="FAX" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(64)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
960 |
<OPTIONSELECTED>
|
|
|
961 |
<OPTIONSELECT Value="0" />
|
|
|
962 |
</OPTIONSELECTED>
|
|
|
963 |
</COLUMN>
|
|
|
964 |
<COLUMN ID="21238" ColName="EMAIL" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
965 |
<OPTIONSELECTED>
|
|
|
966 |
<OPTIONSELECT Value="0" />
|
|
|
967 |
</OPTIONSELECTED>
|
|
|
968 |
</COLUMN>
|
|
|
969 |
<COLUMN ID="21239" ColName="HO_URL" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="http://" Comments="">
|
|
|
970 |
<OPTIONSELECTED>
|
|
|
971 |
<OPTIONSELECT Value="0" />
|
|
|
972 |
</OPTIONSELECTED>
|
|
|
973 |
</COLUMN>
|
|
|
974 |
<COLUMN ID="21240" ColName="LOGO" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
975 |
<OPTIONSELECTED>
|
|
|
976 |
<OPTIONSELECT Value="0" />
|
|
|
977 |
</OPTIONSELECTED>
|
|
|
978 |
</COLUMN>
|
|
|
979 |
<COLUMN ID="21241" ColName="TIME_ZONE" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
980 |
<OPTIONSELECTED>
|
|
|
981 |
<OPTIONSELECT Value="0" />
|
|
|
982 |
</OPTIONSELECTED>
|
|
|
983 |
</COLUMN>
|
|
|
984 |
<COLUMN ID="21242" ColName="ORGANISATION_CLASS" PrevColName="" Pos="16" idDatatype="31" DatatypeParams="(\aBotanic_Garden\a,\aZoo\a,\aHoticultural\a,\aMuseum\a,\aHerbarium\a,\aLaboratory\a,\aOther\a)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="Botanic_Garden" Comments="">
|
|
|
985 |
<OPTIONSELECTED>
|
|
|
986 |
</OPTIONSELECTED>
|
|
|
987 |
</COLUMN>
|
|
|
988 |
<COLUMN ID="21243" ColName="COLLECTION_CLASS" PrevColName="" Pos="17" idDatatype="31" DatatypeParams="(\aliving\a,\adormant\a,\aculture\a,\apreserved\a,\aobservations\a,\aphotography\a,\afossil\a,\aother\a)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="living" Comments="">
|
|
|
989 |
<OPTIONSELECTED>
|
|
|
990 |
</OPTIONSELECTED>
|
|
|
991 |
</COLUMN>
|
|
|
992 |
<COLUMN ID="21244" ColName="INDEX_HERB" PrevColName="" Pos="18" idDatatype="20" DatatypeParams="(16)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
993 |
<OPTIONSELECTED>
|
|
|
994 |
<OPTIONSELECT Value="0" />
|
|
|
995 |
</OPTIONSELECTED>
|
|
|
996 |
</COLUMN>
|
|
|
997 |
<COLUMN ID="21245" ColName="ACCESS_RESTRICTION" PrevColName="" Pos="19" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
998 |
<OPTIONSELECTED>
|
|
|
999 |
</OPTIONSELECTED>
|
|
|
1000 |
</COLUMN>
|
|
|
1001 |
<COLUMN ID="21246" ColName="STATUT_PUBLICATION" PrevColName="" Pos="20" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1002 |
<OPTIONSELECTED>
|
|
|
1003 |
<OPTIONSELECT Value="1" />
|
|
|
1004 |
<OPTIONSELECT Value="0" />
|
|
|
1005 |
</OPTIONSELECTED>
|
|
|
1006 |
</COLUMN>
|
|
|
1007 |
<COLUMN ID="21247" ColName="SOURCE_DES_DONNEES" PrevColName="" Pos="21" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="IH - Index Herbariorum" Comments="">
|
|
|
1008 |
<OPTIONSELECTED>
|
|
|
1009 |
<OPTIONSELECT Value="0" />
|
|
|
1010 |
</OPTIONSELECTED>
|
|
|
1011 |
</COLUMN>
|
|
|
1012 |
<COLUMN ID="21248" ColName="DATE_DERNIERE_MODIF" PrevColName="" Pos="22" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="">
|
|
|
1013 |
<OPTIONSELECTED>
|
|
|
1014 |
</OPTIONSELECTED>
|
|
|
1015 |
</COLUMN>
|
|
|
1016 |
<COLUMN ID="21249" ColName="CE_MODIFIER_PAR" PrevColName="" Pos="23" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1017 |
<OPTIONSELECTED>
|
|
|
1018 |
<OPTIONSELECT Value="0" />
|
|
|
1019 |
<OPTIONSELECT Value="0" />
|
|
|
1020 |
</OPTIONSELECTED>
|
|
|
1021 |
</COLUMN>
|
|
|
1022 |
</COLUMNS>
|
|
|
1023 |
<RELATIONS_START>
|
|
|
1024 |
<RELATION_START ID="21301" />
|
|
|
1025 |
<RELATION_START ID="21321" />
|
|
|
1026 |
<RELATION_START ID="21392" />
|
|
|
1027 |
</RELATIONS_START>
|
|
|
1028 |
<RELATIONS_END>
|
|
|
1029 |
<RELATION_END ID="21308" />
|
|
|
1030 |
<RELATION_END ID="21398" />
|
|
|
1031 |
</RELATIONS_END>
|
|
|
1032 |
<INDICES>
|
|
|
1033 |
<INDEX ID="21250" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1034 |
<INDEXCOLUMNS>
|
|
|
1035 |
<INDEXCOLUMN idColumn="21227" LengthParam="0" />
|
|
|
1036 |
</INDEXCOLUMNS>
|
|
|
1037 |
</INDEX>
|
|
|
1038 |
</INDICES>
|
|
|
1039 |
</TABLE>
|
|
|
1040 |
<TABLE ID="21128" Tablename="HERBIERS_PRES" PrevTableName="" XPos="22" YPos="1604" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" >
|
|
|
1041 |
<COLUMNS>
|
|
|
1042 |
<COLUMN ID="21251" ColName="ID_PRES" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1043 |
<OPTIONSELECTED>
|
|
|
1044 |
<OPTIONSELECT Value="1" />
|
|
|
1045 |
<OPTIONSELECT Value="0" />
|
|
|
1046 |
</OPTIONSELECTED>
|
|
|
1047 |
</COLUMN>
|
|
|
1048 |
<COLUMN ID="21252" ColName="LABEL" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1049 |
<OPTIONSELECTED>
|
|
|
1050 |
<OPTIONSELECT Value="0" />
|
|
|
1051 |
</OPTIONSELECTED>
|
|
|
1052 |
</COLUMN>
|
|
|
1053 |
<COLUMN ID="21253" ColName="LABEL_ANG" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1054 |
<OPTIONSELECTED>
|
|
|
1055 |
<OPTIONSELECT Value="0" />
|
|
|
1056 |
</OPTIONSELECTED>
|
|
|
1057 |
</COLUMN>
|
|
|
1058 |
</COLUMNS>
|
|
|
1059 |
<RELATIONS_START>
|
|
|
1060 |
<RELATION_START ID="21386" />
|
|
|
1061 |
</RELATIONS_START>
|
|
|
1062 |
<INDICES>
|
|
|
1063 |
<INDEX ID="21254" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1064 |
<INDEXCOLUMNS>
|
|
|
1065 |
<INDEXCOLUMN idColumn="21251" LengthParam="0" />
|
|
|
1066 |
</INDEXCOLUMNS>
|
|
|
1067 |
</INDEX>
|
|
|
1068 |
</INDICES>
|
|
|
1069 |
</TABLE>
|
| 27 |
jpm |
1070 |
<TABLE ID="21129" Tablename="HERBIERS_STAFF" PrevTableName="" XPos="769" YPos="796" 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="18" >
|
| 24 |
jpm |
1071 |
<COLUMNS>
|
|
|
1072 |
<COLUMN ID="21255" ColName="ID_STAFF" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1073 |
<OPTIONSELECTED>
|
|
|
1074 |
<OPTIONSELECT Value="0" />
|
|
|
1075 |
<OPTIONSELECT Value="0" />
|
|
|
1076 |
</OPTIONSELECTED>
|
|
|
1077 |
</COLUMN>
|
|
|
1078 |
<COLUMN ID="21256" ColName="NOM" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1079 |
<OPTIONSELECTED>
|
|
|
1080 |
<OPTIONSELECT Value="0" />
|
|
|
1081 |
</OPTIONSELECTED>
|
|
|
1082 |
</COLUMN>
|
|
|
1083 |
<COLUMN ID="21257" ColName="PRENOM" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1084 |
<OPTIONSELECTED>
|
|
|
1085 |
<OPTIONSELECT Value="0" />
|
|
|
1086 |
</OPTIONSELECTED>
|
|
|
1087 |
</COLUMN>
|
|
|
1088 |
<COLUMN ID="21258" ColName="ADRESSE1" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1089 |
<OPTIONSELECTED>
|
|
|
1090 |
<OPTIONSELECT Value="0" />
|
|
|
1091 |
</OPTIONSELECTED>
|
|
|
1092 |
</COLUMN>
|
|
|
1093 |
<COLUMN ID="21259" ColName="ADRESSE2" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1094 |
<OPTIONSELECTED>
|
|
|
1095 |
<OPTIONSELECT Value="0" />
|
|
|
1096 |
</OPTIONSELECTED>
|
|
|
1097 |
</COLUMN>
|
|
|
1098 |
<COLUMN ID="21260" ColName="CP" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1099 |
<OPTIONSELECTED>
|
|
|
1100 |
<OPTIONSELECT Value="0" />
|
|
|
1101 |
</OPTIONSELECTED>
|
|
|
1102 |
</COLUMN>
|
|
|
1103 |
<COLUMN ID="21261" ColName="VILLE" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1104 |
<OPTIONSELECTED>
|
|
|
1105 |
<OPTIONSELECT Value="0" />
|
|
|
1106 |
</OPTIONSELECTED>
|
|
|
1107 |
</COLUMN>
|
|
|
1108 |
<COLUMN ID="21262" ColName="MAIL" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1109 |
<OPTIONSELECTED>
|
|
|
1110 |
<OPTIONSELECT Value="0" />
|
|
|
1111 |
</OPTIONSELECTED>
|
|
|
1112 |
</COLUMN>
|
|
|
1113 |
<COLUMN ID="21263" ColName="TEL" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(64)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1114 |
<OPTIONSELECTED>
|
|
|
1115 |
<OPTIONSELECT Value="0" />
|
|
|
1116 |
</OPTIONSELECTED>
|
|
|
1117 |
</COLUMN>
|
|
|
1118 |
<COLUMN ID="21264" ColName="FAX" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(64)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1119 |
<OPTIONSELECTED>
|
|
|
1120 |
<OPTIONSELECT Value="0" />
|
|
|
1121 |
</OPTIONSELECTED>
|
|
|
1122 |
</COLUMN>
|
|
|
1123 |
<COLUMN ID="21265" ColName="ID_TELA_BOTANICA" PrevColName="" Pos="11" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1124 |
<OPTIONSELECTED>
|
|
|
1125 |
<OPTIONSELECT Value="0" />
|
|
|
1126 |
<OPTIONSELECT Value="0" />
|
|
|
1127 |
</OPTIONSELECTED>
|
|
|
1128 |
</COLUMN>
|
|
|
1129 |
<COLUMN ID="21266" ColName="FONCTION" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1130 |
<OPTIONSELECTED>
|
|
|
1131 |
<OPTIONSELECT Value="0" />
|
|
|
1132 |
</OPTIONSELECTED>
|
|
|
1133 |
</COLUMN>
|
|
|
1134 |
<COLUMN ID="21267" ColName="CONTACT" PrevColName="" Pos="13" idDatatype="31" DatatypeParams="(\anon\a,\aoui\a)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="non" Comments="">
|
|
|
1135 |
<OPTIONSELECTED>
|
|
|
1136 |
</OPTIONSELECTED>
|
|
|
1137 |
</COLUMN>
|
| 27 |
jpm |
1138 |
<COLUMN ID="21268" ColName="DATE_DERNIERE_MODIF" PrevColName="" Pos="14" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
| 24 |
jpm |
1139 |
<OPTIONSELECTED>
|
|
|
1140 |
</OPTIONSELECTED>
|
|
|
1141 |
</COLUMN>
|
|
|
1142 |
<COLUMN ID="21269" ColName="CE_MODIFIER_PAR" PrevColName="" Pos="15" idDatatype="3" DatatypeParams="(9)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1143 |
<OPTIONSELECTED>
|
|
|
1144 |
<OPTIONSELECT Value="0" />
|
|
|
1145 |
<OPTIONSELECT Value="0" />
|
|
|
1146 |
</OPTIONSELECTED>
|
|
|
1147 |
</COLUMN>
|
|
|
1148 |
</COLUMNS>
|
|
|
1149 |
<RELATIONS_START>
|
|
|
1150 |
<RELATION_START ID="21302" />
|
|
|
1151 |
</RELATIONS_START>
|
|
|
1152 |
<RELATIONS_END>
|
|
|
1153 |
<RELATION_END ID="21400" />
|
|
|
1154 |
</RELATIONS_END>
|
|
|
1155 |
<INDICES>
|
|
|
1156 |
<INDEX ID="21270" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1157 |
<INDEXCOLUMNS>
|
|
|
1158 |
<INDEXCOLUMN idColumn="21255" LengthParam="0" />
|
|
|
1159 |
</INDEXCOLUMNS>
|
|
|
1160 |
</INDEX>
|
|
|
1161 |
</INDICES>
|
|
|
1162 |
</TABLE>
|
|
|
1163 |
<TABLE ID="21131" Tablename="HERBIERS_TYPE" PrevTableName="" XPos="26" YPos="1423" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" >
|
|
|
1164 |
<COLUMNS>
|
|
|
1165 |
<COLUMN ID="21274" ColName="ID_TYPE" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1166 |
<OPTIONSELECTED>
|
|
|
1167 |
<OPTIONSELECT Value="0" />
|
|
|
1168 |
<OPTIONSELECT Value="0" />
|
|
|
1169 |
</OPTIONSELECTED>
|
|
|
1170 |
</COLUMN>
|
|
|
1171 |
<COLUMN ID="21275" ColName="LABEL_TYPE" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1172 |
<OPTIONSELECTED>
|
|
|
1173 |
<OPTIONSELECT Value="0" />
|
|
|
1174 |
</OPTIONSELECTED>
|
|
|
1175 |
</COLUMN>
|
|
|
1176 |
</COLUMNS>
|
|
|
1177 |
<RELATIONS_START>
|
|
|
1178 |
<RELATION_START ID="21293" />
|
|
|
1179 |
</RELATIONS_START>
|
|
|
1180 |
<INDICES>
|
|
|
1181 |
<INDEX ID="21276" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1182 |
<INDEXCOLUMNS>
|
|
|
1183 |
<INDEXCOLUMN idColumn="21274" LengthParam="0" />
|
|
|
1184 |
</INDEXCOLUMNS>
|
|
|
1185 |
</INDEX>
|
|
|
1186 |
</INDICES>
|
|
|
1187 |
</TABLE>
|
|
|
1188 |
<TABLE ID="21132" Tablename="HERBIERS_ont_pres" PrevTableName="" XPos="314" YPos="1611" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" >
|
|
|
1189 |
<COLUMNS>
|
|
|
1190 |
<COLUMN ID="21277" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1191 |
<OPTIONSELECTED>
|
|
|
1192 |
<OPTIONSELECT Value="1" />
|
|
|
1193 |
<OPTIONSELECT Value="0" />
|
|
|
1194 |
</OPTIONSELECTED>
|
|
|
1195 |
</COLUMN>
|
|
|
1196 |
<COLUMN ID="21278" ColName="ID_PRES" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1197 |
<OPTIONSELECTED>
|
|
|
1198 |
<OPTIONSELECT Value="1" />
|
|
|
1199 |
<OPTIONSELECT Value="0" />
|
|
|
1200 |
</OPTIONSELECTED>
|
|
|
1201 |
</COLUMN>
|
|
|
1202 |
</COLUMNS>
|
|
|
1203 |
<RELATIONS_END>
|
|
|
1204 |
<RELATION_END ID="21386" />
|
|
|
1205 |
<RELATION_END ID="21387" />
|
|
|
1206 |
</RELATIONS_END>
|
|
|
1207 |
<INDICES>
|
|
|
1208 |
<INDEX ID="21279" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1209 |
<INDEXCOLUMNS>
|
|
|
1210 |
<INDEXCOLUMN idColumn="21277" LengthParam="0" />
|
|
|
1211 |
<INDEXCOLUMN idColumn="21278" LengthParam="0" />
|
|
|
1212 |
</INDEXCOLUMNS>
|
|
|
1213 |
</INDEX>
|
|
|
1214 |
</INDICES>
|
|
|
1215 |
</TABLE>
|
|
|
1216 |
<TABLE ID="21133" Tablename="HERBIERS_ont_un_staff" PrevTableName="" XPos="495" YPos="906" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" >
|
|
|
1217 |
<COLUMNS>
|
|
|
1218 |
<COLUMN ID="21280" ColName="ID_ORG" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1219 |
<OPTIONSELECTED>
|
|
|
1220 |
<OPTIONSELECT Value="0" />
|
|
|
1221 |
<OPTIONSELECT Value="0" />
|
|
|
1222 |
</OPTIONSELECTED>
|
|
|
1223 |
</COLUMN>
|
|
|
1224 |
<COLUMN ID="21281" ColName="ID_STAFF" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
|
|
|
1225 |
<OPTIONSELECTED>
|
|
|
1226 |
<OPTIONSELECT Value="0" />
|
|
|
1227 |
<OPTIONSELECT Value="0" />
|
|
|
1228 |
</OPTIONSELECTED>
|
|
|
1229 |
</COLUMN>
|
|
|
1230 |
</COLUMNS>
|
|
|
1231 |
<RELATIONS_END>
|
|
|
1232 |
<RELATION_END ID="21301" />
|
|
|
1233 |
<RELATION_END ID="21302" />
|
|
|
1234 |
</RELATIONS_END>
|
|
|
1235 |
<INDICES>
|
|
|
1236 |
<INDEX ID="21282" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1237 |
<INDEXCOLUMNS>
|
|
|
1238 |
<INDEXCOLUMN idColumn="21280" LengthParam="0" />
|
|
|
1239 |
<INDEXCOLUMN idColumn="21281" LengthParam="0" />
|
|
|
1240 |
</INDEXCOLUMNS>
|
|
|
1241 |
</INDEX>
|
|
|
1242 |
</INDICES>
|
|
|
1243 |
</TABLE>
|
|
|
1244 |
<TABLE ID="21134" Tablename="gen_COUNTRY" PrevTableName="" XPos="526" YPos="660" 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" >
|
|
|
1245 |
<COLUMNS>
|
|
|
1246 |
<COLUMN ID="21283" ColName="GC_ID" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(5)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1247 |
<OPTIONSELECTED>
|
|
|
1248 |
<OPTIONSELECT Value="0" />
|
|
|
1249 |
</OPTIONSELECTED>
|
|
|
1250 |
</COLUMN>
|
|
|
1251 |
<COLUMN ID="21284" ColName="GC_LOCALE" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(5)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1252 |
<OPTIONSELECTED>
|
|
|
1253 |
<OPTIONSELECT Value="0" />
|
|
|
1254 |
</OPTIONSELECTED>
|
|
|
1255 |
</COLUMN>
|
|
|
1256 |
<COLUMN ID="21285" ColName="GC_NAME" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(80)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1257 |
<OPTIONSELECTED>
|
|
|
1258 |
<OPTIONSELECT Value="0" />
|
|
|
1259 |
</OPTIONSELECTED>
|
|
|
1260 |
</COLUMN>
|
|
|
1261 |
<COLUMN ID="21286" ColName="GC_CAPITAL" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(80)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1262 |
<OPTIONSELECTED>
|
|
|
1263 |
<OPTIONSELECT Value="0" />
|
|
|
1264 |
</OPTIONSELECTED>
|
|
|
1265 |
</COLUMN>
|
|
|
1266 |
<COLUMN ID="21287" ColName="GC_CONTINENT_ID" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1267 |
<OPTIONSELECTED>
|
|
|
1268 |
<OPTIONSELECT Value="0" />
|
|
|
1269 |
<OPTIONSELECT Value="0" />
|
|
|
1270 |
</OPTIONSELECTED>
|
|
|
1271 |
</COLUMN>
|
|
|
1272 |
</COLUMNS>
|
|
|
1273 |
<RELATIONS_START>
|
|
|
1274 |
<RELATION_START ID="21308" />
|
|
|
1275 |
</RELATIONS_START>
|
|
|
1276 |
<INDICES>
|
|
|
1277 |
<INDEX ID="21288" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1278 |
<INDEXCOLUMNS>
|
|
|
1279 |
<INDEXCOLUMN idColumn="21283" LengthParam="0" />
|
|
|
1280 |
</INDEXCOLUMNS>
|
|
|
1281 |
</INDEX>
|
|
|
1282 |
</INDICES>
|
|
|
1283 |
</TABLE>
|
|
|
1284 |
<TABLE ID="21355" Tablename="annuaire_tela" PrevTableName="" XPos="451" YPos="31" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
|
|
|
1285 |
<COLUMNS>
|
|
|
1286 |
<COLUMN ID="21356" ColName="U_ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1287 |
<OPTIONSELECTED>
|
|
|
1288 |
<OPTIONSELECT Value="0" />
|
|
|
1289 |
<OPTIONSELECT Value="0" />
|
|
|
1290 |
</OPTIONSELECTED>
|
|
|
1291 |
</COLUMN>
|
|
|
1292 |
<COLUMN ID="21357" ColName="U_NAME" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1293 |
<OPTIONSELECTED>
|
|
|
1294 |
<OPTIONSELECT Value="0" />
|
|
|
1295 |
</OPTIONSELECTED>
|
|
|
1296 |
</COLUMN>
|
|
|
1297 |
<COLUMN ID="21358" ColName="U_SURNAME" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1298 |
<OPTIONSELECTED>
|
|
|
1299 |
<OPTIONSELECT Value="0" />
|
|
|
1300 |
</OPTIONSELECTED>
|
|
|
1301 |
</COLUMN>
|
|
|
1302 |
<COLUMN ID="21359" ColName="U_FONCTION" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1303 |
<OPTIONSELECTED>
|
|
|
1304 |
<OPTIONSELECT Value="0" />
|
|
|
1305 |
</OPTIONSELECTED>
|
|
|
1306 |
</COLUMN>
|
|
|
1307 |
<COLUMN ID="21360" ColName="U_TITLE" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1308 |
<OPTIONSELECTED>
|
|
|
1309 |
<OPTIONSELECT Value="0" />
|
|
|
1310 |
</OPTIONSELECTED>
|
|
|
1311 |
</COLUMN>
|
|
|
1312 |
<COLUMN ID="21361" ColName="U_PASSWD" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1313 |
<OPTIONSELECTED>
|
|
|
1314 |
<OPTIONSELECT Value="0" />
|
|
|
1315 |
</OPTIONSELECTED>
|
|
|
1316 |
</COLUMN>
|
|
|
1317 |
<COLUMN ID="21362" ColName="U_MAIL" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1318 |
<OPTIONSELECTED>
|
|
|
1319 |
<OPTIONSELECT Value="0" />
|
|
|
1320 |
</OPTIONSELECTED>
|
|
|
1321 |
</COLUMN>
|
|
|
1322 |
<COLUMN ID="21363" ColName="U_WEB" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1323 |
<OPTIONSELECTED>
|
|
|
1324 |
<OPTIONSELECT Value="0" />
|
|
|
1325 |
</OPTIONSELECTED>
|
|
|
1326 |
</COLUMN>
|
|
|
1327 |
<COLUMN ID="21364" ColName="U_ADDR1" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1328 |
<OPTIONSELECTED>
|
|
|
1329 |
<OPTIONSELECT Value="0" />
|
|
|
1330 |
</OPTIONSELECTED>
|
|
|
1331 |
</COLUMN>
|
|
|
1332 |
<COLUMN ID="21365" ColName="U_ADDR2" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1333 |
<OPTIONSELECTED>
|
|
|
1334 |
<OPTIONSELECT Value="0" />
|
|
|
1335 |
</OPTIONSELECTED>
|
|
|
1336 |
</COLUMN>
|
|
|
1337 |
<COLUMN ID="21366" ColName="U_ZIP_CODE" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1338 |
<OPTIONSELECTED>
|
|
|
1339 |
<OPTIONSELECT Value="0" />
|
|
|
1340 |
</OPTIONSELECTED>
|
|
|
1341 |
</COLUMN>
|
|
|
1342 |
<COLUMN ID="21367" ColName="U_CITY" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1343 |
<OPTIONSELECTED>
|
|
|
1344 |
<OPTIONSELECT Value="0" />
|
|
|
1345 |
</OPTIONSELECTED>
|
|
|
1346 |
</COLUMN>
|
|
|
1347 |
<COLUMN ID="21368" ColName="U_STATE" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1348 |
<OPTIONSELECTED>
|
|
|
1349 |
<OPTIONSELECT Value="0" />
|
|
|
1350 |
</OPTIONSELECTED>
|
|
|
1351 |
</COLUMN>
|
|
|
1352 |
<COLUMN ID="21369" ColName="U_COUNTRY" PrevColName="" Pos="14" idDatatype="20" DatatypeParams="(5)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="000" Comments="">
|
|
|
1353 |
<OPTIONSELECTED>
|
|
|
1354 |
<OPTIONSELECT Value="0" />
|
|
|
1355 |
</OPTIONSELECTED>
|
|
|
1356 |
</COLUMN>
|
|
|
1357 |
<COLUMN ID="21370" ColName="U_FRENCH_DPT" PrevColName="" Pos="15" idDatatype="5" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1358 |
<OPTIONSELECTED>
|
|
|
1359 |
<OPTIONSELECT Value="0" />
|
|
|
1360 |
<OPTIONSELECT Value="0" />
|
|
|
1361 |
</OPTIONSELECTED>
|
|
|
1362 |
</COLUMN>
|
|
|
1363 |
<COLUMN ID="21371" ColName="U_ABO" PrevColName="" Pos="16" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1364 |
<OPTIONSELECTED>
|
|
|
1365 |
<OPTIONSELECT Value="0" />
|
|
|
1366 |
</OPTIONSELECTED>
|
|
|
1367 |
</COLUMN>
|
|
|
1368 |
<COLUMN ID="21372" ColName="U_NIV" PrevColName="" Pos="17" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="4" Comments="">
|
|
|
1369 |
<OPTIONSELECTED>
|
|
|
1370 |
<OPTIONSELECT Value="1" />
|
|
|
1371 |
<OPTIONSELECT Value="0" />
|
|
|
1372 |
</OPTIONSELECTED>
|
|
|
1373 |
</COLUMN>
|
|
|
1374 |
<COLUMN ID="21373" ColName="U_SPE" PrevColName="" Pos="18" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1375 |
<OPTIONSELECTED>
|
|
|
1376 |
</OPTIONSELECTED>
|
|
|
1377 |
</COLUMN>
|
|
|
1378 |
<COLUMN ID="21374" ColName="U_GEO" PrevColName="" Pos="19" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1379 |
<OPTIONSELECTED>
|
|
|
1380 |
</OPTIONSELECTED>
|
|
|
1381 |
</COLUMN>
|
|
|
1382 |
<COLUMN ID="21375" ColName="U_ACT" PrevColName="" Pos="20" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="3" Comments="">
|
|
|
1383 |
<OPTIONSELECTED>
|
|
|
1384 |
<OPTIONSELECT Value="0" />
|
|
|
1385 |
<OPTIONSELECT Value="0" />
|
|
|
1386 |
</OPTIONSELECTED>
|
|
|
1387 |
</COLUMN>
|
|
|
1388 |
<COLUMN ID="21376" ColName="U_VALIDE" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1389 |
<OPTIONSELECTED>
|
|
|
1390 |
<OPTIONSELECT Value="0" />
|
|
|
1391 |
<OPTIONSELECT Value="0" />
|
|
|
1392 |
</OPTIONSELECTED>
|
|
|
1393 |
</COLUMN>
|
|
|
1394 |
<COLUMN ID="21377" ColName="U_DATE" PrevColName="" Pos="22" idDatatype="15" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00 00:00:00" Comments="">
|
|
|
1395 |
<OPTIONSELECTED>
|
|
|
1396 |
</OPTIONSELECTED>
|
|
|
1397 |
</COLUMN>
|
|
|
1398 |
<COLUMN ID="21378" ColName="U_ASS" PrevColName="" Pos="23" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="3" Comments="">
|
|
|
1399 |
<OPTIONSELECTED>
|
|
|
1400 |
<OPTIONSELECT Value="0" />
|
|
|
1401 |
<OPTIONSELECT Value="0" />
|
|
|
1402 |
</OPTIONSELECTED>
|
|
|
1403 |
</COLUMN>
|
|
|
1404 |
<COLUMN ID="21379" ColName="U_COT" PrevColName="" Pos="24" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1405 |
<OPTIONSELECTED>
|
|
|
1406 |
<OPTIONSELECT Value="0" />
|
|
|
1407 |
<OPTIONSELECT Value="0" />
|
|
|
1408 |
</OPTIONSELECTED>
|
|
|
1409 |
</COLUMN>
|
|
|
1410 |
<COLUMN ID="21380" ColName="U_LETTRE" PrevColName="" Pos="25" idDatatype="1" DatatypeParams="(4)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1411 |
<OPTIONSELECTED>
|
|
|
1412 |
<OPTIONSELECT Value="0" />
|
|
|
1413 |
<OPTIONSELECT Value="0" />
|
|
|
1414 |
</OPTIONSELECTED>
|
|
|
1415 |
</COLUMN>
|
|
|
1416 |
<COLUMN ID="21381" ColName="at_nom_wiki" PrevColName="" Pos="26" idDatatype="20" DatatypeParams="(128)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
|
|
|
1417 |
<OPTIONSELECTED>
|
|
|
1418 |
<OPTIONSELECT Value="0" />
|
|
|
1419 |
</OPTIONSELECTED>
|
|
|
1420 |
</COLUMN>
|
|
|
1421 |
</COLUMNS>
|
|
|
1422 |
<RELATIONS_START>
|
|
|
1423 |
<RELATION_START ID="21384" />
|
|
|
1424 |
<RELATION_START ID="21390" />
|
|
|
1425 |
<RELATION_START ID="21394" />
|
|
|
1426 |
<RELATION_START ID="21396" />
|
|
|
1427 |
<RELATION_START ID="21398" />
|
|
|
1428 |
<RELATION_START ID="21400" />
|
|
|
1429 |
<RELATION_START ID="21402" />
|
|
|
1430 |
<RELATION_START ID="21404" />
|
|
|
1431 |
</RELATIONS_START>
|
|
|
1432 |
<INDICES>
|
|
|
1433 |
<INDEX ID="21382" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
|
|
|
1434 |
<INDEXCOLUMNS>
|
|
|
1435 |
<INDEXCOLUMN idColumn="21356" LengthParam="0" />
|
|
|
1436 |
</INDEXCOLUMNS>
|
|
|
1437 |
</INDEX>
|
|
|
1438 |
</INDICES>
|
|
|
1439 |
</TABLE>
|
|
|
1440 |
</TABLES>
|
|
|
1441 |
<RELATIONS>
|
|
|
1442 |
<RELATION ID="21289" RelationName="fk_ed_edp" Kind="1" SrcTable="21113" DestTable="21114" FKFields="ED_ID_DROIT=EDP_ID_DROIT\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-1" 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="24" />
|
|
|
1443 |
<RELATION ID="21291" RelationName="fk_epr_edp" Kind="1" SrcTable="21115" DestTable="21114" FKFields="EPR_ID_PROJET=EDP_ID_PROJET\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-3" CaptionOffsetY="-50" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" />
|
|
|
1444 |
<RELATION ID="21293" RelationName="Rel_03" Kind="1" SrcTable="21131" DestTable="21117" FKFields="ID_TYPE=ID_TYPE\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" 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="26" />
|
|
|
1445 |
<RELATION ID="21294" RelationName="Rel_04" Kind="1" SrcTable="21125" DestTable="21117" FKFields="ID_INDIC=ID_INDIC\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="37" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" />
|
|
|
1446 |
<RELATION ID="21295" RelationName="Rel_05" Kind="2" SrcTable="21125" DestTable="21126" FKFields="ID_INDIC=ID_INDIC\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-1" 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="28" />
|
|
|
1447 |
<RELATION ID="21296" RelationName="Rel_06" Kind="2" SrcTable="21118" DestTable="21125" FKFields="ID=ID\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="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="29" />
|
|
|
1448 |
<RELATION ID="21297" RelationName="Rel_07" Kind="2" SrcTable="21121" DestTable="21118" FKFields="ID_DATE_CARAC=DATE_DEBUT_CARAC\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="2" 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="30" />
|
|
|
1449 |
<RELATION ID="21299" RelationName="Rel_08" Kind="2" SrcTable="21122" DestTable="21118" FKFields="ID_DATE_CARAC=DATE_FIN_CARAC\n" FKFieldsComments="\n" relDirection="4" MidOffset="6" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-3" CaptionOffsetY="-46" 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="31" />
|
|
|
1450 |
<RELATION ID="21301" RelationName="fk_ho_hous" Kind="1" SrcTable="21127" DestTable="21133" FKFields="ID_ORG=ID_ORG\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-48" StartIntervalOffsetX="10" StartIntervalOffsetY="-1" EndIntervalOffsetX="-9" EndIntervalOffsetY="-1" 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="32" />
|
|
|
1451 |
<RELATION ID="21302" RelationName="fk_hs_hous" Kind="1" SrcTable="21129" DestTable="21133" FKFields="ID_STAFF=ID_STAFF\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-4" CaptionOffsetY="-49" StartIntervalOffsetX="-9" StartIntervalOffsetY="-2" EndIntervalOffsetX="9" EndIntervalOffsetY="-2" 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="33" />
|
|
|
1452 |
<RELATION ID="21308" RelationName="fk_gc_ho" Kind="2" SrcTable="21134" DestTable="21127" FKFields="GC_ID=COUNTRY_CODE\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-3" CaptionOffsetY="-47" 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="34" />
|
|
|
1453 |
<RELATION ID="21321" RelationName="fk_ho_ha" Kind="1" SrcTable="21127" DestTable="21116" FKFields="ID_ORG=HA_ID_ORG\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="40" 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="39" />
|
|
|
1454 |
<RELATION ID="21324" RelationName="fk_hc_hc_parent" Kind="2" SrcTable="21118" DestTable="21118" FKFields="ID=PARENT_ID\n" FKFieldsComments="\n" relDirection="2" MidOffset="23" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="40" />
|
|
|
1455 |
<RELATION ID="21384" RelationName="fk_at_edp" Kind="1" SrcTable="21355" DestTable="21114" FKFields="U_ID=EDP_ID_UTILISATEUR\n" FKFieldsComments="\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="43" />
|
|
|
1456 |
<RELATION ID="21386" RelationName="Rel_16" Kind="1" SrcTable="21128" DestTable="21132" FKFields="ID_PRES=ID_PRES\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-47" 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="44" />
|
|
|
1457 |
<RELATION ID="21387" RelationName="Rel_17" Kind="1" SrcTable="21118" DestTable="21132" FKFields="ID=ID\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" 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="45" />
|
|
|
1458 |
<RELATION ID="21388" RelationName="Rel_18" Kind="2" SrcTable="21119" DestTable="21118" FKFields="ID_COLL_STATUT=STATUT\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-45" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="46" />
|
| 27 |
jpm |
1459 |
<RELATION ID="21390" RelationName="fk_at_ha" Kind="1" SrcTable="21355" DestTable="21116" FKFields="U_ID=HA_ID_ANNUAIRE\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-47" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="47" />
|
| 24 |
jpm |
1460 |
<RELATION ID="21392" RelationName="fk_ho_hc" Kind="2" SrcTable="21127" DestTable="21118" FKFields="ID_ORG=NUM_ORGANISATION\n" FKFieldsComments="\n" relDirection="2" MidOffset="72" 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="48" />
|
|
|
1461 |
<RELATION ID="21394" RelationName="fk_at_hih" Kind="2" SrcTable="21355" DestTable="21126" FKFields="U_ID=ID_INDICATEUR\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-34" 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="1" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="49" />
|
|
|
1462 |
<RELATION ID="21396" RelationName="fk_at_hc_modifier_par" Kind="2" SrcTable="21355" DestTable="21118" FKFields="U_ID=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="50" />
|
|
|
1463 |
<RELATION ID="21398" RelationName="fk_at_ho_modifier_par" Kind="2" SrcTable="21355" DestTable="21127" FKFields="U_ID=CE_MODIFIER_PAR\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="1" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="51" />
|
|
|
1464 |
<RELATION ID="21400" RelationName="fk_at_hs_modifier_par" Kind="2" SrcTable="21355" DestTable="21129" FKFields="U_ID=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="52" />
|
|
|
1465 |
<RELATION ID="21402" RelationName="fk_at_hco_coordinateur" Kind="1" SrcTable="21355" DestTable="21120" FKFields="U_ID=hc_id_coordinateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="1" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="10" CaptionOffsetY="9" StartIntervalOffsetX="-5" StartIntervalOffsetY="-27" EndIntervalOffsetX="4" EndIntervalOffsetY="-1" 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" />
|
|
|
1466 |
<RELATION ID="21404" RelationName="fk_at_hco_redacteur" Kind="1" SrcTable="21355" DestTable="21120" FKFields="U_ID=HC_ID_REDACTEUR\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-4" CaptionOffsetY="-58" StartIntervalOffsetX="-5" StartIntervalOffsetY="1" EndIntervalOffsetX="4" EndIntervalOffsetY="-27" 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" />
|
|
|
1467 |
<RELATION ID="21406" RelationName="fk_hdcsp_hc" Kind="2" SrcTable="21124" DestTable="21118" FKFields="HDC_ID=PREC_SPECIES\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="3" CaptionOffsetY="-45" 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" />
|
|
|
1468 |
<RELATION ID="21408" RelationName="fk_hdcsc_hc" Kind="2" SrcTable="21123" DestTable="21118" FKFields="HDC_ID=PREC_SPECIMENS\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-21" CaptionOffsetY="-45" 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" />
|
|
|
1469 |
</RELATIONS>
|
|
|
1470 |
<NOTES>
|
|
|
1471 |
</NOTES>
|
|
|
1472 |
<IMAGES>
|
|
|
1473 |
</IMAGES>
|
|
|
1474 |
</METADATA>
|
|
|
1475 |
<PLUGINDATA>
|
|
|
1476 |
<PLUGINDATARECORDS>
|
|
|
1477 |
</PLUGINDATARECORDS>
|
|
|
1478 |
</PLUGINDATA>
|
|
|
1479 |
<QUERYDATA>
|
|
|
1480 |
<QUERYRECORDS>
|
|
|
1481 |
</QUERYRECORDS>
|
|
|
1482 |
</QUERYDATA>
|
|
|
1483 |
<LINKEDMODELS>
|
|
|
1484 |
</LINKEDMODELS>
|
|
|
1485 |
</DBMODEL>
|