프로젝트

일반

사용자정보

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

markus / KCOMDataModel / DataModel / CIModel.edmx @ 77cdac33

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