<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="BAHAModel.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">
  <EntityType Name="OZELLIK">
    <Key>
      <PropertyRef Name="OZELLIKID" />
    </Key>
    <Property Name="OZELLIKID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="ADI" Type="nvarchar" MaxLength="30" />
    <Property Name="FIYATI" Type="float" />
    <Property Name="STOKID" Type="int" />
    <Property Name="KODU" Type="nvarchar" MaxLength="30" />
  </EntityType>
  <EntityType Name="STOK">
    <Key>
      <PropertyRef Name="STOKID" />
    </Key>
    <Property Name="STOKID" Type="int" Nullable="false" />
    <Property Name="GRUP" Type="nvarchar" MaxLength="20" />
    <Property Name="BARKOD" Type="nvarchar" MaxLength="30" />
    <Property Name="KODU" Type="nvarchar" MaxLength="30" Nullable="false" />
    <Property Name="ADI" Type="nvarchar" MaxLength="100" />
    <Property Name="SSATICI" Type="int" />
    <Property Name="SALISFIYAT" Type="float" />
    <Property Name="SFATURANO" Type="nvarchar" MaxLength="20" />
    <Property Name="SFATTARIHI" Type="datetime" />
    <Property Name="SFIYAT1" Type="float" />
    <Property Name="SFIYAT2" Type="float" />
    <Property Name="SFIYAT3" Type="float" />
    <Property Name="SFIYAT4" Type="float" />
    <Property Name="SFIYAT5" Type="float" />
    <Property Name="SDOVIZ" Type="nvarchar" MaxLength="10" />
    <Property Name="AMIKTAR" Type="float" />
    <Property Name="OPTMIKTAR" Type="float" />
    <Property Name="ROMRU" Type="nvarchar" MaxLength="20" />
    <Property Name="RNO" Type="nvarchar" MaxLength="20" />
    <Property Name="EK1" Type="nvarchar" MaxLength="50" />
    <Property Name="EK2" Type="nvarchar" MaxLength="50" />
    <Property Name="EK3" Type="nvarchar" MaxLength="50" />
    <Property Name="EK4" Type="nvarchar" MaxLength="50" />
    <Property Name="EK5" Type="nvarchar" MaxLength="50" />
    <Property Name="ALISKDV" Type="float" />
    <Property Name="SATISKDV" Type="float" />
    <Property Name="ETIKETTIPI" Type="int" />
    <Property Name="BIRIM" Type="nvarchar" MaxLength="15" />
    <Property Name="BIRIM2" Type="nvarchar" MaxLength="15" />
    <Property Name="KATSAYI2" Type="float" />
    <Property Name="BIRIM3" Type="nvarchar" MaxLength="15" />
    <Property Name="KATSAYI3" Type="float" />
    <Property Name="BIRIM4" Type="nvarchar" MaxLength="15" />
    <Property Name="KATSAYI4" Type="float" />
    <Property Name="SAKLA" Type="int" />
    <Property Name="SKOMORAN" Type="float" />
    <Property Name="BKOMORAN" Type="float" />
    <Property Name="ALISIND" Type="float" />
    <Property Name="SATISIND" Type="float" />
    <Property Name="NAKLIYE" Type="float" />
    <Property Name="SKARY" Type="float" />
    <Property Name="BARKOD2" Type="nvarchar" MaxLength="20" />
    <Property Name="BARKOD3" Type="nvarchar" MaxLength="20" />
    <Property Name="BARKOD4" Type="nvarchar" MaxLength="20" />
    <Property Name="TURU" Type="nvarchar" MaxLength="10" />
    <Property Name="URETDEPOID" Type="int" />
    <Property Name="BEKLALISFIYAT" Type="float" />
    <Property Name="SFIYAT1KDV" Type="bit" />
    <Property Name="SFIYAT2KDV" Type="bit" />
    <Property Name="SFIYAT3KDV" Type="bit" />
    <Property Name="SFIYAT4KDV" Type="bit" />
    <Property Name="SFIYAT5KDV" Type="bit" />
    <Property Name="MALIYET" Type="float" />
    <Property Name="HYERI" Type="int" />
    <Property Name="AI" Type="bit" />
    <Property Name="INDGRUP" Type="int" />
    <Property Name="SDEPART" Type="nvarchar" MaxLength="255" />
    <Property Name="UAI" Type="bit" />
    <Property Name="GGRUP" Type="nvarchar" MaxLength="5" />
    <Property Name="ODENMEZ" Type="bit" />
    <Property Name="HLISTE" Type="bit" />
    <Property Name="GADET" Type="float" />
    <Property Name="HEDEFCOST" Type="float" />
    <Property Name="POSTURU" Type="nvarchar" MaxLength="1" />
    <Property Name="KDV" Type="int" />
    <Property Name="OPTIMAL" Type="float" />
    <Property Name="ASGARI" Type="float" />
    <Property Name="RAFNO" Type="nvarchar" MaxLength="15" />
    <Property Name="RAFOMRU" Type="nvarchar" MaxLength="15" />
    <Property Name="OZELKOD1" Type="nvarchar" MaxLength="30" />
    <Property Name="OZELKOD2" Type="nvarchar" MaxLength="30" />
    <Property Name="OZELKOD3" Type="nvarchar" MaxLength="30" />
    <Property Name="EKKOD" Type="nvarchar" MaxLength="15" />
    <Property Name="SONALISF" Type="float" />
    <Property Name="SONSATICI" Type="nvarchar" MaxLength="30" />
    <Property Name="ALISTARIH" Type="datetime" />
    <Property Name="SFIYAT" Type="float" />
    <Property Name="SONKULLANMA" Type="datetime" />
    <Property Name="ABUFE" Type="bit" />
    <Property Name="KISISAYISI" Type="float" />
    <Property Name="RECETEBIRIMI" Type="nvarchar" MaxLength="15" />
    <Property Name="RECETEKATSAYISI" Type="float" />
    <Property Name="SAYIMDURUMU" Type="int" />
    <Property Name="UHHOUR" Type="bit" />
    <Property Name="EKBILGI" Type="nvarchar" MaxLength="1000" />
    <Property Name="COSTFACTOR" Type="float" />
    <Property Name="VARSAYILANBIRIM" Type="int" />
    <Property Name="SARFDEPOID" Type="int" />
    <Property Name="ORTFIYAT" Type="float" />
    <Property Name="SONKT" Type="datetime" />
    <Property Name="SUBEID" Type="int" />
    <Property Name="SONMALIYET" Type="float" />
    <Property Name="KKALDIR" Type="int" />
    <Property Name="RANDEVUZORUNLU" Type="int" />
    <Property Name="ACKZORUNLU" Type="int" />
    <Property Name="KONTURLU" Type="int" />
    <Property Name="SGIDERY" Type="float" />
    <Property Name="KARY" Type="float" />
    <Property Name="BIRIMID" Type="int" />
    <Property Name="BIRIM2ID" Type="int" />
    <Property Name="BIRIM3ID" Type="int" />
    <Property Name="BIRIM4ID" Type="int" />
    <Property Name="SALISFBIRIM" Type="nvarchar" MaxLength="15" />
    <Property Name="SALISFBFIYAT" Type="float" />
    <Property Name="SKODU" Type="nvarchar" MaxLength="50" />
    <Property Name="SAYIMBIRIMI" Type="nvarchar" MaxLength="15" />
    <Property Name="SALISBFIYAT" Type="float" />
    <Property Name="SONAMIKTAR" Type="float" />
    <Property Name="SONABIRIM" Type="nvarchar" MaxLength="20" />
    <Property Name="STEVORAN" Type="nvarchar" MaxLength="5" />
    <Property Name="SONKT2" Type="datetime" />
    <Property Name="SDEPOLAR" Type="nvarchar" MaxLength="255" />
    <Property Name="ALERJEN" Type="int" />
    <Property Name="PISIRMEMETOD" Type="nvarchar" MaxLength="20" />
    <Property Name="PISIRMESICAKLIK" Type="float" />
    <Property Name="SUNUMSICAKLIK" Type="float" />
    <Property Name="SOGUTMASICAKLIK" Type="float" />
    <Property Name="SAKLAMASICAKLIK" Type="float" />
    <Property Name="PISIRMESURE" Type="float" />
    <Property Name="SUNUMSURE" Type="float" />
    <Property Name="SOGUTMASURE" Type="float" />
    <Property Name="HAZIRLIK" Type="ntext" />
    <Property Name="GERIDONER" Type="bit" />
    <Property Name="STOKGRUPID" Type="int" />
    <Property Name="RGRUP" Type="nvarchar" MaxLength="10" />
    <Property Name="SDKONTROL" Type="nvarchar" MaxLength="255" />
    <Property Name="SIPYAZICI" Type="nvarchar" MaxLength="15" />
    <Property Name="RAPORKATSAYISINET" Type="float" />
    <Property Name="STDFIREORANI" Type="float" />
    <Property Name="RAPORKATSAYISI" Type="float" />
    <Property Name="HTURU" Type="nvarchar" MaxLength="20" />
    <Property Name="SERVIS" Type="int" />
    <Property Name="OTOTUKET" Type="bit" />
    <Property Name="FATURABIRIMI" Type="nvarchar" MaxLength="20" />
    <Property Name="SAKLAMASURE" Type="float" />
    <Property Name="PISIRMEMETODU" Type="nvarchar" MaxLength="20" />
    <Property Name="DSATIS" Type="bit" />
    <Property Name="SISEBARKODTAKIP" Type="bit" />
    <Property Name="URETILMEZ" Type="bit" />
    <Property Name="KAREKODU" Type="nvarchar" MaxLength="30" />
    <Property Name="IKINCIURUNIND" Type="bit" />
    <Property Name="POSSIRANO" Type="int" />
    <Property Name="TERAZIBIRIMI" Type="nvarchar" MaxLength="50" />
    <Property Name="FIYATSORULSUN" Type="bit" />
    <Property Name="MIKTARSORULSUN" Type="bit" />
  </EntityType>
  <EntityType Name="STOKGRUP">
    <Key>
      <PropertyRef Name="KODU" />
    </Key>
    <Property Name="KODU" Type="nvarchar" MaxLength="20" Nullable="false" />
    <Property Name="ADI" Type="nvarchar" MaxLength="100" />
    <Property Name="MUHKODU" Type="nvarchar" MaxLength="50" />
    <Property Name="OZELKOD1" Type="nvarchar" MaxLength="50" />
    <Property Name="SAKLA" Type="int" />
    <Property Name="MUHNHESAPID" Type="int" />
    <Property Name="MUHSHESAPID" Type="int" />
    <Property Name="MUHGHESAPID" Type="int" />
    <Property Name="TURU" Type="nvarchar" MaxLength="10" />
    <Property Name="ANAGRUPUZUNLUGU" Type="int" />
    <Property Name="ALTGRUPUZUNLUGU" Type="int" />
    <Property Name="ALT2GRUPUZUNLUGU" Type="int" />
    <Property Name="ALKOLLU" Type="int" />
    <Property Name="DSATIS" Type="int" />
    <Property Name="STOKGRUPID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="MUHAISKHESAPID" Type="int" />
    <Property Name="MUHSISKHESAPID" Type="int" />
    <Property Name="POSAKTIF" Type="int" />
    <Property Name="MASRAF" Type="int" />
    <Property Name="MUHAHESAPID" Type="int" />
    <Property Name="STOKUSTGRUPID" Type="int" />
    <Property Name="STOKALTGRUPID" Type="int" />
    <Property Name="STOKANAGRUPID" Type="int" />
    <Property Name="MIADZORUNLU" Type="int" />
    <Property Name="SUBEID" Type="int" />
    <Property Name="POSGURUBU" Type="nvarchar" MaxLength="50" />
    <Property Name="SGBARKOD" Type="nvarchar" MaxLength="50" />
  </EntityType>
  <Association Name="FK_OZELLIK_STOK">
    <End Role="STOK" Type="Self.STOK" Multiplicity="0..1" />
    <End Role="OZELLIK" Type="Self.OZELLIK" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="STOK">
        <PropertyRef Name="STOKID" />
      </Principal>
      <Dependent Role="OZELLIK">
        <PropertyRef Name="STOKID" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_STOK_STOKgrup">
    <End Role="STOKGRUP" Type="Self.STOKGRUP" Multiplicity="0..1" />
    <End Role="STOK" Type="Self.STOK" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="STOKGRUP">
        <PropertyRef Name="KODU" />
      </Principal>
      <Dependent Role="STOK">
        <PropertyRef Name="GRUP" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Function Name="MPOS_GarsonGiris" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
    <Parameter Name="DepKod" Type="nvarchar" Mode="In" />
    <Parameter Name="Sifre" Type="nvarchar" Mode="In" />
  </Function>
  <Function Name="MPos_HesapGoster" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
    <Parameter Name="DepKodu" Type="nvarchar" Mode="In" />
    <Parameter Name="MasaNo" Type="nvarchar" Mode="In" />
  </Function>
  <Function Name="MPOS_HesapKapat" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
    <Parameter Name="DepKodu" Type="nvarchar" Mode="In" />
    <Parameter Name="MasaNo" Type="nvarchar" Mode="In" />
    <Parameter Name="OdemeTuru" Type="nvarchar" Mode="In" />
  </Function>
  <Function Name="MPOS_MasaListesi" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
    <Parameter Name="DepKod" Type="nvarchar" Mode="In" />
  </Function>
  <Function Name="MPOS_UrunEkle" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
    <Parameter Name="DepKodu" Type="nvarchar" Mode="In" />
    <Parameter Name="MasaNo" Type="nvarchar" Mode="In" />
    <Parameter Name="UrunId" Type="int" Mode="In" />
    <Parameter Name="Adet" Type="float" Mode="In" />
    <Parameter Name="Fiyat" Type="float" Mode="In" />
    <Parameter Name="Ozellik" Type="nvarchar" Mode="In" />
    <Parameter Name="GarsonId" Type="int" Mode="In" />
  </Function>
  <Function Name="MPOS_UrunListesi" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
  <EntityContainer Name="BAHAModelStoreContainer">
    <EntitySet Name="OZELLIK" EntityType="Self.OZELLIK" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="STOK" EntityType="Self.STOK" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="STOKGRUP" EntityType="Self.STOKGRUP" Schema="dbo" store:Type="Tables" />
    <AssociationSet Name="FK_OZELLIK_STOK" Association="Self.FK_OZELLIK_STOK">
      <End Role="STOK" EntitySet="STOK" />
      <End Role="OZELLIK" EntitySet="OZELLIK" />
    </AssociationSet>
    <AssociationSet Name="FK_STOK_STOKgrup" Association="Self.FK_STOK_STOKgrup">
      <End Role="STOKGRUP" EntitySet="STOKGRUP" />
      <End Role="STOK" EntitySet="STOK" />
    </AssociationSet>
  </EntityContainer>
</Schema>