개정판 c8e9b3e4
issue #757 Symbol 수량 집계 관리, markup_data table 열 추가
KCOMDataModel/DataModel/CIModel.edmx | ||
---|---|---|
107 | 107 |
<Property Name="DATA" Type="nvarchar(max)" Nullable="false" /> |
108 | 108 |
<Property Name="MARKUPINFO_VERSION_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
109 | 109 |
<Property Name="DATA_TYPE" Type="int" Nullable="false" /> |
110 |
<Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" /> |
|
110 | 111 |
</EntityType> |
111 | 112 |
<EntityType Name="MARKUP_INFO"> |
112 | 113 |
<Key> |
... | ... | |
139 | 140 |
<Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> |
140 | 141 |
<Property Name="POSITION" Type="nvarchar" MaxLength="50" /> |
141 | 142 |
<Property Name="EMAIL_ADDRESS" Type="nvarchar" MaxLength="50" /> |
142 |
<Property Name="PASSWORD" Type="nvarchar" MaxLength="50" />
|
|
143 |
<Property Name="PASSWORD" Type="nvarchar" MaxLength="64" />
|
|
143 | 144 |
<Property Name="COMPANY" Type="nvarchar" MaxLength="50" /> |
145 |
<Property Name="CREATE_DATETIME" Type="datetime" /> |
|
146 |
<Property Name="MODIFIED_DATETIME" Type="datetime" /> |
|
147 |
<Property Name="ISLICENSE" Type="int" /> |
|
144 | 148 |
</EntityType> |
145 | 149 |
<EntityType Name="SIGN_INFO"> |
146 | 150 |
<Key> |
... | ... | |
352 | 356 |
<Property Name="MARKUPINFO_VERSION_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
353 | 357 |
<Property Name="DATA_TYPE" Type="Int32" Nullable="false" /> |
354 | 358 |
<NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" /> |
359 |
<Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
355 | 360 |
</EntityType> |
356 | 361 |
<EntityType Name="MARKUP_INFO"> |
357 | 362 |
<Key> |
... | ... | |
449 | 454 |
<Property Name="POSITION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
450 | 455 |
<Property Name="EMAIL_ADDRESS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
451 | 456 |
<NavigationProperty Name="SIGN_INFO" Relationship="CIModel.FK_SIGNINFO_MEMBER" FromRole="MEMBER" ToRole="SIGN_INFO" /> |
452 |
<Property Name="PASSWORD" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
457 |
<Property Name="PASSWORD" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
|
|
453 | 458 |
<Property Name="COMPANY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
459 |
<Property Name="CREATE_DATETIME" Type="DateTime" Precision="3" /> |
|
460 |
<Property Name="MODIFIED_DATETIME" Type="DateTime" Precision="3" /> |
|
461 |
<Property Name="ISLICENSE" Type="Int32" /> |
|
454 | 462 |
</EntityType> |
455 | 463 |
<EntityType Name="SIGN_INFO"> |
456 | 464 |
<Key> |
... | ... | |
587 | 595 |
<EntitySetMapping Name="MARKUP_DATA"> |
588 | 596 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)"> |
589 | 597 |
<MappingFragment StoreEntitySet="MARKUP_DATA"> |
590 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
|
598 |
<ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" /> |
|
599 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
|
591 | 600 |
<ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" /> |
592 | 601 |
<ScalarProperty Name="DATA" ColumnName="DATA" /> |
593 | 602 |
<ScalarProperty Name="MARKUPINFO_VERSION_ID" ColumnName="MARKUPINFO_VERSION_ID" /> |
... | ... | |
635 | 644 |
<EntitySetMapping Name="MEMBER"> |
636 | 645 |
<EntityTypeMapping TypeName="CIModel.MEMBER"> |
637 | 646 |
<MappingFragment StoreEntitySet="MEMBER"> |
647 |
<ScalarProperty Name="ISLICENSE" ColumnName="ISLICENSE" /> |
|
648 |
<ScalarProperty Name="MODIFIED_DATETIME" ColumnName="MODIFIED_DATETIME" /> |
|
649 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
|
638 | 650 |
<ScalarProperty Name="COMPANY" ColumnName="COMPANY" /> |
639 | 651 |
<ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" /> |
640 | 652 |
<ScalarProperty Name="EMAIL_ADDRESS" ColumnName="EMAIL_ADDRESS" /> |
... | ... | |
744 | 756 |
</Options> |
745 | 757 |
<!-- Diagram content (shape and connector positions) --> |
746 | 758 |
<Diagrams> |
747 |
<Diagram DiagramId="56537d79007d413b99bb660a37dd2a9f" Name="Diagram1" ZoomLevel="54">
|
|
759 |
<Diagram DiagramId="56537d79007d413b99bb660a37dd2a9f" Name="Diagram1" ZoomLevel="81">
|
|
748 | 760 |
<EntityTypeShape EntityType="CIModel.DOCUMENT_ITEM" Width="1.5" PointX="5.375" PointY="7.75" /> |
749 | 761 |
<EntityTypeShape EntityType="CIModel.DOCINFO" Width="1.5" PointX="7.375" PointY="10.125" /> |
750 | 762 |
<EntityTypeShape EntityType="CIModel.DOCPAGE" Width="1.5" PointX="9.625" PointY="8.125" /> |
내보내기 Unified diff