프로젝트

일반

사용자정보

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

markus / KCOMDataModel / DataModel / CIModel.edmx @ 53880c83

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