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