프로젝트

일반

사용자정보

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

markus / KCOMDataModel / DataModel / CIModel.edmx @ f9d986d9

이력 | 보기 | 이력해설 | 다운로드 (53.5 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 f9d986d9 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 f9d986d9 ljiyeon 
          <Property Name="GROUP_ID" Type="bigint" />
113 787a4489 KangIngu 
        </EntityType>
114 
        <EntityType Name="MARKUP_INFO">
115 
          <Key>
116 
            <PropertyRef Name="ID" />
117 
          </Key>
118 
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
119 
          <Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
120 
          <Property Name="USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
121 
          <Property Name="CREATE_TIME" Type="datetime" Nullable="false" />
122 
          <Property Name="CONSOLIDATE" Type="int" Nullable="false" />
123 
          <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="500" />
124 
          <Property Name="AVOID_CONSOLIDATE" Type="int" Nullable="false" />
125 
          <Property Name="PART_CONSOLIDATE" Type="int" Nullable="false" />
126 
          <Property Name="UPDATE_TIME" Type="datetime" />
127 
        </EntityType>
128 
        <EntityType Name="MARKUP_INFO_VERSION">
129 
          <Key>
130 
            <PropertyRef Name="ID" />
131 
          </Key>
132 
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
133 
          <Property Name="MARKUPINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
134 
          <Property Name="CREATE_DATE" Type="datetime" Nullable="false" />
135 
        </EntityType>
136 
        <EntityType Name="MEMBER">
137 
          <Key>
138 
            <PropertyRef Name="ID" />
139 
          </Key>
140 
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
141 
          <Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" />
142 
          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
143 
          <Property Name="POSITION" Type="nvarchar" MaxLength="50" />
144 
          <Property Name="EMAIL_ADDRESS" Type="nvarchar" MaxLength="50" />
145 c8e9b3e4 ljiyeon 
          <Property Name="PASSWORD" Type="nvarchar" MaxLength="64" />
146 787a4489 KangIngu 
          <Property Name="COMPANY" Type="nvarchar" MaxLength="50" />
147 c8e9b3e4 ljiyeon 
          <Property Name="CREATE_DATETIME" Type="datetime" />
148 
          <Property Name="MODIFIED_DATETIME" Type="datetime" />
149 
          <Property Name="ISLICENSE" Type="int" />
150 787a4489 KangIngu 
        </EntityType>
151 f9d986d9 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 f9d986d9 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 f9d986d9 ljiyeon 
            <Principal Role="MEMBER_DEPT_COLOR">
251 
              <PropertyRef Name="COLORID" />
252 787a4489 KangIngu 
            </Principal>
253 f9d986d9 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 f9d986d9 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 f9d986d9 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 f9d986d9 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 f9d986d9 ljiyeon 
          <Property Name="ENSEMBLEINFO_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
353 787a4489 KangIngu 
        </EntityType>
354 
        <EntityType Name="DOCINFO">
355 
          <Key>
356 
            <PropertyRef Name="ID" />
357 
          </Key>
358 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
359 
          <Property Name="ORIGINAL_FILE" Type="String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
360 
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
361 
          <Property Name="PAGE_COUNT" Type="Int32" Nullable="false" />
362 
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
363 
          <NavigationProperty Name="DOCPAGE" Relationship="CIModel.FK_DOCINFODOFPAGE" FromRole="DOCINFO" ToRole="DOCPAGE" />
364 
          <NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="DOCINFO" ToRole="MARKUP_INFO" />
365 
        </EntityType>
366 
        <EntityType Name="DOCPAGE">
367 
          <Key>
368 
            <PropertyRef Name="ID" />
369 
          </Key>
370 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
371 
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
372 
          <Property Name="PAGE_NUMBER" Type="Int32" Nullable="false" />
373 
          <Property Name="PAGE_WIDTH" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
374 
          <Property Name="PAGE_HEIGHT" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
375 
          <Property Name="PAGE_ANGLE" Type="Int32" Nullable="false" />
376 
          <NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFODOFPAGE" FromRole="DOCPAGE" ToRole="DOCINFO" />
377 
        </EntityType>
378 
        <EntityType Name="MARKUP_DATA">
379 
          <Key>
380 
            <PropertyRef Name="ID" />
381 
          </Key>
382 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
383 
          <Property Name="PAGENUMBER" Type="Int32" Nullable="false" />
384 
          <Property Name="DATA" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
385 
          <Property Name="MARKUPINFO_VERSION_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
386 
          <Property Name="DATA_TYPE" Type="Int32" Nullable="false" />
387 
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" />
388 c8e9b3e4 ljiyeon 
          <Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
389 f9d986d9 ljiyeon 
          <Property Name="GROUP_ID" Type="Int64" />
390 787a4489 KangIngu 
        </EntityType>
391 
        <EntityType Name="MARKUP_INFO">
392 
          <Key>
393 
            <PropertyRef Name="ID" />
394 
          </Key>
395 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
396 
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
397 
          <Property Name="USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
398 
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
399 
          <Property Name="CONSOLIDATE" Type="Int32" Nullable="false" />
400 
          <Property Name="DESCRIPTION" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
401 
          <Property Name="AVOID_CONSOLIDATE" Type="Int32" Nullable="false" />
402 
          <Property Name="PART_CONSOLIDATE" Type="Int32" Nullable="false" />
403 
          <Property Name="UPDATE_TIME" Type="DateTime" Precision="3" />
404 
          <NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="MARKUP_INFO" ToRole="DOCINFO" />
405 
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO" ToRole="MARKUP_INFO_VERSION" />
406 
        </EntityType>
407 
        <EntityType Name="MARKUP_INFO_VERSION">
408 
          <Key>
409 
            <PropertyRef Name="ID" />
410 
          </Key>
411 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
412 
          <Property Name="MARKUPINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
413 
          <Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" />
414 
          <NavigationProperty Name="MARKUP_DATA" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_DATA" />
415 
          <NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_INFO" />
416 
        </EntityType>
417 
        <Association Name="FK_DOCINFODOFPAGE">
418 
          <End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" />
419 
          <End Type="CIModel.DOCPAGE" Role="DOCPAGE" Multiplicity="*" />
420 
          <ReferentialConstraint>
421 
            <Principal Role="DOCINFO">
422 
              <PropertyRef Name="ID" />
423 
            </Principal>
424 
            <Dependent Role="DOCPAGE">
425 
              <PropertyRef Name="DOCINFO_ID" />
426 
            </Dependent>
427 
          </ReferentialConstraint>
428 
        </Association>
429 
        <Association Name="FK_DOCINFOMARKUPINFO">
430 
          <End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" />
431 
          <End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="*" />
432 
          <ReferentialConstraint>
433 
            <Principal Role="DOCINFO">
434 
              <PropertyRef Name="ID" />
435 
            </Principal>
436 
            <Dependent Role="MARKUP_INFO">
437 
              <PropertyRef Name="DOCINFO_ID" />
438 
            </Dependent>
439 
          </ReferentialConstraint>
440 
        </Association>
441 
        <Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA">
442 
          <End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="1" />
443 
          <End Type="CIModel.MARKUP_DATA" Role="MARKUP_DATA" Multiplicity="*" />
444 
          <ReferentialConstraint>
445 
            <Principal Role="MARKUP_INFO_VERSION">
446 
              <PropertyRef Name="ID" />
447 
            </Principal>
448 
            <Dependent Role="MARKUP_DATA">
449 
              <PropertyRef Name="MARKUPINFO_VERSION_ID" />
450 
            </Dependent>
451 
          </ReferentialConstraint>
452 
        </Association>
453 
        <Association Name="FK_MARKUPINFOMARKUPINFO_VERSION">
454 
          <End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="1" />
455 
          <End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="*" />
456 
          <ReferentialConstraint>
457 
            <Principal Role="MARKUP_INFO">
458 
              <PropertyRef Name="ID" />
459 
            </Principal>
460 
            <Dependent Role="MARKUP_INFO_VERSION">
461 
              <PropertyRef Name="MARKUPINFO_ID" />
462 
            </Dependent>
463 
          </ReferentialConstraint>
464 
        </Association>
465 
        <EntityType Name="MARKUP_CHECKLIST">
466 
          <Key>
467 
            <PropertyRef Name="CK_NO" />
468 
          </Key>
469 
          <Property Name="CK_NO" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
470 
          <Property Name="CK_REV_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
471 
          <Property Name="CK_PAGE" Type="Int32" />
472 
          <Property Name="CK_COMMENT" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
473 
          <Property Name="CK_TODO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
474 
          <Property Name="CK_STATUS" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
475 
          <Property Name="CK_RESULT" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
476 
        </EntityType>
477 
        <EntityType Name="MEMBER">
478 
          <Key>
479 
            <PropertyRef Name="ID" />
480 
          </Key>
481 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
482 
          <Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
483 
          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
484 
          <Property Name="POSITION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
485 
          <Property Name="EMAIL_ADDRESS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
486 
          <NavigationProperty Name="SIGN_INFO" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="MEMBER" ToRole="SIGN_INFO" />
487 c8e9b3e4 ljiyeon 
          <Property Name="PASSWORD" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
488 787a4489 KangIngu 
          <Property Name="COMPANY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
489 c8e9b3e4 ljiyeon 
          <Property Name="CREATE_DATETIME" Type="DateTime" Precision="3" />
490 
          <Property Name="MODIFIED_DATETIME" Type="DateTime" Precision="3" />
491 
          <Property Name="ISLICENSE" Type="Int32" />
492 787a4489 KangIngu 
        </EntityType>
493 
        <EntityType Name="SIGN_INFO">
494 
          <Key>
495 
            <PropertyRef Name="ID" />
496 
          </Key>
497 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
498 
          <Property Name="SIGN_STR" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
499 
          <Property Name="MEMBER_USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
500 
          <Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" />
501 
          <Property Name="MODIFY_DATE" Type="DateTime" Precision="3" />
502 
          <NavigationProperty Name="MEMBER" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="SIGN_INFO" ToRole="MEMBER" />
503 
        </EntityType>
504 
        <Association Name="FK_SIGNINFO_MEMBER">
505 
          <End Type="CIModel.MEMBER" Role="MEMBER" Multiplicity="1" />
506 
          <End Type="CIModel.SIGN_INFO" Role="SIGN_INFO" Multiplicity="*" />
507 
          <ReferentialConstraint>
508 
            <Principal Role="MEMBER">
509 
              <PropertyRef Name="ID" />
510 
            </Principal>
511 
            <Dependent Role="SIGN_INFO">
512 
              <PropertyRef Name="MEMBER_USER_ID" />
513 
            </Dependent>
514 
          </ReferentialConstraint>
515 
        </Association>
516 
        <EntityType Name="TALK">
517 
          <Key>
518 
            <PropertyRef Name="ID" />
519 
          </Key>
520 
          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
521 
          <Property Name="TEXT" Type="String" Nullable="false" MaxLength="300" FixedLength="true" Unicode="true" />
522 
          <Property Name="TIMESTAMP" Type="DateTime" Nullable="false" Precision="3" />
523 
          <Property Name="MSGTYPE" Type="Byte" Nullable="false" />
524 
          <Property Name="MSGSIDE" Type="Byte" Nullable="false" />
525 
          <Property Name="RECT_X" Type="Double" />
526 
          <Property Name="RECT_Y" Type="Double" />
527 
          <Property Name="RECT_WIDTH" Type="Double" />
528 
          <Property Name="RECT_HEIGHT" Type="Double" />
529 
          <Property Name="PAGENUMBER" Type="Int32" />
530 
          <Property Name="MEMBER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
531 
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
532 
          <Property Name="MEMBER_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
533 d974f3f8 ljiyeon 
          <Property Name="ANGLE" Type="Int32" Nullable="false" />
534 787a4489 KangIngu 
        </EntityType>
535 
        <EntityType Name="CHECK_LIST">
536 
          <Key>
537 
            <PropertyRef Name="ID" />
538 
          </Key>
539 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
540 
          <Property Name="DOCUMENT_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
541 
          <Property Name="USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
542 
          <Property Name="REVISION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
543 
          <Property Name="PAGENUMBER" Type="Int32" Nullable="false" />
544 
          <Property Name="TODOLIST" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
545 
          <Property Name="IMAGE_URL" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
546 
          <Property Name="STATUS" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
547 
          <Property Name="VENDOR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
548 
          <Property Name="REMARK" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
549 
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
550 
          <Property Name="REV_4" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
551 
          <Property Name="REV_3" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
552 
          <Property Name="REV_2" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
553 
          <Property Name="REV_1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
554 
          <Property Name="REV_0" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
555 
          <Property Name="IMAGE_ANCHOR" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
556 
          <Property Name="CREATE_TIME" Type="DateTime" Precision="3" />
557 
          <Property Name="UPDATE_TIME" Type="DateTime" Precision="3" />
558 
          <Property Name="STATUS_DESC_OPEN" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
559 
          <Property Name="STATUS_DESC_CLOSE" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
560 
          <Property Name="REPLY" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
561 
          <Property Name="DOCUMENT_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
562 
        </EntityType>
563 
        <EntityType Name="CHECK_LIST_HISTORY">
564 
          <Key>
565 
            <PropertyRef Name="ID" />
566 
          </Key>
567 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
568 
          <Property Name="CHECKLIST_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
569 
          <Property Name="REVISION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
570 
          <Property Name="STATUS" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
571 
          <Property Name="STATUS_DESC" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
572 
          <Property Name="TODOLIST" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
573 
          <Property Name="VENDOR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
574 
          <Property Name="REMARK" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
575 
          <Property Name="REPLY" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
576 
          <Property Name="IMAGE_URL" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
577 
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
578 
          <Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
579 
        </EntityType>
580 f9d986d9 ljiyeon 
        <EntityType Name="MEMBER_DEPT_COLOR">
581 
          <Key>
582 
            <PropertyRef Name="COLORID" />
583 
          </Key>
584 
          <Property Name="COLORID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
585 
          <Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
586 
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
587 
          <NavigationProperty Name="MEMBER_DEPT_COLORINFO" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLOR" ToRole="MEMBER_DEPT_COLORINFO" />
588 
        </EntityType>
589 
        <EntityType Name="MEMBER_DEPT_COLORINFO">
590 
          <Key>
591 
            <PropertyRef Name="CVALUEID" />
592 
            <PropertyRef Name="DISPLAYCOLOR" />
593 
            <PropertyRef Name="COLORID" />
594 
          </Key>
595 
          <Property Name="CVALUEID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
596 
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
597 
          <Property Name="COLORID" Type="Int32" Nullable="false" />
598 
          <NavigationProperty Name="MEMBER_DEPT_COLOR" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLORINFO" ToRole="MEMBER_DEPT_COLOR" />
599 
        </EntityType>
600 
        <Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
601 
          <End Type="CIModel.MEMBER_DEPT_COLOR" Role="MEMBER_DEPT_COLOR" Multiplicity="1" />
602 
          <End Type="CIModel.MEMBER_DEPT_COLORINFO" Role="MEMBER_DEPT_COLORINFO" Multiplicity="*" />
603 
          <ReferentialConstraint>
604 
            <Principal Role="MEMBER_DEPT_COLOR">
605 
              <PropertyRef Name="COLORID" />
606 
            </Principal>
607 
            <Dependent Role="MEMBER_DEPT_COLORINFO">
608 
              <PropertyRef Name="COLORID" />
609 
            </Dependent>
610 
          </ReferentialConstraint>
611 
        </Association>
612 787a4489 KangIngu 
        </Schema>
613 
    </edmx:ConceptualModels>
614 
    <!-- C-S mapping content -->
615 
    <edmx:Mappings>
616 
    <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
617 
  <EntityContainerMapping StorageEntityContainer="CIModelStoreContainer" CdmEntityContainer="CIEntities">
618 
    <EntitySetMapping Name="DOCUMENT_ITEM">
619 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCUMENT_ITEM)">
620 
        <MappingFragment StoreEntitySet="DOCUMENT_ITEM">
