ModuleMaster/app_code/catv.dbml - main - ivan/ModMas

ModuleMaster/app_code/catv.dbml
56 строк5 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:4900d9fb6
<?xml version="1.0" encoding="utf-8"?><Database Name="CATV" Class="catvDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=serkweb.serk.lan;Initial Catalog=CATV;User ID=sa" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="CATVConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.TB_COM_MAIN_LINE" Member="TB_COM_MAIN_LINEs">
    <Type Name="TB_COM_MAIN_LINE">
      <Column Name="TYPE" Type="System.String" DbType="NVarChar(3)" CanBeNull="true" />
      <Column Name="LINE" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SECT" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="SHOP_CODE" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="[PLAN]" Member="PLAN" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="TARGET" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="PROD" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="DIF" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="PDR" Type="System.String" DbType="NVarChar(8)" CanBeNull="true" />
      <Column Name="ON_TIME_RATIO" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="STUFFING" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="BALANCE" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="EPASS_RATE" Type="System.String" DbType="NVarChar(384) NOT NULL" CanBeNull="false" />
      <Column Name="UPP" Type="System.String" DbType="NVarChar(384) NOT NULL" CanBeNull="false" />
      <Column Name="MP" Type="System.String" DbType="NVarChar(384) NOT NULL" CanBeNull="false" />
      <Column Name="UPDATED" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.TB_CATV_MAIN_LINE_DETAILS" Member="TB_CATV_MAIN_LINE_DETAILs">
    <Type Name="TB_CATV_MAIN_LINE_DETAIL">
      <Column Name="Line" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Po" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Model" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="[Plan]" Member="Plan" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="Target" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="[Plan start]" Member="Plan_start" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
      <Column Name="[Plan end]" Member="Plan_end" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
      <Column Name="Prod" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
      <Column Name="[Actual start]" Member="Actual_start" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
      <Column Name="[Actual end]" Member="Actual_end" Type="System.String" DbType="NVarChar(16)" CanBeNull="true" />
      <Column Name="DIF" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="DEFECT" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="[Def. rate,%]" Member="Def__rate__" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="TT" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="CURRENT_PROD" Type="System.String" DbType="NVarChar(1)" CanBeNull="true" />
      <Column Name="WORK_DATE" Type="System.String" DbType="NVarChar(8) NOT NULL" CanBeNull="false" />
      <Column Name="LAST_SCAN_DT" Type="System.String" DbType="NVarChar(14)" CanBeNull="true" />
      <Column Name="LAST_SCAN_PAST_MIN" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="UPDATED" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.TB_CATV_WORKING_STATUS_MAIN" Member="TB_CATV_WORKING_STATUS_MAINs">
    <Type Name="TB_CATV_WORKING_STATUS_MAIN">
      <Column Name="LINE" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SHOP_CODE" Type="System.String" DbType="NVarChar(30) NOT NULL" CanBeNull="false" />
      <Column Name="WORK_SEC" Type="System.String" DbType="NVarChar(384)" CanBeNull="true" />
      <Column Name="LINE_IS_WORKING" Type="System.String" DbType="NVarChar(1)" CanBeNull="true" />
      <Column Name="LINE_HAS_LUNCH" Type="System.String" DbType="NVarChar(1)" CanBeNull="true" />
      <Column Name="UPDATED" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
</Database>