프로젝트

일반

사용자정보

통계
| 브랜치(Branch): | 개정판:

markus / KCOMDataModel / DataModel / CIModel.edmx @ 3c71b3a5

이력 | 보기 | 이력해설 | 다운로드 (53.3 KB)

1
<?xml version="1.0" encoding="utf-8"?>
2
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
3
  <!-- EF Runtime content -->
4
  <edmx:Runtime>
5
    <!-- SSDL content -->
6
    <edmx:StorageModels>
7
    <Schema Namespace="CIModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2008" 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/02/edm/ssdl">
8
        <EntityType Name="CHECK_LIST">
9
          <Key>
10
            <PropertyRef Name="ID" />
11
          </Key>
12
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
13
          <Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
14
          <Property Name="USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
15
          <Property Name="REVISION" Type="nvarchar" MaxLength="50" Nullable="false" />
16
          <Property Name="PAGENUMBER" Type="int" Nullable="false" />
17
          <Property Name="TODOLIST" Type="nvarchar(max)" />
18
          <Property Name="IMAGE_URL" Type="nvarchar(max)" Nullable="false" />
19
          <Property Name="STATUS" Type="nvarchar" MaxLength="10" Nullable="false" />
20
          <Property Name="VENDOR" Type="nvarchar" MaxLength="500" />
21
          <Property Name="REMARK" Type="nvarchar(max)" />
22
          <Property Name="PROJECT_NO" Type="nvarchar" MaxLength="50" Nullable="false" />
23
          <Property Name="REV_4" Type="nvarchar" MaxLength="50" />
24
          <Property Name="REV_3" Type="nvarchar" MaxLength="50" />
25
          <Property Name="REV_2" Type="nvarchar" MaxLength="50" />
26
          <Property Name="REV_1" Type="nvarchar" MaxLength="50" />
27
          <Property Name="REV_0" Type="nvarchar" MaxLength="50" />
28
          <Property Name="IMAGE_ANCHOR" Type="nvarchar" MaxLength="50" Nullable="false" />
29
          <Property Name="CREATE_TIME" Type="datetime" />
30
          <Property Name="UPDATE_TIME" Type="datetime" />
31
          <Property Name="STATUS_DESC_OPEN" Type="nvarchar(max)" />
32
          <Property Name="STATUS_DESC_CLOSE" Type="nvarchar(max)" />
33
          <Property Name="REPLY" Type="nvarchar(max)" />
34
          <Property Name="DOCUMENT_NO" Type="nvarchar" MaxLength="50" />
35
        </EntityType>
36
        <EntityType Name="CHECK_LIST_HISTORY">
37
          <Key>
38
            <PropertyRef Name="ID" />
39
          </Key>
40
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
41
          <Property Name="CHECKLIST_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
42
          <Property Name="REVISION" Type="nvarchar" MaxLength="50" Nullable="false" />
43
          <Property Name="STATUS" Type="nvarchar" MaxLength="10" Nullable="false" />
44
          <Property Name="STATUS_DESC" Type="nvarchar(max)" />
45
          <Property Name="TODOLIST" Type="nvarchar(max)" />
46
          <Property Name="VENDOR" Type="nvarchar" MaxLength="500" />
47
          <Property Name="REMARK" Type="nvarchar(max)" />
48
          <Property Name="REPLY" Type="nvarchar(max)" />
49
          <Property Name="IMAGE_URL" Type="nvarchar(max)" />
50
          <Property Name="CREATE_TIME" Type="datetime" Nullable="false" />
51
          <Property Name="UPDATE_TIME" Type="datetime" Nullable="false" />
52
        </EntityType>
53
        <EntityType Name="DOCINFO">
54
          <Key>
55
            <PropertyRef Name="ID" />
56
          </Key>
57
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
58
          <Property Name="ORIGINAL_FILE" Type="nvarchar" MaxLength="500" Nullable="false" />
59
          <Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
60
          <Property Name="PAGE_COUNT" Type="int" Nullable="false" />
61
          <Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" />
62
        </EntityType>
63
        <EntityType Name="DOCPAGE">
64
          <Key>
65
            <PropertyRef Name="ID" />
66
          </Key>
67
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
68
          <Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
69
          <Property Name="PAGE_NUMBER" Type="int" Nullable="false" />
70
          <Property Name="PAGE_WIDTH" Type="nvarchar" MaxLength="20" Nullable="false" />
71
          <Property Name="PAGE_HEIGHT" Type="nvarchar" MaxLength="20" Nullable="false" />
72
          <Property Name="PAGE_ANGLE" Type="int" Nullable="false" />
73
        </EntityType>
74
        <EntityType Name="DOCUMENT_ITEM">
75
          <Key>
76
            <PropertyRef Name="ID" />
77
          </Key>
78
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
79
          <Property Name="REVISION" Type="nvarchar" MaxLength="50" Nullable="false" />
80
          <Property Name="DOCUMENT_NO" Type="nvarchar" MaxLength="50" Nullable="false" />
81
          <Property Name="DOCUMENT_NAME" Type="nvarchar" MaxLength="500" Nullable="false" />
82
          <Property Name="GROUP_NO" Type="nvarchar" MaxLength="50" />
83
          <Property Name="ORIGINAL_FILE" Type="nvarchar" MaxLength="500" Nullable="false" />
84
          <Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
85
          <Property Name="RESULT_FILE" Type="nvarchar" MaxLength="500" />
86
          <Property Name="RESULT" Type="nvarchar" MaxLength="50" />
87
          <Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" />
88
          <Property Name="ENSEMBLEINFO_URL" Type="nvarchar" MaxLength="500" />
89
        </EntityType>
90
        <EntityType Name="MARKUP_CHECKLIST">
91
          <Key>
92
            <PropertyRef Name="CK_NO" />
93
          </Key>
94
          <Property Name="CK_NO" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
95
          <Property Name="CK_REV_NO" Type="nvarchar" MaxLength="10" />
96
          <Property Name="CK_PAGE" Type="int" />
97
          <Property Name="CK_COMMENT" Type="nvarchar" MaxLength="200" />