621 f9d986d9 ljiyeon 
          <ScalarProperty Name="ENSEMBLEINFO_URL" ColumnName="ENSEMBLEINFO_URL" />
622 
                <ScalarProperty Name="ID" ColumnName="ID" />
623 787a4489 KangIngu 
          <ScalarProperty Name="REVISION" ColumnName="REVISION" />
624 
          <ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" />
625 
          <ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" />
626 
          <ScalarProperty Name="GROUP_NO" ColumnName="GROUP_NO" />
627 
          <ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" />
628 
          <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
629 
          <ScalarProperty Name="RESULT_FILE" ColumnName="RESULT_FILE" />
630 
          <ScalarProperty Name="RESULT" ColumnName="RESULT" />
631 
          <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
632 
        </MappingFragment>
633 
      </EntityTypeMapping>
634 
    </EntitySetMapping>
635 
    <EntitySetMapping Name="DOCINFO">
636 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCINFO)">
637 
        <MappingFragment StoreEntitySet="DOCINFO">
638 
          <ScalarProperty Name="ID" ColumnName="ID" />
639 
          <ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" />
640 
          <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
641 
          <ScalarProperty Name="PAGE_COUNT" ColumnName="PAGE_COUNT" />
642 
          <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
643 
        </MappingFragment>
644 
      </EntityTypeMapping>
