개정판 71208c63
Revert "markus 성능개선"
This reverts commit 0cda2a885008c0503d20d124631932685c72d462.
Reason for revert: <INSERT REASONING HERE>
Change-Id: I62fa4a232ee9a418ffceccffe432e7fdda93396d
| DataBase/EntityModel/MarkusModel.edmx | ||
|---|---|---|
| 4 | 4 |
<edmx:Runtime> |
| 5 | 5 |
<!-- SSDL content --> |
| 6 | 6 |
<edmx:StorageModels> |
| 7 |
<Schema Namespace="MarkusDBModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" 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/11/edm/ssdl"> |
|
| 7 |
<Schema Namespace="MarkusDBModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" 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/11/edm/ssdl">
|
|
| 8 | 8 |
<EntityType Name="ATTACH_URL"> |
| 9 | 9 |
<Key> |
| 10 | 10 |
<PropertyRef Name="ID" /> |
| ... | ... | |
| 119 | 119 |
</Key> |
| 120 | 120 |
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 121 | 121 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
| 122 |
<Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
| 122 |
<Property Name="DOCINFO_ID" Type="int" Nullable="false" />
|
|
| 123 | 123 |
<Property Name="MARKUPINFO_ID" Type="int" Nullable="false" /> |
| 124 | 124 |
<Property Name="CREATE_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
| 125 | 125 |
<Property Name="CREATE_DATETIME" Type="datetime" Nullable="false" /> |
| ... | ... | |
| 462 | 462 |
<End Role="SYMBOL_PRIVATE" EntitySet="SYMBOL_PRIVATE" /> |
| 463 | 463 |
</AssociationSet> |
| 464 | 464 |
</EntityContainer> |
| 465 |
</Schema></edmx:StorageModels> |
|
| 465 |
</Schema> |
|
| 466 |
</edmx:StorageModels> |
|
| 466 | 467 |
<!-- CSDL content --> |
| 467 | 468 |
<edmx:ConceptualModels> |
| 468 | 469 |
<Schema Namespace="MarkusDBModel" Alias="Self" annotation:UseStrongSpatialTypes="false" 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/2009/11/edm"> |
| ... | ... | |
| 580 | 581 |
<Property Name="PAGE_NO" Type="Int32" Nullable="false" /> |
| 581 | 582 |
<NavigationProperty Name="MEMBER" Relationship="Self.FK_FAVORIT_DOC_FAVORIT_DOC" FromRole="FAVORITE_DOC" ToRole="MEMBER" /> |
| 582 | 583 |
</EntityType> |
| 584 |
<EntityType Name="FINAL_PDF"> |
|
| 585 |
<Key> |
|
| 586 |
<PropertyRef Name="ID" /> |
|
| 587 |
</Key> |
|
| 588 |
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
|
| 589 |
<Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" /> |
|
| 590 |
<Property Name="DOCINFO_ID" Type="Int32" Nullable="false" /> |
|
| 591 |
<Property Name="MARKUPINFO_ID" Type="Int32" Nullable="false" /> |
|
| 592 |
<Property Name="CREATE_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> |
|
| 593 |
<Property Name="CREATE_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
|
| 594 |
<Property Name="STATUS" Type="Int32" Nullable="false" /> |
|
| 595 |
<Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" /> |
|
| 596 |
<Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" /> |
|
| 597 |
<Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
|
| 598 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
|
| 599 |
<Property Name="START_DATETIME" Type="DateTime" Precision="3" /> |
|
| 600 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
| 601 |
</EntityType> |
|
| 583 | 602 |
<EntityType Name="LOGIN_STAMP"> |
| 584 | 603 |
<Key> |
| 585 | 604 |
<PropertyRef Name="ID" /> |
| ... | ... | |
| 871 | 890 |
<EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" /> |
| 872 | 891 |
<EntitySet Name="ERROR_LOG" EntityType="Self.ERROR_LOG" /> |
| 873 | 892 |
<EntitySet Name="FAVORITE_DOC" EntityType="Self.FAVORITE_DOC" /> |
| 893 |
<EntitySet Name="FINAL_PDF" EntityType="Self.FINAL_PDF" /> |
|
| 874 | 894 |
<EntitySet Name="LOGIN_STAMP" EntityType="Self.LOGIN_STAMP" /> |
| 875 | 895 |
<EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" /> |
| 876 | 896 |
<EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" /> |
| ... | ... | |
| 919 | 939 |
<End Role="MEMBER" EntitySet="MEMBER" /> |
| 920 | 940 |
<End Role="SYMBOL_PRIVATE" EntitySet="SYMBOL_PRIVATE" /> |
| 921 | 941 |
</AssociationSet> |
| 922 |
<EntitySet Name="FINAL_PDF" EntityType="MarkusDBModel.FINAL_PDF" /> |
|
| 923 | 942 |
</EntityContainer> |
| 924 |
<EntityType Name="FINAL_PDF"> |
|
| 925 |
<Key> |
|
| 926 |
<PropertyRef Name="ID" /> |
|
| 927 |
</Key> |
|
| 928 |
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
| 929 |
<Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" /> |
|
| 930 |
<Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
| 931 |
<Property Name="MARKUPINFO_ID" Type="Int32" Nullable="false" /> |
|
| 932 |
<Property Name="CREATE_USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
| 933 |
<Property Name="CREATE_DATETIME" Type="DateTime" Nullable="false" Precision="3" /> |
|
| 934 |
<Property Name="STATUS" Type="Int32" Nullable="false" /> |
|
| 935 |
<Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" /> |
|
| 936 |
<Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" /> |
|
| 937 |
<Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> |
|
| 938 |
<Property Name="END_DATETIME" Type="DateTime" Precision="3" /> |
|
| 939 |
<Property Name="START_DATETIME" Type="DateTime" Precision="3" /> |
|
| 940 |
<Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
| 941 |
</EntityType> |
|
| 942 | 943 |
</Schema> |
| 943 | 944 |
</edmx:ConceptualModels> |
| 944 | 945 |
<!-- C-S mapping content --> |
| ... | ... | |
| 1061 | 1062 |
</MappingFragment> |
| 1062 | 1063 |
</EntityTypeMapping> |
| 1063 | 1064 |
</EntitySetMapping> |
| 1065 |
<EntitySetMapping Name="FINAL_PDF"> |
|
| 1066 |
<EntityTypeMapping TypeName="MarkusDBModel.FINAL_PDF"> |
|
| 1067 |
<MappingFragment StoreEntitySet="FINAL_PDF"> |
|
| 1068 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
|
| 1069 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
|
| 1070 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
|
| 1071 |
<ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" /> |
|
| 1072 |
<ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" /> |
|
| 1073 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
|
| 1074 |
<ScalarProperty Name="STATUS" ColumnName="STATUS" /> |
|
| 1075 |
<ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" /> |
|
| 1076 |
<ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" /> |
|
| 1077 |
<ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" /> |
|
| 1078 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
|
| 1079 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
|
| 1080 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
|
| 1081 |
</MappingFragment> |
|
| 1082 |
</EntityTypeMapping> |
|
| 1083 |
</EntitySetMapping> |
|
| 1064 | 1084 |
<EntitySetMapping Name="LOGIN_STAMP"> |
| 1065 | 1085 |
<EntityTypeMapping TypeName="MarkusDBModel.LOGIN_STAMP"> |
| 1066 | 1086 |
<MappingFragment StoreEntitySet="LOGIN_STAMP"> |
| ... | ... | |
| 1253 | 1273 |
</MappingFragment> |
| 1254 | 1274 |
</EntityTypeMapping> |
| 1255 | 1275 |
</EntitySetMapping> |
| 1256 |
<EntitySetMapping Name="FINAL_PDF"> |
|
| 1257 |
<EntityTypeMapping TypeName="MarkusDBModel.FINAL_PDF"> |
|
| 1258 |
<MappingFragment StoreEntitySet="FINAL_PDF"> |
|
| 1259 |
<ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" /> |
|
| 1260 |
<ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" /> |
|
| 1261 |
<ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" /> |
|
| 1262 |
<ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" /> |
|
| 1263 |
<ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" /> |
|
| 1264 |
<ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" /> |
|
| 1265 |
<ScalarProperty Name="STATUS" ColumnName="STATUS" /> |
|
| 1266 |
<ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" /> |
|
| 1267 |
<ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" /> |
|
| 1268 |
<ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" /> |
|
| 1269 |
<ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" /> |
|
| 1270 |
<ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" /> |
|
| 1271 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
|
| 1272 |
</MappingFragment> |
|
| 1273 |
</EntityTypeMapping> |
|
| 1274 |
</EntitySetMapping> |
|
| 1275 | 1276 |
</EntityContainerMapping> |
| 1276 | 1277 |
</Mapping> |
| 1277 | 1278 |
</edmx:Mappings> |
내보내기 Unified diff