98
          <Property Name="CK_TODO" Type="nvarchar" MaxLength="200" />
99
          <Property Name="CK_STATUS" Type="nvarchar" MaxLength="10" />
100
          <Property Name="CK_RESULT" Type="nvarchar" MaxLength="10" />
101
        </EntityType>
102
        <EntityType Name="MARKUP_DATA">
103
          <Key>
104
            <PropertyRef Name="ID" />
105
          </Key>
106
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
107
          <Property Name="PAGENUMBER" Type="int" Nullable="false" />
108
          <Property Name="DATA" Type="nvarchar(max)" Nullable="false" />
109
          <Property Name="MARKUPINFO_VERSION_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
110
          <Property Name="DATA_TYPE" Type="int" Nullable="false" />
111
          <Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" />
112
        </EntityType>
113
        <EntityType Name="MARKUP_INFO">
114
          <Key>
115
            <PropertyRef Name="ID" />
116
          </Key>
117
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
118
          <Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
119
          <Property Name="USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
120
          <Property Name="CREATE_TIME" Type="datetime" Nullable="false" />
121
          <Property Name="CONSOLIDATE" Type="int" Nullable="false" />
122
          <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="500" />
123
          <Property Name="AVOID_CONSOLIDATE" Type="int" Nullable="false" />
124
          <Property Name="PART_CONSOLIDATE" Type="int" Nullable="false" />
125
          <Property Name="UPDATE_TIME" Type="datetime" />
126
        </EntityType>
127
        <EntityType Name="MARKUP_INFO_VERSION">
128
          <Key>
129
            <PropertyRef Name="ID" />
130
          </Key>
131
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
132
          <Property Name="MARKUPINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
133
          <Property Name="CREATE_DATE" Type="datetime" Nullable="false" />
134
        </EntityType>
135
        <EntityType Name="MEMBER">
136
          <Key>
137
            <PropertyRef Name="ID" />
138
          </Key>
139
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
140
          <Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" />
141
          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
142
          <Property Name="POSITION" Type="nvarchar" MaxLength="50" />
143
          <Property Name="EMAIL_ADDRESS" Type="nvarchar" MaxLength="50" />
144
          <Property Name="PASSWORD" Type="nvarchar" MaxLength="64" />
145
          <Property Name="COMPANY" Type="nvarchar" MaxLength="50" />
146
          <Property Name="CREATE_DATETIME" Type="datetime" />
147
          <Property Name="MODIFIED_DATETIME" Type="datetime" />
148
          <Property Name="ISLICENSE" Type="int" />
149
        </EntityType>
150
        <EntityType Name="MEMBER_DEPT_COLOR">
151
          <Key>
152
            <PropertyRef Name="COLORID" />
153
          </Key>
154
          <Property Name="COLORID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
155
          <Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" />
156
          <Property Name="DISPLAYCOLOR" Type="nvarchar" MaxLength="10" Nullable="false" />
157
        </EntityType>
158
        <EntityType Name="MEMBER_DEPT_COLORINFO">
159
          <Key>
160
            <PropertyRef Name="CVALUEID" />
161
            <PropertyRef Name="DISPLAYCOLOR" />
162
            <PropertyRef Name="COLORID" />
163
          </Key>
164
          <Property Name="CVALUEID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
165
          <Property Name="DISPLAYCOLOR" Type="nvarchar" MaxLength="10" Nullable="false" />
166
          <Property Name="COLORID" Type="int" Nullable="false" />
167
        </EntityType>
168
        <EntityType Name="SIGN_INFO">
169
          <Key>
170
            <PropertyRef Name="ID" />
171
          </Key>
172
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
173
          <Property Name="SIGN_STR" Type="nvarchar(max)" Nullable="false" />
174
          <Property Name="MEMBER_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
175
          <Property Name="CREATE_DATE" Type="datetime" Nullable="false" />
176
          <Property Name="MODIFY_DATE" Type="datetime" />
177
        </EntityType>
178
        <EntityType Name="TALK">
179
          <Key>
180
            <PropertyRef Name="ID" />
181
          </Key>
182
          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
183
          <Property Name="TEXT" Type="nchar" MaxLength="300" Nullable="false" />
184
          <Property Name="TIMESTAMP" Type="datetime" Nullable="false" />
185
          <Property Name="MSGTYPE" Type="tinyint" Nullable="false" />
186
          <Property Name="MSGSIDE" Type="tinyint" Nullable="false" />
187
          <Property Name="RECT_X" Type="float" />
188
          <Property Name="RECT_Y" Type="float" />
189
          <Property Name="RECT_WIDTH" Type="float" />
190
          <Property Name="RECT_HEIGHT" Type="float" />
191
          <Property Name="PAGENUMBER" Type="int" />
192
          <Property Name="MEMBER_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
193
          <Property Name="DOCUMENT_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
194
          <Property Name="MEMBER_NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
195
          <Property Name="ANGLE" Type="int" Nullable="false" />
196
        </EntityType>
197
        <Association Name="FK_DOCINFODOFPAGE">
198
          <End Role="DOCINFO" Type="Self.DOCINFO" Multiplicity="1" />
199
          <End Role="DOCPAGE" Type="Self.DOCPAGE" Multiplicity="*" />
200
          <ReferentialConstraint>
201
            <Principal Role="DOCINFO">
202
              <PropertyRef Name="ID" />
203
            </Principal>
204
            <Dependent Role="DOCPAGE">
205
              <PropertyRef Name="DOCINFO_ID" />
206
            </Dependent>
207
          </ReferentialConstraint>
208
        </Association>
209
        <Association Name="FK_DOCINFOMARKUPINFO">
210
          <End Role="DOCINFO" Type="Self.DOCINFO" Multiplicity="1" />
211
          <End Role="MARKUP_INFO" Type="Self.MARKUP_INFO" Multiplicity="*" />
212
          <ReferentialConstraint>
213
            <Principal Role="DOCINFO">
214
              <PropertyRef Name="ID" />
215
            </Principal>
216
            <Dependent Role="MARKUP_INFO">