645 
    </EntitySetMapping>
646 
    <EntitySetMapping Name="DOCPAGE">
647 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCPAGE)">
648 
        <MappingFragment StoreEntitySet="DOCPAGE">
649 
          <ScalarProperty Name="ID" ColumnName="ID" />
650 
          <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
651 
          <ScalarProperty Name="PAGE_NUMBER" ColumnName="PAGE_NUMBER" />
652 
          <ScalarProperty Name="PAGE_WIDTH" ColumnName="PAGE_WIDTH" />
653 
          <ScalarProperty Name="PAGE_HEIGHT" ColumnName="PAGE_HEIGHT" />
654 
          <ScalarProperty Name="PAGE_ANGLE" ColumnName="PAGE_ANGLE" />
655 
        </MappingFragment>
656 
      </EntityTypeMapping>
657 
    </EntitySetMapping>
658 
    <EntitySetMapping Name="MARKUP_DATA">
659 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)">
660 
        <MappingFragment StoreEntitySet="MARKUP_DATA">
661 f9d986d9 ljiyeon 
          <ScalarProperty Name="GROUP_ID" ColumnName="GROUP_ID" />
662 
                <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
663 c8e9b3e4 ljiyeon 
                <ScalarProperty Name="ID" ColumnName="ID" />
664 787a4489 KangIngu 
          <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
