Subversion Repositories Applications.gtt

Rev

Rev 84 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 84 Rev 95
1
<?xml version="1.0" standalone="yes" ?>
1
<?xml version="1.0" standalone="yes" ?>
2
<DBMODEL Version="4.0">
2
<DBMODEL Version="4.0">
3
<SETTINGS>
3
<SETTINGS>
4
<GLOBALSETTINGS ModelName="model_reverse_engineered" 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="Gestion v4" 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="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Nimbus Sans L" CanvasWidth="4096" CanvasHeight="2842" />
4
<GLOBALSETTINGS ModelName="model_reverse_engineered" 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="Gestion v4" 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="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Nimbus Sans L" CanvasWidth="4096" CanvasHeight="2842" />
5
<DATATYPEGROUPS>
5
<DATATYPEGROUPS>
6
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
6
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
7
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
7
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
8
<DATATYPEGROUP Name="String Types" Icon="3" />
8
<DATATYPEGROUP Name="String Types" Icon="3" />
9
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
9
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
10
<DATATYPEGROUP Name="User defined Types" Icon="5" />
10
<DATATYPEGROUP Name="User defined Types" Icon="5" />
11
<DATATYPEGROUP Name="Geographic Types" Icon="6" />
11
<DATATYPEGROUP Name="Geographic Types" Icon="6" />
12
</DATATYPEGROUPS>
12
</DATATYPEGROUPS>
13
<DATATYPES>
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="" >
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>
15
<PARAMS>
16
<PARAM Name="length" />
16
<PARAM Name="length" />
17
</PARAMS>
17
</PARAMS>
18
<OPTIONS>
18
<OPTIONS>
19
<OPTION Name="UNSIGNED" Default="1" />
19
<OPTION Name="UNSIGNED" Default="1" />
20
<OPTION Name="ZEROFILL" Default="0" />
20
<OPTION Name="ZEROFILL" Default="0" />
21
</OPTIONS>
21
</OPTIONS>
22
</DATATYPE>
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="" >
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>
24
<PARAMS>
25
<PARAM Name="length" />
25
<PARAM Name="length" />
26
</PARAMS>
26
</PARAMS>
27
<OPTIONS>
27
<OPTIONS>
28
<OPTION Name="UNSIGNED" Default="1" />
28
<OPTION Name="UNSIGNED" Default="1" />
29
<OPTION Name="ZEROFILL" Default="0" />
29
<OPTION Name="ZEROFILL" Default="0" />
30
</OPTIONS>
30
</OPTIONS>
31
</DATATYPE>
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="" >
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>
33
<PARAMS>
34
<PARAM Name="length" />
34
<PARAM Name="length" />
35
</PARAMS>
35
</PARAMS>
36
<OPTIONS>
36
<OPTIONS>
37
<OPTION Name="UNSIGNED" Default="1" />
37
<OPTION Name="UNSIGNED" Default="1" />
38
<OPTION Name="ZEROFILL" Default="0" />
38
<OPTION Name="ZEROFILL" Default="0" />
39
</OPTIONS>
39
</OPTIONS>
40
</DATATYPE>
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="" >
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>
42
<PARAMS>
43
<PARAM Name="length" />
43
<PARAM Name="length" />
44
</PARAMS>
44
</PARAMS>
45
<OPTIONS>
45
<OPTIONS>
46
<OPTION Name="UNSIGNED" Default="0" />
46
<OPTION Name="UNSIGNED" Default="0" />
47
<OPTION Name="ZEROFILL" Default="0" />
47
<OPTION Name="ZEROFILL" Default="0" />
48
</OPTIONS>
48
</OPTIONS>
49
</DATATYPE>
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="" >
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>
51
<PARAMS>
52
<PARAM Name="length" />
52
<PARAM Name="length" />
53
</PARAMS>
53
</PARAMS>
54
<OPTIONS>
54
<OPTIONS>
55
<OPTION Name="UNSIGNED" Default="1" />
55
<OPTION Name="UNSIGNED" Default="1" />
56
<OPTION Name="ZEROFILL" Default="0" />
56
<OPTION Name="ZEROFILL" Default="0" />
57
</OPTIONS>
57
</OPTIONS>
58
</DATATYPE>
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="" >
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>
60
<PARAMS>
61
<PARAM Name="length" />
61
<PARAM Name="length" />
62
</PARAMS>
62
</PARAMS>
63
<OPTIONS>
63
<OPTIONS>
64
<OPTION Name="UNSIGNED" Default="0" />
64
<OPTION Name="UNSIGNED" Default="0" />
65
<OPTION Name="ZEROFILL" Default="0" />
65
<OPTION Name="ZEROFILL" Default="0" />
66
</OPTIONS>
66
</OPTIONS>
67
</DATATYPE>
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="" >
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>
69
<PARAMS>
70
<PARAM Name="precision" />
70
<PARAM Name="precision" />
71
</PARAMS>
71
</PARAMS>
72
<OPTIONS>
72
<OPTIONS>
73
<OPTION Name="ZEROFILL" Default="0" />
73
<OPTION Name="ZEROFILL" Default="0" />
74
</OPTIONS>
74
</OPTIONS>
75
</DATATYPE>
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="" >
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>
77
<PARAMS>
78
<PARAM Name="length" />
78
<PARAM Name="length" />
79
<PARAM Name="decimals" />
79
<PARAM Name="decimals" />
80
</PARAMS>
80
</PARAMS>
81
<OPTIONS>
81
<OPTIONS>
82
<OPTION Name="ZEROFILL" Default="0" />
82
<OPTION Name="ZEROFILL" Default="0" />
83
</OPTIONS>
83
</OPTIONS>
84
</DATATYPE>
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="" >
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>
86
<PARAMS>
87
<PARAM Name="length" />
87
<PARAM Name="length" />
88
<PARAM Name="decimals" />
88
<PARAM Name="decimals" />
89
</PARAMS>
89
</PARAMS>
90
<OPTIONS>
90
<OPTIONS>
91
<OPTION Name="ZEROFILL" Default="0" />
91
<OPTION Name="ZEROFILL" Default="0" />
92
</OPTIONS>
92
</OPTIONS>
93
</DATATYPE>
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="" >
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>
95
<PARAMS>
96
<PARAM Name="length" />
96
<PARAM Name="length" />
97
<PARAM Name="decimals" />
97
<PARAM Name="decimals" />
98
</PARAMS>
98
</PARAMS>
99
<OPTIONS>
99
<OPTIONS>
100
<OPTION Name="ZEROFILL" Default="0" />
100
<OPTION Name="ZEROFILL" Default="0" />
101
</OPTIONS>
101
</OPTIONS>
102
</DATATYPE>
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="" >
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>
104
<PARAMS>
105
<PARAM Name="length" />
105
<PARAM Name="length" />
106
<PARAM Name="decimals" />
106
<PARAM Name="decimals" />
107
</PARAMS>
107
</PARAMS>
108
<OPTIONS>
108
<OPTIONS>
109
<OPTION Name="ZEROFILL" Default="0" />
109
<OPTION Name="ZEROFILL" Default="0" />
110
</OPTIONS>
110
</OPTIONS>
111
</DATATYPE>
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="" >
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>
113
<PARAMS>
114
<PARAM Name="length" />
114
<PARAM Name="length" />
115
<PARAM Name="decimals" />
115
<PARAM Name="decimals" />
116
</PARAMS>
116
</PARAMS>
117
<OPTIONS>
117
<OPTIONS>
118
<OPTION Name="ZEROFILL" Default="0" />
118
<OPTION Name="ZEROFILL" Default="0" />
119
</OPTIONS>
119
</OPTIONS>
120
</DATATYPE>
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="" >
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>
122
<PARAMS>
123
<PARAM Name="length" />
123
<PARAM Name="length" />
124
<PARAM Name="decimals" />
124
<PARAM Name="decimals" />
125
</PARAMS>
125
</PARAMS>
126
<OPTIONS>
126
<OPTIONS>
127
<OPTION Name="ZEROFILL" Default="0" />
127
<OPTION Name="ZEROFILL" Default="0" />
128
</OPTIONS>
128
</OPTIONS>
129
</DATATYPE>
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="" >
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>
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="" >
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>
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="" >
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>
135
<PARAMS>
136
<PARAM Name="length" />
136
<PARAM Name="length" />
137
</PARAMS>
137
</PARAMS>
138
</DATATYPE>
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="" >
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>
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="" >
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>
142
<PARAMS>
143
<PARAM Name="length" />
143
<PARAM Name="length" />
144
</PARAMS>
144
</PARAMS>
145
</DATATYPE>
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="" >
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>
147
<PARAMS>
148
<PARAM Name="length" />
148
<PARAM Name="length" />
149
</PARAMS>
149
</PARAMS>
150
<OPTIONS>
150
<OPTIONS>
151
<OPTION Name="BINARY" Default="0" />
151
<OPTION Name="BINARY" Default="0" />
152
</OPTIONS>
152
</OPTIONS>
153
</DATATYPE>
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="" >
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>
155
<PARAMS>
156
<PARAM Name="length" />
156
<PARAM Name="length" />
157
</PARAMS>
157
</PARAMS>
158
<OPTIONS>
158
<OPTIONS>
159
<OPTION Name="BINARY" Default="0" />
159
<OPTION Name="BINARY" Default="0" />
160
</OPTIONS>
160
</OPTIONS>
161
</DATATYPE>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
183
<PARAMS>
184
<PARAM Name="values" />
184
<PARAM Name="values" />
185
</PARAMS>
185
</PARAMS>
186
</DATATYPE>
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="" >
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>
188
<PARAMS>
189
<PARAM Name="values" />
189
<PARAM Name="values" />
190
</PARAMS>
190
</PARAMS>
191
</DATATYPE>
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="" >
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>
193
<OPTIONS>
194
<OPTION Name="BINARY" Default="0" />
194
<OPTION Name="BINARY" Default="0" />
195
</OPTIONS>
195
</OPTIONS>
196
</DATATYPE>
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="" >
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>
198
<OPTIONS>
199
<OPTION Name="BINARY" Default="0" />
199
<OPTION Name="BINARY" Default="0" />
200
</OPTIONS>
200
</OPTIONS>
201
</DATATYPE>
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="" >
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>
203
<OPTIONS>
204
<OPTION Name="BINARY" Default="0" />
204
<OPTION Name="BINARY" Default="0" />
205
</OPTIONS>
205
</OPTIONS>
206
</DATATYPE>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
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="" >
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>
220
</DATATYPE>
221
</DATATYPES>
221
</DATATYPES>
222
<COMMON_DATATYPES>
222
<COMMON_DATATYPES>
223
<COMMON_DATATYPE ID="5" />
223
<COMMON_DATATYPE ID="5" />
224
<COMMON_DATATYPE ID="8" />
224
<COMMON_DATATYPE ID="8" />
225
<COMMON_DATATYPE ID="20" />
225
<COMMON_DATATYPE ID="20" />
226
<COMMON_DATATYPE ID="15" />
226
<COMMON_DATATYPE ID="15" />
227
<COMMON_DATATYPE ID="22" />
227
<COMMON_DATATYPE ID="22" />
228
<COMMON_DATATYPE ID="28" />
228
<COMMON_DATATYPE ID="28" />
229
<COMMON_DATATYPE ID="26" />
229
<COMMON_DATATYPE ID="26" />
230
<COMMON_DATATYPE ID="33" />
230
<COMMON_DATATYPE ID="33" />
231
<COMMON_DATATYPE ID="34" />
231
<COMMON_DATATYPE ID="34" />
232
<COMMON_DATATYPE ID="35" />
232
<COMMON_DATATYPE ID="35" />
233
</COMMON_DATATYPES>
233
</COMMON_DATATYPES>
234
<TABLEPREFIXES>
234
<TABLEPREFIXES>
235
<TABLEPREFIX Name="Default (no prefix)" />
235
<TABLEPREFIX Name="Default (no prefix)" />
236
</TABLEPREFIXES>
236
</TABLEPREFIXES>
237
<REGIONCOLORS>
237
<REGIONCOLORS>
238
<REGIONCOLOR Color="Red=#FFEEEC" />
238
<REGIONCOLOR Color="Red=#FFEEEC" />
239
<REGIONCOLOR Color="Yellow=#FEFDED" />
239
<REGIONCOLOR Color="Yellow=#FEFDED" />
240
<REGIONCOLOR Color="Green=#EAFFE5" />
240
<REGIONCOLOR Color="Green=#EAFFE5" />
241
<REGIONCOLOR Color="Cyan=#ECFDFF" />
241
<REGIONCOLOR Color="Cyan=#ECFDFF" />
242
<REGIONCOLOR Color="Blue=#F0F1FE" />
242
<REGIONCOLOR Color="Blue=#F0F1FE" />
243
<REGIONCOLOR Color="Magenta=#FFEBFA" />
243
<REGIONCOLOR Color="Magenta=#FFEBFA" />
244
</REGIONCOLORS>
244
</REGIONCOLORS>
245
<POSITIONMARKERS>
245
<POSITIONMARKERS>
246
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
246
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
247
<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" />
248
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
249
<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" />
250
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
251
<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" />
252
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
253
<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" />
254
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
255
<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" />
256
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
257
</POSITIONMARKERS>
257
</POSITIONMARKERS>
258
</SETTINGS>
258
</SETTINGS>
259
<METADATA>
259
<METADATA>
260
<REGIONS>
260
<REGIONS>
-
 