217
              <PropertyRef Name="DOCINFO_ID" />
218
            </Dependent>
219
          </ReferentialConstraint>
220
        </Association>
221
        <Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA">
222
          <End Role="MARKUP_INFO_VERSION" Type="Self.MARKUP_INFO_VERSION" Multiplicity="1" />
223
          <End Role="MARKUP_DATA" Type="Self.MARKUP_DATA" Multiplicity="*" />
224
          <ReferentialConstraint>
225
            <Principal Role="MARKUP_INFO_VERSION">
226
              <PropertyRef Name="ID" />
227
            </Principal>
228
            <Dependent Role="MARKUP_DATA">
229
              <PropertyRef Name="MARKUPINFO_VERSION_ID" />
230
            </Dependent>
231
          </ReferentialConstraint>
232
        </Association>
233
        <Association Name="FK_MARKUPINFOMARKUPINFO_VERSION">
234
          <End Role="MARKUP_INFO" Type="Self.MARKUP_INFO" Multiplicity="1" />
235
          <End Role="MARKUP_INFO_VERSION" Type="Self.MARKUP_INFO_VERSION" Multiplicity="*" />
236
          <ReferentialConstraint>
237
            <Principal Role="MARKUP_INFO">
238
              <PropertyRef Name="ID" />
239
            </Principal>
240
            <Dependent Role="MARKUP_INFO_VERSION">
241
              <PropertyRef Name="MARKUPINFO_ID" />
242
            </Dependent>
243
          </ReferentialConstraint>
244
        </Association>
245
        <Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
246
          <End Role="MEMBER_DEPT_COLOR" Type="Self.MEMBER_DEPT_COLOR" Multiplicity="1" />
247
          <End Role="MEMBER_DEPT_COLORINFO" Type="Self.MEMBER_DEPT_COLORINFO" Multiplicity="*" />
248
          <ReferentialConstraint>
249
            <Principal Role="MEMBER_DEPT_COLOR">
250
              <PropertyRef Name="COLORID" />
251
            </Principal>
252
            <Dependent Role="MEMBER_DEPT_COLORINFO">
253
              <PropertyRef Name="COLORID" />
254
            </Dependent>
255
          </ReferentialConstraint>
256
        </Association>
257
        <EntityContainer Name="CIModelStoreContainer">
258
          <EntitySet Name="CHECK_LIST" EntityType="Self.CHECK_LIST" Schema="dbo" store:Type="Tables" />
259
          <EntitySet Name="CHECK_LIST_HISTORY" EntityType="Self.CHECK_LIST_HISTORY" Schema="dbo" store:Type="Tables" />
260
          <EntitySet Name="DOCINFO" EntityType="Self.DOCINFO" Schema="dbo" store:Type="Tables" />
261
          <EntitySet Name="DOCPAGE" EntityType="Self.DOCPAGE" Schema="dbo" store:Type="Tables" />
262
          <EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" Schema="dbo" store:Type="Tables" />
263
          <EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" Schema="dbo" store:Type="Tables" />
264
          <EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" Schema="dbo" store:Type="Tables" />
265
          <EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" />
266
          <EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" />
267
          <EntitySet Name="MEMBER" EntityType="Self.MEMBER" Schema="dbo" store:Type="Tables" />
268
          <EntitySet Name="MEMBER_DEPT_COLOR" EntityType="Self.MEMBER_DEPT_COLOR" Schema="dbo" store:Type="Tables" />
269
          <EntitySet Name="MEMBER_DEPT_COLORINFO" EntityType="Self.MEMBER_DEPT_COLORINFO" Schema="dbo" store:Type="Tables" />
270
          <EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" />
271
          <EntitySet Name="TALK" EntityType="Self.TALK" Schema="dbo" store:Type="Tables" />
272
          <AssociationSet Name="FK_DOCINFODOFPAGE" Association="Self.FK_DOCINFODOFPAGE">
273
            <End Role="DOCINFO" EntitySet="DOCINFO" />
274
            <End Role="DOCPAGE" EntitySet="DOCPAGE" />
275
          </AssociationSet>
276
          <AssociationSet Name="FK_DOCINFOMARKUPINFO" Association="Self.FK_DOCINFOMARKUPINFO">
277
            <End Role="DOCINFO" EntitySet="DOCINFO" />
278
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
279
          </AssociationSet>
280
          <AssociationSet Name="FK_MARKUPINFO_VERSIONMARKUPDATA" Association="Self.FK_MARKUPINFO_VERSIONMARKUPDATA">
281
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
282
            <End Role="MARKUP_DATA" EntitySet="MARKUP_DATA" />
283
          </AssociationSet>
284
          <AssociationSet Name="FK_MARKUPINFOMARKUPINFO_VERSION" Association="Self.FK_MARKUPINFOMARKUPINFO_VERSION">
285
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
286
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
287
          </AssociationSet>
288
          <AssociationSet Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" Association="Self.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
289
            <End Role="MEMBER_DEPT_COLOR" EntitySet="MEMBER_DEPT_COLOR" />
290
            <End Role="MEMBER_DEPT_COLORINFO" EntitySet="MEMBER_DEPT_COLORINFO" />
291
          </AssociationSet>
292
        </EntityContainer>
293
      </Schema></edmx:StorageModels>
294
    <!-- CSDL content -->
295
    <edmx:ConceptualModels>
296
      <Schema Namespace="CIModel" Alias="Self" 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/2008/09/edm">
297
        <EntityContainer Name="CIEntities" annotation:LazyLoadingEnabled="true">
298
          <EntitySet Name="DOCUMENT_ITEM" EntityType="CIModel.DOCUMENT_ITEM" />
299
          <EntitySet Name="DOCINFO" EntityType="CIModel.DOCINFO" />
300
          <EntitySet Name="DOCPAGE" EntityType="CIModel.DOCPAGE" />
301
          <EntitySet Name="MARKUP_DATA" EntityType="CIModel.MARKUP_DATA" />
302
          <EntitySet Name="MARKUP_INFO" EntityType="CIModel.MARKUP_INFO" />