665 
          <ScalarProperty Name="DATA" ColumnName="DATA" />
666 
          <ScalarProperty Name="MARKUPINFO_VERSION_ID" ColumnName="MARKUPINFO_VERSION_ID" />
667 
          <ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" />
668 
        </MappingFragment>
669 
      </EntityTypeMapping>
670 
    </EntitySetMapping>
671 
    <EntitySetMapping Name="MARKUP_INFO">
672 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO)">
673 
        <MappingFragment StoreEntitySet="MARKUP_INFO">
674 
          <ScalarProperty Name="ID" ColumnName="ID" />
675 
          <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
676 
          <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
677 
          <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
678 
          <ScalarProperty Name="CONSOLIDATE" ColumnName="CONSOLIDATE" />
679 
          <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
680 
          <ScalarProperty Name="AVOID_CONSOLIDATE" ColumnName="AVOID_CONSOLIDATE" />
681 
          <ScalarProperty Name="PART_CONSOLIDATE" ColumnName="PART_CONSOLIDATE" />
682 
          <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
683 
        </MappingFragment>
684 
      </EntityTypeMapping>
685 
    </EntitySetMapping>
686 
    <EntitySetMapping Name="MARKUP_INFO_VERSION">
687 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO_VERSION)">
688 
        <MappingFragment StoreEntitySet="MARKUP_INFO_VERSION">
