프로젝트

일반

사용자정보

개정판 77cdac33

ID77cdac33b7bca4641193c97216f85dde1a21cb5e
상위 74abcf6f
하위 a7bee7cf

김태성이(가) 약 3년 전에 추가함

벽산 수정 후 백업

Change-Id: I8e3eb48f615478a49efa0ab4014a8ef17d273d0a

차이점 보기:

KCOMDataModel/DataModel/CIModel.edmx
100 100
          <Property Name="CK_STATUS" Type="nvarchar" MaxLength="10" />
101 101
          <Property Name="CK_RESULT" Type="nvarchar" MaxLength="10" />
102 102
        </EntityType>
103
        <!--생성 중 오류 발생:
104
경고 6002: 테이블/뷰 'markus.dbo.MARKUP_DATA'에 기본 키가 정의되지 않았습니다. 키가 유추되었고 읽기 전용 테이블/뷰로 정의되었습니다.-->
105 103
        <EntityType Name="MARKUP_DATA">
106 104
          <Key>
107 105
            <PropertyRef Name="ID" />
108
            
109
            
110
            
111
            
112 106
          </Key>
113 107
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
114 108
          <Property Name="PAGENUMBER" Type="int" Nullable="false" />
......
186 180
          <Property Name="MEMBER_NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
187 181
          <Property Name="ANGLE" Type="int" Nullable="false" />
188 182
        </EntityType>
183
        <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>
189 231
        <EntityContainer Name="CIModelStoreContainer">
190 232
          <EntitySet Name="CHECK_LIST" EntityType="Self.CHECK_LIST" Schema="dbo" store:Type="Tables" />
191 233
          <EntitySet Name="CHECK_LIST_HISTORY" EntityType="Self.CHECK_LIST_HISTORY" Schema="dbo" store:Type="Tables" />
......
193 235
          <EntitySet Name="DOCPAGE" EntityType="Self.DOCPAGE" Schema="dbo" store:Type="Tables" />
194 236
          <EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" Schema="dbo" store:Type="Tables" />
195 237
          <EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" Schema="dbo" store:Type="Tables" />
238
          <EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" Schema="dbo" store:Type="Tables" />
196 239
          <EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" />
197 240
          <EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" />
198 241
          <EntitySet Name="MEMBER" EntityType="Self.MEMBER" Schema="dbo" store:Type="Tables" />
199 242
          <EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" />
200 243
          <EntitySet Name="TALK" EntityType="Self.TALK" Schema="dbo" store:Type="Tables" />
201
          <EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" store:Type="Tables" store:Schema="dbo">
202
            <DefiningQuery>SELECT 
203
[MARKUP_DATA].[ID] AS [ID], 
204
[MARKUP_DATA].[PAGENUMBER] AS [PAGENUMBER], 
205
[MARKUP_DATA].[DATA] AS [DATA], 
206
[MARKUP_DATA].[MARKUPINFO_VERSION_ID] AS [MARKUPINFO_VERSION_ID], 
207
[MARKUP_DATA].[DATA_TYPE] AS [DATA_TYPE], 
208
[MARKUP_DATA].[SYMBOL_ID] AS [SYMBOL_ID], 
209
[MARKUP_DATA].[REMARK] AS [REMARK], 
210
[MARKUP_DATA].[InsertTime] AS [InsertTime]
211
FROM [dbo].[MARKUP_DATA] AS [MARKUP_DATA]</DefiningQuery>
212
          </EntitySet>
213
        </EntityContainer>
214
      </Schema></edmx:StorageModels>
215
    <!-- CSDL content -->
216
    <edmx:ConceptualModels>
217
      <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">
218
        <EntityContainer Name="CIEntities" annotation:LazyLoadingEnabled="true">
219
          <EntitySet Name="DOCUMENT_ITEM" EntityType="CIModel.DOCUMENT_ITEM" />
220
          <EntitySet Name="DOCINFO" EntityType="CIModel.DOCINFO" />
221
          <EntitySet Name="DOCPAGE" EntityType="CIModel.DOCPAGE" />
222
          <EntitySet Name="MARKUP_DATA" EntityType="CIModel.MARKUP_DATA" />
223
          <EntitySet Name="MARKUP_INFO" EntityType="CIModel.MARKUP_INFO" />
224
          <EntitySet Name="MARKUP_INFO_VERSION" EntityType="CIModel.MARKUP_INFO_VERSION" />
225
          <AssociationSet Name="FK_DOCINFODOFPAGE" Association="CIModel.FK_DOCINFODOFPAGE">