261
<REGION ID="1777" RegionName="A impl\195\169menter" XPos="969" YPos="148" Width="340" Height="670" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" />
261
</REGIONS>
262
</REGIONS>
262
<TABLES>
263
<TABLES>
263
<TABLE ID="1394" Tablename="gestion_absence" PrevTableName="" XPos="386" YPos="643" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
264
<TABLE ID="1394" Tablename="gestion_absence" PrevTableName="" XPos="386" YPos="643" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
264
<COLUMNS>
265
<COLUMNS>
265
<COLUMN ID="1761" ColName="ga_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
266
<COLUMN ID="1761" ColName="ga_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
266
<OPTIONSELECTED>
267
<OPTIONSELECTED>
267
<OPTIONSELECT Value="1" />
268
<OPTIONSELECT Value="1" />
268
<OPTIONSELECT Value="0" />
269
<OPTIONSELECT Value="0" />
269
</OPTIONSELECTED>
270
</OPTIONSELECTED>
270
</COLUMN>
271
</COLUMN>
271
<COLUMN ID="1762" ColName="ga_id_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
272
<COLUMN ID="1762" ColName="ga_id_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
272
<OPTIONSELECTED>
273
<OPTIONSELECTED>
273
<OPTIONSELECT Value="1" />
274
<OPTIONSELECT Value="1" />
274
<OPTIONSELECT Value="0" />
275
<OPTIONSELECT Value="0" />
275
</OPTIONSELECTED>
276
</OPTIONSELECTED>
276
</COLUMN>
277
</COLUMN>
277
<COLUMN ID="1411" ColName="ga_id_date_absence" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
278
<COLUMN ID="1411" ColName="ga_id_date_absence" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
278
<OPTIONSELECTED>
279
<OPTIONSELECTED>
279
</OPTIONSELECTED>
280
</OPTIONSELECTED>
280
</COLUMN>
281
</COLUMN>
281
<COLUMN ID="1413" ColName="ga_duree" PrevColName="" Pos="5" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
282
<COLUMN ID="1413" ColName="ga_duree" PrevColName="" Pos="5" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
282
<OPTIONSELECTED>
283
<OPTIONSELECTED>
283
<OPTIONSELECT Value="0" />
284
<OPTIONSELECT Value="0" />
284
</OPTIONSELECTED>
285
</OPTIONSELECTED>
285
</COLUMN>
286
</COLUMN>
286
</COLUMNS>
287
</COLUMNS>
287
<RELATIONS_END>
288
<RELATIONS_END>
288
<RELATION_END ID="1583" />
289
<RELATION_END ID="1583" />
289
<RELATION_END ID="1585" />
290
<RELATION_END ID="1585" />
290
</RELATIONS_END>
291
</RELATIONS_END>
291
<INDICES>
292
<INDICES>
292
<INDEX ID="1414" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
293
<INDEX ID="1414" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
293
<INDEXCOLUMNS>
294
<INDEXCOLUMNS>
294
<INDEXCOLUMN idColumn="1761" LengthParam="0" />
295
<INDEXCOLUMN idColumn="1761" LengthParam="0" />
295
<INDEXCOLUMN idColumn="1762" LengthParam="0" />
296
<INDEXCOLUMN idColumn="1762" LengthParam="0" />
296
<INDEXCOLUMN idColumn="1411" LengthParam="0" />
297
<INDEXCOLUMN idColumn="1411" LengthParam="0" />
297
</INDEXCOLUMNS>
298
</INDEXCOLUMNS>
298
</INDEX>
299
</INDEX>
299
</INDICES>
300
</INDICES>
300
</TABLE>
301
</TABLE>
301
<TABLE ID="1395" Tablename="gestion_projet_categorie" PrevTableName="gestion_categorie" XPos="43" YPos="71" 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="3" >
302
<TABLE ID="1395" Tablename="gestion_projet_categorie" PrevTableName="gestion_categorie" XPos="43" YPos="71" 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="3" >
302
<COLUMNS>
303
<COLUMNS>
303
<COLUMN ID="1415" ColName="gpc_id_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
304
<COLUMN ID="1415" ColName="gpc_id_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
304
<OPTIONSELECTED>
305
<OPTIONSELECTED>
305
<OPTIONSELECT Value="1" />
306
<OPTIONSELECT Value="1" />
306
<OPTIONSELECT Value="0" />
307
<OPTIONSELECT Value="0" />
307
</OPTIONSELECTED>
308
</OPTIONSELECTED>
308
</COLUMN>
309
</COLUMN>
309
<COLUMN ID="1416" ColName="gpc_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
310
<COLUMN ID="1416" ColName="gpc_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
310
<OPTIONSELECTED>
311
<OPTIONSELECTED>
311
<OPTIONSELECT Value="0" />
312
<OPTIONSELECT Value="0" />
312
</OPTIONSELECTED>
313
</OPTIONSELECTED>
313
</COLUMN>
314
</COLUMN>
314
</COLUMNS>
315
</COLUMNS>
315
<RELATIONS_START>
316
<RELATIONS_START>
316
<RELATION_START ID="1564" />
317
<RELATION_START ID="1564" />
317
</RELATIONS_START>
318
</RELATIONS_START>
318
<INDICES>
319
<INDICES>
319
<INDEX ID="1417" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
320
<INDEX ID="1417" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
320
<INDEXCOLUMNS>
321
<INDEXCOLUMNS>
321
<INDEXCOLUMN idColumn="1415" LengthParam="0" />
322
<INDEXCOLUMN idColumn="1415" LengthParam="0" />
322
</INDEXCOLUMNS>
323
</INDEXCOLUMNS>
323
</INDEX>
324
</INDEX>
324
</INDICES>
325
</INDICES>
325
</TABLE>
326
</TABLE>
326
<TABLE ID="1396" Tablename="gestion_frais_km" PrevTableName="gestion_composer_utilisateur_frais_kilometrique" XPos="1027" YPos="349" 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="4" >
327
<TABLE ID="1396" Tablename="gestion_frais_km" PrevTableName="gestion_composer_utilisateur_frais_kilometrique" XPos="1027" YPos="349" 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="4" >
327
<COLUMNS>
328
<COLUMNS>
328
<COLUMN ID="1605" ColName="gfk_id_frais_km" PrevColName="gcufk_id_frais_km" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
329
<COLUMN ID="1605" ColName="gfk_id_frais_km" PrevColName="gcufk_id_frais_km" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
329
<OPTIONSELECTED>
330
<OPTIONSELECTED>
330
<OPTIONSELECT Value="1" />
331
<OPTIONSELECT Value="1" />
331
<OPTIONSELECT Value="0" />
332
<OPTIONSELECT Value="0" />
332
</OPTIONSELECTED>
333
</OPTIONSELECTED>
333
</COLUMN>
334
</COLUMN>
334
<COLUMN ID="1737" ColName="gfkt_id_frais_km_taux" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
335
<COLUMN ID="1737" ColName="gfkt_id_frais_km_taux" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
335
<OPTIONSELECTED>
336
<OPTIONSELECTED>
336
<OPTIONSELECT Value="1" />
337
<OPTIONSELECT Value="1" />
337
<OPTIONSELECT Value="0" />
338
<OPTIONSELECT Value="0" />
338
</OPTIONSELECTED>
339
</OPTIONSELECTED>
339
</COLUMN>
340
</COLUMN>
340
<COLUMN ID="1639" ColName="gfk_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
341
<COLUMN ID="1639" ColName="gfk_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
341
<OPTIONSELECTED>
342
<OPTIONSELECTED>
342
<OPTIONSELECT Value="1" />
343
<OPTIONSELECT Value="1" />
343
<OPTIONSELECT Value="0" />
344
<OPTIONSELECT Value="0" />
344
</OPTIONSELECTED>
345
</OPTIONSELECTED>
345
</COLUMN>
346
</COLUMN>
346
<COLUMN ID="1420" ColName="gfk_date" PrevColName="gcufk_date_frais" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
347
<COLUMN ID="1420" ColName="gfk_date" PrevColName="gcufk_date_frais" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
347
<OPTIONSELECTED>
348
<OPTIONSELECTED>
348
</OPTIONSELECTED>
349
</OPTIONSELECTED>
349
</COLUMN>
350
</COLUMN>
350
<COLUMN ID="1421" ColName="gfk_nbre_km" PrevColName="gcufk_nb_kilometre" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
351
<COLUMN ID="1421" ColName="gfk_nbre_km" PrevColName="gcufk_nb_kilometre" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
351
<OPTIONSELECTED>
352
<OPTIONSELECTED>
352
<OPTIONSELECT Value="0" />
353
<OPTIONSELECT Value="0" />
353
</OPTIONSELECTED>
354
</OPTIONSELECTED>
354
</COLUMN>
355
</COLUMN>
355
<COLUMN ID="1422" ColName="gfk_objet" PrevColName="gcufk_objet" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
356
<COLUMN ID="1422" ColName="gfk_objet" PrevColName="gcufk_objet" Pos="5" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
356
<OPTIONSELECTED>
357
<OPTIONSELECTED>
357
<OPTIONSELECT Value="0" />
358
<OPTIONSELECT Value="0" />
358
</OPTIONSELECTED>
359
</OPTIONSELECTED>
359
</COLUMN>
360
</COLUMN>
360
<COLUMN ID="1423" ColName="gfk_trajet" PrevColName="gcufk_trajet" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
361
<COLUMN ID="1423" ColName="gfk_trajet" PrevColName="gcufk_trajet" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
361
<OPTIONSELECTED>
362
<OPTIONSELECTED>
362
<OPTIONSELECT Value="0" />
363
<OPTIONSELECT Value="0" />
363
</OPTIONSELECTED>
364
</OPTIONSELECTED>
364
</COLUMN>
365
</COLUMN>
365
<COLUMN ID="1424" ColName="gfk_montant_total" PrevColName="gcufk_montant_total" Pos="7" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
366
<COLUMN ID="1424" ColName="gfk_montant_total" PrevColName="gcufk_montant_total" Pos="7" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
366
<OPTIONSELECTED>
367
<OPTIONSELECTED>
367
<OPTIONSELECT Value="0" />
368
<OPTIONSELECT Value="0" />
368
</OPTIONSELECTED>
369
</OPTIONSELECTED>
369
</COLUMN>
370
</COLUMN>
370
</COLUMNS>
371
</COLUMNS>
371
<RELATIONS_END>
372
<RELATIONS_END>
372
<RELATION_END ID="1503" />
373
<RELATION_END ID="1503" />
373
<RELATION_END ID="1505" />
374
<RELATION_END ID="1505" />
374
</RELATIONS_END>
375
</RELATIONS_END>
375
<INDICES>
376
<INDICES>
376
<INDEX ID="1425" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
377
<INDEX ID="1425" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
377
<INDEXCOLUMNS>
378
<INDEXCOLUMNS>
378
<INDEXCOLUMN idColumn="1605" LengthParam="0" />
379
<INDEXCOLUMN idColumn="1605" LengthParam="0" />
379
</INDEXCOLUMNS>
380
</INDEXCOLUMNS>
380
</INDEX>
381
</INDEX>
381
</INDICES>
382
</INDICES>
382
</TABLE>
383
</TABLE>
383
<TABLE ID="1397" Tablename="gestion_note_frais_ligne" PrevTableName="gestion_depense" XPos="1025" YPos="651" 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" >
384
<TABLE ID="1397" Tablename="gestion_note_frais_ligne" PrevTableName="gestion_depense" XPos="1025" YPos="651" 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" >
384
<COLUMNS>
385
<COLUMNS>
385
<COLUMN ID="1617" ColName="gnfl_id_note_frais_ligne" PrevColName="gld_id_ligne_depense" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
386
<COLUMN ID="1617" ColName="gnfl_id_note_frais_ligne" PrevColName="gld_id_ligne_depense" Pos="3" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
386
<OPTIONSELECTED>
387
<OPTIONSELECTED>
387
<OPTIONSELECT Value="1" />
388
<OPTIONSELECT Value="1" />
388
<OPTIONSELECT Value="0" />
389
<OPTIONSELECT Value="0" />
389
</OPTIONSELECTED>
390
</OPTIONSELECTED>
390
</COLUMN>
391
</COLUMN>
391
<COLUMN ID="1634" ColName="gnfl_ce_note_frais" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
392
<COLUMN ID="1634" ColName="gnfl_ce_note_frais" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
392
<OPTIONSELECTED>
393
<OPTIONSELECTED>
393
<OPTIONSELECT Value="1" />
394
<OPTIONSELECT Value="1" />
394
<OPTIONSELECT Value="0" />
395
<OPTIONSELECT Value="0" />
395
</OPTIONSELECTED>
396
</OPTIONSELECTED>
396
</COLUMN>
397
</COLUMN>
397
<COLUMN ID="1428" ColName="gnfl_date" PrevColName="gd_date_depense" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
398
<COLUMN ID="1428" ColName="gnfl_date" PrevColName="gd_date_depense" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
398
<OPTIONSELECTED>
399
<OPTIONSELECTED>
399
</OPTIONSELECTED>
400
</OPTIONSELECTED>
400
</COLUMN>
401
</COLUMN>
401
<COLUMN ID="1429" ColName="gnfl_montant_ht" PrevColName="gd_montant_ht" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
402
<COLUMN ID="1429" ColName="gnfl_montant_ht" PrevColName="gd_montant_ht" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
402
<OPTIONSELECTED>
403
<OPTIONSELECTED>
403
<OPTIONSELECT Value="0" />
404
<OPTIONSELECT Value="0" />
404
</OPTIONSELECTED>
405
</OPTIONSELECTED>
405
</COLUMN>
406
</COLUMN>
406
<COLUMN ID="1620" ColName="gnfl_taux_tva" PrevColName="gld_taux_tva" Pos="5" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
407
<COLUMN ID="1620" ColName="gnfl_taux_tva" PrevColName="gld_taux_tva" Pos="5" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
407
<OPTIONSELECTED>
408
<OPTIONSELECTED>
408
<OPTIONSELECT Value="0" />
409
<OPTIONSELECT Value="0" />
409
</OPTIONSELECTED>
410
</OPTIONSELECTED>
410
</COLUMN>
411
</COLUMN>
411
<COLUMN ID="1430" ColName="gnfl_montant_ttc" PrevColName="gd_montant_ttc" Pos="5" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
412
<COLUMN ID="1430" ColName="gnfl_montant_ttc" PrevColName="gd_montant_ttc" Pos="5" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
412
<OPTIONSELECTED>
413
<OPTIONSELECTED>
413
<OPTIONSELECT Value="0" />
414
<OPTIONSELECT Value="0" />
414
</OPTIONSELECTED>
415
</OPTIONSELECTED>
415
</COLUMN>
416
</COLUMN>
416
</COLUMNS>
417
</COLUMNS>
417
<RELATIONS_END>
418
<RELATIONS_END>
418
<RELATION_END ID="1500" />
419
<RELATION_END ID="1500" />
419
</RELATIONS_END>
420
</RELATIONS_END>
420
<INDICES>
421
<INDICES>
421
<INDEX ID="1431" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
422
<INDEX ID="1431" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
422
<INDEXCOLUMNS>
423
<INDEXCOLUMNS>
423
<INDEXCOLUMN idColumn="1617" LengthParam="0" />
424
<INDEXCOLUMN idColumn="1617" LengthParam="0" />
424
</INDEXCOLUMNS>
425
</INDEXCOLUMNS>
425
</INDEX>
426
</INDEX>
426
</INDICES>
427
</INDICES>
427
</TABLE>
428
</TABLE>
428
<TABLE ID="1398" Tablename="gestion_frais_km_taux" PrevTableName="gestion_frais_kilometrique" XPos="1027" YPos="245" 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="6" >
429
<TABLE ID="1398" Tablename="gestion_frais_km_taux" PrevTableName="gestion_frais_kilometrique" XPos="1027" YPos="245" 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="6" >
429
<COLUMNS>
430
<COLUMNS>
430
<COLUMN ID="1432" ColName="gfkt_id_frais_km_taux" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
431
<COLUMN ID="1432" ColName="gfkt_id_frais_km_taux" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
431
<OPTIONSELECTED>
432
<OPTIONSELECTED>
432
<OPTIONSELECT Value="1" />
433
<OPTIONSELECT Value="1" />
433
<OPTIONSELECT Value="0" />
434
<OPTIONSELECT Value="0" />
434
</OPTIONSELECTED>
435
</OPTIONSELECTED>
435
</COLUMN>
436
</COLUMN>
436
<COLUMN ID="1433" ColName="gfkt_taux" PrevColName="" Pos="2" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
437
<COLUMN ID="1433" ColName="gfkt_taux" PrevColName="" Pos="2" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
437
<OPTIONSELECTED>
438
<OPTIONSELECTED>
438
<OPTIONSELECT Value="0" />
439
<OPTIONSELECT Value="0" />
439
</OPTIONSELECTED>
440
</OPTIONSELECTED>
440
</COLUMN>
441
</COLUMN>
441
</COLUMNS>
442
</COLUMNS>
442
<RELATIONS_START>
443
<RELATIONS_START>
443
<RELATION_START ID="1505" />
444
<RELATION_START ID="1505" />
444
</RELATIONS_START>
445
</RELATIONS_START>
445
<INDICES>
446
<INDICES>
446
<INDEX ID="1434" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
447
<INDEX ID="1434" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
447
<INDEXCOLUMNS>
448
<INDEXCOLUMNS>
448
<INDEXCOLUMN idColumn="1432" LengthParam="0" />
449
<INDEXCOLUMN idColumn="1432" LengthParam="0" />
449
</INDEXCOLUMNS>
450
</INDEXCOLUMNS>
450
</INDEX>
451
</INDEX>
451
</INDICES>
452
</INDICES>
452
</TABLE>
453
</TABLE>
453
<TABLE ID="1399" Tablename="gestion_absence_motif" PrevTableName="gestion_motif_absence" XPos="44" YPos="521" 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="7" >
454
<TABLE ID="1399" Tablename="gestion_absence_motif" PrevTableName="gestion_motif_absence" XPos="44" YPos="521" 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="7" >
454
<COLUMNS>
455
<COLUMNS>
455
<COLUMN ID="1435" ColName="gam_id_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
456
<COLUMN ID="1435" ColName="gam_id_absence_motif" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
456
<OPTIONSELECTED>
457
<OPTIONSELECTED>
457
<OPTIONSELECT Value="1" />
458
<OPTIONSELECT Value="1" />
458
<OPTIONSELECT Value="0" />
459
<OPTIONSELECT Value="0" />
459
</OPTIONSELECTED>
460
</OPTIONSELECTED>
460
</COLUMN>
461
</COLUMN>
461
<COLUMN ID="1436" ColName="gam_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Libell\195\169 du motif d\aabscence.">
462
<COLUMN ID="1436" ColName="gam_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Libell\195\169 du motif d\aabscence.">
462
<OPTIONSELECTED>
463
<OPTIONSELECTED>
463
<OPTIONSELECT Value="0" />
464
<OPTIONSELECT Value="0" />
464
</OPTIONSELECTED>
465
</OPTIONSELECTED>
465
</COLUMN>
466
</COLUMN>
466
<COLUMN ID="1770" ColName="gam_cp_diminuer" PrevColName="" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif diminue le nombre d\aheur de cong\195\169s pay\195\169s.">
467
<COLUMN ID="1770" ColName="gam_mark_cp_diminuer" PrevColName="gam_cp_diminuer" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif diminue le nombre d\aheur de cong\195\169s pay\195\169s.">
467
<OPTIONSELECTED>
468
<OPTIONSELECTED>
468
</OPTIONSELECTED>
469
</OPTIONSELECTED>
469
</COLUMN>
470
</COLUMN>
470
<COLUMN ID="1771" ColName="gam_hs_augmenter" PrevColName="" Pos="3" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif augmente quand m\195\170me le nombre d\aheures supl\195\169mentaires.">
-
 