689 
          <ScalarProperty Name="ID" ColumnName="ID" />
690 
          <ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" />
691 
          <ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" />
692 
        </MappingFragment>
693 
      </EntityTypeMapping>
694 
    </EntitySetMapping>
695 
    <EntitySetMapping Name="MARKUP_CHECKLIST">
696 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_CHECKLIST)">
697 
        <MappingFragment StoreEntitySet="MARKUP_CHECKLIST">
698 
          <ScalarProperty Name="CK_NO" ColumnName="CK_NO" />
699 
          <ScalarProperty Name="CK_REV_NO" ColumnName="CK_REV_NO" />
700 
          <ScalarProperty Name="CK_PAGE" ColumnName="CK_PAGE" />
701 
          <ScalarProperty Name="CK_COMMENT" ColumnName="CK_COMMENT" />
702 
          <ScalarProperty Name="CK_TODO" ColumnName="CK_TODO" />
703 
          <ScalarProperty Name="CK_STATUS" ColumnName="CK_STATUS" />
704 
          <ScalarProperty Name="CK_RESULT" ColumnName="CK_RESULT" />
705 
        </MappingFragment>
706 
      </EntityTypeMapping>
707 
    </EntitySetMapping>
708 
          <EntitySetMapping Name="MEMBER">
709 
            <EntityTypeMapping TypeName="CIModel.MEMBER">