303
          <EntitySet Name="MARKUP_INFO_VERSION" EntityType="CIModel.MARKUP_INFO_VERSION" />
304
          <AssociationSet Name="FK_DOCINFODOFPAGE" Association="CIModel.FK_DOCINFODOFPAGE">
305
            <End Role="DOCINFO" EntitySet="DOCINFO" />
306
            <End Role="DOCPAGE" EntitySet="DOCPAGE" />
307
          </AssociationSet>
308
          <AssociationSet Name="FK_DOCINFOMARKUPINFO" Association="CIModel.FK_DOCINFOMARKUPINFO">
309
            <End Role="DOCINFO" EntitySet="DOCINFO" />
310
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
311
          </AssociationSet>
312
          <AssociationSet Name="FK_MARKUPINFO_VERSIONMARKUPDATA" Association="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA">
313
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
314
            <End Role="MARKUP_DATA" EntitySet="MARKUP_DATA" />
315
          </AssociationSet>
316
          <AssociationSet Name="FK_MARKUPINFOMARKUPINFO_VERSION" Association="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION">
317
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
318
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
319
          </AssociationSet>
320
          <EntitySet Name="MARKUP_CHECKLIST" EntityType="CIModel.MARKUP_CHECKLIST" />
321
          <EntitySet Name="MEMBER" EntityType="CIModel.MEMBER" />
322
          <EntitySet Name="SIGN_INFO" EntityType="CIModel.SIGN_INFO" />
323
          <AssociationSet Name="FK_SIGNINFO_MEMBER" Association="CIModel.FK_SIGNINFO_MEMBER">
324
            <End Role="MEMBER" EntitySet="MEMBER" />
325
            <End Role="SIGN_INFO" EntitySet="SIGN_INFO" />
326
          </AssociationSet>
327
          <EntitySet Name="TALK" EntityType="CIModel.TALK" />
328
          <EntitySet Name="CHECK_LIST" EntityType="CIModel.CHECK_LIST" />
329
          <EntitySet Name="CHECK_LIST_HISTORY" EntityType="CIModel.CHECK_LIST_HISTORY" />
330
          <EntitySet Name="MEMBER_DEPT_COLOR" EntityType="CIModel.MEMBER_DEPT_COLOR" />
331
          <EntitySet Name="MEMBER_DEPT_COLORINFO" EntityType="CIModel.MEMBER_DEPT_COLORINFO" />
332
          <AssociationSet Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
333
            <End Role="MEMBER_DEPT_COLOR" EntitySet="MEMBER_DEPT_COLOR" />
334
            <End Role="MEMBER_DEPT_COLORINFO" EntitySet="MEMBER_DEPT_COLORINFO" />
335
          </AssociationSet>
336
          </EntityContainer>
337
        <EntityType Name="DOCUMENT_ITEM">
338
          <Key>
339
            <PropertyRef Name="ID" />
340
          </Key>
341
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
342
          <Property Name="REVISION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
343
          <Property Name="DOCUMENT_NO" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
344
          <Property Name="DOCUMENT_NAME" Type="String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
345
          <Property Name="GROUP_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
346
          <Property Name="ORIGINAL_FILE" Type="String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
347
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
348
          <Property Name="RESULT_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
349
          <Property Name="RESULT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
350
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
351
          <Property Name="ENSEMBLEINFO_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
352
        </EntityType>
353
        <EntityType Name="DOCINFO">
354
          <Key>
355
            <PropertyRef Name="ID" />
356
          </Key>
357
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
358
          <Property Name="ORIGINAL_FILE" Type="String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
359
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
360
          <Property Name="PAGE_COUNT" Type="Int32" Nullable="false" />
361
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
362
          <NavigationProperty Name="DOCPAGE" Relationship="CIModel.FK_DOCINFODOFPAGE" FromRole="DOCINFO" ToRole="DOCPAGE" />
363
          <NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="DOCINFO" ToRole="MARKUP_INFO" />
364
        </EntityType>
365
        <EntityType Name="DOCPAGE">
366
          <Key>
367
            <PropertyRef Name="ID" />
368
          </Key>
369
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
370
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
371
          <Property Name="PAGE_NUMBER" Type="Int32" Nullable="false" />
372
          <Property Name="PAGE_WIDTH" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
373
          <Property Name="PAGE_HEIGHT" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
374
          <Property Name="PAGE_ANGLE" Type="Int32" Nullable="false" />
375
          <NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFODOFPAGE" FromRole="DOCPAGE" ToRole="DOCINFO" />
376
        </EntityType>
377
        <EntityType Name="MARKUP_DATA">
378
          <Key>
379
            <PropertyRef Name="ID" />
380
          </Key>
381
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
382
          <Property Name="PAGENUMBER" Type="Int32" Nullable="false" />
383
          <Property Name="DATA" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
384
          <Property Name="MARKUPINFO_VERSION_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
385
          <Property Name="DATA_TYPE" Type="Int32" Nullable="false" />
386
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" />
387
          <Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
388
        </EntityType>
389
        <EntityType Name="MARKUP_INFO">
390
          <Key>
391
            <PropertyRef Name="ID" />
392
          </Key>
393
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
394
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
395
          <Property Name="USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
396
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
397
          <Property Name="CONSOLIDATE" Type="Int32" Nullable="false" />
398
          <Property Name="DESCRIPTION" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
399
          <Property Name="AVOID_CONSOLIDATE" Type="Int32" Nullable="false" />
400
          <Property Name="PART_CONSOLIDATE" Type="Int32" Nullable="false" />
401
          <Property Name="UPDATE_TIME" Type="DateTime" Precision="3" />
402
          <NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="MARKUP_INFO" ToRole="DOCINFO" />
403
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO" ToRole="MARKUP_INFO_VERSION" />
404
        </EntityType>
405
        <EntityType Name="MARKUP_INFO_VERSION">
406
          <Key>
407
            <PropertyRef Name="ID" />
408
          </Key>
409
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
410
          <Property Name="MARKUPINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
411
          <Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" />
412
          <NavigationProperty Name="MARKUP_DATA" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_DATA" />