471
<OPTIONSELECTED>
-
 
472
</OPTIONSELECTED>
-
 
473
</COLUMN>
-
 
474
<COLUMN ID="1772" ColName="gam_hs_diminuer" PrevColName="" Pos="4" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif diminue le nombre d\aheures supl\195\169mentaires.">
471
<COLUMN ID="1772" ColName="gam_mark_hs_diminuer" PrevColName="gam_hs_diminuer" Pos="4" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Indique si ce motif diminue le nombre d\aheures supl\195\169mentaires.">
475
<OPTIONSELECTED>
472
<OPTIONSELECTED>
476
</OPTIONSELECTED>
473
</OPTIONSELECTED>
477
</COLUMN>
474
</COLUMN>
478
</COLUMNS>
475
</COLUMNS>
479
<RELATIONS_START>
476
<RELATIONS_START>
480
<RELATION_START ID="1583" />
477
<RELATION_START ID="1583" />
481
</RELATIONS_START>
478
</RELATIONS_START>
482
<INDICES>
479
<INDICES>
483
<INDEX ID="1438" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
480
<INDEX ID="1438" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
484
<INDEXCOLUMNS>
481
<INDEXCOLUMNS>
485
<INDEXCOLUMN idColumn="1435" LengthParam="0" />
482
<INDEXCOLUMN idColumn="1435" LengthParam="0" />
486
</INDEXCOLUMNS>
483
</INDEXCOLUMNS>
487
</INDEX>
484
</INDEX>
488
</INDICES>
485
</INDICES>
489
</TABLE>
486
</TABLE>
490
<TABLE ID="1402" Tablename="gestion_utilisateur_a_projet" PrevTableName="gestion_preferences" XPos="384" YPos="357" 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="10" >
487
<TABLE ID="1402" Tablename="gestion_utilisateur_a_projet" PrevTableName="gestion_preferences" XPos="384" YPos="357" 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="10" >
491
<COLUMNS>
488
<COLUMNS>
492
<COLUMN ID="1631" ColName="guap_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
489
<COLUMN ID="1631" ColName="guap_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
493
<OPTIONSELECTED>
490
<OPTIONSELECTED>
494
<OPTIONSELECT Value="1" />
491
<OPTIONSELECT Value="1" />
495
<OPTIONSELECT Value="0" />
492
<OPTIONSELECT Value="0" />
496
</OPTIONSELECTED>
493
</OPTIONSELECTED>
497
</COLUMN>
494
</COLUMN>
498
<COLUMN ID="1632" ColName="guap_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
495
<COLUMN ID="1632" ColName="guap_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
499
<OPTIONSELECTED>
496
<OPTIONSELECTED>
500
<OPTIONSELECT Value="1" />
497
<OPTIONSELECT Value="1" />
501
<OPTIONSELECT Value="0" />
498
<OPTIONSELECT Value="0" />
502
</OPTIONSELECTED>
499
</OPTIONSELECTED>
503
</COLUMN>
500
</COLUMN>
504
</COLUMNS>
501
</COLUMNS>
505
<RELATIONS_END>
502
<RELATIONS_END>
506
<RELATION_END ID="1494" />
503
<RELATION_END ID="1494" />
507
<RELATION_END ID="1498" />
504
<RELATION_END ID="1498" />
508
</RELATIONS_END>
505
</RELATIONS_END>
509
<INDICES>
506
<INDICES>
510
<INDEX ID="1447" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
507
<INDEX ID="1447" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
511
<INDEXCOLUMNS>
508
<INDEXCOLUMNS>
512
<INDEXCOLUMN idColumn="1631" LengthParam="0" />
509
<INDEXCOLUMN idColumn="1631" LengthParam="0" />
513
<INDEXCOLUMN idColumn="1632" LengthParam="0" />
510
<INDEXCOLUMN idColumn="1632" LengthParam="0" />
514
</INDEXCOLUMNS>
511
</INDEXCOLUMNS>
515
</INDEX>
512
</INDEX>
516
</INDICES>
513
</INDICES>
517
</TABLE>
514
</TABLE>
518
<TABLE ID="1404" Tablename="gestion_projet" PrevTableName="" XPos="44" YPos="195" 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="12" >
515
<TABLE ID="1404" Tablename="gestion_projet" PrevTableName="" XPos="44" YPos="195" 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="12" >
519
<COLUMNS>
516
<COLUMNS>
520
<COLUMN ID="1522" ColName="gp_id_projet" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Identifiant du projet.">
517
<COLUMN ID="1522" ColName="gp_id_projet" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="Identifiant du projet.">
521
<OPTIONSELECTED>
518
<OPTIONSELECTED>
522
<OPTIONSELECT Value="1" />
519
<OPTIONSELECT Value="1" />
523
<OPTIONSELECT Value="0" />
520
<OPTIONSELECT Value="0" />
524
</OPTIONSELECTED>
521
</OPTIONSELECTED>
525
</COLUMN>
522
</COLUMN>
526
<COLUMN ID="1766" ColName="gp_ce_projet_parent" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
523
<COLUMN ID="1766" ColName="gp_ce_projet_parent" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
527
<OPTIONSELECTED>
524
<OPTIONSELECTED>
528
<OPTIONSELECT Value="1" />
525
<OPTIONSELECT Value="1" />
529
<OPTIONSELECT Value="0" />
526
<OPTIONSELECT Value="0" />
530
</OPTIONSELECTED>
527
</OPTIONSELECTED>
531
</COLUMN>
528
</COLUMN>
532
<COLUMN ID="1629" ColName="gp_ce_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la cat\195\169gorie du projet.">
529
<COLUMN ID="1629" ColName="gp_ce_categorie" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="Identifiant de la cat\195\169gorie du projet.">
533
<OPTIONSELECTED>
530
<OPTIONSELECTED>
534
<OPTIONSELECT Value="1" />
531
<OPTIONSELECT Value="1" />
535
<OPTIONSELECT Value="0" />
532
<OPTIONSELECT Value="0" />
536
</OPTIONSELECTED>
533
</OPTIONSELECTED>
537
</COLUMN>
534
</COLUMN>
538
<COLUMN ID="1455" ColName="gp_nom" PrevColName="gp_nom_projet" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du projet.">
535
<COLUMN ID="1455" ColName="gp_nom" PrevColName="gp_nom_projet" Pos="3" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du projet.">
539
<OPTIONSELECTED>
536
<OPTIONSELECTED>
540
<OPTIONSELECT Value="0" />
537
<OPTIONSELECT Value="0" />
541
</OPTIONSELECTED>
538
</OPTIONSELECTED>
542
</COLUMN>
539
</COLUMN>
543
<COLUMN ID="1456" ColName="gp_description" PrevColName="" Pos="4" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description d\195\169taill\195\169e du projet.">
540
<COLUMN ID="1456" ColName="gp_description" PrevColName="" Pos="4" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Description d\195\169taill\195\169e du projet.">
544
<OPTIONSELECTED>
541
<OPTIONSELECTED>
545
</OPTIONSELECTED>
542
</OPTIONSELECTED>
546
</COLUMN>
543
</COLUMN>
547
<COLUMN ID="1457" ColName="gp_date_debut" PrevColName="" Pos="5" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de d\195\169but du projet">
544
<COLUMN ID="1457" ColName="gp_date_debut" PrevColName="" Pos="5" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de d\195\169but du projet">
548
<OPTIONSELECTED>
545
<OPTIONSELECTED>
549
</OPTIONSELECTED>
546
</OPTIONSELECTED>
550
</COLUMN>
547
</COLUMN>
551
<COLUMN ID="1768" ColName="gp_date_fin" PrevColName="" Pos="8" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de fin du projet estim\195\169e.">
548
<COLUMN ID="1768" ColName="gp_date_fin" PrevColName="" Pos="8" idDatatype="14" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="Date de fin du projet estim\195\169e.">
552
<OPTIONSELECTED>
549
<OPTIONSELECTED>
553
</OPTIONSELECTED>
550
</OPTIONSELECTED>
554
</COLUMN>
551
</COLUMN>
555
<COLUMN ID="1458" ColName="gp_duree_prevue" PrevColName="" Pos="6" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Dur\195\169e pr\195\169vue du projet en jour.">
552
<COLUMN ID="1458" ColName="gp_duree_prevue" PrevColName="" Pos="6" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Dur\195\169e pr\195\169vue du projet en jour.">
556
<OPTIONSELECTED>
553
<OPTIONSELECTED>
557
<OPTIONSELECT Value="0" />
554
<OPTIONSELECT Value="0" />
558
</OPTIONSELECTED>
555
</OPTIONSELECTED>
559
</COLUMN>
556
</COLUMN>
560
<COLUMN ID="1459" ColName="gp_avancement" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Pourcentage d\aavancement du projet.">
557
<COLUMN ID="1459" ColName="gp_avancement" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Pourcentage d\aavancement du projet.">
561
<OPTIONSELECTED>
558
<OPTIONSELECTED>
562
<OPTIONSELECT Value="0" />
559
<OPTIONSELECT Value="0" />
563
<OPTIONSELECT Value="0" />
560
<OPTIONSELECT Value="0" />
564
</OPTIONSELECTED>
561
</OPTIONSELECTED>
565
</COLUMN>
562
</COLUMN>
566
</COLUMNS>
563
</COLUMNS>
567
<RELATIONS_START>
564
<RELATIONS_START>
568
<RELATION_START ID="1498" />
565
<RELATION_START ID="1498" />
569
<RELATION_START ID="1511" />
566
<RELATION_START ID="1511" />
570
<RELATION_START ID="1764" />
567
<RELATION_START ID="1764" />
571
</RELATIONS_START>
568
</RELATIONS_START>
572
<RELATIONS_END>
569
<RELATIONS_END>
573
<RELATION_END ID="1564" />
570
<RELATION_END ID="1564" />
574
<RELATION_END ID="1764" />
571
<RELATION_END ID="1764" />
575
</RELATIONS_END>
572
</RELATIONS_END>
576
<INDICES>
573
<INDICES>
577
<INDEX ID="1625" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
574
<INDEX ID="1625" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
578
<INDEXCOLUMNS>
575
<INDEXCOLUMNS>
579
<INDEXCOLUMN idColumn="1522" LengthParam="0" />
576
<INDEXCOLUMN idColumn="1522" LengthParam="0" />
580
</INDEXCOLUMNS>
577
</INDEXCOLUMNS>
581
</INDEX>
578
</INDEX>
582
</INDICES>
579
</INDICES>
583
</TABLE>
580
</TABLE>
584
<TABLE ID="1405" Tablename="gestion_utilisateur_statut" PrevTableName="gestion_statut" XPos="673" YPos="234" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" >
581
<TABLE ID="1405" Tablename="gestion_utilisateur_statut" PrevTableName="gestion_statut" XPos="673" YPos="234" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" >
585
<COLUMNS>
582
<COLUMNS>
586
<COLUMN ID="1461" ColName="gus_id_utilisateur_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
583
<COLUMN ID="1461" ColName="gus_id_utilisateur_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
587
<OPTIONSELECTED>
584
<OPTIONSELECTED>
588
<OPTIONSELECT Value="1" />
585
<OPTIONSELECT Value="1" />
589
<OPTIONSELECT Value="0" />
586
<OPTIONSELECT Value="0" />
590
</OPTIONSELECTED>
587
</OPTIONSELECTED>
591
</COLUMN>
588
</COLUMN>
592
<COLUMN ID="1462" ColName="gus_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
589
<COLUMN ID="1462" ColName="gus_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
593
<OPTIONSELECTED>
590
<OPTIONSELECTED>
594
<OPTIONSELECT Value="0" />
591
<OPTIONSELECT Value="0" />
595
</OPTIONSELECTED>
592
</OPTIONSELECTED>
596
</COLUMN>
593
</COLUMN>
597
<COLUMN ID="1776" ColName="gus_mark_recapitulatif" PrevColName="" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="Indique si ce type d\autilisateur doit appara\195\174tre dans le r\195\169capitulatif ou pas.">
594
<COLUMN ID="1776" ColName="gus_mark_recapitulatif" PrevColName="" Pos="2" idDatatype="22" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="1" Comments="Indique si ce type d\autilisateur doit appara\195\174tre dans le r\195\169capitulatif ou pas.">
598
<OPTIONSELECTED>
595
<OPTIONSELECTED>
599
</OPTIONSELECTED>
596
</OPTIONSELECTED>
600
</COLUMN>
597
</COLUMN>
601
</COLUMNS>
598
</COLUMNS>
602
<RELATIONS_START>
599
<RELATIONS_START>
603
<RELATION_START ID="1592" />
600
<RELATION_START ID="1592" />
604
</RELATIONS_START>
601
</RELATIONS_START>
605
<INDICES>
602
<INDICES>
606
<INDEX ID="1463" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
603
<INDEX ID="1463" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
607
<INDEXCOLUMNS>
604
<INDEXCOLUMNS>
608
<INDEXCOLUMN idColumn="1461" LengthParam="0" />
605
<INDEXCOLUMN idColumn="1461" LengthParam="0" />
609
</INDEXCOLUMNS>
606
</INDEXCOLUMNS>
610
</INDEX>
607
</INDEX>
611
</INDICES>
608
</INDICES>
612
</TABLE>
609
</TABLE>
613
<TABLE ID="1407" Tablename="gestion_travail_projet" PrevTableName="gestion_travail" XPos="394" YPos="473" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" >
610
<TABLE ID="1407" Tablename="gestion_travail_projet" PrevTableName="gestion_travail" XPos="394" YPos="473" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" >
614
<COLUMNS>
611
<COLUMNS>
615
<COLUMN ID="1742" ColName="gtp_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
612
<COLUMN ID="1742" ColName="gtp_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
616
<OPTIONSELECTED>
613
<OPTIONSELECTED>
617
<OPTIONSELECT Value="1" />
614
<OPTIONSELECT Value="1" />
618
<OPTIONSELECT Value="0" />
615
<OPTIONSELECT Value="0" />
619
</OPTIONSELECTED>
616
</OPTIONSELECTED>
620
</COLUMN>
617
</COLUMN>
621
<COLUMN ID="1743" ColName="gtp_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
618
<COLUMN ID="1743" ColName="gtp_id_projet" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
622
<OPTIONSELECTED>
619
<OPTIONSELECTED>
623
<OPTIONSELECT Value="1" />
620
<OPTIONSELECT Value="1" />
624
<OPTIONSELECT Value="0" />
621
<OPTIONSELECT Value="0" />
625
</OPTIONSELECTED>
622
</OPTIONSELECTED>
626
</COLUMN>
623
</COLUMN>
627
<COLUMN ID="1474" ColName="gtp_id_date_travail" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
624
<COLUMN ID="1474" ColName="gtp_id_date_travail" PrevColName="" Pos="3" idDatatype="14" DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0000-00-00" Comments="">
628
<OPTIONSELECTED>
625
<OPTIONSELECTED>
629
</OPTIONSELECTED>
626
</OPTIONSELECTED>
630
</COLUMN>
627
</COLUMN>
631
<COLUMN ID="1475" ColName="gtp_duree" PrevColName="" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
628
<COLUMN ID="1475" ColName="gtp_duree" PrevColName="" Pos="4" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
632
<OPTIONSELECTED>
629
<OPTIONSELECTED>
633
<OPTIONSELECT Value="0" />
630
<OPTIONSELECT Value="0" />
634
</OPTIONSELECTED>
631
</OPTIONSELECTED>
635
</COLUMN>
632
</COLUMN>
636
</COLUMNS>
633
</COLUMNS>
637
<RELATIONS_END>
634
<RELATIONS_END>
638
<RELATION_END ID="1510" />
635
<RELATION_END ID="1510" />
639
<RELATION_END ID="1511" />
636
<RELATION_END ID="1511" />
640
</RELATIONS_END>
637
</RELATIONS_END>
641
<INDICES>
638
<INDICES>
642
<INDEX ID="1476" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
639
<INDEX ID="1476" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
643
<INDEXCOLUMNS>
640
<INDEXCOLUMNS>
644
<INDEXCOLUMN idColumn="1742" LengthParam="0" />
641
<INDEXCOLUMN idColumn="1742" LengthParam="0" />
645
<INDEXCOLUMN idColumn="1743" LengthParam="0" />
642
<INDEXCOLUMN idColumn="1743" LengthParam="0" />
646
<INDEXCOLUMN idColumn="1474" LengthParam="0" />
643
<INDEXCOLUMN idColumn="1474" LengthParam="0" />
647
</INDEXCOLUMNS>
644
</INDEXCOLUMNS>
648
</INDEX>
645
</INDEX>
649
</INDICES>
646
</INDICES>
650
</TABLE>
647
</TABLE>
651
<TABLE ID="1408" Tablename="gestion_utilisateur" PrevTableName="" XPos="686" YPos="365" 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" >
648
<TABLE ID="1408" Tablename="gestion_utilisateur" PrevTableName="" XPos="686" YPos="365" 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" >
652
<COLUMNS>
649
<COLUMNS>
653
<COLUMN ID="1477" ColName="gu_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
650
<COLUMN ID="1477" ColName="gu_id_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
654
<OPTIONSELECTED>
651
<OPTIONSELECTED>
655
<OPTIONSELECT Value="1" />
652
<OPTIONSELECT Value="1" />
656
<OPTIONSELECT Value="0" />
653
<OPTIONSELECT Value="0" />
657
</OPTIONSELECTED>
654
</OPTIONSELECTED>
658
</COLUMN>
655
</COLUMN>
659
<COLUMN ID="1763" ColName="gu_ce_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
656
<COLUMN ID="1763" ColName="gu_ce_statut" PrevColName="" Pos="1" idDatatype="1" DatatypeParams="(3)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
660
<OPTIONSELECTED>
657
<OPTIONSELECTED>
661
<OPTIONSELECT Value="1" />
658
<OPTIONSELECT Value="1" />
662
<OPTIONSELECT Value="0" />
659
<OPTIONSELECT Value="0" />
663
</OPTIONSELECTED>
660
</OPTIONSELECTED>
664
</COLUMN>
661
</COLUMN>
665
<COLUMN ID="1479" ColName="gu_nom" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
662
<COLUMN ID="1479" ColName="gu_nom" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
666
<OPTIONSELECTED>
663
<OPTIONSELECTED>
667
<OPTIONSELECT Value="0" />
664
<OPTIONSELECT Value="0" />
668
</OPTIONSELECTED>
665
</OPTIONSELECTED>
669
</COLUMN>
666
</COLUMN>
670
<COLUMN ID="1480" ColName="gu_prenom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
667
<COLUMN ID="1480" ColName="gu_prenom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
671
<OPTIONSELECTED>
668
<OPTIONSELECTED>
672
<OPTIONSELECT Value="0" />
669
<OPTIONSELECT Value="0" />
673
</OPTIONSELECTED>
670
</OPTIONSELECTED>
674
</COLUMN>
671
</COLUMN>
675
<COLUMN ID="1481" ColName="gu_password" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
672
<COLUMN ID="1481" ColName="gu_password" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
676
<OPTIONSELECTED>
673
<OPTIONSELECTED>
677
<OPTIONSELECT Value="0" />
674
<OPTIONSELECT Value="0" />
678
</OPTIONSELECTED>
675
</OPTIONSELECTED>
679
</COLUMN>
676
</COLUMN>
680
<COLUMN ID="1482" ColName="gu_email" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
677
<COLUMN ID="1482" ColName="gu_email" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
681
<OPTIONSELECTED>
678
<OPTIONSELECTED>
682
<OPTIONSELECT Value="0" />
679
<OPTIONSELECT Value="0" />
683
</OPTIONSELECTED>
680
</OPTIONSELECTED>
684
</COLUMN>
681
</COLUMN>
685
<COLUMN ID="1483" ColName="gu_telephone" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
682
<COLUMN ID="1483" ColName="gu_telephone" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
686
<OPTIONSELECTED>
683
<OPTIONSELECTED>
687
<OPTIONSELECT Value="1" />
684
<OPTIONSELECT Value="1" />
688
<OPTIONSELECT Value="0" />
685
<OPTIONSELECT Value="0" />
689
</OPTIONSELECTED>
686
</OPTIONSELECTED>
690
</COLUMN>
687
</COLUMN>
691
<COLUMN ID="1484" ColName="gu_adresse" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
688
<COLUMN ID="1484" ColName="gu_adresse" PrevColName="" Pos="8" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
692
<OPTIONSELECTED>
689
<OPTIONSELECTED>
693
<OPTIONSELECT Value="0" />
690
<OPTIONSELECT Value="0" />
694
</OPTIONSELECTED>
691
</OPTIONSELECTED>
695
</COLUMN>
692
</COLUMN>
696
<COLUMN ID="1485" ColName="gu_code_postal" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
693
<COLUMN ID="1485" ColName="gu_code_postal" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
697
<OPTIONSELECTED>
694
<OPTIONSELECTED>
698
<OPTIONSELECT Value="1" />
695
<OPTIONSELECT Value="1" />
699
<OPTIONSELECT Value="0" />
696
<OPTIONSELECT Value="0" />
700
</OPTIONSELECTED>
697
</OPTIONSELECTED>
701
</COLUMN>
698
</COLUMN>
702
<COLUMN ID="1486" ColName="gu_ville" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(50)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
699
<COLUMN ID="1486" ColName="gu_ville" PrevColName="" Pos="10" idDatatype="20" DatatypeParams="(50)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
703
<OPTIONSELECTED>
700
<OPTIONSELECTED>
704
<OPTIONSELECT Value="0" />
701
<OPTIONSELECT Value="0" />
705
</OPTIONSELECTED>
702
</OPTIONSELECTED>
706
</COLUMN>
703
</COLUMN>
707
<COLUMN ID="1487" ColName="gu_quota_heures_supp" PrevColName="" Pos="11" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
704
<COLUMN ID="1487" ColName="gu_quota_heures_supp" PrevColName="" Pos="11" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
708
<OPTIONSELECTED>
705
<OPTIONSELECTED>
709
<OPTIONSELECT Value="0" />
706
<OPTIONSELECT Value="0" />
710
</OPTIONSELECTED>
707
</OPTIONSELECTED>
711
</COLUMN>
708
</COLUMN>
712
<COLUMN ID="1488" ColName="gu_conges_payes" PrevColName="" Pos="12" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
709
<COLUMN ID="1488" ColName="gu_conges_payes" PrevColName="" Pos="12" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
713
<OPTIONSELECTED>
710
<OPTIONSELECTED>
714
<OPTIONSELECT Value="0" />
711
<OPTIONSELECT Value="0" />
715
</OPTIONSELECTED>
712
</OPTIONSELECTED>
716
</COLUMN>
713
</COLUMN>
717
<COLUMN ID="1489" ColName="gu_temps_de_travail" PrevColName="" Pos="13" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
714
<COLUMN ID="1489" ColName="gu_temps_de_travail" PrevColName="" Pos="13" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
718
<OPTIONSELECTED>
715
<OPTIONSELECTED>
719
<OPTIONSELECT Value="0" />
716
<OPTIONSELECT Value="0" />
720
</OPTIONSELECTED>
717
</OPTIONSELECTED>
721
</COLUMN>
718
</COLUMN>
722
<COLUMN ID="1490" ColName="gu_mark_admin" PrevColName="" Pos="14" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
719
<COLUMN ID="1490" ColName="gu_mark_admin" PrevColName="" Pos="14" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
723
<OPTIONSELECTED>
720
<OPTIONSELECTED>
724
</OPTIONSELECTED>
721
</OPTIONSELECTED>
725
</COLUMN>
722
</COLUMN>
726
<COLUMN ID="1491" ColName="gu_mark_recapitulatif" PrevColName="" Pos="15" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
723
<COLUMN ID="1491" ColName="gu_mark_recapitulatif" PrevColName="" Pos="15" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
727
<OPTIONSELECTED>
724
<OPTIONSELECTED>
728
</OPTIONSELECTED>
725
</OPTIONSELECTED>
729
</COLUMN>
726
</COLUMN>
730
<COLUMN ID="1492" ColName="gu_notes" PrevColName="" Pos="16" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
727
<COLUMN ID="1492" ColName="gu_notes" PrevColName="" Pos="16" idDatatype="28" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
731
<OPTIONSELECTED>
728
<OPTIONSELECTED>
732
</OPTIONSELECTED>
729
</OPTIONSELECTED>
733
</COLUMN>
730
</COLUMN>
734
</COLUMNS>
731
</COLUMNS>
735
<RELATIONS_START>
732
<RELATIONS_START>
736
<RELATION_START ID="1494" />
733
<RELATION_START ID="1494" />
737
<RELATION_START ID="1503" />
734
<RELATION_START ID="1503" />
738
<RELATION_START ID="1510" />
735
<RELATION_START ID="1510" />
739
<RELATION_START ID="1585" />
736
<RELATION_START ID="1585" />
740
<RELATION_START ID="1612" />
737
<RELATION_START ID="1612" />
741
</RELATIONS_START>
738
</RELATIONS_START>
742
<RELATIONS_END>
739
<RELATIONS_END>
743
<RELATION_END ID="1592" />
740
<RELATION_END ID="1592" />
744
</RELATIONS_END>
741
</RELATIONS_END>
745
<INDICES>
742
<INDICES>
746
<INDEX ID="1493" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
743
<INDEX ID="1493" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
747
<INDEXCOLUMNS>
744
<INDEXCOLUMNS>
748
<INDEXCOLUMN idColumn="1477" LengthParam="0" />
745
<INDEXCOLUMN idColumn="1477" LengthParam="0" />
749
</INDEXCOLUMNS>
746
</INDEXCOLUMNS>
750
</INDEX>
747
</INDEX>
751
</INDICES>
748
</INDICES>
752
</TABLE>
749
</TABLE>
753
<TABLE ID="1400" Tablename="gestion_note_frais" PrevTableName="" XPos="1030" YPos="525" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
750
<TABLE ID="1400" Tablename="gestion_note_frais" PrevTableName="" XPos="1030" YPos="525" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
754
<COLUMNS>
751
<COLUMNS>
755
<COLUMN ID="1439" ColName="gnf_id_note_frais" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
752
<COLUMN ID="1439" ColName="gnf_id_note_frais" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
756
<OPTIONSELECTED>
753
<OPTIONSELECTED>
757
<OPTIONSELECT Value="1" />
754
<OPTIONSELECT Value="1" />
758
<OPTIONSELECT Value="0" />
755
<OPTIONSELECT Value="0" />
759
</OPTIONSELECTED>
756
</OPTIONSELECTED>
760
</COLUMN>
757
</COLUMN>
761
<COLUMN ID="1614" ColName="gnf_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
758
<COLUMN ID="1614" ColName="gnf_ce_utilisateur" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
762
<OPTIONSELECTED>
759
<OPTIONSELECTED>
763
<OPTIONSELECT Value="1" />
760
<OPTIONSELECT Value="1" />
764
<OPTIONSELECT Value="0" />
761
<OPTIONSELECT Value="0" />
765
</OPTIONSELECTED>
762
</OPTIONSELECTED>
766
</COLUMN>
763
</COLUMN>
767
<COLUMN ID="1440" ColName="gnf_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
764
<COLUMN ID="1440" ColName="gnf_libelle" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
768
<OPTIONSELECTED>
765
<OPTIONSELECTED>
769
<OPTIONSELECT Value="0" />
766
<OPTIONSELECT Value="0" />
770
</OPTIONSELECTED>
767
</OPTIONSELECTED>
771
</COLUMN>
768
</COLUMN>
772
</COLUMNS>
769
</COLUMNS>
773
<RELATIONS_START>
770
<RELATIONS_START>
774
<RELATION_START ID="1500" />
771
<RELATION_START ID="1500" />
775
</RELATIONS_START>
772
</RELATIONS_START>
776
<RELATIONS_END>
773
<RELATIONS_END>
777
<RELATION_END ID="1612" />
774
<RELATION_END ID="1612" />
778
</RELATIONS_END>
775
</RELATIONS_END>
779
<INDICES>
776
<INDICES>
780
<INDEX ID="1441" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
777
<INDEX ID="1441" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
781
<INDEXCOLUMNS>
778
<INDEXCOLUMNS>
782
<INDEXCOLUMN idColumn="1439" LengthParam="0" />
779
<INDEXCOLUMN idColumn="1439" LengthParam="0" />
783
</INDEXCOLUMNS>
780
</INDEXCOLUMNS>
784
</INDEX>
781
</INDEX>
785
</INDICES>
782
</INDICES>
786
</TABLE>
783
</TABLE>
787
</TABLES>
784
</TABLES>
788
<RELATIONS>
785
<RELATIONS>
789
<RELATION ID="1494" RelationName="fk_gu_guap" Kind="1" SrcTable="1408" DestTable="1402" FKFields="gu_id_utilisateur=guap_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="-13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="48" CaptionOffsetY="-33" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" />
786
<RELATION ID="1494" RelationName="fk_gu_guap" Kind="1" SrcTable="1408" DestTable="1402" FKFields="gu_id_utilisateur=guap_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="-13" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="48" CaptionOffsetY="-33" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" />
790
<RELATION ID="1498" RelationName="fk_gp_guap" Kind="1" SrcTable="1404" DestTable="1402" FKFields="gp_id_projet=guap_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="19" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-53" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="18" />
787
<RELATION ID="1498" RelationName="fk_gp_guap" Kind="1" SrcTable="1404" DestTable="1402" FKFields="gp_id_projet=guap_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="19" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-53" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="18" />
791
<RELATION ID="1503" RelationName="fk_gu_gfk" Kind="2" SrcTable="1408" DestTable="1396" FKFields="gu_id_utilisateur=gfk_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" />
788
<RELATION ID="1503" RelationName="fk_gu_gfk" Kind="2" SrcTable="1408" DestTable="1396" FKFields="gu_id_utilisateur=gfk_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" />
792
<RELATION ID="1505" RelationName="fk_gfkt_gfk" Kind="2" SrcTable="1398" DestTable="1396" FKFields="gfkt_id_frais_km_taux=gfkt_id_frais_km_taux\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-59" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" />
789
<RELATION ID="1505" RelationName="fk_gfkt_gfk" Kind="2" SrcTable="1398" DestTable="1396" FKFields="gfkt_id_frais_km_taux=gfkt_id_frais_km_taux\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-59" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" />
793
<RELATION ID="1510" RelationName="fk_gu_gtp" Kind="1" SrcTable="1408" DestTable="1407" FKFields="gu_id_utilisateur=gtp_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-1" CaptionOffsetY="-46" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
790
<RELATION ID="1510" RelationName="fk_gu_gtp" Kind="1" SrcTable="1408" DestTable="1407" FKFields="gu_id_utilisateur=gtp_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-1" CaptionOffsetY="-46" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
794
<RELATION ID="1511" RelationName="fk_gp_gtp" Kind="1" SrcTable="1404" DestTable="1407" FKFields="gp_id_projet=gtp_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="-12" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="48" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" />
791
<RELATION ID="1511" RelationName="fk_gp_gtp" Kind="1" SrcTable="1404" DestTable="1407" FKFields="gp_id_projet=gtp_id_projet\n" FKFieldsComments="\n" relDirection="2" MidOffset="-12" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="48" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" />
795
<RELATION ID="1564" RelationName="fk_gpc_gp" Kind="5" SrcTable="1395" DestTable="1404" FKFields="gpc_id_categorie=gp_ce_categorie\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
792
<RELATION ID="1564" RelationName="fk_gpc_gp" Kind="5" SrcTable="1395" DestTable="1404" FKFields="gpc_id_categorie=gp_ce_categorie\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
796
<RELATION ID="1583" RelationName="fk_gam_ga" Kind="1" SrcTable="1399" DestTable="1394" FKFields="gam_id_absence_motif=ga_id_absence_motif\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
793
<RELATION ID="1583" RelationName="fk_gam_ga" Kind="1" SrcTable="1399" DestTable="1394" FKFields="gam_id_absence_motif=ga_id_absence_motif\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-47" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
797
<RELATION ID="1585" RelationName="fk_gu_ga" Kind="1" SrcTable="1408" DestTable="1394" FKFields="gu_id_utilisateur=ga_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-45" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
794
<RELATION ID="1585" RelationName="fk_gu_ga" Kind="1" SrcTable="1408" DestTable="1394" FKFields="gu_id_utilisateur=ga_id_utilisateur\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-45" CaptionOffsetY="-22" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
798
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gu_ce_statut\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-41" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
795
<RELATION ID="1592" RelationName="fk_gs_gu" Kind="2" SrcTable="1405" DestTable="1408" FKFields="gus_id_utilisateur_statut=gu_ce_statut\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-41" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
799
<RELATION ID="1500" RelationName="fk_gnf_gnfl" Kind="5" SrcTable="1400" DestTable="1397" FKFields="gnf_id_note_frais=gnfl_ce_note_frais\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-48" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" />
796
<RELATION ID="1500" RelationName="fk_gnf_gnfl" Kind="5" SrcTable="1400" DestTable="1397" FKFields="gnf_id_note_frais=gnfl_ce_note_frais\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-48" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" />
800
<RELATION ID="1612" RelationName="fk_gu_gnf" Kind="2" SrcTable="1408" DestTable="1400" FKFields="gu_id_utilisateur=gnf_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
797
<RELATION ID="1612" RelationName="fk_gu_gnf" Kind="2" SrcTable="1408" DestTable="1400" FKFields="gu_id_utilisateur=gnf_ce_utilisateur\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
801
<RELATION ID="1764" RelationName="fk_gp_gp_parent" Kind="2" SrcTable="1404" DestTable="1404" FKFields="gp_id_projet=gp_ce_projet_parent\n" FKFieldsComments="\n" relDirection="2" MidOffset="23" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-71" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
798
<RELATION ID="1764" RelationName="fk_gp_gp_parent" Kind="2" SrcTable="1404" DestTable="1404" FKFields="gp_id_projet=gp_ce_projet_parent\n" FKFieldsComments="\n" relDirection="2" MidOffset="23" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-71" CaptionOffsetY="-23" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" />
802
</RELATIONS>
799
</RELATIONS>
803
<NOTES>
800
<NOTES>
804
</NOTES>
801
</NOTES>
805
<IMAGES>
802
<IMAGES>
806
</IMAGES>
803
</IMAGES>
807
</METADATA>
804
</METADATA>
808
<PLUGINDATA>
805
<PLUGINDATA>
809
<PLUGINDATARECORDS>
806
<PLUGINDATARECORDS>
810
</PLUGINDATARECORDS>
807
</PLUGINDATARECORDS>
811
</PLUGINDATA>
808
</PLUGINDATA>
812
<QUERYDATA>
809
<QUERYDATA>
813
<QUERYRECORDS>
810
<QUERYRECORDS>
814
</QUERYRECORDS>
811
</QUERYRECORDS>
815
</QUERYDATA>
812
</QUERYDATA>
816
<LINKEDMODELS>
813
<LINKEDMODELS>
817
</LINKEDMODELS>
814
</LINKEDMODELS>
818
</DBMODEL>
815
</DBMODEL>