244
          <AssociationSet Name="FK_DOCPAGE_DOCINFO" Association="Self.FK_DOCPAGE_DOCINFO">
226 245
            <End Role="DOCINFO" EntitySet="DOCINFO" />
227 246
            <End Role="DOCPAGE" EntitySet="DOCPAGE" />
228 247
          </AssociationSet>
229
          <AssociationSet Name="FK_DOCINFOMARKUPINFO" Association="CIModel.FK_DOCINFOMARKUPINFO">
230
            <End Role="DOCINFO" EntitySet="DOCINFO" />
231
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
232
          </AssociationSet>
233
          <AssociationSet Name="FK_MARKUPINFO_VERSIONMARKUPDATA" Association="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA">
248
          <AssociationSet Name="FK_MARKUP_DATA_MARKUP_INFO_VERSION" Association="Self.FK_MARKUP_DATA_MARKUP_INFO_VERSION">
234 249
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
235 250
            <End Role="MARKUP_DATA" EntitySet="MARKUP_DATA" />
236 251
          </AssociationSet>
237
          <AssociationSet Name="FK_MARKUPINFOMARKUPINFO_VERSION" Association="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION">
252
          <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">
238 257
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
239 258
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
240 259
          </AssociationSet>
260
        </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" />
241 267
          <EntitySet Name="MARKUP_CHECKLIST" EntityType="CIModel.MARKUP_CHECKLIST" />
242 268
          <EntitySet Name="MEMBER" EntityType="CIModel.MEMBER" />
243 269
          <EntitySet Name="SIGN_INFO" EntityType="CIModel.SIGN_INFO" />
......
248 274
          <EntitySet Name="TALK" EntityType="CIModel.TALK" />
249 275
          <EntitySet Name="CHECK_LIST" EntityType="CIModel.CHECK_LIST" />
250 276
          <EntitySet Name="CHECK_LIST_HISTORY" EntityType="CIModel.CHECK_LIST_HISTORY" />
277
          <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>
251 298
          </EntityContainer>
252 299
        <EntityType Name="DOCUMENT_ITEM">
253 300
          <Key>
......
266 313
          <Property Name="Link" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
267 314
          <Property Name="CreateDate" Type="DateTime" Precision="3" />
268 315
        </EntityType>
269
        <EntityType Name="DOCINFO">
270
          <Key>
271
            <PropertyRef Name="ID" />
272
          </Key>
273
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
274
          <Property Name="ORIGINAL_FILE" Type="String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
275
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
276
          <Property Name="PAGE_COUNT" Type="Int32" Nullable="false" />
277
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
278
          <NavigationProperty Name="DOCPAGE" Relationship="CIModel.FK_DOCINFODOFPAGE" FromRole="DOCINFO" ToRole="DOCPAGE" />
279
          <NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="DOCINFO" ToRole="MARKUP_INFO" />
280
        </EntityType>
281
        <EntityType Name="DOCPAGE">
282
          <Key>
283
            <PropertyRef Name="ID" />
284
          </Key>
285
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
286
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
287
          <Property Name="PAGE_NUMBER" Type="Int32" Nullable="false" />
288
          <Property Name="PAGE_WIDTH" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
289
          <Property Name="PAGE_HEIGHT" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
290
          <Property Name="PAGE_ANGLE" Type="Int32" Nullable="false" />
291
          <NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFODOFPAGE" FromRole="DOCPAGE" ToRole="DOCINFO" />
292
        </EntityType>
293
        <EntityType Name="MARKUP_DATA">
294
          <Key>
295
            <PropertyRef Name="ID" />
296
          </Key>
297
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
298
          <Property Name="PAGENUMBER" Type="Int32" Nullable="false" />
299
          <Property Name="DATA" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
300
          <Property Name="MARKUPINFO_VERSION_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
301
          <Property Name="DATA_TYPE" Type="Int32" Nullable="false" />
302
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" />
303
          <Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
304
          <Property Name="REMARK" Type="String" MaxLength="40" FixedLength="false" Unicode="false" />
305
          <Property Name="InsertTime" Type="DateTime" Precision="3" />
306
        </EntityType>
307
        <EntityType Name="MARKUP_INFO">
308
          <Key>
309
            <PropertyRef Name="ID" />
310
          </Key>
311
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
312
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
313
          <Property Name="USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
314
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
315
          <Property Name="CONSOLIDATE" Type="Int32" Nullable="false" />
316
          <Property Name="DESCRIPTION" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
