프로젝트

일반

사용자정보

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

markus / KCOMDataModel / DataModel / CIModel.edmx @ 40b3ce25

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

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