413
          <NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_INFO" />
414
        </EntityType>
415
        <Association Name="FK_DOCINFODOFPAGE">
416
          <End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" />
417
          <End Type="CIModel.DOCPAGE" Role="DOCPAGE" Multiplicity="*" />
418
          <ReferentialConstraint>
419
            <Principal Role="DOCINFO">
420
              <PropertyRef Name="ID" />
421
            </Principal>
422
            <Dependent Role="DOCPAGE">
423
              <PropertyRef Name="DOCINFO_ID" />
424
            </Dependent>
425
          </ReferentialConstraint>
426
        </Association>
427
        <Association Name="FK_DOCINFOMARKUPINFO">
428
          <End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" />
429
          <End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="*" />
430
          <ReferentialConstraint>
431
            <Principal Role="DOCINFO">
432
              <PropertyRef Name="ID" />
433
            </Principal>
434
            <Dependent Role="MARKUP_INFO">
435
              <PropertyRef Name="DOCINFO_ID" />
436
            </Dependent>
437
          </ReferentialConstraint>
438
        </Association>
439
        <Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA">
440
          <End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="1" />
441
          <End Type="CIModel.MARKUP_DATA" Role="MARKUP_DATA" Multiplicity="*" />
442
          <ReferentialConstraint>
443
            <Principal Role="MARKUP_INFO_VERSION">
444
              <PropertyRef Name="ID" />
445
            </Principal>
446
            <Dependent Role="MARKUP_DATA">
447
              <PropertyRef Name="MARKUPINFO_VERSION_ID" />
448
            </Dependent>
449
          </ReferentialConstraint>
450
        </Association>
451
        <Association Name="FK_MARKUPINFOMARKUPINFO_VERSION">
452
          <End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="1" />
453
          <End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="*" />
454
          <ReferentialConstraint>
455
            <Principal Role="MARKUP_INFO">
456
              <PropertyRef Name="ID" />
457
            </Principal>
458
            <Dependent Role="MARKUP_INFO_VERSION">
459
              <PropertyRef Name="MARKUPINFO_ID" />
460
            </Dependent>
461
          </ReferentialConstraint>
462
        </Association>
463
        <EntityType Name="MARKUP_CHECKLIST">
464
          <Key>
465
            <PropertyRef Name="CK_NO" />
466
          </Key>
467
          <Property Name="CK_NO" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
468
          <Property Name="CK_REV_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
469
          <Property Name="CK_PAGE" Type="Int32" />
470
          <Property Name="CK_COMMENT" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
471
          <Property Name="CK_TODO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
472
          <Property Name="CK_STATUS" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
473
          <Property Name="CK_RESULT" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
474
        </EntityType>
475
        <EntityType Name="MEMBER">
476
          <Key>
477
            <PropertyRef Name="ID" />
478
          </Key>
479
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
480
          <Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
481
          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
482
          <Property Name="POSITION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
483
          <Property Name="EMAIL_ADDRESS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
484
          <NavigationProperty Name="SIGN_INFO" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="MEMBER" ToRole="SIGN_INFO" />
485
          <Property Name="PASSWORD" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
486
          <Property Name="COMPANY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
487
          <Property Name="CREATE_DATETIME" Type="DateTime" Precision="3" />
488
          <Property Name="MODIFIED_DATETIME" Type="DateTime" Precision="3" />
489
          <Property Name="ISLICENSE" Type="Int32" />
490
        </EntityType>
491
        <EntityType Name="SIGN_INFO">
492
          <Key>
493
            <PropertyRef Name="ID" />
494
          </Key>
495
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
496
          <Property Name="SIGN_STR" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
497
          <Property Name="MEMBER_USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
498
          <Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" />
499
          <Property Name="MODIFY_DATE" Type="DateTime" Precision="3" />
500
          <NavigationProperty Name="MEMBER" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="SIGN_INFO" ToRole="MEMBER" />
501
        </EntityType>
502
        <Association Name="FK_SIGNINFO_MEMBER">
503
          <End Type="CIModel.MEMBER" Role="MEMBER" Multiplicity="1" />
504
          <End Type="CIModel.SIGN_INFO" Role="SIGN_INFO" Multiplicity="*" />
505
          <ReferentialConstraint>
506
            <Principal Role="MEMBER">
507
              <PropertyRef Name="ID" />
508
            </Principal>
509
            <Dependent Role="SIGN_INFO">
510
              <PropertyRef Name="MEMBER_USER_ID" />
511
            </Dependent>
512
          </ReferentialConstraint>
513
        </Association>
514
        <EntityType Name="TALK">
515
          <Key>
516
            <PropertyRef Name="ID" />
517
          </Key>
518
          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
519
          <Property Name="TEXT" Type="String" Nullable="false" MaxLength="300" FixedLength="true" Unicode="true" />
520
          <Property Name="TIMESTAMP" Type="DateTime" Nullable="false" Precision="3" />
521
          <Property Name="MSGTYPE" Type="Byte" Nullable="false" />
522
          <Property Name="MSGSIDE" Type="Byte" Nullable="false" />
523
          <Property Name="RECT_X" Type="Double" />
524
          <Property Name="RECT_Y" Type="Double" />
525
          <Property Name="RECT_WIDTH" Type="Double" />
526
          <Property Name="RECT_HEIGHT" Type="Double" />
527
          <Property Name="PAGENUMBER" Type="Int32" />
528
          <Property Name="MEMBER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
529
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
530
          <Property Name="MEMBER_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
531
          <Property Name="ANGLE" Type="Int32" Nullable="false" />
532
        </EntityType>
533
        <EntityType Name="CHECK_LIST">
534
          <Key>
535
            <PropertyRef Name="ID" />
536
          </Key>
537
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
538
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
539
          <Property Name="USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
540
          <Property Name="REVISION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
541
          <Property Name="PAGENUMBER" Type="Int32" Nullable="false" />
542
          <Property Name="TODOLIST" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
543
          <Property Name="IMAGE_URL" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
544
          <Property Name="STATUS" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
545
          <Property Name="VENDOR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