317
          <Property Name="AVOID_CONSOLIDATE" Type="Int32" Nullable="false" />
318
          <Property Name="PART_CONSOLIDATE" Type="Int32" Nullable="false" />
319
          <Property Name="UPDATE_TIME" Type="DateTime" Precision="3" />
320
          <NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="MARKUP_INFO" ToRole="DOCINFO" />
321
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO" ToRole="MARKUP_INFO_VERSION" />
322
        </EntityType>
323
        <EntityType Name="MARKUP_INFO_VERSION">
324
          <Key>
325
            <PropertyRef Name="ID" />
326
          </Key>
327
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
328
          <Property Name="MARKUPINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
329
          <Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" />
330
          <NavigationProperty Name="MARKUP_DATA" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_DATA" />
331
          <NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_INFO" />
332
        </EntityType>
333
        <Association Name="FK_DOCINFODOFPAGE">
334
          <End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" />
335
          <End Type="CIModel.DOCPAGE" Role="DOCPAGE" Multiplicity="*" />
336
          <ReferentialConstraint>
337
            <Principal Role="DOCINFO">
338
              <PropertyRef Name="ID" />
339
            </Principal>
340
            <Dependent Role="DOCPAGE">
341
              <PropertyRef Name="DOCINFO_ID" />
342
            </Dependent>
343
          </ReferentialConstraint>
344
        </Association>
345
        <Association Name="FK_DOCINFOMARKUPINFO">
346
          <End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" />
347
          <End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="*" />
348
          <ReferentialConstraint>
349
            <Principal Role="DOCINFO">
350
              <PropertyRef Name="ID" />
351
            </Principal>
352
            <Dependent Role="MARKUP_INFO">
353
              <PropertyRef Name="DOCINFO_ID" />
354
            </Dependent>
355
          </ReferentialConstraint>
356
        </Association>
357
        <Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA">
358
          <End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="1" />
359
          <End Type="CIModel.MARKUP_DATA" Role="MARKUP_DATA" Multiplicity="*" />
360
          <ReferentialConstraint>
361
            <Principal Role="MARKUP_INFO_VERSION">
362
              <PropertyRef Name="ID" />
363
            </Principal>
364
            <Dependent Role="MARKUP_DATA">
365
              <PropertyRef Name="MARKUPINFO_VERSION_ID" />
366
            </Dependent>
367
          </ReferentialConstraint>
368
        </Association>
369
        <Association Name="FK_MARKUPINFOMARKUPINFO_VERSION">
370
          <End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="1" />
371
          <End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="*" />
372
          <ReferentialConstraint>
373
            <Principal Role="MARKUP_INFO">
374
              <PropertyRef Name="ID" />
375
            </Principal>
376
            <Dependent Role="MARKUP_INFO_VERSION">
377
              <PropertyRef Name="MARKUPINFO_ID" />
378
            </Dependent>
379
          </ReferentialConstraint>
380
        </Association>
381 316
        <EntityType Name="MARKUP_CHECKLIST">
382 317
          <Key>
383 318
            <PropertyRef Name="CK_NO" />
......
494 429
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
495 430
          <Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
496 431
        </EntityType>
432
        <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>
497 544
        </Schema>
498 545
    </edmx:ConceptualModels>
499 546
    <!-- C-S mapping content -->
......
518 565
        </MappingFragment>
519 566
      </EntityTypeMapping>
520 567
    </EntitySetMapping>
521
    <EntitySetMapping Name="DOCINFO">
522
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCINFO)">
523
        <MappingFragment StoreEntitySet="DOCINFO">
524
          <ScalarProperty Name="ID" ColumnName="ID" />
525
          <ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" />
526
          <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
527
          <ScalarProperty Name="PAGE_COUNT" ColumnName="PAGE_COUNT" />
528
          <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
529
        </MappingFragment>
530
      </EntityTypeMapping>
531
    </EntitySetMapping>
532
    <EntitySetMapping Name="DOCPAGE">
533
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCPAGE)">
534
        <MappingFragment StoreEntitySet="DOCPAGE">
535
          <ScalarProperty Name="ID" ColumnName="ID" />
536
          <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
537
          <ScalarProperty Name="PAGE_NUMBER" ColumnName="PAGE_NUMBER" />
538
          <ScalarProperty Name="PAGE_WIDTH" ColumnName="PAGE_WIDTH" />
539
          <ScalarProperty Name="PAGE_HEIGHT" ColumnName="PAGE_HEIGHT" />
540
          <ScalarProperty Name="PAGE_ANGLE" ColumnName="PAGE_ANGLE" />
