프로젝트

일반

사용자정보

개정판 53880c83

ID53880c83defd8cc6468fd4130469156a289f4e62
상위 6472f348
하위 97e8ad04

이지연이(가) 5년 이상 전에 추가함

issue #886: Symbol legend 생성 작업 중....

차이점 보기:

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 89 
        </EntityType>
89 90 
        <EntityType Name="MARKUP_CHECKLIST">
90 91 
          <Key>
......
108 109 
          <Property Name="MARKUPINFO_VERSION_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
109 110 
          <Property Name="DATA_TYPE" Type="int" Nullable="false" />
110 111 
          <Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" />
112 
          <Property Name="GROUP_ID" Type="bigint" />
113 
        </EntityType>
114 
        <EntityType Name="MARKUP_DATA_GROUP">
115 
          <Key>
116 
            <PropertyRef Name="ID" />
117 
          </Key>
118 
          <Property Name="ID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
119 
          <Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" />
120 
          <Property Name="STATE" Type="int" Nullable="false" />
111 121 
        </EntityType>
112 122 
        <EntityType Name="MARKUP_INFO">
113 123 
          <Key>
......
146 156 
          <Property Name="MODIFIED_DATETIME" Type="datetime" />
147 157 
          <Property Name="ISLICENSE" Type="int" />
148 158 
        </EntityType>
159 
        <EntityType Name="MEMBER_DEPT_COLOR">
160 
          <Key>
161 
            <PropertyRef Name="COLORID" />
162 
          </Key>
163 
          <Property Name="COLORID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
164 
          <Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" />
165 
          <Property Name="DISPLAYCOLOR" Type="nvarchar" MaxLength="10" Nullable="false" />
166 
        </EntityType>
167 
        <EntityType Name="MEMBER_DEPT_COLORINFO">
168 
          <Key>
169 
            <PropertyRef Name="CVALUEID" />
170 
            <PropertyRef Name="DISPLAYCOLOR" />
171 
            <PropertyRef Name="COLORID" />
172 
          </Key>
173 
          <Property Name="CVALUEID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
174 
          <Property Name="DISPLAYCOLOR" Type="nvarchar" MaxLength="10" Nullable="false" />
175 
          <Property Name="COLORID" Type="int" Nullable="false" />
176 
        </EntityType>
149 177 
        <EntityType Name="SIGN_INFO">
150 178 
          <Key>
151 179 
            <PropertyRef Name="ID" />
......
223 251 
            </Dependent>
224 252 
          </ReferentialConstraint>
225 253 
        </Association>
226 
        <Association Name="FK_SIGNINFO_MEMBER">
227 
          <End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" />
228 
          <End Role="SIGN_INFO" Type="Self.SIGN_INFO" Multiplicity="*" />
254 
        <Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
255 
          <End Role="MEMBER_DEPT_COLOR" Type="Self.MEMBER_DEPT_COLOR" Multiplicity="1" />
256 
          <End Role="MEMBER_DEPT_COLORINFO" Type="Self.MEMBER_DEPT_COLORINFO" Multiplicity="*" />
229 257 
          <ReferentialConstraint>
230 
            <Principal Role="MEMBER">
231 
              <PropertyRef Name="ID" />
258 
            <Principal Role="MEMBER_DEPT_COLOR">
259 
              <PropertyRef Name="COLORID" />
232 260 
            </Principal>
233 
            <Dependent Role="SIGN_INFO">
234 
              <PropertyRef Name="MEMBER_USER_ID" />
261 
            <Dependent Role="MEMBER_DEPT_COLORINFO">
262 
              <PropertyRef Name="COLORID" />
235 263 
            </Dependent>
236 264 
          </ReferentialConstraint>
237 265 
        </Association>
......
243 271 
          <EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" Schema="dbo" store:Type="Tables" />
244 272 
          <EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" Schema="dbo" store:Type="Tables" />
245 273 
          <EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" Schema="dbo" store:Type="Tables" />
274 
          <EntitySet Name="MARKUP_DATA_GROUP" EntityType="Self.MARKUP_DATA_GROUP" Schema="dbo" store:Type="Tables" />
246 275 
          <EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" />
247 276 
          <EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" />
248 277 
          <EntitySet Name="MEMBER" EntityType="Self.MEMBER" Schema="dbo" store:Type="Tables" />
278 
          <EntitySet Name="MEMBER_DEPT_COLOR" EntityType="Self.MEMBER_DEPT_COLOR" Schema="dbo" store:Type="Tables" />
279 
          <EntitySet Name="MEMBER_DEPT_COLORINFO" EntityType="Self.MEMBER_DEPT_COLORINFO" Schema="dbo" store:Type="Tables" />
249 280 
          <EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" />
250 281 
          <EntitySet Name="TALK" EntityType="Self.TALK" Schema="dbo" store:Type="Tables" />