546
          <Property Name="REMARK" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
547
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
548
          <Property Name="REV_4" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
549
          <Property Name="REV_3" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
550
          <Property Name="REV_2" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
551
          <Property Name="REV_1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
552
          <Property Name="REV_0" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
553
          <Property Name="IMAGE_ANCHOR" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
554
          <Property Name="CREATE_TIME" Type="DateTime" Precision="3" />
555
          <Property Name="UPDATE_TIME" Type="DateTime" Precision="3" />
556
          <Property Name="STATUS_DESC_OPEN" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
557
          <Property Name="STATUS_DESC_CLOSE" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
558
          <Property Name="REPLY" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
559
          <Property Name="DOCUMENT_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
560
        </EntityType>
561
        <EntityType Name="CHECK_LIST_HISTORY">
562
          <Key>
563
            <PropertyRef Name="ID" />
564
          </Key>
565
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
566
          <Property Name="CHECKLIST_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
567
          <Property Name="REVISION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
568
          <Property Name="STATUS" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
569
          <Property Name="STATUS_DESC" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
570
          <Property Name="TODOLIST" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
571
          <Property Name="VENDOR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
572
          <Property Name="REMARK" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
573
          <Property Name="REPLY" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
574
          <Property Name="IMAGE_URL" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
575
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
576
          <Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
577
        </EntityType>
578
        <EntityType Name="MEMBER_DEPT_COLOR">
579
          <Key>
580
            <PropertyRef Name="COLORID" />
581
          </Key>
582
          <Property Name="COLORID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
583
          <Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
584
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
585
          <NavigationProperty Name="MEMBER_DEPT_COLORINFO" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLOR" ToRole="MEMBER_DEPT_COLORINFO" />
586
        </EntityType>
587
        <EntityType Name="MEMBER_DEPT_COLORINFO">
588
          <Key>
589
            <PropertyRef Name="CVALUEID" />
590
            <PropertyRef Name="DISPLAYCOLOR" />
591
            <PropertyRef Name="COLORID" />
592
          </Key>
593
          <Property Name="CVALUEID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
594
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
595
          <Property Name="COLORID" Type="Int32" Nullable="false" />
596
          <NavigationProperty Name="MEMBER_DEPT_COLOR" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLORINFO" ToRole="MEMBER_DEPT_COLOR" />
597
        </EntityType>
598
        <Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
599
          <End Type="CIModel.MEMBER_DEPT_COLOR" Role="MEMBER_DEPT_COLOR" Multiplicity="1" />
600
          <End Type="CIModel.MEMBER_DEPT_COLORINFO" Role="MEMBER_DEPT_COLORINFO" Multiplicity="*" />
601
          <ReferentialConstraint>
602
            <Principal Role="MEMBER_DEPT_COLOR">
603
              <PropertyRef Name="COLORID" />
604
            </Principal>
605
            <Dependent Role="MEMBER_DEPT_COLORINFO">
606
              <PropertyRef Name="COLORID" />
607
            </Dependent>
608
          </ReferentialConstraint>
609
        </Association>
610
        </Schema>
611
    </edmx:ConceptualModels>
612
    <!-- C-S mapping content -->
613
    <edmx:Mappings>
614
    <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
615
  <EntityContainerMapping StorageEntityContainer="CIModelStoreContainer" CdmEntityContainer="CIEntities">
616
    <EntitySetMapping Name="DOCUMENT_ITEM">
617
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCUMENT_ITEM)">
618
        <MappingFragment StoreEntitySet="DOCUMENT_ITEM">
619
          <ScalarProperty Name="ENSEMBLEINFO_URL" ColumnName="ENSEMBLEINFO_URL" />
620
                <ScalarProperty Name="ID" ColumnName="ID" />
621
          <ScalarProperty Name="REVISION" ColumnName="REVISION" />
622
          <ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" />
623
          <ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" />
624
          <ScalarProperty Name="GROUP_NO" ColumnName="GROUP_NO" />
625
          <ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" />
626
          <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
627
          <ScalarProperty Name="RESULT_FILE" ColumnName="RESULT_FILE" />
628
          <ScalarProperty Name="RESULT" ColumnName="RESULT" />
629
          <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
630
        </MappingFragment>
631
      </EntityTypeMapping>
632
    </EntitySetMapping>
633
    <EntitySetMapping Name="DOCINFO">
634
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCINFO)">
635
        <MappingFragment StoreEntitySet="DOCINFO">
636
          <ScalarProperty Name="ID" ColumnName="ID" />
637
          <ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" />
638
          <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
639
          <ScalarProperty Name="PAGE_COUNT" ColumnName="PAGE_COUNT" />
640
          <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
641
        </MappingFragment>
642
      </EntityTypeMapping>
643
    </EntitySetMapping>
644
    <EntitySetMapping Name="DOCPAGE">
645
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCPAGE)">
646
        <MappingFragment StoreEntitySet="DOCPAGE">
647
          <ScalarProperty Name="ID" ColumnName="ID" />
648
          <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
649
          <ScalarProperty Name="PAGE_NUMBER" ColumnName="PAGE_NUMBER" />
650
          <ScalarProperty Name="PAGE_WIDTH" ColumnName="PAGE_WIDTH" />
651
          <ScalarProperty Name="PAGE_HEIGHT" ColumnName="PAGE_HEIGHT" />
652
          <ScalarProperty Name="PAGE_ANGLE" ColumnName="PAGE_ANGLE" />
653
        </MappingFragment>
654
      </EntityTypeMapping>
655
    </EntitySetMapping>
656
    <EntitySetMapping Name="MARKUP_DATA">
657
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)">
658
        <MappingFragment StoreEntitySet="MARKUP_DATA">
659
                <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
660
                <ScalarProperty Name="ID" ColumnName="ID" />
661
          <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
662
          <ScalarProperty Name="DATA" ColumnName="DATA" />
663
          <ScalarProperty Name="MARKUPINFO_VERSION_ID" ColumnName="MARKUPINFO_VERSION_ID" />
664
          <ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" />
665
        </MappingFragment>