541
        </MappingFragment>
542
      </EntityTypeMapping>
543
    </EntitySetMapping>
544
    <EntitySetMapping Name="MARKUP_DATA">
545
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)">
546
        <MappingFragment StoreEntitySet="MARKUP_DATA">
547
                <ScalarProperty Name="InsertTime" ColumnName="InsertTime" />
548
                <ScalarProperty Name="REMARK" ColumnName="REMARK" />
549
                <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
550
                <ScalarProperty Name="ID" ColumnName="ID" />
551
          <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
552
          <ScalarProperty Name="DATA" ColumnName="DATA" />
553
          <ScalarProperty Name="MARKUPINFO_VERSION_ID" ColumnName="MARKUPINFO_VERSION_ID" />
554
          <ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" />
555
        </MappingFragment>
556
      </EntityTypeMapping>
557
    </EntitySetMapping>
558
    <EntitySetMapping Name="MARKUP_INFO">
559
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO)">
560
        <MappingFragment StoreEntitySet="MARKUP_INFO">
561
          <ScalarProperty Name="ID" ColumnName="ID" />
562
          <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
563
          <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
564
          <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
565
          <ScalarProperty Name="CONSOLIDATE" ColumnName="CONSOLIDATE" />
566
          <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
567
          <ScalarProperty Name="AVOID_CONSOLIDATE" ColumnName="AVOID_CONSOLIDATE" />
568
          <ScalarProperty Name="PART_CONSOLIDATE" ColumnName="PART_CONSOLIDATE" />
569
          <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
570
        </MappingFragment>
571
      </EntityTypeMapping>
572
    </EntitySetMapping>
573
    <EntitySetMapping Name="MARKUP_INFO_VERSION">
574
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO_VERSION)">
575
        <MappingFragment StoreEntitySet="MARKUP_INFO_VERSION">
576
          <ScalarProperty Name="ID" ColumnName="ID" />
577
          <ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" />
578
          <ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" />
579
        </MappingFragment>
580
      </EntityTypeMapping>
581
    </EntitySetMapping>
582 568
    <EntitySetMapping Name="MARKUP_CHECKLIST">
583 569
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_CHECKLIST)">
584 570
        <MappingFragment StoreEntitySet="MARKUP_CHECKLIST">
......
687 673
              </MappingFragment>
688 674
            </EntityTypeMapping>
689 675
          </EntitySetMapping>
676
          <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>
690 737
          </EntityContainerMapping>
691 738
</Mapping></edmx:Mappings>
692 739
  </edmx:Runtime>
......
710 757
    <Diagrams>
711 758
      <Diagram DiagramId="56537d79007d413b99bb660a37dd2a9f" Name="Diagram1" ZoomLevel="105">
712 759
        <EntityTypeShape EntityType="CIModel.DOCUMENT_ITEM" Width="1.5" PointX="5.375" PointY="7.75" />
713
        <EntityTypeShape EntityType="CIModel.DOCINFO" Width="1.5" PointX="7.375" PointY="10.125" />
714
        <EntityTypeShape EntityType="CIModel.DOCPAGE" Width="1.5" PointX="9.625" PointY="8.125" />
715
        <EntityTypeShape EntityType="CIModel.MARKUP_DATA" Width="2.25" PointX="14.125" PointY="11.75" />
716
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO" Width="1.5" PointX="9.625" PointY="11.25" />
717
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO_VERSION" Width="1.5" PointX="11.875" PointY="11.875" />
718
        <AssociationConnector Association="CIModel.FK_DOCINFODOFPAGE" />
719
        <AssociationConnector Association="CIModel.FK_DOCINFOMARKUPINFO" />
720
        <AssociationConnector Association="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" />
721
        <AssociationConnector Association="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" />
722 760
        <EntityTypeShape EntityType="CIModel.MARKUP_CHECKLIST" Width="1.5" PointX="0.75" PointY="0.75" />
723 761
        <EntityTypeShape EntityType="CIModel.MEMBER" Width="1.5" PointX="0.75" PointY="14.125" />
724 762
        <EntityTypeShape EntityType="CIModel.SIGN_INFO" Width="1.5" PointX="3" PointY="12.125" />
......
726 764
        <EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" />
727 765
        <EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" />
728 766
        <EntityTypeShape EntityType="CIModel.CHECK_LIST_HISTORY" Width="1.5" PointX="5.375" PointY="0.75" />
767
        <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" />
729 776
        </Diagram>
730 777
    </Diagrams>
731 778
  </Designer>

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)