markus / DataBase / EntityModel / MarkusModel.edmx @ 4cb62752
이력 | 보기 | 이력해설 | 다운로드 (79.2 KB)
1 |
<?xml version="1.0" encoding="utf-8"?> |
---|---|
2 |
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx"> |
3 |
<!-- EF Runtime content --> |
4 |
<edmx:Runtime> |
5 |
<!-- SSDL content --> |
6 |
<edmx:StorageModels> |
7 |
<Schema Namespace="MarkusDBModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl"> |
8 |
<EntityType Name="ATTACH_URL"> |
9 |
<Key> |
10 |
<PropertyRef Name="ID" /> |
11 |
</Key> |
12 |
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> |
13 |
<Property Name="GROUP_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
14 |
<Property Name="ATTACH_URL1" Type="nvarchar" MaxLength="500" Nullable="false" /> |
15 |
<Property Name="FILE_NAME" Type="nvarchar" MaxLength="500" Nullable="false" /> |
16 |
<Property Name="CREATE_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
17 |
<Property Name="CREATE_DATE" Type="datetime" Nullable="false" /> |
18 |
</EntityType> |
19 |
<EntityType Name="CERTIFY_CMS_TEST"> |
20 |
<Key> |
21 |
<PropertyRef Name="ID" /> |
22 |
</Key> |
23 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
24 |
<Property Name="MEMBER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
25 |
<Property Name="ACCESSTOKEN" Type="nvarchar" MaxLength="200" Nullable="false" /> |
26 |
<Property Name="LOGIN_DATE" Type="nvarchar" MaxLength="50" Nullable="false" /> |
27 |
<Property Name="EXPIRE_DATE" Type="nvarchar" MaxLength="50" Nullable="false" /> |
28 |
<Property Name="DEVICE_TYPE" Type="int" Nullable="false" /> |
29 |
<Property Name="DEVICE_SERIAL_NUMBER" Type="nvarchar" MaxLength="30" /> |
30 |
</EntityType> |
31 |
<EntityType Name="CONVERTER_DOC"> |
32 |
<Key> |
33 |
<PropertyRef Name="ID" /> |
34 |
</Key> |
35 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
36 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
37 |
<Property Name="DOCUMENT_URL" Type="nvarchar" MaxLength="500" Nullable="false" /> |
38 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
39 |
<Property Name="CREATE_DATETIME" Type="datetime" Nullable="false" /> |
40 |
<Property Name="STATUS" Type="int" Nullable="false" /> |
41 |
<Property Name="TOTAL_PAGE" Type="int" Nullable="false" /> |
42 |
<Property Name="CURRENT_PAGE" Type="int" Nullable="false" /> |
43 |
<Property Name="EXCEPTION" Type="nvarchar(max)" /> |
44 |
<Property Name="END_DATETIME" Type="datetime" /> |
45 |
<Property Name="START_DATETIME" Type="datetime" /> |
46 |
<Property Name="SERVICE_ID" Type="nvarchar" MaxLength="50" /> |
47 |
<Property Name="RECONVERTER" Type="int" Nullable="false" /> |
48 |
</EntityType> |
49 |
<EntityType Name="DOCINFO"> |
50 |
<Key> |
51 |
<PropertyRef Name="ID" /> |
52 |
</Key> |
53 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
54 |
<Property Name="ORIGINAL_FILE" Type="nvarchar" MaxLength="500" Nullable="false" /> |
55 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
56 |
<Property Name="PAGE_COUNT" Type="int" Nullable="false" /> |
57 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
58 |
</EntityType> |
59 |
<EntityType Name="DOCPAGE"> |
60 |
<Key> |
61 |
<PropertyRef Name="ID" /> |
62 |
</Key> |
63 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
64 |
<Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
65 |
<Property Name="PAGE_NUMBER" Type="int" Nullable="false" /> |
66 |
<Property Name="PAGE_WIDTH" Type="nvarchar" MaxLength="20" Nullable="false" /> |
67 |
<Property Name="PAGE_HEIGHT" Type="nvarchar" MaxLength="20" Nullable="false" /> |
68 |
<Property Name="PAGE_ANGLE" Type="int" Nullable="false" /> |
69 |
</EntityType> |
70 |
<EntityType Name="DOCUMENT_ITEM"> |
71 |
<Key> |
72 |
<PropertyRef Name="ID" /> |
73 |
</Key> |
74 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
75 |
<Property Name="REVISION" Type="nvarchar" MaxLength="50" Nullable="false" /> |
76 |
<Property Name="DOCUMENT_NO" Type="nvarchar" MaxLength="50" Nullable="false" /> |
77 |
<Property Name="DOCUMENT_NAME" Type="nvarchar" MaxLength="500" Nullable="false" /> |
78 |
<Property Name="GROUP_NO" Type="nvarchar" MaxLength="50" /> |
79 |
<Property Name="ORIGINAL_FILE" Type="nvarchar" MaxLength="500" Nullable="false" /> |
80 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
81 |
<Property Name="RESULT_FILE" Type="nvarchar" MaxLength="500" /> |
82 |
<Property Name="RESULT" Type="nvarchar" MaxLength="50" /> |
83 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
84 |
<Property Name="Link" Type="varchar(max)" /> |
85 |
</EntityType> |
86 |
<EntityType Name="ERROR_LOG"> |
87 |
<Key> |
88 |
<PropertyRef Name="ID" /> |
89 |
</Key> |
90 |
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> |
91 |
<Property Name="SERVICE_NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> |
92 |
<Property Name="LEVEL" Type="nvarchar" MaxLength="10" /> |
93 |
<Property Name="TYPE" Type="nvarchar" MaxLength="10" /> |
94 |
<Property Name="CONTENTS" Type="nvarchar(max)" /> |
95 |
<Property Name="CREATE_DATETIME" Type="nvarchar(max)" Nullable="false" /> |
96 |
<Property Name="CODE" Type="nvarchar" MaxLength="10" Nullable="false" /> |
97 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
98 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
99 |
</EntityType> |
100 |
<EntityType Name="FAVORITE_DOC"> |
101 |
<Key> |
102 |
<PropertyRef Name="ID" /> |
103 |
</Key> |
104 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
105 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
106 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
107 |
<Property Name="GROUP_NO" Type="nvarchar" MaxLength="50" Nullable="false" /> |
108 |
<Property Name="DOCUMENT_NO" Type="nvarchar" MaxLength="50" Nullable="false" /> |
109 |
<Property Name="MEMBER_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
110 |
<Property Name="DESCRIPTION" Type="nvarchar(max)" /> |
111 |
<Property Name="CREATE_TIME" Type="datetime" Nullable="false" /> |
112 |
<Property Name="FLAG" Type="int" Nullable="false" /> |
113 |
<Property Name="REVISION" Type="nvarchar" MaxLength="50" Nullable="false" /> |
114 |
<Property Name="PAGE_NO" Type="int" Nullable="false" /> |
115 |
</EntityType> |
116 |
<EntityType Name="FINAL_PDF"> |
117 |
<Key> |
118 |
<PropertyRef Name="ID" /> |
119 |
</Key> |
120 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
121 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
122 |
<Property Name="DOCINFO_ID" Type="int" Nullable="false" /> |
123 |
<Property Name="MARKUPINFO_ID" Type="int" Nullable="false" /> |
124 |
<Property Name="CREATE_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
125 |
<Property Name="CREATE_DATETIME" Type="datetime" Nullable="false" /> |
126 |
<Property Name="STATUS" Type="int" Nullable="false" /> |
127 |
<Property Name="TOTAL_PAGE" Type="int" Nullable="false" /> |
128 |
<Property Name="CURRENT_PAGE" Type="int" Nullable="false" /> |
129 |
<Property Name="EXCEPTION" Type="nvarchar(max)" /> |
130 |
<Property Name="END_DATETIME" Type="datetime" /> |
131 |
<Property Name="START_DATETIME" Type="datetime" /> |
132 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" /> |
133 |
</EntityType> |
134 |
<EntityType Name="LOGIN_STAMP"> |
135 |
<Key> |
136 |
<PropertyRef Name="ID" /> |
137 |
</Key> |
138 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
139 |
<Property Name="USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
140 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
141 |
<Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
142 |
<Property Name="START_DATETIME" Type="datetime" Nullable="false" /> |
143 |
<Property Name="END_DATETIME" Type="datetime" /> |
144 |
<Property Name="ISLOGIN" Type="int" Nullable="false" /> |
145 |
</EntityType> |
146 |
<EntityType Name="MARKUP_CHECKLIST"> |
147 |
<Key> |
148 |
<PropertyRef Name="CK_NO" /> |
149 |
</Key> |
150 |
<Property Name="CK_NO" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> |
151 |
<Property Name="CK_REV_NO" Type="nvarchar" MaxLength="10" /> |
152 |
<Property Name="CK_PAGE" Type="int" /> |
153 |
<Property Name="CK_COMMENT" Type="nvarchar" MaxLength="200" /> |
154 |
<Property Name="CK_TODO" Type="nvarchar" MaxLength="200" /> |
155 |
<Property Name="CK_STATUS" Type="nvarchar" MaxLength="10" /> |
156 |
<Property Name="CK_RESULT" Type="nvarchar" MaxLength="10" /> |
157 |
</EntityType> |
158 |
<EntityType Name="MARKUP_DATA"> |
159 |
<Key> |
160 |
<PropertyRef Name="ID" /> |
161 |
</Key> |
162 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
163 |
<Property Name="PAGENUMBER" Type="int" Nullable="false" /> |
164 |
<Property Name="DATA" Type="nvarchar(max)" Nullable="false" /> |
165 |
<Property Name="MARKUPINFO_VERSION_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
166 |
<Property Name="DATA_TYPE" Type="int" Nullable="false" /> |
167 |
</EntityType> |
168 |
<EntityType Name="MARKUP_INFO"> |
169 |
<Key> |
170 |
<PropertyRef Name="ID" /> |
171 |
</Key> |
172 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
173 |
<Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
174 |
<Property Name="USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
175 |
<Property Name="CREATE_TIME" Type="datetime" Nullable="false" /> |
176 |
<Property Name="CONSOLIDATE" Type="int" Nullable="false" /> |
177 |
<Property Name="DESCRIPTION" Type="nvarchar" MaxLength="500" /> |
178 |
<Property Name="AVOID_CONSOLIDATE" Type="int" Nullable="false" /> |
179 |
<Property Name="PART_CONSOLIDATE" Type="int" Nullable="false" /> |
180 |
<Property Name="UPDATE_TIME" Type="datetime" /> |
181 |
</EntityType> |
182 |
<EntityType Name="MARKUP_INFO_VERSION"> |
183 |
<Key> |
184 |
<PropertyRef Name="ID" /> |
185 |
</Key> |
186 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
187 |
<Property Name="MARKUPINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
188 |
<Property Name="CREATE_DATE" Type="datetime" Nullable="false" /> |
189 |
</EntityType> |
190 |
<EntityType Name="MEMBER"> |
191 |
<Key> |
192 |
<PropertyRef Name="ID" /> |
193 |
</Key> |
194 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
195 |
<Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" /> |
196 |
<Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> |
197 |
<Property Name="POSITION" Type="nvarchar" MaxLength="50" /> |
198 |
<Property Name="EMAIL_ADDRESS" Type="nvarchar" MaxLength="50" /> |
199 |
</EntityType> |
200 |
<EntityType Name="MEMBER_CMS_TEST"> |
201 |
<Key> |
202 |
<PropertyRef Name="ID" /> |
203 |
</Key> |
204 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
205 |
<Property Name="MEMBER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
206 |
<Property Name="MEMBER_PASS" Type="nvarchar" MaxLength="50" Nullable="false" /> |
207 |
</EntityType> |
208 |
<EntityType Name="PRINT_DOC"> |
209 |
<Key> |
210 |
<PropertyRef Name="ID" /> |
211 |
</Key> |
212 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
213 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
214 |
<Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
215 |
<Property Name="CREATE_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
216 |
<Property Name="STATUS" Type="int" Nullable="false" /> |
217 |
<Property Name="CURRENT_PAGE" Type="int" Nullable="false" /> |
218 |
<Property Name="TOTAL_PAGE" Type="int" Nullable="false" /> |
219 |
<Property Name="EXCEPTION" Type="nvarchar(max)" /> |
220 |
<Property Name="START_DATETIME" Type="datetime" Nullable="false" /> |
221 |
<Property Name="END_DATETIME" Type="datetime" /> |
222 |
<Property Name="IS_EXPORT_FILE" Type="int" Nullable="false" /> |
223 |
<Property Name="PRINT_PAGES" Type="int" Nullable="false" /> |
224 |
<Property Name="PDFURL" Type="nvarchar(max)" Nullable="false" /> |
225 |
<Property Name="IS_ONLY_RED" Type="int" Nullable="false" /> |
226 |
</EntityType> |
227 |
<EntityType Name="PRINT_EXCEL"> |
228 |
<Key> |
229 |
<PropertyRef Name="ID" /> |
230 |
</Key> |
231 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
232 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
233 |
<Property Name="GROUP_NO" Type="nvarchar" MaxLength="50" Nullable="false" /> |
234 |
<Property Name="CREATE_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
235 |
<Property Name="START_DATETIME" Type="datetime" Nullable="false" /> |
236 |
<Property Name="END_DATETIME" Type="datetime" /> |
237 |
<Property Name="EXCEPTION" Type="nvarchar" MaxLength="500" /> |
238 |
<Property Name="STATUS" Type="int" Nullable="false" /> |
239 |
<Property Name="DOCUMENT_ID_SET" Type="nvarchar" MaxLength="50" Nullable="false" /> |
240 |
<Property Name="FILE_PATH" Type="nvarchar(max)" /> |
241 |
</EntityType> |
242 |
<EntityType Name="PROJECT_SETTING"> |
243 |
<Key> |
244 |
<PropertyRef Name="ID" /> |
245 |
</Key> |
246 |
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> |
247 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
248 |
<Property Name="REVISION" Type="nvarchar" MaxLength="30" Nullable="false" /> |
249 |
<Property Name="RESULT" Type="nvarchar" MaxLength="30" Nullable="false" /> |
250 |
</EntityType> |
251 |
<EntityType Name="PROPERTIES"> |
252 |
<Key> |
253 |
<PropertyRef Name="ID" /> |
254 |
</Key> |
255 |
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> |
256 |
<Property Name="TYPE" Type="nvarchar" MaxLength="50" Nullable="false" /> |
257 |
<Property Name="PROPERTY" Type="nvarchar" MaxLength="100" Nullable="false" /> |
258 |
<Property Name="VALUE" Type="varchar(max)" Nullable="false" /> |
259 |
</EntityType> |
260 |
<EntityType Name="RUN_PROJECTS"> |
261 |
<Key> |
262 |
<PropertyRef Name="PROJECT_NO" /> |
263 |
</Key> |
264 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
265 |
<Property Name="PROJECT_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> |
266 |
<Property Name="RUN_DATETIME" Type="datetime" Nullable="false" /> |
267 |
<Property Name="IS_ACTIVITY" Type="int" Nullable="false" /> |
268 |
</EntityType> |
269 |
<EntityType Name="SERVICE_PROPERTIES"> |
270 |
<Key> |
271 |
<PropertyRef Name="ID" /> |
272 |
</Key> |
273 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
274 |
<Property Name="SERVICET_TYPE" Type="int" Nullable="false" /> |
275 |
<Property Name="SERVICE_ADDRESS" Type="nvarchar" MaxLength="100" /> |
276 |
<Property Name="SERVICE_PORT" Type="int" /> |
277 |
<Property Name="HOST_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> |
278 |
<Property Name="PROCESS_COUNT" Type="int" Nullable="false" /> |
279 |
</EntityType> |
280 |
<EntityType Name="SIGN_INFO"> |
281 |
<Key> |
282 |
<PropertyRef Name="ID" /> |
283 |
</Key> |
284 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
285 |
<Property Name="SIGN_STR" Type="nvarchar(max)" Nullable="false" /> |
286 |
<Property Name="MEMBER_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
287 |
<Property Name="CREATE_DATE" Type="datetime" Nullable="false" /> |
288 |
<Property Name="MODIFY_DATE" Type="datetime" /> |
289 |
</EntityType> |
290 |
<EntityType Name="SYMBOL_PRIVATE"> |
291 |
<Key> |
292 |
<PropertyRef Name="ID" /> |
293 |
</Key> |
294 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
295 |
<Property Name="MEMBER_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
296 |
<Property Name="NAME" Type="nvarchar" MaxLength="500" Nullable="false" /> |
297 |
<Property Name="IMAGE_URL" Type="nvarchar" MaxLength="500" Nullable="false" /> |
298 |
<Property Name="DATA" Type="nvarchar(max)" Nullable="false" /> |
299 |
</EntityType> |
300 |
<EntityType Name="SYMBOL_PUBLIC"> |
301 |
<Key> |
302 |
<PropertyRef Name="ID" /> |
303 |
</Key> |
304 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
305 |
<Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" Nullable="false" /> |
306 |
<Property Name="IMAGE_URL" Type="nvarchar" MaxLength="500" Nullable="false" /> |
307 |
<Property Name="DATA" Type="nvarchar(max)" Nullable="false" /> |
308 |
<Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> |
309 |
</EntityType> |
310 |
<Association Name="FK_ATTACH_URL_DOCUMENT_ITEM"> |
311 |
<End Role="DOCUMENT_ITEM" Type="Self.DOCUMENT_ITEM" Multiplicity="1" /> |
312 |
<End Role="ATTACH_URL" Type="Self.ATTACH_URL" Multiplicity="*" /> |
313 |
<ReferentialConstraint> |
314 |
<Principal Role="DOCUMENT_ITEM"> |
315 |
<PropertyRef Name="ID" /> |
316 |
</Principal> |
317 |
<Dependent Role="ATTACH_URL"> |
318 |
<PropertyRef Name="GROUP_ID" /> |
319 |
</Dependent> |
320 |
</ReferentialConstraint> |
321 |
</Association> |
322 |
<Association Name="FK_DOCINFODOFPAGE"> |
323 |
<End Role="DOCINFO" Type="Self.DOCINFO" Multiplicity="1" /> |
324 |
<End Role="DOCPAGE" Type="Self.DOCPAGE" Multiplicity="*" /> |
325 |
<ReferentialConstraint> |
326 |
<Principal Role="DOCINFO"> |
327 |
<PropertyRef Name="ID" /> |
328 |
</Principal> |
329 |
<Dependent Role="DOCPAGE"> |
330 |
<PropertyRef Name="DOCINFO_ID" /> |
331 |
</Dependent> |
332 |
</ReferentialConstraint> |
333 |
</Association> |
334 |
<Association Name="FK_DOCINFOMARKUPINFO"> |
335 |
<End Role="DOCINFO" Type="Self.DOCINFO" Multiplicity="1" /> |
336 |
<End Role="MARKUP_INFO" Type="Self.MARKUP_INFO" Multiplicity="*" /> |
337 |
<ReferentialConstraint> |
338 |
<Principal Role="DOCINFO"> |
339 |
<PropertyRef Name="ID" /> |
340 |
</Principal> |
341 |
<Dependent Role="MARKUP_INFO"> |
342 |
<PropertyRef Name="DOCINFO_ID" /> |
343 |
</Dependent> |
344 |
</ReferentialConstraint> |
345 |
</Association> |
346 |
<Association Name="FK_FAVORIT_DOC_FAVORIT_DOC"> |
347 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" /> |
348 |
<End Role="FAVORITE_DOC" Type="Self.FAVORITE_DOC" Multiplicity="*" /> |
349 |
<ReferentialConstraint> |
350 |
<Principal Role="MEMBER"> |
351 |
<PropertyRef Name="ID" /> |
352 |
</Principal> |
353 |
<Dependent Role="FAVORITE_DOC"> |
354 |
<PropertyRef Name="MEMBER_USER_ID" /> |
355 |
</Dependent> |
356 |
</ReferentialConstraint> |
357 |
</Association> |
358 |
<Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA"> |
359 |
<End Role="MARKUP_INFO_VERSION" Type="Self.MARKUP_INFO_VERSION" Multiplicity="1" /> |
360 |
<End Role="MARKUP_DATA" Type="Self.MARKUP_DATA" Multiplicity="*" /> |
361 |
<ReferentialConstraint> |
362 |
<Principal Role="MARKUP_INFO_VERSION"> |
363 |
<PropertyRef Name="ID" /> |
364 |
</Principal> |
365 |
<Dependent Role="MARKUP_DATA"> |
366 |
<PropertyRef Name="MARKUPINFO_VERSION_ID" /> |
367 |
</Dependent> |
368 |
</ReferentialConstraint> |
369 |
</Association> |
370 |
<Association Name="FK_MARKUPINFOMARKUPINFO_VERSION"> |
371 |
<End Role="MARKUP_INFO" Type="Self.MARKUP_INFO" Multiplicity="1" /> |
372 |
<End Role="MARKUP_INFO_VERSION" Type="Self.MARKUP_INFO_VERSION" Multiplicity="*" /> |
373 |
<ReferentialConstraint> |
374 |
<Principal Role="MARKUP_INFO"> |
375 |
<PropertyRef Name="ID" /> |
376 |
</Principal> |
377 |
<Dependent Role="MARKUP_INFO_VERSION"> |
378 |
<PropertyRef Name="MARKUPINFO_ID" /> |
379 |
</Dependent> |
380 |
</ReferentialConstraint> |
381 |
</Association> |
382 |
<Association Name="FK_SIGNINFO_MEMBER"> |
383 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" /> |
384 |
<End Role="SIGN_INFO" Type="Self.SIGN_INFO" Multiplicity="*" /> |
385 |
<ReferentialConstraint> |
386 |
<Principal Role="MEMBER"> |
387 |
<PropertyRef Name="ID" /> |
388 |
</Principal> |
389 |
<Dependent Role="SIGN_INFO"> |
390 |
<PropertyRef Name="MEMBER_USER_ID" /> |
391 |
</Dependent> |
392 |
</ReferentialConstraint> |
393 |
</Association> |
394 |
<Association Name="FK_SYMBOL_PRIVATE_MEMBER"> |
395 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" /> |
396 |
<End Role="SYMBOL_PRIVATE" Type="Self.SYMBOL_PRIVATE" Multiplicity="*" /> |
397 |
<ReferentialConstraint> |
398 |
<Principal Role="MEMBER"> |
399 |
<PropertyRef Name="ID" /> |
400 |
</Principal> |
401 |
<Dependent Role="SYMBOL_PRIVATE"> |
402 |
<PropertyRef Name="MEMBER_USER_ID" /> |
403 |
</Dependent> |
404 |
</ReferentialConstraint> |
405 |
</Association> |
406 |
<EntityContainer Name="MarkusDBModelStoreContainer"> |
407 |
<EntitySet Name="ATTACH_URL" EntityType="Self.ATTACH_URL" Schema="dbo" store:Type="Tables" /> |
408 |
<EntitySet Name="CERTIFY_CMS_TEST" EntityType="Self.CERTIFY_CMS_TEST" Schema="dbo" store:Type="Tables" /> |
409 |
<EntitySet Name="CONVERTER_DOC" EntityType="Self.CONVERTER_DOC" Schema="dbo" store:Type="Tables" /> |
410 |
<EntitySet Name="DOCINFO" EntityType="Self.DOCINFO" Schema="dbo" store:Type="Tables" /> |
411 |
<EntitySet Name="DOCPAGE" EntityType="Self.DOCPAGE" Schema="dbo" store:Type="Tables" /> |
412 |
<EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" Schema="dbo" store:Type="Tables" /> |
413 |
<EntitySet Name="ERROR_LOG" EntityType="Self.ERROR_LOG" Schema="dbo" store:Type="Tables" /> |
414 |
<EntitySet Name="FAVORITE_DOC" EntityType="Self.FAVORITE_DOC" Schema="dbo" store:Type="Tables" /> |
415 |
<EntitySet Name="FINAL_PDF" EntityType="Self.FINAL_PDF" Schema="dbo" store:Type="Tables" /> |
416 |
<EntitySet Name="LOGIN_STAMP" EntityType="Self.LOGIN_STAMP" Schema="dbo" store:Type="Tables" /> |
417 |
<EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" Schema="dbo" store:Type="Tables" /> |
418 |
<EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" Schema="dbo" store:Type="Tables" /> |
419 |
<EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" /> |
420 |
<EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" /> |
421 |
<EntitySet Name="MEMBER" EntityType="Self.MEMBER" Schema="dbo" store:Type="Tables" /> |
422 |
<EntitySet Name="MEMBER_CMS_TEST" EntityType="Self.MEMBER_CMS_TEST" Schema="dbo" store:Type="Tables" /> |
423 |
<EntitySet Name="PRINT_DOC" EntityType="Self.PRINT_DOC" Schema="dbo" store:Type="Tables" /> |
424 |
<EntitySet Name="PRINT_EXCEL" EntityType="Self.PRINT_EXCEL" Schema="dbo" store:Type="Tables" /> |
425 |
<EntitySet Name="PROJECT_SETTING" EntityType="Self.PROJECT_SETTING" Schema="dbo" store:Type="Tables" /> |
426 |
<EntitySet Name="PROPERTIES" EntityType="Self.PROPERTIES" Schema="dbo" store:Type="Tables" /> |
427 |
<EntitySet Name="RUN_PROJECTS" EntityType="Self.RUN_PROJECTS" Schema="dbo" store:Type="Tables" /> |
428 |
<EntitySet Name="SERVICE_PROPERTIES" EntityType="Self.SERVICE_PROPERTIES" Schema="dbo" store:Type="Tables" /> |
429 |
<EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" /> |
430 |
<EntitySet Name="SYMBOL_PRIVATE" EntityType="Self.SYMBOL_PRIVATE" Schema="dbo" store:Type="Tables" /> |
431 |
<EntitySet Name="SYMBOL_PUBLIC" EntityType="Self.SYMBOL_PUBLIC" Schema="dbo" store:Type="Tables" /> |
432 |
<AssociationSet Name="FK_ATTACH_URL_DOCUMENT_ITEM" Association="Self.FK_ATTACH_URL_DOCUMENT_ITEM"> |
433 |
<End Role="DOCUMENT_ITEM" EntitySet="DOCUMENT_ITEM" /> |
434 |
<End Role="ATTACH_URL" EntitySet="ATTACH_URL" /> |
435 |
</AssociationSet> |
436 |
<AssociationSet Name="FK_DOCINFODOFPAGE" Association="Self.FK_DOCINFODOFPAGE"> |
437 |
<End Role="DOCINFO" EntitySet="DOCINFO" /> |
438 |
<End Role="DOCPAGE" EntitySet="DOCPAGE" /> |
439 |
</AssociationSet> |
440 |
<AssociationSet Name="FK_DOCINFOMARKUPINFO" Association="Self.FK_DOCINFOMARKUPINFO"> |
441 |
<End Role="DOCINFO" EntitySet="DOCINFO" /> |
442 |
<End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" /> |
443 |
</AssociationSet> |
444 |
<AssociationSet Name="FK_FAVORIT_DOC_FAVORIT_DOC" Association="Self.FK_FAVORIT_DOC_FAVORIT_DOC"> |
445 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
446 |
<End Role="FAVORITE_DOC" EntitySet="FAVORITE_DOC" /> |
447 |
</AssociationSet> |
448 |
<AssociationSet Name="FK_MARKUPINFO_VERSIONMARKUPDATA" Association="Self.FK_MARKUPINFO_VERSIONMARKUPDATA"> |
449 |
<End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" /> |
450 |
<End Role="MARKUP_DATA" EntitySet="MARKUP_DATA" /> |
451 |
</AssociationSet> |
452 |
<AssociationSet Name="FK_MARKUPINFOMARKUPINFO_VERSION" Association="Self.FK_MARKUPINFOMARKUPINFO_VERSION"> |
453 |
<End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" /> |
454 |
<End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" /> |
455 |
</AssociationSet> |
456 |
<AssociationSet Name="FK_SIGNINFO_MEMBER" Association="Self.FK_SIGNINFO_MEMBER"> |
457 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
458 |
<End Role="SIGN_INFO" EntitySet="SIGN_INFO" /> |
459 |
</AssociationSet> |
460 |
<AssociationSet Name="FK_SYMBOL_PRIVATE_MEMBER" Association="Self.FK_SYMBOL_PRIVATE_MEMBER"> |
461 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
462 |
<End Role="SYMBOL_PRIVATE" EntitySet="SYMBOL_PRIVATE" /> |
463 |
</AssociationSet> |
464 |
</EntityContainer> |
465 |
</Schema> |
466 |
</edmx:StorageModels> |
467 |
<!-- CSDL content --> |
468 |
<edmx:ConceptualModels> |
469 |
<Schema Namespace="MarkusDBModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm"> |
470 |
<EntityType Name="ATTACH_URL"> |
471 |
<Key> |
472 |
<PropertyRef Name="ID" /> |
473 |
</Key> |
474 |
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
475 |
<Property Name="GROUP_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
476 |
<Property Name="ATTACH_URL1" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
477 |
<Property Name="FILE_NAME" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
478 |
<Property Name="CREATE_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
479 |
<Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" /> |
480 |
<NavigationProperty Name="DOCUMENT_ITEM" Relationship="Self.FK_ATTACH_URL_DOCUMENT_ITEM" FromRole="ATTACH_URL" ToRole="DOCUMENT_ITEM" /> |
481 |
</EntityType> |
482 |
<EntityType Name="CERTIFY_CMS_TEST"> |
483 |
<Key> |
484 |
<PropertyRef Name="ID" /> |
485 |
</Key> |
486 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
487 |
<Property Name="MEMBER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
488 |
<Property Name="ACCESSTOKEN" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" /> |
489 |
<Property Name="LOGIN_DATE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
490 |
<Property Name="EXPIRE_DATE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
491 |
<Property Name="DEVICE_TYPE" Type="Int32" Nullable="false" /> |
492 |
<Property Name="DEVICE_SERIAL_NUMBER" Type="String" MaxLength="30" FixedLength="false" Unicode="true" /> |
493 |
</EntityType> |
494 |
<EntityType Name="CONVERTER_DOC"> |
495 |
<Key> |
496 |
<PropertyRef Name="ID" /> |
497 |
</Key> |
498 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
499 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
500 |
<Property Name="DOCUMENT_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
501 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
502 |
<Property Name="CREATE_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
503 |
<Property Name="STATUS" Type="Int32" Nullable="false" /> |
504 |
<Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" /> |
505 |
<Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" /> |
506 |
<Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
507 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
508 |
<Property Name="START_DATETIME" Type="DateTime" Precision="3" /> |
509 |
<Property Name="SERVICE_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
510 |
<Property Name="RECONVERTER" Type="Int32" Nullable="false" /> |
511 |
</EntityType> |
512 |
<EntityType Name="DOCINFO"> |
513 |
<Key> |
514 |
<PropertyRef Name="ID" /> |
515 |
</Key> |
516 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
517 |
<Property Name="ORIGINAL_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
518 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
519 |
<Property Name="PAGE_COUNT" Type="Int32" Nullable="false" /> |
520 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
521 |
<NavigationProperty Name="DOCPAGE" Relationship="Self.FK_DOCINFODOFPAGE" FromRole="DOCINFO" ToRole="DOCPAGE" /> |
522 |
<NavigationProperty Name="MARKUP_INFO" Relationship="Self.FK_DOCINFOMARKUPINFO" FromRole="DOCINFO" ToRole="MARKUP_INFO" /> |
523 |
</EntityType> |
524 |
<EntityType Name="DOCPAGE"> |
525 |
<Key> |
526 |
<PropertyRef Name="ID" /> |
527 |
</Key> |
528 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
529 |
<Property Name="DOCINFO_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
530 |
<Property Name="PAGE_NUMBER" Type="Int32" Nullable="false" /> |
531 |
<Property Name="PAGE_WIDTH" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" /> |
532 |
<Property Name="PAGE_HEIGHT" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" /> |
533 |
<Property Name="PAGE_ANGLE" Type="Int32" Nullable="false" /> |
534 |
<NavigationProperty Name="DOCINFO" Relationship="Self.FK_DOCINFODOFPAGE" FromRole="DOCPAGE" ToRole="DOCINFO" /> |
535 |
</EntityType> |
536 |
<EntityType Name="DOCUMENT_ITEM"> |
537 |
<Key> |
538 |
<PropertyRef Name="ID" /> |
539 |
</Key> |
540 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
541 |
<Property Name="REVISION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
542 |
<Property Name="DOCUMENT_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
543 |
<Property Name="DOCUMENT_NAME" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
544 |
<Property Name="GROUP_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
545 |
<Property Name="ORIGINAL_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
546 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
547 |
<Property Name="RESULT_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
548 |
<Property Name="RESULT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
549 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
550 |
<Property Name="Link" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" /> |
551 |
<NavigationProperty Name="ATTACH_URL" Relationship="Self.FK_ATTACH_URL_DOCUMENT_ITEM" FromRole="DOCUMENT_ITEM" ToRole="ATTACH_URL" /> |
552 |
</EntityType> |
553 |
<EntityType Name="ERROR_LOG"> |
554 |
<Key> |
555 |
<PropertyRef Name="ID" /> |
556 |
</Key> |
557 |
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
558 |
<Property Name="SERVICE_NAME" Type="String" MaxLength="30" FixedLength="false" Unicode="true" Nullable="false" /> |
559 |
<Property Name="LEVEL" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
560 |
<Property Name="TYPE" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
561 |
<Property Name="CONTENTS" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
562 |
<Property Name="CREATE_DATETIME" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" /> |
563 |
<Property Name="CODE" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
564 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
565 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
566 |
</EntityType> |
567 |
<EntityType Name="FAVORITE_DOC"> |
568 |
<Key> |
569 |
<PropertyRef Name="ID" /> |
570 |
</Key> |
571 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
572 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
573 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
574 |
<Property Name="GROUP_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
575 |
<Property Name="DOCUMENT_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
576 |
<Property Name="MEMBER_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
577 |
<Property Name="DESCRIPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
578 |
<Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
579 |
<Property Name="FLAG" Type="Int32" Nullable="false" /> |
580 |
<Property Name="REVISION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
581 |
<Property Name="PAGE_NO" Type="Int32" Nullable="false" /> |
582 |
<NavigationProperty Name="MEMBER" Relationship="Self.FK_FAVORIT_DOC_FAVORIT_DOC" FromRole="FAVORITE_DOC" ToRole="MEMBER" /> |
583 |
</EntityType> |
584 |
<EntityType Name="FINAL_PDF"> |
585 |
<Key> |
586 |
<PropertyRef Name="ID" /> |
587 |
</Key> |
588 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
589 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
590 |
<Property Name="DOCINFO_ID" Type="Int32" Nullable="false" /> |
591 |
<Property Name="MARKUPINFO_ID" Type="Int32" Nullable="false" /> |
592 |
<Property Name="CREATE_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
593 |
<Property Name="CREATE_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
594 |
<Property Name="STATUS" Type="Int32" Nullable="false" /> |
595 |
<Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" /> |
596 |
<Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" /> |
597 |
<Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
598 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
599 |
<Property Name="START_DATETIME" Type="DateTime" Precision="3" /> |
600 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
601 |
</EntityType> |
602 |
<EntityType Name="LOGIN_STAMP"> |
603 |
<Key> |
604 |
<PropertyRef Name="ID" /> |
605 |
</Key> |
606 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
607 |
<Property Name="USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
608 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
609 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
610 |
<Property Name="START_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
611 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
612 |
<Property Name="ISLOGIN" Type="Int32" Nullable="false" /> |
613 |
</EntityType> |
614 |
<EntityType Name="MARKUP_CHECKLIST"> |
615 |
<Key> |
616 |
<PropertyRef Name="CK_NO" /> |
617 |
</Key> |
618 |
<Property Name="CK_NO" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
619 |
<Property Name="CK_REV_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
620 |
<Property Name="CK_PAGE" Type="Int32" /> |
621 |
<Property Name="CK_COMMENT" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> |
622 |
<Property Name="CK_TODO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> |
623 |
<Property Name="CK_STATUS" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
624 |
<Property Name="CK_RESULT" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
625 |
</EntityType> |
626 |
<EntityType Name="MARKUP_DATA"> |
627 |
<Key> |
628 |
<PropertyRef Name="ID" /> |
629 |
</Key> |
630 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
631 |
<Property Name="PAGENUMBER" Type="Int32" Nullable="false" /> |
632 |
<Property Name="DATA" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" /> |
633 |
<Property Name="MARKUPINFO_VERSION_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
634 |
<Property Name="DATA_TYPE" Type="Int32" Nullable="false" /> |
635 |
<NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="Self.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" /> |
636 |
</EntityType> |
637 |
<EntityType Name="MARKUP_INFO"> |
638 |
<Key> |
639 |
<PropertyRef Name="ID" /> |
640 |
</Key> |
641 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
642 |
<Property Name="DOCINFO_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
643 |
<Property Name="USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
644 |
<Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
645 |
<Property Name="CONSOLIDATE" Type="Int32" Nullable="false" /> |
646 |
<Property Name="DESCRIPTION" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
647 |
<Property Name="AVOID_CONSOLIDATE" Type="Int32" Nullable="false" /> |
648 |
<Property Name="PART_CONSOLIDATE" Type="Int32" Nullable="false" /> |
649 |
<Property Name="UPDATE_TIME" Type="DateTime" Precision="3" /> |
650 |
<NavigationProperty Name="DOCINFO" Relationship="Self.FK_DOCINFOMARKUPINFO" FromRole="MARKUP_INFO" ToRole="DOCINFO" /> |
651 |
<NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="Self.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO" ToRole="MARKUP_INFO_VERSION" /> |
652 |
</EntityType> |
653 |
<EntityType Name="MARKUP_INFO_VERSION"> |
654 |
<Key> |
655 |
<PropertyRef Name="ID" /> |
656 |
</Key> |
657 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
658 |
<Property Name="MARKUPINFO_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
659 |
<Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" /> |
660 |
<NavigationProperty Name="MARKUP_DATA" Relationship="Self.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_DATA" /> |
661 |
<NavigationProperty Name="MARKUP_INFO" Relationship="Self.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_INFO" /> |
662 |
</EntityType> |
663 |
<EntityType Name="MEMBER"> |
664 |
<Key> |
665 |
<PropertyRef Name="ID" /> |
666 |
</Key> |
667 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
668 |
<Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
669 |
<Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
670 |
<Property Name="POSITION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
671 |
<Property Name="EMAIL_ADDRESS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
672 |
<NavigationProperty Name="FAVORITE_DOC" Relationship="Self.FK_FAVORIT_DOC_FAVORIT_DOC" FromRole="MEMBER" ToRole="FAVORITE_DOC" /> |
673 |
<NavigationProperty Name="SIGN_INFO" Relationship="Self.FK_SIGNINFO_MEMBER" FromRole="MEMBER" ToRole="SIGN_INFO" /> |
674 |
<NavigationProperty Name="SYMBOL_PRIVATE" Relationship="Self.FK_SYMBOL_PRIVATE_MEMBER" FromRole="MEMBER" ToRole="SYMBOL_PRIVATE" /> |
675 |
</EntityType> |
676 |
<EntityType Name="MEMBER_CMS_TEST"> |
677 |
<Key> |
678 |
<PropertyRef Name="ID" /> |
679 |
</Key> |
680 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
681 |
<Property Name="MEMBER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
682 |
<Property Name="MEMBER_PASS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
683 |
</EntityType> |
684 |
<EntityType Name="PRINT_DOC"> |
685 |
<Key> |
686 |
<PropertyRef Name="ID" /> |
687 |
</Key> |
688 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
689 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
690 |
<Property Name="DOCINFO_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
691 |
<Property Name="CREATE_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
692 |
<Property Name="STATUS" Type="Int32" Nullable="false" /> |
693 |
<Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" /> |
694 |
<Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" /> |
695 |
<Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
696 |
<Property Name="START_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
697 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
698 |
<Property Name="IS_EXPORT_FILE" Type="Int32" Nullable="false" /> |
699 |
<Property Name="PRINT_PAGES" Type="Int32" Nullable="false" /> |
700 |
<Property Name="PDFURL" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" /> |
701 |
<Property Name="IS_ONLY_RED" Type="Int32" Nullable="false" /> |
702 |
</EntityType> |
703 |
<EntityType Name="PRINT_EXCEL"> |
704 |
<Key> |
705 |
<PropertyRef Name="ID" /> |
706 |
</Key> |
707 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
708 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
709 |
<Property Name="GROUP_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
710 |
<Property Name="CREATE_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
711 |
<Property Name="START_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
712 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
713 |
<Property Name="EXCEPTION" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
714 |
<Property Name="STATUS" Type="Int32" Nullable="false" /> |
715 |
<Property Name="DOCUMENT_ID_SET" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
716 |
<Property Name="FILE_PATH" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
717 |
</EntityType> |
718 |
<EntityType Name="PROJECT_SETTING"> |
719 |
<Key> |
720 |
<PropertyRef Name="ID" /> |
721 |
</Key> |
722 |
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
723 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
724 |
<Property Name="REVISION" Type="String" MaxLength="30" FixedLength="false" Unicode="true" Nullable="false" /> |
725 |
<Property Name="RESULT" Type="String" MaxLength="30" FixedLength="false" Unicode="true" Nullable="false" /> |
726 |
</EntityType> |
727 |
<EntityType Name="PROPERTIES"> |
728 |
<Key> |
729 |
<PropertyRef Name="ID" /> |
730 |
</Key> |
731 |
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
732 |
<Property Name="TYPE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
733 |
<Property Name="PROPERTY" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> |
734 |
<Property Name="VALUE" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" Nullable="false" /> |
735 |
</EntityType> |
736 |
<EntityType Name="RUN_PROJECTS"> |
737 |
<Key> |
738 |
<PropertyRef Name="PROJECT_NO" /> |
739 |
</Key> |
740 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
741 |
<Property Name="PROJECT_NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
742 |
<Property Name="RUN_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
743 |
<Property Name="IS_ACTIVITY" Type="Int32" Nullable="false" /> |
744 |
</EntityType> |
745 |
<EntityType Name="SERVICE_PROPERTIES"> |
746 |
<Key> |
747 |
<PropertyRef Name="ID" /> |
748 |
</Key> |
749 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
750 |
<Property Name="SERVICET_TYPE" Type="Int32" Nullable="false" /> |
751 |
<Property Name="SERVICE_ADDRESS" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> |
752 |
<Property Name="SERVICE_PORT" Type="Int32" /> |
753 |
<Property Name="HOST_NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> |
754 |
<Property Name="PROCESS_COUNT" Type="Int32" Nullable="false" /> |
755 |
</EntityType> |
756 |
<EntityType Name="SIGN_INFO"> |
757 |
<Key> |
758 |
<PropertyRef Name="ID" /> |
759 |
</Key> |
760 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
761 |
<Property Name="SIGN_STR" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" /> |
762 |
<Property Name="MEMBER_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
763 |
<Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" /> |
764 |
<Property Name="MODIFY_DATE" Type="DateTime" Precision="3" /> |
765 |
<NavigationProperty Name="MEMBER" Relationship="Self.FK_SIGNINFO_MEMBER" FromRole="SIGN_INFO" ToRole="MEMBER" /> |
766 |
</EntityType> |
767 |
<EntityType Name="SYMBOL_PRIVATE"> |
768 |
<Key> |
769 |
<PropertyRef Name="ID" /> |
770 |
</Key> |
771 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
772 |
<Property Name="MEMBER_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
773 |
<Property Name="NAME" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
774 |
<Property Name="IMAGE_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
775 |
<Property Name="DATA" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" /> |
776 |
<NavigationProperty Name="MEMBER" Relationship="Self.FK_SYMBOL_PRIVATE_MEMBER" FromRole="SYMBOL_PRIVATE" ToRole="MEMBER" /> |
777 |
</EntityType> |
778 |
<EntityType Name="SYMBOL_PUBLIC"> |
779 |
<Key> |
780 |
<PropertyRef Name="ID" /> |
781 |
</Key> |
782 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
783 |
<Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
784 |
<Property Name="IMAGE_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" /> |
785 |
<Property Name="DATA" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" /> |
786 |
<Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
787 |
</EntityType> |
788 |
<Association Name="FK_ATTACH_URL_DOCUMENT_ITEM"> |
789 |
<End Role="DOCUMENT_ITEM" Type="Self.DOCUMENT_ITEM" Multiplicity="1" /> |
790 |
<End Role="ATTACH_URL" Type="Self.ATTACH_URL" Multiplicity="*" /> |
791 |
<ReferentialConstraint> |
792 |
<Principal Role="DOCUMENT_ITEM"> |
793 |
<PropertyRef Name="ID" /> |
794 |
</Principal> |
795 |
<Dependent Role="ATTACH_URL"> |
796 |
<PropertyRef Name="GROUP_ID" /> |
797 |
</Dependent> |
798 |
</ReferentialConstraint> |
799 |
</Association> |
800 |
<Association Name="FK_DOCINFODOFPAGE"> |
801 |
<End Role="DOCINFO" Type="Self.DOCINFO" Multiplicity="1" /> |
802 |
<End Role="DOCPAGE" Type="Self.DOCPAGE" Multiplicity="*" /> |
803 |
<ReferentialConstraint> |
804 |
<Principal Role="DOCINFO"> |
805 |
<PropertyRef Name="ID" /> |
806 |
</Principal> |
807 |
<Dependent Role="DOCPAGE"> |
808 |
<PropertyRef Name="DOCINFO_ID" /> |
809 |
</Dependent> |
810 |
</ReferentialConstraint> |
811 |
</Association> |
812 |
<Association Name="FK_DOCINFOMARKUPINFO"> |
813 |
<End Role="DOCINFO" Type="Self.DOCINFO" Multiplicity="1" /> |
814 |
<End Role="MARKUP_INFO" Type="Self.MARKUP_INFO" Multiplicity="*" /> |
815 |
<ReferentialConstraint> |
816 |
<Principal Role="DOCINFO"> |
817 |
<PropertyRef Name="ID" /> |
818 |
</Principal> |
819 |
<Dependent Role="MARKUP_INFO"> |
820 |
<PropertyRef Name="DOCINFO_ID" /> |
821 |
</Dependent> |
822 |
</ReferentialConstraint> |
823 |
</Association> |
824 |
<Association Name="FK_FAVORIT_DOC_FAVORIT_DOC"> |
825 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" /> |
826 |
<End Role="FAVORITE_DOC" Type="Self.FAVORITE_DOC" Multiplicity="*" /> |
827 |
<ReferentialConstraint> |
828 |
<Principal Role="MEMBER"> |
829 |
<PropertyRef Name="ID" /> |
830 |
</Principal> |
831 |
<Dependent Role="FAVORITE_DOC"> |
832 |
<PropertyRef Name="MEMBER_USER_ID" /> |
833 |
</Dependent> |
834 |
</ReferentialConstraint> |
835 |
</Association> |
836 |
<Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA"> |
837 |
<End Role="MARKUP_INFO_VERSION" Type="Self.MARKUP_INFO_VERSION" Multiplicity="1" /> |
838 |
<End Role="MARKUP_DATA" Type="Self.MARKUP_DATA" Multiplicity="*" /> |
839 |
<ReferentialConstraint> |
840 |
<Principal Role="MARKUP_INFO_VERSION"> |
841 |
<PropertyRef Name="ID" /> |
842 |
</Principal> |
843 |
<Dependent Role="MARKUP_DATA"> |
844 |
<PropertyRef Name="MARKUPINFO_VERSION_ID" /> |
845 |
</Dependent> |
846 |
</ReferentialConstraint> |
847 |
</Association> |
848 |
<Association Name="FK_MARKUPINFOMARKUPINFO_VERSION"> |
849 |
<End Role="MARKUP_INFO" Type="Self.MARKUP_INFO" Multiplicity="1" /> |
850 |
<End Role="MARKUP_INFO_VERSION" Type="Self.MARKUP_INFO_VERSION" Multiplicity="*" /> |
851 |
<ReferentialConstraint> |
852 |
<Principal Role="MARKUP_INFO"> |
853 |
<PropertyRef Name="ID" /> |
854 |
</Principal> |
855 |
<Dependent Role="MARKUP_INFO_VERSION"> |
856 |
<PropertyRef Name="MARKUPINFO_ID" /> |
857 |
</Dependent> |
858 |
</ReferentialConstraint> |
859 |
</Association> |
860 |
<Association Name="FK_SIGNINFO_MEMBER"> |
861 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" /> |
862 |
<End Role="SIGN_INFO" Type="Self.SIGN_INFO" Multiplicity="*" /> |
863 |
<ReferentialConstraint> |
864 |
<Principal Role="MEMBER"> |
865 |
<PropertyRef Name="ID" /> |
866 |
</Principal> |
867 |
<Dependent Role="SIGN_INFO"> |
868 |
<PropertyRef Name="MEMBER_USER_ID" /> |
869 |
</Dependent> |
870 |
</ReferentialConstraint> |
871 |
</Association> |
872 |
<Association Name="FK_SYMBOL_PRIVATE_MEMBER"> |
873 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" /> |
874 |
<End Role="SYMBOL_PRIVATE" Type="Self.SYMBOL_PRIVATE" Multiplicity="*" /> |
875 |
<ReferentialConstraint> |
876 |
<Principal Role="MEMBER"> |
877 |
<PropertyRef Name="ID" /> |
878 |
</Principal> |
879 |
<Dependent Role="SYMBOL_PRIVATE"> |
880 |
<PropertyRef Name="MEMBER_USER_ID" /> |
881 |
</Dependent> |
882 |
</ReferentialConstraint> |
883 |
</Association> |
884 |
<EntityContainer Name="MarkusModel" annotation:LazyLoadingEnabled="true"> |
885 |
<EntitySet Name="ATTACH_URL" EntityType="Self.ATTACH_URL" /> |
886 |
<EntitySet Name="CERTIFY_CMS_TEST" EntityType="Self.CERTIFY_CMS_TEST" /> |
887 |
<EntitySet Name="CONVERTER_DOC" EntityType="Self.CONVERTER_DOC" /> |
888 |
<EntitySet Name="DOCINFO" EntityType="Self.DOCINFO" /> |
889 |
<EntitySet Name="DOCPAGE" EntityType="Self.DOCPAGE" /> |
890 |
<EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" /> |
891 |
<EntitySet Name="ERROR_LOG" EntityType="Self.ERROR_LOG" /> |
892 |
<EntitySet Name="FAVORITE_DOC" EntityType="Self.FAVORITE_DOC" /> |
893 |
<EntitySet Name="FINAL_PDF" EntityType="Self.FINAL_PDF" /> |
894 |
<EntitySet Name="LOGIN_STAMP" EntityType="Self.LOGIN_STAMP" /> |
895 |
<EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" /> |
896 |
<EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" /> |
897 |
<EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" /> |
898 |
<EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" /> |
899 |
<EntitySet Name="MEMBER" EntityType="Self.MEMBER" /> |
900 |
<EntitySet Name="MEMBER_CMS_TEST" EntityType="Self.MEMBER_CMS_TEST" /> |
901 |
<EntitySet Name="PRINT_DOC" EntityType="Self.PRINT_DOC" /> |
902 |
<EntitySet Name="PRINT_EXCEL" EntityType="Self.PRINT_EXCEL" /> |
903 |
<EntitySet Name="PROJECT_SETTING" EntityType="Self.PROJECT_SETTING" /> |
904 |
<EntitySet Name="PROPERTIES" EntityType="Self.PROPERTIES" /> |
905 |
<EntitySet Name="RUN_PROJECTS" EntityType="Self.RUN_PROJECTS" /> |
906 |
<EntitySet Name="SERVICE_PROPERTIES" EntityType="Self.SERVICE_PROPERTIES" /> |
907 |
<EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" /> |
908 |
<EntitySet Name="SYMBOL_PRIVATE" EntityType="Self.SYMBOL_PRIVATE" /> |
909 |
<EntitySet Name="SYMBOL_PUBLIC" EntityType="Self.SYMBOL_PUBLIC" /> |
910 |
<AssociationSet Name="FK_ATTACH_URL_DOCUMENT_ITEM" Association="Self.FK_ATTACH_URL_DOCUMENT_ITEM"> |
911 |
<End Role="DOCUMENT_ITEM" EntitySet="DOCUMENT_ITEM" /> |
912 |
<End Role="ATTACH_URL" EntitySet="ATTACH_URL" /> |
913 |
</AssociationSet> |
914 |
<AssociationSet Name="FK_DOCINFODOFPAGE" Association="Self.FK_DOCINFODOFPAGE"> |
915 |
<End Role="DOCINFO" EntitySet="DOCINFO" /> |
916 |
<End Role="DOCPAGE" EntitySet="DOCPAGE" /> |
917 |
</AssociationSet> |
918 |
<AssociationSet Name="FK_DOCINFOMARKUPINFO" Association="Self.FK_DOCINFOMARKUPINFO"> |
919 |
<End Role="DOCINFO" EntitySet="DOCINFO" /> |
920 |
<End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" /> |
921 |
</AssociationSet> |
922 |
<AssociationSet Name="FK_FAVORIT_DOC_FAVORIT_DOC" Association="Self.FK_FAVORIT_DOC_FAVORIT_DOC"> |
923 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
924 |
<End Role="FAVORITE_DOC" EntitySet="FAVORITE_DOC" /> |
925 |
</AssociationSet> |
926 |
<AssociationSet Name="FK_MARKUPINFO_VERSIONMARKUPDATA" Association="Self.FK_MARKUPINFO_VERSIONMARKUPDATA"> |
927 |
<End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" /> |
928 |
<End Role="MARKUP_DATA" EntitySet="MARKUP_DATA" /> |
929 |
</AssociationSet> |
930 |
<AssociationSet Name="FK_MARKUPINFOMARKUPINFO_VERSION" Association="Self.FK_MARKUPINFOMARKUPINFO_VERSION"> |
931 |
<End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" /> |
932 |
<End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" /> |
933 |
</AssociationSet> |
934 |
<AssociationSet Name="FK_SIGNINFO_MEMBER" Association="Self.FK_SIGNINFO_MEMBER"> |
935 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
936 |
<End Role="SIGN_INFO" EntitySet="SIGN_INFO" /> |
937 |
</AssociationSet> |
938 |
<AssociationSet Name="FK_SYMBOL_PRIVATE_MEMBER" Association="Self.FK_SYMBOL_PRIVATE_MEMBER"> |
939 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
940 |
<End Role="SYMBOL_PRIVATE" EntitySet="SYMBOL_PRIVATE" /> |
941 |
</AssociationSet> |
942 |
</EntityContainer> |
943 |
</Schema> |
944 |
</edmx:ConceptualModels> |
945 |
<!-- C-S mapping content --> |
946 |
<edmx:Mappings> |
947 |
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs"> |
948 |
<EntityContainerMapping StorageEntityContainer="MarkusDBModelStoreContainer" CdmEntityContainer="MarkusModel"> |
949 |
<EntitySetMapping Name="ATTACH_URL"> |
950 |
<EntityTypeMapping TypeName="MarkusDBModel.ATTACH_URL"> |
951 |
<MappingFragment StoreEntitySet="ATTACH_URL"> |
952 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
953 |
<ScalarProperty Name="GROUP_ID" ColumnName="GROUP_ID" /> |
954 |
<ScalarProperty Name="ATTACH_URL1" ColumnName="ATTACH_URL1" /> |
955 |
<ScalarProperty Name="FILE_NAME" ColumnName="FILE_NAME" /> |
956 |
<ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" /> |
957 |
<ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" /> |
958 |
</MappingFragment> |
959 |
</EntityTypeMapping> |
960 |
</EntitySetMapping> |
961 |
<EntitySetMapping Name="CERTIFY_CMS_TEST"> |
962 |
<EntityTypeMapping TypeName="MarkusDBModel.CERTIFY_CMS_TEST"> |
963 |
<MappingFragment StoreEntitySet="CERTIFY_CMS_TEST"> |
964 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
965 |
<ScalarProperty Name="MEMBER_ID" ColumnName="MEMBER_ID" /> |
966 |
<ScalarProperty Name="ACCESSTOKEN" ColumnName="ACCESSTOKEN" /> |
967 |
<ScalarProperty Name="LOGIN_DATE" ColumnName="LOGIN_DATE" /> |
968 |
<ScalarProperty Name="EXPIRE_DATE" ColumnName="EXPIRE_DATE" /> |
969 |
<ScalarProperty Name="DEVICE_TYPE" ColumnName="DEVICE_TYPE" /> |
970 |
<ScalarProperty Name="DEVICE_SERIAL_NUMBER" ColumnName="DEVICE_SERIAL_NUMBER" /> |
971 |
</MappingFragment> |
972 |
</EntityTypeMapping> |
973 |
</EntitySetMapping> |
974 |
<EntitySetMapping Name="CONVERTER_DOC"> |
975 |
<EntityTypeMapping TypeName="MarkusDBModel.CONVERTER_DOC"> |
976 |
<MappingFragment StoreEntitySet="CONVERTER_DOC"> |
977 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
978 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
979 |
<ScalarProperty Name="DOCUMENT_URL" ColumnName="DOCUMENT_URL" /> |
980 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
981 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
982 |
<ScalarProperty Name="STATUS" ColumnName="STATUS" /> |
983 |
<ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" /> |
984 |
<ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" /> |
985 |
<ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" /> |
986 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
987 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
988 |
<ScalarProperty Name="SERVICE_ID" ColumnName="SERVICE_ID" /> |
989 |
<ScalarProperty Name="RECONVERTER" ColumnName="RECONVERTER" /> |
990 |
</MappingFragment> |
991 |
</EntityTypeMapping> |
992 |
</EntitySetMapping> |
993 |
<EntitySetMapping Name="DOCINFO"> |
994 |
<EntityTypeMapping TypeName="MarkusDBModel.DOCINFO"> |
995 |
<MappingFragment StoreEntitySet="DOCINFO"> |
996 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
997 |
<ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" /> |
998 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
999 |
<ScalarProperty Name="PAGE_COUNT" ColumnName="PAGE_COUNT" /> |
1000 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1001 |
</MappingFragment> |
1002 |
</EntityTypeMapping> |
1003 |
</EntitySetMapping> |
1004 |
<EntitySetMapping Name="DOCPAGE"> |
1005 |
<EntityTypeMapping TypeName="MarkusDBModel.DOCPAGE"> |
1006 |
<MappingFragment StoreEntitySet="DOCPAGE"> |
1007 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1008 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
1009 |
<ScalarProperty Name="PAGE_NUMBER" ColumnName="PAGE_NUMBER" /> |
1010 |
<ScalarProperty Name="PAGE_WIDTH" ColumnName="PAGE_WIDTH" /> |
1011 |
<ScalarProperty Name="PAGE_HEIGHT" ColumnName="PAGE_HEIGHT" /> |
1012 |
<ScalarProperty Name="PAGE_ANGLE" ColumnName="PAGE_ANGLE" /> |
1013 |
</MappingFragment> |
1014 |
</EntityTypeMapping> |
1015 |
</EntitySetMapping> |
1016 |
<EntitySetMapping Name="DOCUMENT_ITEM"> |
1017 |
<EntityTypeMapping TypeName="MarkusDBModel.DOCUMENT_ITEM"> |
1018 |
<MappingFragment StoreEntitySet="DOCUMENT_ITEM"> |
1019 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1020 |
<ScalarProperty Name="REVISION" ColumnName="REVISION" /> |
1021 |
<ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" /> |
1022 |
<ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" /> |
1023 |
<ScalarProperty Name="GROUP_NO" ColumnName="GROUP_NO" /> |
1024 |
<ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" /> |
1025 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
1026 |
<ScalarProperty Name="RESULT_FILE" ColumnName="RESULT_FILE" /> |
1027 |
<ScalarProperty Name="RESULT" ColumnName="RESULT" /> |
1028 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1029 |
<ScalarProperty Name="Link" ColumnName="Link" /> |
1030 |
</MappingFragment> |
1031 |
</EntityTypeMapping> |
1032 |
</EntitySetMapping> |
1033 |
<EntitySetMapping Name="ERROR_LOG"> |
1034 |
<EntityTypeMapping TypeName="MarkusDBModel.ERROR_LOG"> |
1035 |
<MappingFragment StoreEntitySet="ERROR_LOG"> |
1036 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1037 |
<ScalarProperty Name="SERVICE_NAME" ColumnName="SERVICE_NAME" /> |
1038 |
<ScalarProperty Name="LEVEL" ColumnName="LEVEL" /> |
1039 |
<ScalarProperty Name="TYPE" ColumnName="TYPE" /> |
1040 |
<ScalarProperty Name="CONTENTS" ColumnName="CONTENTS" /> |
1041 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
1042 |
<ScalarProperty Name="CODE" ColumnName="CODE" /> |
1043 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
1044 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1045 |
</MappingFragment> |
1046 |
</EntityTypeMapping> |
1047 |
</EntitySetMapping> |
1048 |
<EntitySetMapping Name="FAVORITE_DOC"> |
1049 |
<EntityTypeMapping TypeName="MarkusDBModel.FAVORITE_DOC"> |
1050 |
<MappingFragment StoreEntitySet="FAVORITE_DOC"> |
1051 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1052 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1053 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
1054 |
<ScalarProperty Name="GROUP_NO" ColumnName="GROUP_NO" /> |
1055 |
<ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" /> |
1056 |
<ScalarProperty Name="MEMBER_USER_ID" ColumnName="MEMBER_USER_ID" /> |
1057 |
<ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> |
1058 |
<ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" /> |
1059 |
<ScalarProperty Name="FLAG" ColumnName="FLAG" /> |
1060 |
<ScalarProperty Name="REVISION" ColumnName="REVISION" /> |
1061 |
<ScalarProperty Name="PAGE_NO" ColumnName="PAGE_NO" /> |
1062 |
</MappingFragment> |
1063 |
</EntityTypeMapping> |
1064 |
</EntitySetMapping> |
1065 |
<EntitySetMapping Name="FINAL_PDF"> |
1066 |
<EntityTypeMapping TypeName="MarkusDBModel.FINAL_PDF"> |
1067 |
<MappingFragment StoreEntitySet="FINAL_PDF"> |
1068 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1069 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1070 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
1071 |
<ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" /> |
1072 |
<ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" /> |
1073 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
1074 |
<ScalarProperty Name="STATUS" ColumnName="STATUS" /> |
1075 |
<ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" /> |
1076 |
<ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" /> |
1077 |
<ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" /> |
1078 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
1079 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
1080 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
1081 |
</MappingFragment> |
1082 |
</EntityTypeMapping> |
1083 |
</EntitySetMapping> |
1084 |
<EntitySetMapping Name="LOGIN_STAMP"> |
1085 |
<EntityTypeMapping TypeName="MarkusDBModel.LOGIN_STAMP"> |
1086 |
<MappingFragment StoreEntitySet="LOGIN_STAMP"> |
1087 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1088 |
<ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> |
1089 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1090 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
1091 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
1092 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
1093 |
<ScalarProperty Name="ISLOGIN" ColumnName="ISLOGIN" /> |
1094 |
</MappingFragment> |
1095 |
</EntityTypeMapping> |
1096 |
</EntitySetMapping> |
1097 |
<EntitySetMapping Name="MARKUP_CHECKLIST"> |
1098 |
<EntityTypeMapping TypeName="MarkusDBModel.MARKUP_CHECKLIST"> |
1099 |
<MappingFragment StoreEntitySet="MARKUP_CHECKLIST"> |
1100 |
<ScalarProperty Name="CK_NO" ColumnName="CK_NO" /> |
1101 |
<ScalarProperty Name="CK_REV_NO" ColumnName="CK_REV_NO" /> |
1102 |
<ScalarProperty Name="CK_PAGE" ColumnName="CK_PAGE" /> |
1103 |
<ScalarProperty Name="CK_COMMENT" ColumnName="CK_COMMENT" /> |
1104 |
<ScalarProperty Name="CK_TODO" ColumnName="CK_TODO" /> |
1105 |
<ScalarProperty Name="CK_STATUS" ColumnName="CK_STATUS" /> |
1106 |
<ScalarProperty Name="CK_RESULT" ColumnName="CK_RESULT" /> |
1107 |
</MappingFragment> |
1108 |
</EntityTypeMapping> |
1109 |
</EntitySetMapping> |
1110 |
<EntitySetMapping Name="MARKUP_DATA"> |
1111 |
<EntityTypeMapping TypeName="MarkusDBModel.MARKUP_DATA"> |
1112 |
<MappingFragment StoreEntitySet="MARKUP_DATA"> |
1113 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1114 |
<ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" /> |
1115 |
<ScalarProperty Name="DATA" ColumnName="DATA" /> |
1116 |
<ScalarProperty Name="MARKUPINFO_VERSION_ID" ColumnName="MARKUPINFO_VERSION_ID" /> |
1117 |
<ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" /> |
1118 |
</MappingFragment> |
1119 |
</EntityTypeMapping> |
1120 |
</EntitySetMapping> |
1121 |
<EntitySetMapping Name="MARKUP_INFO"> |
1122 |
<EntityTypeMapping TypeName="MarkusDBModel.MARKUP_INFO"> |
1123 |
<MappingFragment StoreEntitySet="MARKUP_INFO"> |
1124 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1125 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
1126 |
<ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> |
1127 |
<ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" /> |
1128 |
<ScalarProperty Name="CONSOLIDATE" ColumnName="CONSOLIDATE" /> |
1129 |
<ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> |
1130 |
<ScalarProperty Name="AVOID_CONSOLIDATE" ColumnName="AVOID_CONSOLIDATE" /> |
1131 |
<ScalarProperty Name="PART_CONSOLIDATE" ColumnName="PART_CONSOLIDATE" /> |
1132 |
<ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" /> |
1133 |
</MappingFragment> |
1134 |
</EntityTypeMapping> |
1135 |
</EntitySetMapping> |
1136 |
<EntitySetMapping Name="MARKUP_INFO_VERSION"> |
1137 |
<EntityTypeMapping TypeName="MarkusDBModel.MARKUP_INFO_VERSION"> |
1138 |
<MappingFragment StoreEntitySet="MARKUP_INFO_VERSION"> |
1139 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1140 |
<ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" /> |
1141 |
<ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" /> |
1142 |
</MappingFragment> |
1143 |
</EntityTypeMapping> |
1144 |
</EntitySetMapping> |
1145 |
<EntitySetMapping Name="MEMBER"> |
1146 |
<EntityTypeMapping TypeName="MarkusDBModel.MEMBER"> |
1147 |
<MappingFragment StoreEntitySet="MEMBER"> |
1148 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1149 |
<ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" /> |
1150 |
<ScalarProperty Name="NAME" ColumnName="NAME" /> |
1151 |
<ScalarProperty Name="POSITION" ColumnName="POSITION" /> |
1152 |
<ScalarProperty Name="EMAIL_ADDRESS" ColumnName="EMAIL_ADDRESS" /> |
1153 |
</MappingFragment> |
1154 |
</EntityTypeMapping> |
1155 |
</EntitySetMapping> |
1156 |
<EntitySetMapping Name="MEMBER_CMS_TEST"> |
1157 |
<EntityTypeMapping TypeName="MarkusDBModel.MEMBER_CMS_TEST"> |
1158 |
<MappingFragment StoreEntitySet="MEMBER_CMS_TEST"> |
1159 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1160 |
<ScalarProperty Name="MEMBER_ID" ColumnName="MEMBER_ID" /> |
1161 |
<ScalarProperty Name="MEMBER_PASS" ColumnName="MEMBER_PASS" /> |
1162 |
</MappingFragment> |
1163 |
</EntityTypeMapping> |
1164 |
</EntitySetMapping> |
1165 |
<EntitySetMapping Name="PRINT_DOC"> |
1166 |
<EntityTypeMapping TypeName="MarkusDBModel.PRINT_DOC"> |
1167 |
<MappingFragment StoreEntitySet="PRINT_DOC"> |
1168 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1169 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1170 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
1171 |
<ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" /> |
1172 |
<ScalarProperty Name="STATUS" ColumnName="STATUS" /> |
1173 |
<ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" /> |
1174 |
<ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" /> |
1175 |
<ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" /> |
1176 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
1177 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
1178 |
<ScalarProperty Name="IS_EXPORT_FILE" ColumnName="IS_EXPORT_FILE" /> |
1179 |
<ScalarProperty Name="PRINT_PAGES" ColumnName="PRINT_PAGES" /> |
1180 |
<ScalarProperty Name="PDFURL" ColumnName="PDFURL" /> |
1181 |
<ScalarProperty Name="IS_ONLY_RED" ColumnName="IS_ONLY_RED" /> |
1182 |
</MappingFragment> |
1183 |
</EntityTypeMapping> |
1184 |
</EntitySetMapping> |
1185 |
<EntitySetMapping Name="PRINT_EXCEL"> |
1186 |
<EntityTypeMapping TypeName="MarkusDBModel.PRINT_EXCEL"> |
1187 |
<MappingFragment StoreEntitySet="PRINT_EXCEL"> |
1188 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1189 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1190 |
<ScalarProperty Name="GROUP_NO" ColumnName="GROUP_NO" /> |
1191 |
<ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" /> |
1192 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
1193 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
1194 |
<ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" /> |
1195 |
<ScalarProperty Name="STATUS" ColumnName="STATUS" /> |
1196 |
<ScalarProperty Name="DOCUMENT_ID_SET" ColumnName="DOCUMENT_ID_SET" /> |
1197 |
<ScalarProperty Name="FILE_PATH" ColumnName="FILE_PATH" /> |
1198 |
</MappingFragment> |
1199 |
</EntityTypeMapping> |
1200 |
</EntitySetMapping> |
1201 |
<EntitySetMapping Name="PROJECT_SETTING"> |
1202 |
<EntityTypeMapping TypeName="MarkusDBModel.PROJECT_SETTING"> |
1203 |
<MappingFragment StoreEntitySet="PROJECT_SETTING"> |
1204 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1205 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1206 |
<ScalarProperty Name="REVISION" ColumnName="REVISION" /> |
1207 |
<ScalarProperty Name="RESULT" ColumnName="RESULT" /> |
1208 |
</MappingFragment> |
1209 |
</EntityTypeMapping> |
1210 |
</EntitySetMapping> |
1211 |
<EntitySetMapping Name="PROPERTIES"> |
1212 |
<EntityTypeMapping TypeName="MarkusDBModel.PROPERTIES"> |
1213 |
<MappingFragment StoreEntitySet="PROPERTIES"> |
1214 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1215 |
<ScalarProperty Name="TYPE" ColumnName="TYPE" /> |
1216 |
<ScalarProperty Name="PROPERTY" ColumnName="PROPERTY" /> |
1217 |
<ScalarProperty Name="VALUE" ColumnName="VALUE" /> |
1218 |
</MappingFragment> |
1219 |
</EntityTypeMapping> |
1220 |
</EntitySetMapping> |
1221 |
<EntitySetMapping Name="RUN_PROJECTS"> |
1222 |
<EntityTypeMapping TypeName="MarkusDBModel.RUN_PROJECTS"> |
1223 |
<MappingFragment StoreEntitySet="RUN_PROJECTS"> |
1224 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
1225 |
<ScalarProperty Name="PROJECT_NAME" ColumnName="PROJECT_NAME" /> |
1226 |
<ScalarProperty Name="RUN_DATETIME" ColumnName="RUN_DATETIME" /> |
1227 |
<ScalarProperty Name="IS_ACTIVITY" ColumnName="IS_ACTIVITY" /> |
1228 |
</MappingFragment> |
1229 |
</EntityTypeMapping> |
1230 |
</EntitySetMapping> |
1231 |
<EntitySetMapping Name="SERVICE_PROPERTIES"> |
1232 |
<EntityTypeMapping TypeName="MarkusDBModel.SERVICE_PROPERTIES"> |
1233 |
<MappingFragment StoreEntitySet="SERVICE_PROPERTIES"> |
1234 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1235 |
<ScalarProperty Name="SERVICET_TYPE" ColumnName="SERVICET_TYPE" /> |
1236 |
<ScalarProperty Name="SERVICE_ADDRESS" ColumnName="SERVICE_ADDRESS" /> |
1237 |
<ScalarProperty Name="SERVICE_PORT" ColumnName="SERVICE_PORT" /> |
1238 |
<ScalarProperty Name="HOST_NAME" ColumnName="HOST_NAME" /> |
1239 |
<ScalarProperty Name="PROCESS_COUNT" ColumnName="PROCESS_COUNT" /> |
1240 |
</MappingFragment> |
1241 |
</EntityTypeMapping> |
1242 |
</EntitySetMapping> |
1243 |
<EntitySetMapping Name="SIGN_INFO"> |
1244 |
<EntityTypeMapping TypeName="MarkusDBModel.SIGN_INFO"> |
1245 |
<MappingFragment StoreEntitySet="SIGN_INFO"> |
1246 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1247 |
<ScalarProperty Name="SIGN_STR" ColumnName="SIGN_STR" /> |
1248 |
<ScalarProperty Name="MEMBER_USER_ID" ColumnName="MEMBER_USER_ID" /> |
1249 |
<ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" /> |
1250 |
<ScalarProperty Name="MODIFY_DATE" ColumnName="MODIFY_DATE" /> |
1251 |
</MappingFragment> |
1252 |
</EntityTypeMapping> |
1253 |
</EntitySetMapping> |
1254 |
<EntitySetMapping Name="SYMBOL_PRIVATE"> |
1255 |
<EntityTypeMapping TypeName="MarkusDBModel.SYMBOL_PRIVATE"> |
1256 |
<MappingFragment StoreEntitySet="SYMBOL_PRIVATE"> |
1257 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1258 |
<ScalarProperty Name="MEMBER_USER_ID" ColumnName="MEMBER_USER_ID" /> |
1259 |
<ScalarProperty Name="NAME" ColumnName="NAME" /> |
1260 |
<ScalarProperty Name="IMAGE_URL" ColumnName="IMAGE_URL" /> |
1261 |
<ScalarProperty Name="DATA" ColumnName="DATA" /> |
1262 |
</MappingFragment> |
1263 |
</EntityTypeMapping> |
1264 |
</EntitySetMapping> |
1265 |
<EntitySetMapping Name="SYMBOL_PUBLIC"> |
1266 |
<EntityTypeMapping TypeName="MarkusDBModel.SYMBOL_PUBLIC"> |
1267 |
<MappingFragment StoreEntitySet="SYMBOL_PUBLIC"> |
1268 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
1269 |
<ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" /> |
1270 |
<ScalarProperty Name="IMAGE_URL" ColumnName="IMAGE_URL" /> |
1271 |
<ScalarProperty Name="DATA" ColumnName="DATA" /> |
1272 |
<ScalarProperty Name="NAME" ColumnName="NAME" /> |
1273 |
</MappingFragment> |
1274 |
</EntityTypeMapping> |
1275 |
</EntitySetMapping> |
1276 |
</EntityContainerMapping> |
1277 |
</Mapping> |
1278 |
</edmx:Mappings> |
1279 |
</edmx:Runtime> |
1280 |
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) --> |
1281 |
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx"> |
1282 |
<Connection> |
1283 |
<DesignerInfoPropertySet> |
1284 |
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" /> |
1285 |
</DesignerInfoPropertySet> |
1286 |
</Connection> |
1287 |
<Options> |
1288 |
<DesignerInfoPropertySet> |
1289 |
<DesignerProperty Name="ValidateOnBuild" Value="true" /> |
1290 |
<DesignerProperty Name="EnablePluralization" Value="false" /> |
1291 |
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" /> |
1292 |
<DesignerProperty Name="UseLegacyProvider" Value="false" /> |
1293 |
<DesignerProperty Name="CodeGenerationStrategy" Value="없음" /> |
1294 |
</DesignerInfoPropertySet> |
1295 |
</Options> |
1296 |
<!-- Diagram content (shape and connector positions) --> |
1297 |
<Diagrams></Diagrams> |
1298 |
</Designer> |
1299 |
</edmx:Edmx> |