251 282 
          <AssociationSet Name="FK_DOCINFODOFPAGE" Association="Self.FK_DOCINFODOFPAGE">
......
264 295 
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
265 296 
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
266 297 
          </AssociationSet>
267 
          <AssociationSet Name="FK_SIGNINFO_MEMBER" Association="Self.FK_SIGNINFO_MEMBER">
268 
            <End Role="MEMBER" EntitySet="MEMBER" />
269 
            <End Role="SIGN_INFO" EntitySet="SIGN_INFO" />
298 
          <AssociationSet Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" Association="Self.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
299 
            <End Role="MEMBER_DEPT_COLOR" EntitySet="MEMBER_DEPT_COLOR" />
300 
            <End Role="MEMBER_DEPT_COLORINFO" EntitySet="MEMBER_DEPT_COLORINFO" />
270 301 
          </AssociationSet>
271 302 
        </EntityContainer>
272 303 
      </Schema></edmx:StorageModels>
......
306 337 
          <EntitySet Name="TALK" EntityType="CIModel.TALK" />
307 338 
          <EntitySet Name="CHECK_LIST" EntityType="CIModel.CHECK_LIST" />
308 339 
          <EntitySet Name="CHECK_LIST_HISTORY" EntityType="CIModel.CHECK_LIST_HISTORY" />
340 
          <EntitySet Name="MARKUP_DATA_GROUP" EntityType="CIModel.MARKUP_DATA_GROUP" />
341 
          <EntitySet Name="MEMBER_DEPT_COLOR" EntityType="CIModel.MEMBER_DEPT_COLOR" />
342 
          <EntitySet Name="MEMBER_DEPT_COLORINFO" EntityType="CIModel.MEMBER_DEPT_COLORINFO" />
343 
          <AssociationSet Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
344 
            <End Role="MEMBER_DEPT_COLOR" EntitySet="MEMBER_DEPT_COLOR" />
345 
            <End Role="MEMBER_DEPT_COLORINFO" EntitySet="MEMBER_DEPT_COLORINFO" />
346 
          </AssociationSet>
309 347 
          </EntityContainer>
310 348 
        <EntityType Name="DOCUMENT_ITEM">
311 349 
          <Key>
......
321 359 
          <Property Name="RESULT_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
322 360 
          <Property Name="RESULT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
323 361 
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
362 
          <Property Name="ENSEMBLEINFO_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
324 363 
        </EntityType>
325 364 
        <EntityType Name="DOCINFO">
326 365 
          <Key>
......
357 396 
          <Property Name="DATA_TYPE" Type="Int32" Nullable="false" />
358 397 
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" />
359 398 
          <Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
399 
          <Property Name="GROUP_ID" Type="Int64" />
360 400 
        </EntityType>
361 401 
        <EntityType Name="MARKUP_INFO">
362 402 
          <Key>
......
547 587 
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
548 588 
          <Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
549 589 
        </EntityType>
590 
        <EntityType Name="MARKUP_DATA_GROUP">
591 
          <Key>
592 
            <PropertyRef Name="ID" />
593 
          </Key>
594 
          <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
595 
          <Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
596 
          <Property Name="STATE" Type="Int32" Nullable="false" />
597 
        </EntityType>
598 
        <EntityType Name="MEMBER_DEPT_COLOR">
599 
          <Key>
600 
            <PropertyRef Name="COLORID" />
601 
          </Key>
602 
          <Property Name="COLORID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
603 
          <Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
604 
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
605 
          <NavigationProperty Name="MEMBER_DEPT_COLORINFO" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLOR" ToRole="MEMBER_DEPT_COLORINFO" />
606 
        </EntityType>
607 
        <EntityType Name="MEMBER_DEPT_COLORINFO">
608 
          <Key>
609 
            <PropertyRef Name="CVALUEID" />
610 
            <PropertyRef Name="DISPLAYCOLOR" />
611 
            <PropertyRef Name="COLORID" />
612 
          </Key>
613 
          <Property Name="CVALUEID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
614 
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
615 
          <Property Name="COLORID" Type="Int32" Nullable="false" />
616 
          <NavigationProperty Name="MEMBER_DEPT_COLOR" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLORINFO" ToRole="MEMBER_DEPT_COLOR" />
617 
        </EntityType>
618 
        <Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
619 
          <End Type="CIModel.MEMBER_DEPT_COLOR" Role="MEMBER_DEPT_COLOR" Multiplicity="1" />
620 
          <End Type="CIModel.MEMBER_DEPT_COLORINFO" Role="MEMBER_DEPT_COLORINFO" Multiplicity="*" />
621 
          <ReferentialConstraint>
622 
            <Principal Role="MEMBER_DEPT_COLOR">
623 
              <PropertyRef Name="COLORID" />