666
      </EntityTypeMapping>
667
    </EntitySetMapping>
668
    <EntitySetMapping Name="MARKUP_INFO">
669
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO)">
670
        <MappingFragment StoreEntitySet="MARKUP_INFO">
671
          <ScalarProperty Name="ID" ColumnName="ID" />
672
          <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
673
          <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
674
          <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
675
          <ScalarProperty Name="CONSOLIDATE" ColumnName="CONSOLIDATE" />
676
          <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
677
          <ScalarProperty Name="AVOID_CONSOLIDATE" ColumnName="AVOID_CONSOLIDATE" />
678
          <ScalarProperty Name="PART_CONSOLIDATE" ColumnName="PART_CONSOLIDATE" />
679
          <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
680
        </MappingFragment>
681
      </EntityTypeMapping>
682
    </EntitySetMapping>
683
    <EntitySetMapping Name="MARKUP_INFO_VERSION">
684
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO_VERSION)">
685
        <MappingFragment StoreEntitySet="MARKUP_INFO_VERSION">
686
          <ScalarProperty Name="ID" ColumnName="ID" />
687
          <ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" />
688
          <ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" />
689
        </MappingFragment>
690
      </EntityTypeMapping>
691
    </EntitySetMapping>
692
    <EntitySetMapping Name="MARKUP_CHECKLIST">
693
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_CHECKLIST)">
694
        <MappingFragment StoreEntitySet="MARKUP_CHECKLIST">
695
          <ScalarProperty Name="CK_NO" ColumnName="CK_NO" />
696
          <ScalarProperty Name="CK_REV_NO" ColumnName="CK_REV_NO" />
697
          <ScalarProperty Name="CK_PAGE" ColumnName="CK_PAGE" />
698
          <ScalarProperty Name="CK_COMMENT" ColumnName="CK_COMMENT" />
699
          <ScalarProperty Name="CK_TODO" ColumnName="CK_TODO" />
700
          <ScalarProperty Name="CK_STATUS" ColumnName="CK_STATUS" />
701
          <ScalarProperty Name="CK_RESULT" ColumnName="CK_RESULT" />
702
        </MappingFragment>
703
      </EntityTypeMapping>
704
    </EntitySetMapping>
705
          <EntitySetMapping Name="MEMBER">
706
            <EntityTypeMapping TypeName="CIModel.MEMBER">
707
              <MappingFragment StoreEntitySet="MEMBER">
708
                <ScalarProperty Name="ISLICENSE" ColumnName="ISLICENSE" />
709
                <ScalarProperty Name="MODIFIED_DATETIME" ColumnName="MODIFIED_DATETIME" />
710
                <ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" />
711
                <ScalarProperty Name="COMPANY" ColumnName="COMPANY" />
712
                <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" />
713
                <ScalarProperty Name="EMAIL_ADDRESS" ColumnName="EMAIL_ADDRESS" />
714
                <ScalarProperty Name="POSITION" ColumnName="POSITION" />
715
                <ScalarProperty Name="NAME" ColumnName="NAME" />
716
                <ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" />
717
                <ScalarProperty Name="ID" ColumnName="ID" />
718
              </MappingFragment>
719
            </EntityTypeMapping>
720
          </EntitySetMapping>
721
          <EntitySetMapping Name="SIGN_INFO">
722
            <EntityTypeMapping TypeName="CIModel.SIGN_INFO">
723
              <MappingFragment StoreEntitySet="SIGN_INFO">
724
                <ScalarProperty Name="MODIFY_DATE" ColumnName="MODIFY_DATE" />
725
                <ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" />
726
                <ScalarProperty Name="MEMBER_USER_ID" ColumnName="MEMBER_USER_ID" />
727
                <ScalarProperty Name="SIGN_STR" ColumnName="SIGN_STR" />
728
                <ScalarProperty Name="ID" ColumnName="ID" />
729
              </MappingFragment>
730
            </EntityTypeMapping>
731
          </EntitySetMapping>
732
          <EntitySetMapping Name="TALK">
733
            <EntityTypeMapping TypeName="CIModel.TALK">
734
              <MappingFragment StoreEntitySet="TALK">
735
                <ScalarProperty Name="ANGLE" ColumnName="ANGLE" />
736
                <ScalarProperty Name="MEMBER_NAME" ColumnName="MEMBER_NAME" />
737
                <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
738
                <ScalarProperty Name="MEMBER_ID" ColumnName="MEMBER_ID" />
739
                <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
740
                <ScalarProperty Name="RECT_HEIGHT" ColumnName="RECT_HEIGHT" />
741
                <ScalarProperty Name="RECT_WIDTH" ColumnName="RECT_WIDTH" />
742
                <ScalarProperty Name="RECT_Y" ColumnName="RECT_Y" />
743
                <ScalarProperty Name="RECT_X" ColumnName="RECT_X" />
744
                <ScalarProperty Name="MSGSIDE" ColumnName="MSGSIDE" />
745
                <ScalarProperty Name="MSGTYPE" ColumnName="MSGTYPE" />
746
                <ScalarProperty Name="TIMESTAMP" ColumnName="TIMESTAMP" />
747
                <ScalarProperty Name="TEXT" ColumnName="TEXT" />
748
                <ScalarProperty Name="ID" ColumnName="ID" />
749
              </MappingFragment>
750
            </EntityTypeMapping>
751
          </EntitySetMapping>
752
          <EntitySetMapping Name="CHECK_LIST">
753
            <EntityTypeMapping TypeName="CIModel.CHECK_LIST">
754
              <MappingFragment StoreEntitySet="CHECK_LIST">
755
                <ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" />
756
                <ScalarProperty Name="REPLY" ColumnName="REPLY" />
757
                <ScalarProperty Name="STATUS_DESC_CLOSE" ColumnName="STATUS_DESC_CLOSE" />
758
                <ScalarProperty Name="STATUS_DESC_OPEN" ColumnName="STATUS_DESC_OPEN" />
759
                <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
760
                <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
761
                <ScalarProperty Name="IMAGE_ANCHOR" ColumnName="IMAGE_ANCHOR" />
