pr2/tkaniGK/DataClasses1.dbml

<?xml version="1.0" encoding="utf-8"?><Database Name="GaydukTkani" Class="DataClasses1DataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="AppSettings" ConnectionString="Data Source=Class31000;Initial Catalog=GaydukTkani;Integrated Security=True" SettingsObjectName="tkaniGK.Properties.Settings" SettingsPropertyName="GaydukTkaniConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.furnitura" Member="furnitura">
    <Type Name="furnitura">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="naimenovanioa" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="hirina" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="dlina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="tip" Type="System.String" DbType="NChar(10)" CanBeNull="true" />
      <Column Name="prise" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="ves" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="izobrazenia" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Association Name="furnitura_sklad_furnitur" Member="sklad_furnitur" ThisKey="id" OtherKey="id_furnitur" Type="sklad_furnitur" />
    </Type>
  </Table>
  <Table Name="dbo.furnitura_izdelia" Member="furnitura_izdelia">
    <Type Name="furnitura_izdelia">
      <Column Name="id_furnitur" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="id_izdelia" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="razmehenia" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="hirina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="dlina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="povorot" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="kolichestvo" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.furnitura12" Member="furnitura12">
    <Type Name="furnitura12">
      <Column Name="Артикул" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Наименование" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="Ширина" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Длина" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Тип" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Цена" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.izdelia" Member="izdelia">
    <Type Name="izdelia">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="naimenovania" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="hirina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="dlina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="izobrazenia" Type="System.Data.Linq.Binary" DbType="Image" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="koment" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Association Name="izdelia_Tkani_izdelia" Member="Tkani_izdelia" ThisKey="id" OtherKey="id_izdelia" Type="Tkani_izdelia" />
      <Association Name="izdelia_zakazan_izdelia" Member="zakazan_izdelia" ThisKey="id" OtherKey="id_izdelia" Type="zakazan_izdelia" />
    </Type>
  </Table>
  <Table Name="dbo.izdelia12" Member="izdelia12">
    <Type Name="izdelia12">
      <Column Name="Артикул" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Наименование" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="Ширина" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Длина" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Column_5" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.polzovatel" Member="polzovatel">
    <Type Name="polzovatel">
      <Column Name="login" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="parol" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="rol" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="naimenovania" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Association Name="polzovatel_zakaz" Member="zakaz" ThisKey="login" OtherKey="zakazhik" Type="zakaz" />
      <Association Name="polzovatel_zakaz1" Member="zakaz1" ThisKey="login" OtherKey="menedzer" Type="zakaz" />
    </Type>
  </Table>
  <Table Name="dbo.sklad_furnitur" Member="sklad_furnitur">
    <Type Name="sklad_furnitur">
      <Column Name="partia" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="id_furnitur" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="kolih" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Association Name="furnitura_sklad_furnitur" Member="furnitura" ThisKey="id_furnitur" OtherKey="id" Type="furnitura" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.sklad_tkani" Member="sklad_tkani">
    <Type Name="sklad_tkani">
      <Column Name="rulon" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="artikul_tkani" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="dlina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Association Name="tkani_sklad_tkani" Member="tkani" ThisKey="artikul_tkani" OtherKey="id" Type="tkani" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.tkani" Member="tkani">
    <Type Name="tkani">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="naimenovania" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="color" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="risunok" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="sostav" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="hirina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="dlina" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="prise" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="izobrazenia" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Association Name="tkani_sklad_tkani" Member="sklad_tkani" ThisKey="id" OtherKey="artikul_tkani" Type="sklad_tkani" />
      <Association Name="tkani_Tkani_izdelia" Member="Tkani_izdelia" ThisKey="id" OtherKey="id_tkani" Type="Tkani_izdelia" />
    </Type>
  </Table>
  <Table Name="dbo.Tkani_izdelia" Member="Tkani_izdelia">
    <Type Name="Tkani_izdelia">
      <Column Name="id_tkani" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="id_izdelia" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Association Name="izdelia_Tkani_izdelia" Member="izdelia" ThisKey="id_izdelia" OtherKey="id" Type="izdelia" IsForeignKey="true" />
      <Association Name="tkani_Tkani_izdelia" Member="tkani" ThisKey="id_tkani" OtherKey="id" Type="tkani" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.tkani12" Member="tkani12">
    <Type Name="tkani12">
      <Column Name="Артикул" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Название" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Цвет" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Рисунок" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Состав" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Ширина" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Длина" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Цена" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.zakaz" Member="zakaz">
    <Type Name="zakaz">
      <Column Name="nomer" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="data" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="vpolnenia" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="zakazhik" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="menedzer" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="stoimost" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Association Name="zakaz_zakazan_izdelia" Member="zakazan_izdelia" ThisKey="nomer" OtherKey="nomer_zakaza" Type="zakazan_izdelia" />
      <Association Name="polzovatel_zakaz" Member="polzovatel" ThisKey="zakazhik" OtherKey="login" Type="polzovatel" IsForeignKey="true" />
      <Association Name="polzovatel_zakaz1" Member="polzovatel1" ThisKey="menedzer" OtherKey="login" Type="polzovatel" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.zakazan_izdelia" Member="zakazan_izdelia">
    <Type Name="zakazan_izdelia">
      <Column Name="id_izdelia" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="nomer_zakaza" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="kolichestvo" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Association Name="izdelia_zakazan_izdelia" Member="izdelia" ThisKey="id_izdelia" OtherKey="id" Type="izdelia" IsForeignKey="true" />
      <Association Name="zakaz_zakazan_izdelia" Member="zakaz" ThisKey="nomer_zakaza" OtherKey="nomer" Type="zakaz" IsForeignKey="true" />
    </Type>
  </Table>
</Database>