프로젝트

일반

사용자정보

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

markus / KCOMDataModel / DataModel / CIModel.edmx @ ab5aa762

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