710 
              <MappingFragment StoreEntitySet="MEMBER">
711 c8e9b3e4 ljiyeon 
                <ScalarProperty Name="ISLICENSE" ColumnName="ISLICENSE" />
712 
                <ScalarProperty Name="MODIFIED_DATETIME" ColumnName="MODIFIED_DATETIME" />
713 
                <ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" />
714 787a4489 KangIngu 
                <ScalarProperty Name="COMPANY" ColumnName="COMPANY" />
715 
                <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" />
716 
                <ScalarProperty Name="EMAIL_ADDRESS" ColumnName="EMAIL_ADDRESS" />
717 
                <ScalarProperty Name="POSITION" ColumnName="POSITION" />
718 
                <ScalarProperty Name="NAME" ColumnName="NAME" />
719 
                <ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" />
720 
                <ScalarProperty Name="ID" ColumnName="ID" />
721 
              </MappingFragment>
722 
            </EntityTypeMapping>
723 
          </EntitySetMapping>
724 
          <EntitySetMapping Name="SIGN_INFO">
725 
            <EntityTypeMapping TypeName="CIModel.SIGN_INFO">
726 
              <MappingFragment StoreEntitySet="SIGN_INFO">
727 
                <ScalarProperty Name="MODIFY_DATE" ColumnName="MODIFY_DATE" />
728 
                <ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" />
729 
                <ScalarProperty Name="MEMBER_USER_ID" ColumnName="MEMBER_USER_ID" />
730 
                <ScalarProperty Name="SIGN_STR" ColumnName="SIGN_STR" />
731 
                <ScalarProperty Name="ID" ColumnName="ID" />
732 
              </MappingFragment>
733 
            </EntityTypeMapping>
734 
          </EntitySetMapping>
735 
          <EntitySetMapping Name="TALK">
736 
            <EntityTypeMapping TypeName="CIModel.TALK">
737 
              <MappingFragment StoreEntitySet="TALK">
738 d974f3f8 ljiyeon 
                <ScalarProperty Name="ANGLE" ColumnName="ANGLE" />
739 787a4489 KangIngu 
                <ScalarProperty Name="MEMBER_NAME" ColumnName="MEMBER_NAME" />
740 
                <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
741 
                <ScalarProperty Name="MEMBER_ID" ColumnName="MEMBER_ID" />
742 
                <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
743 
                <ScalarProperty Name="RECT_HEIGHT" ColumnName="RECT_HEIGHT" />
744 
                <ScalarProperty Name="RECT_WIDTH" ColumnName="RECT_WIDTH" />
