프로젝트

일반

사용자정보

개정판 f9d986d9

IDf9d986d90c1b5f3c2acd180f043c5b872677ce24
상위 6472f348
하위 92aa67fb

이지연이(가) 약 6년 전에 추가함

issue #885 부서/사용자 색상 설정

차이점 보기:

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" />
111 113 
        </EntityType>
112 114 
        <EntityType Name="MARKUP_INFO">
113 115 
          <Key>
......
146 148 
          <Property Name="MODIFIED_DATETIME" Type="datetime" />
147 149 
          <Property Name="ISLICENSE" Type="int" />
148 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 
        </EntityType>
149 169 
        <EntityType Name="SIGN_INFO">
150 170 
          <Key>
151 171 
            <PropertyRef Name="ID" />
......
223 243 
            </Dependent>
224 244 
          </ReferentialConstraint>
225 245 
        </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="*" />
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="*" />
229 249 
          <ReferentialConstraint>
230 
            <Principal Role="MEMBER">
231 
              <PropertyRef Name="ID" />
250 
            <Principal Role="MEMBER_DEPT_COLOR">
251 
              <PropertyRef Name="COLORID" />
232 252 
            </Principal>
233 
            <Dependent Role="SIGN_INFO">
234 
              <PropertyRef Name="MEMBER_USER_ID" />
253 
            <Dependent Role="MEMBER_DEPT_COLORINFO">
254 
              <PropertyRef Name="COLORID" />
235 255 
            </Dependent>
236 256 
          </ReferentialConstraint>
237 257 
        </Association>
......
246 266 
          <EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" />
247 267 
          <EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" />
248 268 
          <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" />
249 271 
          <EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" />
250 272 
          <EntitySet Name="TALK" EntityType="Self.TALK" Schema="dbo" store:Type="Tables" />
251 273 
          <AssociationSet Name="FK_DOCINFODOFPAGE" Association="Self.FK_DOCINFODOFPAGE">
......
264 286 
            <End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" />
265 287 
            <End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" />
266 288 
          </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" />
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" />
270 292 
          </AssociationSet>
271 293 
        </EntityContainer>
272 294 
      </Schema></edmx:StorageModels>
......
306 328 
          <EntitySet Name="TALK" EntityType="CIModel.TALK" />
307 329 
          <EntitySet Name="CHECK_LIST" EntityType="CIModel.CHECK_LIST" />
308 330 
          <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>
309 337 
          </EntityContainer>
310 338 
        <EntityType Name="DOCUMENT_ITEM">
311 339 
          <Key>
......
321 349 
          <Property Name="RESULT_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
322 350 
          <Property Name="RESULT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
323 351 
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
352 
          <Property Name="ENSEMBLEINFO_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
324 353 
        </EntityType>
325 354 
        <EntityType Name="DOCINFO">
326 355 
          <Key>
......
357 386 
          <Property Name="DATA_TYPE" Type="Int32" Nullable="false" />
358 387 
          <NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" />
359 388 
          <Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
389 
          <Property Name="GROUP_ID" Type="Int64" />
360 390 
        </EntityType>
361 391 
        <EntityType Name="MARKUP_INFO">
362 392 
          <Key>
......
547 577 
          <Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
548 578 
          <Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" />
549 579 
        </EntityType>
580 
        <EntityType Name="MEMBER_DEPT_COLOR">
581 
          <Key>
582 
            <PropertyRef Name="COLORID" />
583 
          </Key>
584 
          <Property Name="COLORID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
585 
          <Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
586 
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
587 
          <NavigationProperty Name="MEMBER_DEPT_COLORINFO" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLOR" ToRole="MEMBER_DEPT_COLORINFO" />
588 
        </EntityType>
589 
        <EntityType Name="MEMBER_DEPT_COLORINFO">
590 
          <Key>
591 
            <PropertyRef Name="CVALUEID" />
592 
            <PropertyRef Name="DISPLAYCOLOR" />
593 
            <PropertyRef Name="COLORID" />
594 
          </Key>