624 
            </Principal>
625 
            <Dependent Role="MEMBER_DEPT_COLORINFO">
626 
              <PropertyRef Name="COLORID" />
627 
            </Dependent>
628 
          </ReferentialConstraint>
629 
        </Association>
550 630 
        </Schema>
551 631 
    </edmx:ConceptualModels>
552 632 
    <!-- C-S mapping content -->
......
556 636 
    <EntitySetMapping Name="DOCUMENT_ITEM">
557 637 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCUMENT_ITEM)">
558 638 
        <MappingFragment StoreEntitySet="DOCUMENT_ITEM">
559 
          <ScalarProperty Name="ID" ColumnName="ID" />
639 
          <ScalarProperty Name="ENSEMBLEINFO_URL" ColumnName="ENSEMBLEINFO_URL" />
640 
                <ScalarProperty Name="ID" ColumnName="ID" />
560 641 
          <ScalarProperty Name="REVISION" ColumnName="REVISION" />
561 642 
          <ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" />
562 643 
          <ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" />
......
595 676 
    <EntitySetMapping Name="MARKUP_DATA">
596 677 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)">
597 678 
        <MappingFragment StoreEntitySet="MARKUP_DATA">
598 
          <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
679 
          <ScalarProperty Name="GROUP_ID" ColumnName="GROUP_ID" />
680 
                <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
599 681 
                <ScalarProperty Name="ID" ColumnName="ID" />
600 682 
          <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
601 683 
          <ScalarProperty Name="DATA" ColumnName="DATA" />
......
735 817 
              </MappingFragment>
736 818 
            </EntityTypeMapping>
737 819 
          </EntitySetMapping>
820 
          <EntitySetMapping Name="MARKUP_DATA_GROUP">
821 
            <EntityTypeMapping TypeName="CIModel.MARKUP_DATA_GROUP">
822 
              <MappingFragment StoreEntitySet="MARKUP_DATA_GROUP">
823 
                <ScalarProperty Name="STATE" ColumnName="STATE" />
824 
                <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
825 
                <ScalarProperty Name="ID" ColumnName="ID" />
826 
              </MappingFragment>
827 
            </EntityTypeMapping>
828 
          </EntitySetMapping>
829 
          <EntitySetMapping Name="MEMBER_DEPT_COLOR">
830 
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLOR">
831 
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLOR">
832 
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
833 
                <ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" />
834 
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
835 
              </MappingFragment>
836 
            </EntityTypeMapping>
837 
          </EntitySetMapping>
838 
          <EntitySetMapping Name="MEMBER_DEPT_COLORINFO">
839 
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLORINFO">
840 
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLORINFO">
841 
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
842 
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
843 
                <ScalarProperty Name="CVALUEID" ColumnName="CVALUEID" />
844 
              </MappingFragment>
845 
            </EntityTypeMapping>
846 
          </EntitySetMapping>
738 847 
          </EntityContainerMapping>
739 848 
</Mapping></edmx:Mappings>
740 849 
  </edmx:Runtime>
......
760 869 
        <EntityTypeShape EntityType="CIModel.DOCUMENT_ITEM" Width="1.5" PointX="5.375" PointY="7.75" />
761 870 
        <EntityTypeShape EntityType="CIModel.DOCINFO" Width="1.5" PointX="7.375" PointY="10.125" />
762 871 
        <EntityTypeShape EntityType="CIModel.DOCPAGE" Width="1.5" PointX="9.625" PointY="8.125" />
763 
        <EntityTypeShape EntityType="CIModel.MARKUP_DATA" Width="1.5" PointX="14.125" PointY="11.75" />
872 
        <EntityTypeShape EntityType="CIModel.MARKUP_DATA" Width="2.25" PointX="14.125" PointY="11.75" />
764 873 
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO" Width="1.5" PointX="9.625" PointY="11.25" />
765 874 
        <EntityTypeShape EntityType="CIModel.MARKUP_INFO_VERSION" Width="1.5" PointX="11.875" PointY="11.875" />
766 875 
        <AssociationConnector Association="CIModel.FK_DOCINFODOFPAGE" />
......
774 883 
        <EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" />
775 884 
        <EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" />
776 885 
        <EntityTypeShape EntityType="CIModel.CHECK_LIST_HISTORY" Width="1.5" PointX="5.375" PointY="0.75" />
886 
        <EntityTypeShape EntityType="CIModel.MARKUP_DATA_GROUP" Width="2.625" PointX="7.375" PointY="0.75" />
887 
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLOR" Width="1.5" PointX="7.375" PointY="3.875" />
888 
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLORINFO" Width="1.5" PointX="9.625" PointY="3.875" />
889 
        <AssociationConnector Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" />
777 890 
        </Diagram>
778 891 
    </Diagrams>
779 892 
  </Designer>

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)