745 
                <ScalarProperty Name="RECT_Y" ColumnName="RECT_Y" />
746 
                <ScalarProperty Name="RECT_X" ColumnName="RECT_X" />
747 
                <ScalarProperty Name="MSGSIDE" ColumnName="MSGSIDE" />
748 
                <ScalarProperty Name="MSGTYPE" ColumnName="MSGTYPE" />
749 
                <ScalarProperty Name="TIMESTAMP" ColumnName="TIMESTAMP" />
750 
                <ScalarProperty Name="TEXT" ColumnName="TEXT" />
751 
                <ScalarProperty Name="ID" ColumnName="ID" />
752 
              </MappingFragment>
753 
            </EntityTypeMapping>
754 
          </EntitySetMapping>
755 
          <EntitySetMapping Name="CHECK_LIST">
756 
            <EntityTypeMapping TypeName="CIModel.CHECK_LIST">
757 
              <MappingFragment StoreEntitySet="CHECK_LIST">
758 
                <ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" />
759 
                <ScalarProperty Name="REPLY" ColumnName="REPLY" />
760 
                <ScalarProperty Name="STATUS_DESC_CLOSE" ColumnName="STATUS_DESC_CLOSE" />
761 
                <ScalarProperty Name="STATUS_DESC_OPEN" ColumnName="STATUS_DESC_OPEN" />
762 
                <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
763 
                <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
764 
                <ScalarProperty Name="IMAGE_ANCHOR" ColumnName="IMAGE_ANCHOR" />
765 
                <ScalarProperty Name="REV_0" ColumnName="REV_0" />
766 
                <ScalarProperty Name="REV_1" ColumnName="REV_1" />
767 
                <ScalarProperty Name="REV_2" ColumnName="REV_2" />
768 
                <ScalarProperty Name="REV_3" ColumnName="REV_3" />
769 
                <ScalarProperty Name="REV_4" ColumnName="REV_4" />
770 
                <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
771 
                <ScalarProperty Name="REMARK" ColumnName="REMARK" />
772 
                <ScalarProperty Name="VENDOR" ColumnName="VENDOR" />
773 
                <ScalarProperty Name="STATUS" ColumnName="STATUS" />
774 
                <ScalarProperty Name="IMAGE_URL" ColumnName="IMAGE_URL" />
775 
                <ScalarProperty Name="TODOLIST" ColumnName="TODOLIST" />
776 
                <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
777 
                <ScalarProperty Name="REVISION" ColumnName="REVISION" />
778 
                <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
779 
                <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
780 
                <ScalarProperty Name="ID" ColumnName="ID" />
781 
              </MappingFragment>
782 
            </EntityTypeMapping>
783 
          </EntitySetMapping>
784 
          <EntitySetMapping Name="CHECK_LIST_HISTORY">
785 
            <EntityTypeMapping TypeName="CIModel.CHECK_LIST_HISTORY">
786 
              <MappingFragment StoreEntitySet="CHECK_LIST_HISTORY">
787 
                <ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" />
788 
                <ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" />
789 
                <ScalarProperty Name="IMAGE_URL" ColumnName="IMAGE_URL" />
790 
                <ScalarProperty Name="REPLY" ColumnName="REPLY" />
791 
                <ScalarProperty Name="REMARK" ColumnName="REMARK" />
792 
                <ScalarProperty Name="VENDOR" ColumnName="VENDOR" />
793 
                <ScalarProperty Name="TODOLIST" ColumnName="TODOLIST" />
794 
                <ScalarProperty Name="STATUS_DESC" ColumnName="STATUS_DESC" />
795 
                <ScalarProperty Name="STATUS" ColumnName="STATUS" />
796 
                <ScalarProperty Name="REVISION" ColumnName="REVISION" />
797 
                <ScalarProperty Name="CHECKLIST_ID" ColumnName="CHECKLIST_ID" />
798 
                <ScalarProperty Name="ID" ColumnName="ID" />
799 
              </MappingFragment>
800 
            </EntityTypeMapping>