595 
          <Property Name="CVALUEID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
596 
          <Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
597 
          <Property Name="COLORID" Type="Int32" Nullable="false" />
598 
          <NavigationProperty Name="MEMBER_DEPT_COLOR" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLORINFO" ToRole="MEMBER_DEPT_COLOR" />
599 
        </EntityType>
600 
        <Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
601 
          <End Type="CIModel.MEMBER_DEPT_COLOR" Role="MEMBER_DEPT_COLOR" Multiplicity="1" />
602 
          <End Type="CIModel.MEMBER_DEPT_COLORINFO" Role="MEMBER_DEPT_COLORINFO" Multiplicity="*" />
603 
          <ReferentialConstraint>
604 
            <Principal Role="MEMBER_DEPT_COLOR">
605 
              <PropertyRef Name="COLORID" />
606 
            </Principal>
607 
            <Dependent Role="MEMBER_DEPT_COLORINFO">
608 
              <PropertyRef Name="COLORID" />
609 
            </Dependent>
610 
          </ReferentialConstraint>
611 
        </Association>
550 612 
        </Schema>
551 613 
    </edmx:ConceptualModels>
552 614 
    <!-- C-S mapping content -->
......
556 618 
    <EntitySetMapping Name="DOCUMENT_ITEM">
557 619 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCUMENT_ITEM)">
558 620 
        <MappingFragment StoreEntitySet="DOCUMENT_ITEM">
559 
          <ScalarProperty Name="ID" ColumnName="ID" />
621 
          <ScalarProperty Name="ENSEMBLEINFO_URL" ColumnName="ENSEMBLEINFO_URL" />
622 
                <ScalarProperty Name="ID" ColumnName="ID" />
560 623 
          <ScalarProperty Name="REVISION" ColumnName="REVISION" />
561 624 
          <ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" />
562 625 
          <ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" />
......
595 658 
    <EntitySetMapping Name="MARKUP_DATA">
596 659 
      <EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)">
597 660 
        <MappingFragment StoreEntitySet="MARKUP_DATA">
598 
          <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
661 
          <ScalarProperty Name="GROUP_ID" ColumnName="GROUP_ID" />
662 
                <ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" />
599 663 
                <ScalarProperty Name="ID" ColumnName="ID" />
600 664 
          <ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" />
601 665 
          <ScalarProperty Name="DATA" ColumnName="DATA" />
......
735 799 
              </MappingFragment>
736 800 
            </EntityTypeMapping>
737 801 
          </EntitySetMapping>
802 
          <EntitySetMapping Name="MEMBER_DEPT_COLOR">
803 
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLOR">
804 
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLOR">
805 
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
806 
                <ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" />
807 
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
808 
              </MappingFragment>
809 
            </EntityTypeMapping>
810 
          </EntitySetMapping>
811 
          <EntitySetMapping Name="MEMBER_DEPT_COLORINFO">
812 
            <EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLORINFO">
813 
              <MappingFragment StoreEntitySet="MEMBER_DEPT_COLORINFO">
814 
                <ScalarProperty Name="COLORID" ColumnName="COLORID" />
815 
                <ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" />
816 
                <ScalarProperty Name="CVALUEID" ColumnName="CVALUEID" />
817 
              </MappingFragment>
818 
            </EntityTypeMapping>
819 
          </EntitySetMapping>
738 820 
          </EntityContainerMapping>
739 821 
</Mapping></edmx:Mappings>
740 822 
  </edmx:Runtime>
......
774 856 
        <EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" />
775 857 
        <EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" />
776 858 
        <EntityTypeShape EntityType="CIModel.CHECK_LIST_HISTORY" Width="1.5" PointX="5.375" PointY="0.75" />
859 
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLOR" Width="1.5" PointX="7.375" PointY="0.875" />
860 
        <EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLORINFO" Width="1.5" PointX="9.625" PointY="0.875" />
861 
        <AssociationConnector Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" />
777 862 
        </Diagram>
778 863 
    </Diagrams>
779 864 
  </Designer>

내보내기 Unified diff

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