762
                <ScalarProperty Name="REV_0" ColumnName="REV_0" />
763
                <ScalarProperty Name="REV_1" ColumnName="REV_1" />
764
                <ScalarProperty Name="REV_2" ColumnName="REV_2" />
765
                <ScalarProperty Name="REV_3" ColumnName="REV_3" />
766
                <ScalarProperty Name="REV_4" ColumnName="REV_4" />
767
                <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
768
                <ScalarProperty Name="REMARK" ColumnName="REMARK" />
769
                <ScalarProperty Name="VENDOR" ColumnName="VENDOR" />
770
                <ScalarProperty Name="STATUS" ColumnName="STATUS" />
771
                <ScalarProperty Name="IMAGE_URL" ColumnName="IMAGE_URL" />
772
                <ScalarProperty Name="TODOLIST" ColumnName="TODOLIST" />
773
                <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
774
                <ScalarProperty Name="REVISION" ColumnName="REVISION" />
775
                <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
776
                <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
777
                <ScalarProperty Name="ID" ColumnName="ID" />
778
              </MappingFragment>
779
            </EntityTypeMapping>
780
          </EntitySetMapping>
781
          <EntitySetMapping Name="CHECK_LIST_HISTORY">
782
            <EntityTypeMapping TypeName="CIModel.CHECK_LIST_HISTORY">
783
              <MappingFragment StoreEntitySet="CHECK_LIST_HISTORY">
784
                <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
785
                <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
786
                <ScalarProperty Name="IMAGE_URL" ColumnName="IMAGE_URL" />
787
                <ScalarProperty Name="REPLY" ColumnName="REPLY" />
788
                <ScalarProperty Name="REMARK" ColumnName="REMARK" />
789
                <ScalarProperty Name="VENDOR" ColumnName="VENDOR" />
790
                <ScalarProperty Name="TODOLIST" ColumnName="TODOLIST" />
791
                <ScalarProperty Name="STATUS_DESC" ColumnName="STATUS_DESC" />
792
                <ScalarProperty Name="STATUS" ColumnName="STATUS" />
793
                <ScalarProperty Name="REVISION" ColumnName="REVISION" />
794
                <ScalarProperty Name="CHECKLIST_ID" ColumnName="CHECKLIST_ID" />
795
                <ScalarProperty Name="ID" ColumnName="ID" />
796
              </MappingFragment>
797
            </EntityTypeMapping>
798
          </EntitySetMapping>
799
          <EntitySetMapping Name="MEMBER_DEPT_COLOR">
800
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLOR">
801
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLOR">
802
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
803
                <ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" />
804
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
805
              </MappingFragment>
806
            </EntityTypeMapping>
807
          </EntitySetMapping>
808
          <EntitySetMapping Name="MEMBER_DEPT_COLORINFO">
809
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLORINFO">
810
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLORINFO">
811
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
812
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
813
                <ScalarProperty Name="CVALUEID" ColumnName="CVALUEID" />
814
              </MappingFragment>
815
            </EntityTypeMapping>
816
          </EntitySetMapping>
817
          </EntityContainerMapping>
818
</Mapping></edmx:Mappings>
819
  </edmx:Runtime>
820
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
821
  <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
822
    <Connection>
823
      <DesignerInfoPropertySet>
824
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
825
      </DesignerInfoPropertySet>
826
    </Connection>
827
    <Options>
828
      <DesignerInfoPropertySet>
829
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
830
        <DesignerProperty Name="EnablePluralization" Value="false" />
831
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
832
        <DesignerProperty Name="UseLegacyProvider" Value="True" />
833
        <DesignerProperty Name="CodeGenerationStrategy" Value="기본값" />
834
      </DesignerInfoPropertySet>
835
    </Options>
836
    <!-- Diagram content (shape and connector positions) -->
837
    <Diagrams>
838
      <Diagram DiagramId="56537d79007d413b99bb660a37dd2a9f" Name="Diagram1" ZoomLevel="81">
839
        <EntityTypeShape EntityType="CIModel.DOCUMENT_ITEM" Width="1.5" PointX="5.375" PointY="7.75" />
840
        <EntityTypeShape EntityType="CIModel.DOCINFO" Width="1.5" PointX="7.375" PointY="10.125" />
841
        <EntityTypeShape EntityType="CIModel.DOCPAGE" Width="1.5" PointX="9.625" PointY="8.125" />
842
        <EntityTypeShape EntityType="CIModel.MARKUP_DATA" Width="2.25" PointX="14.125" PointY="11.75" />
843
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO" Width="1.5" PointX="9.625" PointY="11.25" />
844
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO_VERSION" Width="1.5" PointX="11.875" PointY="11.875" />
845
        <AssociationConnector Association="CIModel.FK_DOCINFODOFPAGE" />
846
        <AssociationConnector Association="CIModel.FK_DOCINFOMARKUPINFO" />
847
        <AssociationConnector Association="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" />
848
        <AssociationConnector Association="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" />
849
        <EntityTypeShape EntityType="CIModel.MARKUP_CHECKLIST" Width="1.5" PointX="0.75" PointY="0.75" />
850
        <EntityTypeShape EntityType="CIModel.MEMBER" Width="1.5" PointX="0.75" PointY="14.125" />
851
        <EntityTypeShape EntityType="CIModel.SIGN_INFO" Width="1.5" PointX="3" PointY="12.125" />
852
        <AssociationConnector Association="CIModel.FK_SIGNINFO_MEMBER" />
853
        <EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" />
854
        <EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" />
855
        <EntityTypeShape EntityType="CIModel.CHECK_LIST_HISTORY" Width="1.5" PointX="5.375" PointY="0.75" />
856
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLOR" Width="1.5" PointX="7.375" PointY="3.875" />
857
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLORINFO" Width="1.5" PointX="9.625" PointY="3.875" />
858
        <AssociationConnector Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" />
859
        </Diagram>
860
    </Diagrams>
861
  </Designer>
862
</edmx:Edmx>
클립보드 이미지 추가 (최대 크기: 500 MB)