프로젝트

일반

사용자정보

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

markus / KCOMDataModel / DataModel / CIModel.edmx @ ffd70d3c

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