801 
          </EntitySetMapping>
802 f9d986d9 ljiyeon 
          <EntitySetMapping Name="MEMBER_DEPT_COLOR">
803 
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLOR">
804 
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLOR">
805 
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
806 
                <ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" />
807 
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
808 
              </MappingFragment>
809 
            </EntityTypeMapping>
810 
          </EntitySetMapping>
811 
          <EntitySetMapping Name="MEMBER_DEPT_COLORINFO">
812 
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLORINFO">
813 
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLORINFO">
814 
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
815 
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
816 
                <ScalarProperty Name="CVALUEID" ColumnName="CVALUEID" />
817 
              </MappingFragment>
818 
            </EntityTypeMapping>
819 
          </EntitySetMapping>
820 787a4489 KangIngu 
          </EntityContainerMapping>
821 
</Mapping></edmx:Mappings>
822 
  </edmx:Runtime>
823 
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
824 
  <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
825 
    <Connection>
826 
      <DesignerInfoPropertySet>
827 
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
828 
      </DesignerInfoPropertySet>
829 
    </Connection>
830 
    <Options>
831 
      <DesignerInfoPropertySet>
832 
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
833 
        <DesignerProperty Name="EnablePluralization" Value="false" />
834 
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
835 
        <DesignerProperty Name="UseLegacyProvider" Value="True" />
836 
        <DesignerProperty Name="CodeGenerationStrategy" Value="기본값" />
837 
      </DesignerInfoPropertySet>
838 
    </Options>
839 
    <!-- Diagram content (shape and connector positions) -->
840 
    <Diagrams>
841 c8e9b3e4 ljiyeon 
      <Diagram DiagramId="56537d79007d413b99bb660a37dd2a9f" Name="Diagram1" ZoomLevel="81">
842 787a4489 KangIngu 
        <EntityTypeShape EntityType="CIModel.DOCUMENT_ITEM" Width="1.5" PointX="5.375" PointY="7.75" />
843 
        <EntityTypeShape EntityType="CIModel.DOCINFO" Width="1.5" PointX="7.375" PointY="10.125" />
844 
        <EntityTypeShape EntityType="CIModel.DOCPAGE" Width="1.5" PointX="9.625" PointY="8.125" />
845 
        <EntityTypeShape EntityType="CIModel.MARKUP_DATA" Width="1.5" PointX="14.125" PointY="11.75" />
846 
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO" Width="1.5" PointX="9.625" PointY="11.25" />
847 
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO_VERSION" Width="1.5" PointX="11.875" PointY="11.875" />
848 
        <AssociationConnector Association="CIModel.FK_DOCINFODOFPAGE" />
849 
        <AssociationConnector Association="CIModel.FK_DOCINFOMARKUPINFO" />
850 
        <AssociationConnector Association="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" />
851 
        <AssociationConnector Association="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" />
852 
        <EntityTypeShape EntityType="CIModel.MARKUP_CHECKLIST" Width="1.5" PointX="0.75" PointY="0.75" />
853 
        <EntityTypeShape EntityType="CIModel.MEMBER" Width="1.5" PointX="0.75" PointY="14.125" />
854 
        <EntityTypeShape EntityType="CIModel.SIGN_INFO" Width="1.5" PointX="3" PointY="12.125" />
855 
        <AssociationConnector Association="CIModel.FK_SIGNINFO_MEMBER" />
856 
        <EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" />
857 
        <EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" />
858 
        <EntityTypeShape EntityType="CIModel.CHECK_LIST_HISTORY" Width="1.5" PointX="5.375" PointY="0.75" />
859 f9d986d9 ljiyeon 
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLOR" Width="1.5" PointX="7.375" PointY="0.875" />
860 
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLORINFO" Width="1.5" PointX="9.625" PointY="0.875" />
861 
        <AssociationConnector Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" />
862 787a4489 KangIngu 
        </Diagram>
863 
    </Diagrams>
864 
  </Designer>
865 
</edmx:Edmx>
클립보드 이미지 추가 (최대 크기: 500 MB)