markus / KCOMDataModel / DataModel / CIModel.edmx @ c0977e97
이력 | 보기 | 이력해설 | 다운로드 (53.4 KB)
1 |
<?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 |
<Property Name="ENSEMBLEINFO_URL" Type="nvarchar" MaxLength="500" /> |
89 |
</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 |
<Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" /> |
112 |
<Property Name="GROUP_ID" Type="bigint" /> |
113 |
</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 |
<Property Name="PASSWORD" Type="nvarchar" MaxLength="64" /> |
146 |
<Property Name="COMPANY" Type="nvarchar" MaxLength="50" /> |
147 |
<Property Name="CREATE_DATETIME" Type="datetime" /> |
148 |
<Property Name="MODIFIED_DATETIME" Type="datetime" /> |
149 |
<Property Name="ISLICENSE" Type="int" /> |
150 |
</EntityType> |
151 |
<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 |
<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 |
<Property Name="ANGLE" Type="int" Nullable="false" /> |
197 |
</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 |
<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 |
<ReferentialConstraint> |
250 |
<Principal Role="MEMBER_DEPT_COLOR"> |
251 |
<PropertyRef Name="COLORID" /> |
252 |
</Principal> |
253 |
<Dependent Role="MEMBER_DEPT_COLORINFO"> |
254 |
<PropertyRef Name="COLORID" /> |
255 |
</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 |
<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 |
<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 |
<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 |
</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 |
<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 |
</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 |
<Property Name="ENSEMBLEINFO_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
353 |
</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 |
<Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
389 |
</EntityType> |
390 |
<EntityType Name="MARKUP_INFO"> |
391 |
<Key> |
392 |
<PropertyRef Name="ID" /> |
393 |
</Key> |
394 |
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
395 |
<Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
396 |
<Property Name="USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
397 |
<Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
398 |
<Property Name="CONSOLIDATE" Type="Int32" Nullable="false" /> |
399 |
<Property Name="DESCRIPTION" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
400 |
<Property Name="AVOID_CONSOLIDATE" Type="Int32" Nullable="false" /> |
401 |
<Property Name="PART_CONSOLIDATE" Type="Int32" Nullable="false" /> |
402 |
<Property Name="UPDATE_TIME" Type="DateTime" Precision="3" /> |
403 |
<NavigationProperty Name="DOCINFO" Relationship="CIModel.FK_DOCINFOMARKUPINFO" FromRole="MARKUP_INFO" ToRole="DOCINFO" /> |
404 |
<NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO" ToRole="MARKUP_INFO_VERSION" /> |
405 |
</EntityType> |
406 |
<EntityType Name="MARKUP_INFO_VERSION"> |
407 |
<Key> |
408 |
<PropertyRef Name="ID" /> |
409 |
</Key> |
410 |
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
411 |
<Property Name="MARKUPINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
412 |
<Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" /> |
413 |
<NavigationProperty Name="MARKUP_DATA" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_DATA" /> |
414 |
<NavigationProperty Name="MARKUP_INFO" Relationship="CIModel.FK_MARKUPINFOMARKUPINFO_VERSION" FromRole="MARKUP_INFO_VERSION" ToRole="MARKUP_INFO" /> |
415 |
</EntityType> |
416 |
<Association Name="FK_DOCINFODOFPAGE"> |
417 |
<End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" /> |
418 |
<End Type="CIModel.DOCPAGE" Role="DOCPAGE" Multiplicity="*" /> |
419 |
<ReferentialConstraint> |
420 |
<Principal Role="DOCINFO"> |
421 |
<PropertyRef Name="ID" /> |
422 |
</Principal> |
423 |
<Dependent Role="DOCPAGE"> |
424 |
<PropertyRef Name="DOCINFO_ID" /> |
425 |
</Dependent> |
426 |
</ReferentialConstraint> |
427 |
</Association> |
428 |
<Association Name="FK_DOCINFOMARKUPINFO"> |
429 |
<End Type="CIModel.DOCINFO" Role="DOCINFO" Multiplicity="1" /> |
430 |
<End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="*" /> |
431 |
<ReferentialConstraint> |
432 |
<Principal Role="DOCINFO"> |
433 |
<PropertyRef Name="ID" /> |
434 |
</Principal> |
435 |
<Dependent Role="MARKUP_INFO"> |
436 |
<PropertyRef Name="DOCINFO_ID" /> |
437 |
</Dependent> |
438 |
</ReferentialConstraint> |
439 |
</Association> |
440 |
<Association Name="FK_MARKUPINFO_VERSIONMARKUPDATA"> |
441 |
<End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="1" /> |
442 |
<End Type="CIModel.MARKUP_DATA" Role="MARKUP_DATA" Multiplicity="*" /> |
443 |
<ReferentialConstraint> |
444 |
<Principal Role="MARKUP_INFO_VERSION"> |
445 |
<PropertyRef Name="ID" /> |
446 |
</Principal> |
447 |
<Dependent Role="MARKUP_DATA"> |
448 |
<PropertyRef Name="MARKUPINFO_VERSION_ID" /> |
449 |
</Dependent> |
450 |
</ReferentialConstraint> |
451 |
</Association> |
452 |
<Association Name="FK_MARKUPINFOMARKUPINFO_VERSION"> |
453 |
<End Type="CIModel.MARKUP_INFO" Role="MARKUP_INFO" Multiplicity="1" /> |
454 |
<End Type="CIModel.MARKUP_INFO_VERSION" Role="MARKUP_INFO_VERSION" Multiplicity="*" /> |
455 |
<ReferentialConstraint> |
456 |
<Principal Role="MARKUP_INFO"> |
457 |
<PropertyRef Name="ID" /> |
458 |
</Principal> |
459 |
<Dependent Role="MARKUP_INFO_VERSION"> |
460 |
<PropertyRef Name="MARKUPINFO_ID" /> |
461 |
</Dependent> |
462 |
</ReferentialConstraint> |
463 |
</Association> |
464 |
<EntityType Name="MARKUP_CHECKLIST"> |
465 |
<Key> |
466 |
<PropertyRef Name="CK_NO" /> |
467 |
</Key> |
468 |
<Property Name="CK_NO" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
469 |
<Property Name="CK_REV_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
470 |
<Property Name="CK_PAGE" Type="Int32" /> |
471 |
<Property Name="CK_COMMENT" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> |
472 |
<Property Name="CK_TODO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> |
473 |
<Property Name="CK_STATUS" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
474 |
<Property Name="CK_RESULT" Type="String" MaxLength="10" FixedLength="false" Unicode="true" /> |
475 |
</EntityType> |
476 |
<EntityType Name="MEMBER"> |
477 |
<Key> |
478 |
<PropertyRef Name="ID" /> |
479 |
</Key> |
480 |
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
481 |
<Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
482 |
<Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
483 |
<Property Name="POSITION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
484 |
<Property Name="EMAIL_ADDRESS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
485 |
<NavigationProperty Name="SIGN_INFO" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="MEMBER" ToRole="SIGN_INFO" /> |
486 |
<Property Name="PASSWORD" Type="String" MaxLength="64" FixedLength="false" Unicode="true" /> |
487 |
<Property Name="COMPANY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
488 |
<Property Name="CREATE_DATETIME" Type="DateTime" Precision="3" /> |
489 |
<Property Name="MODIFIED_DATETIME" Type="DateTime" Precision="3" /> |
490 |
<Property Name="ISLICENSE" Type="Int32" /> |
491 |
</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 |
<Property Name="ANGLE" Type="Int32" Nullable="false" /> |
533 |
</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 |
<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 |
</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 |
<ScalarProperty Name="ENSEMBLEINFO_URL" ColumnName="ENSEMBLEINFO_URL" /> |
621 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
622 |
<ScalarProperty Name="REVISION" ColumnName="REVISION" /> |
623 |
<ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" /> |
624 |
<ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" /> |
625 |
<ScalarProperty Name="GROUP_NO" ColumnName="GROUP_NO" /> |
626 |
<ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" /> |
627 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
628 |
<ScalarProperty Name="RESULT_FILE" ColumnName="RESULT_FILE" /> |
629 |
<ScalarProperty Name="RESULT" ColumnName="RESULT" /> |
630 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
631 |
</MappingFragment> |
632 |
</EntityTypeMapping> |
633 |
</EntitySetMapping> |
634 |
<EntitySetMapping Name="DOCINFO"> |
635 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCINFO)"> |
636 |
<MappingFragment StoreEntitySet="DOCINFO"> |
637 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
638 |
<ScalarProperty Name="ORIGINAL_FILE" ColumnName="ORIGINAL_FILE" /> |
639 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
640 |
<ScalarProperty Name="PAGE_COUNT" ColumnName="PAGE_COUNT" /> |
641 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
642 |
</MappingFragment> |
643 |
</EntityTypeMapping> |
644 |
</EntitySetMapping> |
645 |
<EntitySetMapping Name="DOCPAGE"> |
646 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCPAGE)"> |
647 |
<MappingFragment StoreEntitySet="DOCPAGE"> |
648 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
649 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
650 |
<ScalarProperty Name="PAGE_NUMBER" ColumnName="PAGE_NUMBER" /> |
651 |
<ScalarProperty Name="PAGE_WIDTH" ColumnName="PAGE_WIDTH" /> |
652 |
<ScalarProperty Name="PAGE_HEIGHT" ColumnName="PAGE_HEIGHT" /> |
653 |
<ScalarProperty Name="PAGE_ANGLE" ColumnName="PAGE_ANGLE" /> |
654 |
</MappingFragment> |
655 |
</EntityTypeMapping> |
656 |
</EntitySetMapping> |
657 |
<EntitySetMapping Name="MARKUP_DATA"> |
658 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)"> |
659 |
<MappingFragment StoreEntitySet="MARKUP_DATA"> |
660 |
<ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" /> |
661 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
662 |
<ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" /> |
663 |
<ScalarProperty Name="DATA" ColumnName="DATA" /> |
664 |
<ScalarProperty Name="MARKUPINFO_VERSION_ID" ColumnName="MARKUPINFO_VERSION_ID" /> |
665 |
<ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" /> |
666 |
</MappingFragment> |
667 |
</EntityTypeMapping> |
668 |
</EntitySetMapping> |
669 |
<EntitySetMapping Name="MARKUP_INFO"> |
670 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO)"> |
671 |
<MappingFragment StoreEntitySet="MARKUP_INFO"> |
672 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
673 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
674 |
<ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> |
675 |
<ScalarProperty Name="CREATE_TIME" ColumnName="CREATE_TIME" /> |
676 |
<ScalarProperty Name="CONSOLIDATE" ColumnName="CONSOLIDATE" /> |
677 |
<ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> |
678 |
<ScalarProperty Name="AVOID_CONSOLIDATE" ColumnName="AVOID_CONSOLIDATE" /> |
679 |
<ScalarProperty Name="PART_CONSOLIDATE" ColumnName="PART_CONSOLIDATE" /> |
680 |
<ScalarProperty Name="UPDATE_TIME" ColumnName="UPDATE_TIME" /> |
681 |
</MappingFragment> |
682 |
</EntityTypeMapping> |
683 |
</EntitySetMapping> |
684 |
<EntitySetMapping Name="MARKUP_INFO_VERSION"> |
685 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_INFO_VERSION)"> |
686 |
<MappingFragment StoreEntitySet="MARKUP_INFO_VERSION"> |
687 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
688 |
<ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" /> |
689 |
<ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" /> |
690 |
</MappingFragment> |
691 |
</EntityTypeMapping> |
692 |
</EntitySetMapping> |
693 |
<EntitySetMapping Name="MARKUP_CHECKLIST"> |
694 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_CHECKLIST)"> |
695 |
<MappingFragment StoreEntitySet="MARKUP_CHECKLIST"> |
696 |
<ScalarProperty Name="CK_NO" ColumnName="CK_NO" /> |
697 |
<ScalarProperty Name="CK_REV_NO" ColumnName="CK_REV_NO" /> |
698 |
<ScalarProperty Name="CK_PAGE" ColumnName="CK_PAGE" /> |
699 |
<ScalarProperty Name="CK_COMMENT" ColumnName="CK_COMMENT" /> |
700 |
<ScalarProperty Name="CK_TODO" ColumnName="CK_TODO" /> |
701 |
<ScalarProperty Name="CK_STATUS" ColumnName="CK_STATUS" /> |
702 |
<ScalarProperty Name="CK_RESULT" ColumnName="CK_RESULT" /> |
703 |
</MappingFragment> |
704 |
</EntityTypeMapping> |
705 |
</EntitySetMapping> |
706 |
<EntitySetMapping Name="MEMBER"> |
707 |
<EntityTypeMapping TypeName="CIModel.MEMBER"> |
708 |
<MappingFragment StoreEntitySet="MEMBER"> |
709 |
<ScalarProperty Name="ISLICENSE" ColumnName="ISLICENSE" /> |
710 |
<ScalarProperty Name="MODIFIED_DATETIME" ColumnName="MODIFIED_DATETIME" /> |
711 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
712 |
<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 |
<ScalarProperty Name="ANGLE" ColumnName="ANGLE" /> |
737 |
<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 |
<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 |
</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 |
<Diagram DiagramId="56537d79007d413b99bb660a37dd2a9f" Name="Diagram1" ZoomLevel="81"> |
840 |
<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 |
<EntityTypeShape EntityType="CIModel.MARKUP_DATA" Width="2.25" PointX="14.125" PointY="11.75" /> |
844 |
<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 |
<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 |
</Diagram> |
861 |
</Diagrams> |
862 |
</Designer> |
863 |
</edmx:Edmx> |