개정판 74abcf6f
sign manager 추가
Change-Id: Ia511ce9bf05e3a238353a549118d3b29ab673aa0
| KCOMDataModel/DataModel/CIModel.edmx | ||
|---|---|---|
| 85 | 85 |
<Property Name="RESULT_FILE" Type="nvarchar" MaxLength="500" /> |
| 86 | 86 |
<Property Name="RESULT" Type="nvarchar" MaxLength="50" /> |
| 87 | 87 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
| 88 |
<Property Name="ENSEMBLEINFO_URL" Type="nvarchar" MaxLength="500" /> |
|
| 88 |
<Property Name="Link" Type="nvarchar" MaxLength="500" /> |
|
| 89 |
<Property Name="CreateDate" Type="datetime" /> |
|
| 89 | 90 |
</EntityType> |
| 90 | 91 |
<EntityType Name="MARKUP_CHECKLIST"> |
| 91 | 92 |
<Key> |
| ... | ... | |
| 99 | 100 |
<Property Name="CK_STATUS" Type="nvarchar" MaxLength="10" /> |
| 100 | 101 |
<Property Name="CK_RESULT" Type="nvarchar" MaxLength="10" /> |
| 101 | 102 |
</EntityType> |
| 103 |
<!--생성 중 오류 발생: |
|
| 104 |
경고 6002: 테이블/뷰 'markus.dbo.MARKUP_DATA'에 기본 키가 정의되지 않았습니다. 키가 유추되었고 읽기 전용 테이블/뷰로 정의되었습니다.--> |
|
| 102 | 105 |
<EntityType Name="MARKUP_DATA"> |
| 103 | 106 |
<Key> |
| 104 | 107 |
<PropertyRef Name="ID" /> |
| 108 |
|
|
| 109 |
|
|
| 110 |
|
|
| 111 |
|
|
| 105 | 112 |
</Key> |
| 106 | 113 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 107 | 114 |
<Property Name="PAGENUMBER" Type="int" Nullable="false" /> |
| ... | ... | |
| 109 | 116 |
<Property Name="MARKUPINFO_VERSION_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 110 | 117 |
<Property Name="DATA_TYPE" Type="int" Nullable="false" /> |
| 111 | 118 |
<Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" /> |
| 119 |
<Property Name="REMARK" Type="varchar" MaxLength="40" /> |
|
| 120 |
<Property Name="InsertTime" Type="datetime" /> |
|
| 112 | 121 |
</EntityType> |
| 113 | 122 |
<EntityType Name="MARKUP_INFO"> |
| 114 | 123 |
<Key> |
| ... | ... | |
| 141 | 150 |
<Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 142 | 151 |
<Property Name="POSITION" Type="nvarchar" MaxLength="50" /> |
| 143 | 152 |
<Property Name="EMAIL_ADDRESS" Type="nvarchar" MaxLength="50" /> |
| 144 |
<Property Name="PASSWORD" Type="nvarchar" MaxLength="64" />
|
|
| 153 |
<Property Name="PASSWORD" Type="nvarchar" MaxLength="100" />
|
|
| 145 | 154 |
<Property Name="COMPANY" Type="nvarchar" MaxLength="50" /> |
| 146 | 155 |
<Property Name="CREATE_DATETIME" Type="datetime" /> |
| 147 | 156 |
<Property Name="MODIFIED_DATETIME" Type="datetime" /> |
| 148 | 157 |
<Property Name="ISLICENSE" Type="int" /> |
| 149 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="50" /> |
|
| 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 | 158 |
</EntityType> |
| 169 | 159 |
<EntityType Name="SIGN_INFO"> |
| 170 | 160 |
<Key> |
| ... | ... | |
| 175 | 165 |
<Property Name="MEMBER_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 176 | 166 |
<Property Name="CREATE_DATE" Type="datetime" Nullable="false" /> |
| 177 | 167 |
<Property Name="MODIFY_DATE" Type="datetime" /> |
| 168 |
<Property Name="SIGN_STROKES" Type="varchar(max)" /> |
|
| 178 | 169 |
</EntityType> |
| 179 | 170 |
<EntityType Name="TALK"> |
| 180 | 171 |
<Key> |
| ... | ... | |
| 195 | 186 |
<Property Name="MEMBER_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 196 | 187 |
<Property Name="ANGLE" Type="int" Nullable="false" /> |
| 197 | 188 |
</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 | 189 |
<EntityContainer Name="CIModelStoreContainer"> |
| 259 | 190 |
<EntitySet Name="CHECK_LIST" EntityType="Self.CHECK_LIST" Schema="dbo" store:Type="Tables" /> |
| 260 | 191 |
<EntitySet Name="CHECK_LIST_HISTORY" EntityType="Self.CHECK_LIST_HISTORY" Schema="dbo" store:Type="Tables" /> |
| ... | ... | |
| 262 | 193 |
<EntitySet Name="DOCPAGE" EntityType="Self.DOCPAGE" Schema="dbo" store:Type="Tables" /> |
| 263 | 194 |
<EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" Schema="dbo" store:Type="Tables" /> |
| 264 | 195 |
<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 | 196 |
<EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" /> |
| 267 | 197 |
<EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" /> |
| 268 | 198 |
<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 | 199 |
<EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" /> |
| 272 | 200 |
<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> |
|
| 201 |
<EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" store:Type="Tables" store:Schema="dbo"> |
|
| 202 |
<DefiningQuery>SELECT |
|
| 203 |
[MARKUP_DATA].[ID] AS [ID], |
|
| 204 |
[MARKUP_DATA].[PAGENUMBER] AS [PAGENUMBER], |
|
| 205 |
[MARKUP_DATA].[DATA] AS [DATA], |
|
| 206 |
[MARKUP_DATA].[MARKUPINFO_VERSION_ID] AS [MARKUPINFO_VERSION_ID], |
|
| 207 |
[MARKUP_DATA].[DATA_TYPE] AS [DATA_TYPE], |
|
| 208 |
[MARKUP_DATA].[SYMBOL_ID] AS [SYMBOL_ID], |
|
| 209 |
[MARKUP_DATA].[REMARK] AS [REMARK], |
|
| 210 |
[MARKUP_DATA].[InsertTime] AS [InsertTime] |
|
| 211 |
FROM [dbo].[MARKUP_DATA] AS [MARKUP_DATA]</DefiningQuery> |
|
| 212 |
</EntitySet> |
|
| 293 | 213 |
</EntityContainer> |
| 294 | 214 |
</Schema></edmx:StorageModels> |
| 295 | 215 |
<!-- CSDL content --> |
| ... | ... | |
| 328 | 248 |
<EntitySet Name="TALK" EntityType="CIModel.TALK" /> |
| 329 | 249 |
<EntitySet Name="CHECK_LIST" EntityType="CIModel.CHECK_LIST" /> |
| 330 | 250 |
<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 | 251 |
</EntityContainer> |
| 338 | 252 |
<EntityType Name="DOCUMENT_ITEM"> |
| 339 | 253 |
<Key> |
| ... | ... | |
| 349 | 263 |
<Property Name="RESULT_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
| 350 | 264 |
<Property Name="RESULT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
| 351 | 265 |
<Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" /> |
| 266 |
<Property Name="Link" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
|
| 267 |
<Property Name="CreateDate" Type="DateTime" Precision="3" /> |
|
| 352 | 268 |
</EntityType> |
| 353 | 269 |
<EntityType Name="DOCINFO"> |
| 354 | 270 |
<Key> |
| ... | ... | |
| 385 | 301 |
<Property Name="DATA_TYPE" Type="Int32" Nullable="false" /> |
| 386 | 302 |
<NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" /> |
| 387 | 303 |
<Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
| 304 |
<Property Name="REMARK" Type="String" MaxLength="40" FixedLength="false" Unicode="false" /> |
|
| 305 |
<Property Name="InsertTime" Type="DateTime" Precision="3" /> |
|
| 388 | 306 |
</EntityType> |
| 389 | 307 |
<EntityType Name="MARKUP_INFO"> |
| 390 | 308 |
<Key> |
| ... | ... | |
| 482 | 400 |
<Property Name="POSITION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
| 483 | 401 |
<Property Name="EMAIL_ADDRESS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
| 484 | 402 |
<NavigationProperty Name="SIGN_INFO" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="MEMBER" ToRole="SIGN_INFO" /> |
| 485 |
<Property Name="PASSWORD" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
|
|
| 403 |
<Property Name="PASSWORD" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
| 486 | 404 |
<Property Name="COMPANY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
| 487 | 405 |
<Property Name="CREATE_DATETIME" Type="DateTime" Precision="3" /> |
| 488 | 406 |
<Property Name="MODIFIED_DATETIME" Type="DateTime" Precision="3" /> |
| 489 | 407 |
<Property Name="ISLICENSE" Type="Int32" /> |
| 490 |
<Property Name="PROJECT_NO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
| 491 | 408 |
</EntityType> |
| 492 | 409 |
<EntityType Name="SIGN_INFO"> |
| 493 | 410 |
<Key> |
| ... | ... | |
| 499 | 416 |
<Property Name="CREATE_DATE" Type="DateTime" Nullable="false" Precision="3" /> |
| 500 | 417 |
<Property Name="MODIFY_DATE" Type="DateTime" Precision="3" /> |
| 501 | 418 |
<NavigationProperty Name="MEMBER" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="SIGN_INFO" ToRole="MEMBER" /> |
| 419 |
<Property Name="SIGN_STROKES" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" /> |
|
| 502 | 420 |
</EntityType> |
| 503 | 421 |
<Association Name="FK_SIGNINFO_MEMBER"> |
| 504 | 422 |
<End Type="CIModel.MEMBER" Role="MEMBER" Multiplicity="1" /> |
| ... | ... | |
| 576 | 494 |
<Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
| 577 | 495 |
<Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
| 578 | 496 |
</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 | 497 |
</Schema> |
| 612 | 498 |
</edmx:ConceptualModels> |
| 613 | 499 |
<!-- C-S mapping content --> |
| ... | ... | |
| 617 | 503 |
<EntitySetMapping Name="DOCUMENT_ITEM"> |
| 618 | 504 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCUMENT_ITEM)"> |
| 619 | 505 |
<MappingFragment StoreEntitySet="DOCUMENT_ITEM"> |
| 506 |
<ScalarProperty Name="CreateDate" ColumnName="CreateDate" /> |
|
| 507 |
<ScalarProperty Name="Link" ColumnName="Link" /> |
|
| 620 | 508 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
| 621 | 509 |
<ScalarProperty Name="REVISION" ColumnName="REVISION" /> |
| 622 | 510 |
<ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" /> |
| ... | ... | |
| 656 | 544 |
<EntitySetMapping Name="MARKUP_DATA"> |
| 657 | 545 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)"> |
| 658 | 546 |
<MappingFragment StoreEntitySet="MARKUP_DATA"> |
| 547 |
<ScalarProperty Name="InsertTime" ColumnName="InsertTime" /> |
|
| 548 |
<ScalarProperty Name="REMARK" ColumnName="REMARK" /> |
|
| 659 | 549 |
<ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" /> |
| 660 | 550 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
| 661 | 551 |
<ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" /> |
| ... | ... | |
| 705 | 595 |
<EntitySetMapping Name="MEMBER"> |
| 706 | 596 |
<EntityTypeMapping TypeName="CIModel.MEMBER"> |
| 707 | 597 |
<MappingFragment StoreEntitySet="MEMBER"> |
| 708 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
|
| 709 | 598 |
<ScalarProperty Name="ISLICENSE" ColumnName="ISLICENSE" /> |
| 710 | 599 |
<ScalarProperty Name="MODIFIED_DATETIME" ColumnName="MODIFIED_DATETIME" /> |
| 711 | 600 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
| ... | ... | |
| 720 | 609 |
</EntityTypeMapping> |
| 721 | 610 |
</EntitySetMapping> |
| 722 | 611 |
<EntitySetMapping Name="SIGN_INFO"> |
| 723 |
<EntityTypeMapping TypeName="CIModel.SIGN_INFO">
|
|
| 612 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.SIGN_INFO)">
|
|
| 724 | 613 |
<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" /> |
|
| 614 |
<ScalarProperty Name="SIGN_STROKES" ColumnName="SIGN_STROKES" /> |
|
| 729 | 615 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
| 616 |
<ScalarProperty Name="SIGN_STR" ColumnName="SIGN_STR" /> |
|
| 617 |
<ScalarProperty Name="MEMBER_USER_ID" ColumnName="MEMBER_USER_ID" /> |
|
| 618 |
<ScalarProperty Name="CREATE_DATE" ColumnName="CREATE_DATE" /> |
|
| 619 |
<ScalarProperty Name="MODIFY_DATE" ColumnName="MODIFY_DATE" /> |
|
| 730 | 620 |
</MappingFragment> |
| 731 | 621 |
</EntityTypeMapping> |
| 732 | 622 |
</EntitySetMapping> |
| ... | ... | |
| 797 | 687 |
</MappingFragment> |
| 798 | 688 |
</EntityTypeMapping> |
| 799 | 689 |
</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 | 690 |
</EntityContainerMapping> |
| 819 | 691 |
</Mapping></edmx:Mappings> |
| 820 | 692 |
</edmx:Runtime> |
| ... | ... | |
| 854 | 726 |
<EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" /> |
| 855 | 727 |
<EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" /> |
| 856 | 728 |
<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 | 729 |
</Diagram> |
| 861 | 730 |
</Diagrams> |
| 862 | 731 |
</Designer> |
내보내기 Unified diff
