TUBAASİL.sqlce

-- Script Date: 22.01.2014 21:02  - ErikEJ.SqlCeScripting version 3.5.2.35
CREATE TABLE [TBL_URUN_TIPI] (
  [TBL_URUN_TIPI_ID] int IDENTITY (1,1) NOT NULL
, [URUN_TIPI_ADI] nvarchar(50) NULL
, [URUN_TIPI_ACIKLAMA] nvarchar(50) NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_URUN_CINSI] (
  [TBL_URUN_CINSI_ID] int IDENTITY (1,1) NOT NULL
, [TBL_URUN_TIPI_ID] int NULL
, [URUN_CINSI_ADI] nvarchar(50) NULL
, [URUN_CINSI_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_URUN_MARKA] (
  [TBL_URUN_MARKA_ID] int IDENTITY (1,1) NOT NULL
, [TBL_URUN_TIPI_ID] int NULL
, [TBL_URUN_CINSI_ID] int NOT NULL
, [URUN_MARKA_ADI] nvarchar(50) NULL
, [URUN_MARKA_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_URUN_BIRIM] (
  [TBL_URUN_BIRIM_ID] int IDENTITY (1,1) NOT NULL
, [URUN_BIRIM_ADI] nvarchar(50) NULL
, [URUN_BIRIM_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SPARIS_TURU] (
  [TBL_SPARIS_TURU_ID] int IDENTITY (1,1) NOT NULL
, [SPARIS_TURU_ADI] nvarchar(50) NULL
, [SPARIS_TURU_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SIRKET_TIPI] (
  [TBL_SIRKET_TIPI_ID] int IDENTITY (1,1) NOT NULL
, [SIRKET_TIPI_ADI] nvarchar(50) NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SIRKET_SINIF] (
  [TBL_SIRKET_SINIF_ID] int IDENTITY (1,1) NOT NULL
, [SIRKET_SINIF_ADI] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SIRKET_GRUB] (
  [TBL_SIRKET_GRUB_ID] int IDENTITY (1,1) NOT NULL
, [SIRKET_GRUP_ADI] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SIRKET] (
  [TBL_SIRKET_ID] int IDENTITY (1,1) NOT NULL
, [TBL_SIRKET_GRUB_ID] int NULL
, [TBL_SIRKET_SINIF_ID] int NULL
, [TBL_SIRKET_TIPI_ID] int NULL
, [SIRKET_ADI] nvarchar(50) NULL
, [SIRKET_TELEFON_1] nvarchar(50) NULL
, [SIRKET_TELEFON_2] nvarchar(50) NULL
, [SIRKET_FAX_1] nvarchar(50) NULL
, [SIRKET_FAX_2] nvarchar(50) NULL
, [SIRKET_MAIL_1] nvarchar(50) NULL
, [SIRKET_MAIL_2] nvarchar(50) NULL
, [SIRKET_WEB_ADRES] nvarchar(50) NULL
, [SIRKET_VERGI_DAIRESI] nvarchar(50) NULL
, [SIRKET_VERGI_NO] nvarchar(50) NULL
, [SIRKET_ADRES] ntext NULL
, [SIRKET_IL] nvarchar(50) NULL
, [SIRKET_ILCE] nvarchar(50) NULL
, [SIRKET_POSTA_KODU] nvarchar(50) NULL
, [SIRKET_BANKA_ADI] nvarchar(50) NULL
, [SIRKET_BANKA_SUBE_ADI] nvarchar(50) NULL
, [SIRKET_HESAP_NO] nvarchar(50) NULL
, [SIRKET_IBAN] nvarchar(50) NULL
, [SIRKET_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_PERSONEL] (
  [TBL_PERSONEL_ID] int IDENTITY (1,1) NOT NULL
, [PERSONEL_AD_SOYAD] nvarchar(50) NULL
, [YETKI_SEVIYESI] ntext NULL
, [SIFRE] ntext NULL
, [BARKOD_ID] ntext NULL
, [PERSONEL_GOREVI] nvarchar(50) NULL
, [PERSONEL_TELEFON1] nvarchar(50) NULL
, [PERSONEL_TELEFON2] nvarchar(50) NULL
, [PERSONEL_MAIL] nvarchar(50) NULL
, [PERSONEL_CALISMA_DURUMU] nvarchar(50) NULL
, [PERSONEL_ISE_BASLAMA_TARIHI] nvarchar(50) NULL
, [PERSONEL_ISTEN_AYRILMA_TARIHI] nvarchar(50) NULL
, [PERSONEL_ISE_GELIS_SAATI] nvarchar(50) NULL
, [PERSONEL_ISTEN_CIKIS_SAATI] nvarchar(50) NULL
, [PERSONEL_SSK_NO] nvarchar(50) NULL
, [PERSONEL_CINSIYET] nvarchar(50) NULL
, [PERSONEL_KIMLIK_NO] nvarchar(50) NULL
, [PERSONEL_DOGUM_TARIHI] nvarchar(50) NULL
, [PERSONEL_DOGUM_YERI] nvarchar(50) NULL
, [PERSONEL_EGITIM_DURUMU] nvarchar(50) NULL
, [PERSONEL_ACIKLAMA] nvarchar(50) NULL
, [PERSONEL_AYAKKABI_NO] nvarchar(50) NULL
, [PERSONEL_GOMLEK_NO] nvarchar(50) NULL
, [PERSONEL_MONT_NO] nvarchar(50) NULL
, [PERSONEL_PANTOLON_NO] nvarchar(50) NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_PARA_TIPI] (
  [TBL_PARA_TIPI_ID] int IDENTITY (1,1) NOT NULL
, [PARA_TIPI_ADI] nvarchar(50) NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_ODEME_TURU] (
  [TBL_ODEME_TURU_ID] int IDENTITY (1,1) NOT NULL
, [ODEME_TURU_ADI] nvarchar(50) NULL
, [ODEME_TURU_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_ODEME_TIPI] (
  [TBL_ODEME_TIPI_ID] int IDENTITY (1,1) NOT NULL
, [ODEME_TIPI_ADI] nvarchar(50) NULL
, [ODEME_TIPI_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_KDV] (
  [TBL_KDV_ID] int NOT NULL
, [KDV_YUZDESI] int NULL
, [KDV_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_URUN] (
  [TBL_URUN_ID] int IDENTITY (1,1) NOT NULL
, [URUN_ADI] nvarchar(50) NULL
, [URUN_KODU] ntext NULL
, [TBL_URUN_TIPI_ID] int NULL
, [TBL_URUN_CINSI_ID] int NULL
, [TBL_URUN_MARKA_ID] int NULL
, [TBL_URUN_BIRIM_ID] int NULL
, [TBL_KDV_ID] int NULL
, [URUN_DURUM] nvarchar(50) NULL
, [URUN_ALIS_FIYATI] nvarchar(50) NULL
, [URUN_SATIS_FIYATI] nvarchar(50) NULL
, [TBL_PARA_TIPI_ID] int NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_KASA] (
  [TBL_KASA_ID] int IDENTITY (1,1) NOT NULL
, [TBL_PARA_TIPI_ID] int NULL
, [KASA_ADI] nvarchar(50) NULL
, [KASA_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_ODEME] (
  [TBL_ODEME_ID] int IDENTITY (1,1) NOT NULL
, [ODEME_KAYIT_TARIHI] nvarchar(50) NULL
, [ODEME_VADE_TARIHI] nvarchar(50) NULL
, [TBL_ODEME_TURU_ID] int NULL
, [TBL_ODEME_TIPI_ID] int NULL
, [BELGE_NO] nvarchar(50) NULL
, [TBL_SIRKET_ID] int NULL
, [TUTAR] nvarchar(50) NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_KASA_ID] int NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_GIDER] (
  [TBL_GIDER_ID] int IDENTITY (1,1) NOT NULL
, [TBL_PARA_TIPI_ID] int NULL
, [GİDER_ADI] nvarchar(50) NULL
, [GİDER_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_FIS] (
  [TBL_FIS_ID] int IDENTITY (1,1) NOT NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SIRKET_BAKIYE] (
  [TBL_SIRKET_BAKIYE_ID] int IDENTITY (1,1) NOT NULL
, [TBL_SIRKET_ID] int NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_FIS_ID] int NULL
, [KUR] nvarchar(50) NULL
, [TARIH] nvarchar(50) NULL
, [TUTAR] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_KASA_BAKIYE] (
  [TBL_KASA_BAKIYE_ID] int IDENTITY (1,1) NOT NULL
, [TBL_KASA_ID] int NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_FIS_ID] int NULL
, [KUR] nvarchar(50) NULL
, [TARIH] nvarchar(50) NULL
, [TUTAR] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_GIDER_BAKIYE] (
  [TBL_GIDER_BAKIYE_ID] int IDENTITY (1,1) NOT NULL
, [TBL_GIDER_ID] int NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_FIS_ID] int NULL
, [KUR] nvarchar(50) NULL
, [TARIH] nvarchar(50) NULL
, [TUTAR] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_FATURA_TURU] (
  [TBL_FATURA_TURU_ID] int IDENTITY (1,1) NOT NULL
, [FATURA_TURU_ADI] nvarchar(50) NULL
, [FATURA_TURU_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_DEPO_TRANSFER] (
  [TBL_DEPO_TRANSFER_ID] int IDENTITY (1,1) NOT NULL
, [DEPO_TRANSFER_ADI] nvarchar(50) NULL
, [DEPO_TRANSFER_TARIHI] nvarchar(50) NULL
, [DEPO_TRANSFER_NEREDEN] nvarchar(50) NULL
, [DEPO_TRANSFER_NEREYE] nvarchar(50) NULL
, [TBL_URUN_ID] int NULL
, [DEPO_TRANSFER_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_DEPO] (
  [TBL_DEPO_ID] int IDENTITY (1,1) NOT NULL
, [DEPO_ADI] nvarchar(50) NULL
, [DEPO_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_URUN_STOK] (
  [TBL_URUN_STOK_ID] int IDENTITY (1,1) NOT NULL
, [TBL_URUN_ID] int NULL
, [TBL_DEPO_ID] int NULL
, [URUN_BIRIM_MIKTARI] int NULL
, [STOK_DURUM] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_SPARIS] (
  [TBL_SPARIS_ID] int IDENTITY (1,1) NOT NULL
, [TBL_SIRKET_ID] int NULL
, [TBL_SPARIS_TURU_ID] int NULL
, [SPARIS_TARIH] nvarchar(50) NULL
, [SPARIS_VADE_TARIH] nvarchar(50) NULL
, [SPARIS_FATURA_SERI_NO] nvarchar(50) NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_ODEME_TIPI_ID] int NULL
, [TBL_KASA_ID] int NULL
, [TBL_DEPO_ID] int NULL
, [TBL_PERSONEL_ID] int NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_URUN_SPARIS] (
  [TBL_URUN_SPARIS_ID] int IDENTITY (1,1) NOT NULL
, [TBL_URUN_ID] int NULL
, [TBL_SIPARIS_ID] int NULL
, [URUN_SIPARIS_MIKTAR] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_FATURA] (
  [TBL_FATURA_ID] int IDENTITY (1,1) NOT NULL
, [TBL_SIRKET_ID] int NULL
, [TBL_FATURA_TURU_ID] int NULL
, [FATURA_TARIH] nvarchar(50) NULL
, [FATURA_VADE_TARIH] nvarchar(50) NULL
, [FATURA_FATURA_SERI_NO] nvarchar(50) NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_ODEME_TIPI_ID] int NULL
, [TBL_KASA_ID] int NULL
, [TBL_DEPO_ID] int NULL
, [TBL_PERSONEL_ID] int NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
, [TBL_SPARIS_ID] int NULL
);
GO
CREATE TABLE [TBL_URUN_FATURA] (
  [TBL_URUN_FATURA_ID] int IDENTITY (1,1) NOT NULL
, [TBL_URUN_ID] int NULL
, [TBL_FATURA_ID] int NULL
, [URUN_FATURA_MIKTAR] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_DEPO_ISLEM] (
  [TBL_DEPO_ISLEM_ID] int IDENTITY (1,1) NOT NULL
, [TBL_DEPO_ID] int NULL
, [TBL_URUN_ID] int NULL
, [DEPO_ISLEM_ADI] nvarchar(50) NULL
, [URUN_MIKTAR] nvarchar(50) NULL
, [DEPO_ONAY] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_BANKA] (
  [TBL_BANKA_ID] int IDENTITY (1,1) NOT NULL
, [BANKA_ADI] nvarchar(50) NULL
, [BANKA_SUBE_ADI] nvarchar(50) NULL
, [BANKA_IBAN_NO] nvarchar(50) NULL
, [TBL_PARA_TIPI_ID] int NULL
, [BANKA_TELEFON_1] nvarchar(50) NULL
, [BANKA_TELEFON_2] nvarchar(50) NULL
, [BANKA_ADRES] ntext NULL
, [BANKA_IL] nvarchar(50) NULL
, [BANKA_ILCE] nvarchar(50) NULL
, [BANKA_MAIL] nvarchar(50) NULL
, [BANKA_ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
CREATE TABLE [TBL_BANKA_BAKIYE] (
  [TBL_BANKA_BAKIYE_ID] int IDENTITY (1,1) NOT NULL
, [TBL_BANKA_ID] int NULL
, [TBL_PARA_TIPI_ID] int NULL
, [TBL_FIS_ID] int NULL
, [KUR] nvarchar(50) NULL
, [TARIH] nvarchar(50) NULL
, [TUTAR] nvarchar(50) NULL
, [ACIKLAMA] ntext NULL
, [YEDEK] ntext NULL
);
GO
ALTER TABLE [TBL_URUN_TIPI] ADD CONSTRAINT [PK_TBL_URUN_TIPI] PRIMARY KEY ([TBL_URUN_TIPI_ID]);
GO
ALTER TABLE [TBL_URUN_CINSI] ADD CONSTRAINT [PK_TBL_URUN_CINSI] PRIMARY KEY ([TBL_URUN_CINSI_ID]);
GO
ALTER TABLE [TBL_URUN_MARKA] ADD CONSTRAINT [PK_TBL_URUN_MARKA] PRIMARY KEY ([TBL_URUN_MARKA_ID]);
GO
ALTER TABLE [TBL_URUN_BIRIM] ADD CONSTRAINT [PK_TBL_URUN_BIRIM] PRIMARY KEY ([TBL_URUN_BIRIM_ID]);
GO
ALTER TABLE [TBL_SPARIS_TURU] ADD CONSTRAINT [PK_TBL_SPARIS_TURU] PRIMARY KEY ([TBL_SPARIS_TURU_ID]);
GO
ALTER TABLE [TBL_SIRKET_TIPI] ADD CONSTRAINT [PK_TBL_SIRKET_TIPI] PRIMARY KEY ([TBL_SIRKET_TIPI_ID]);
GO
ALTER TABLE [TBL_SIRKET_SINIF] ADD CONSTRAINT [PK_TBL_SIRKET_SINIF_1] PRIMARY KEY ([TBL_SIRKET_SINIF_ID]);
GO
ALTER TABLE [TBL_SIRKET_GRUB] ADD CONSTRAINT [PK_TBL_SIRKET_GRUB_1] PRIMARY KEY ([TBL_SIRKET_GRUB_ID]);
GO
ALTER TABLE [TBL_SIRKET] ADD CONSTRAINT [PK_TBL_SIRKET_1] PRIMARY KEY ([TBL_SIRKET_ID]);
GO
ALTER TABLE [TBL_PERSONEL] ADD CONSTRAINT [PK_TBL_PERSONEL] PRIMARY KEY ([TBL_PERSONEL_ID]);
GO
ALTER TABLE [TBL_PARA_TIPI] ADD CONSTRAINT [PK_TBL_PARA_TIPI_1] PRIMARY KEY ([TBL_PARA_TIPI_ID]);
GO
ALTER TABLE [TBL_ODEME_TURU] ADD CONSTRAINT [PK_TBL_ODEME_TURU] PRIMARY KEY ([TBL_ODEME_TURU_ID]);
GO
ALTER TABLE [TBL_ODEME_TIPI] ADD CONSTRAINT [PK_TBL_ODEME_TIPI] PRIMARY KEY ([TBL_ODEME_TIPI_ID]);
GO
ALTER TABLE [TBL_KDV] ADD CONSTRAINT [PK_TBL_KDV] PRIMARY KEY ([TBL_KDV_ID]);
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [PK_TBL_URUN] PRIMARY KEY ([TBL_URUN_ID]);
GO
ALTER TABLE [TBL_KASA] ADD CONSTRAINT [PK_TBL_KASA] PRIMARY KEY ([TBL_KASA_ID]);
GO
ALTER TABLE [TBL_ODEME] ADD CONSTRAINT [PK_TBL_ODEME] PRIMARY KEY ([TBL_ODEME_ID]);
GO
ALTER TABLE [TBL_GIDER] ADD CONSTRAINT [PK_TBL_GIDER] PRIMARY KEY ([TBL_GIDER_ID]);
GO
ALTER TABLE [TBL_FIS] ADD CONSTRAINT [PK_TBL_FIS] PRIMARY KEY ([TBL_FIS_ID]);
GO
ALTER TABLE [TBL_SIRKET_BAKIYE] ADD CONSTRAINT [PK_TBL_SIRKET_BAKIYE_1] PRIMARY KEY ([TBL_SIRKET_BAKIYE_ID]);
GO
ALTER TABLE [TBL_KASA_BAKIYE] ADD CONSTRAINT [PK_TBL_KASA_BAKIYE_1] PRIMARY KEY ([TBL_KASA_BAKIYE_ID]);
GO
ALTER TABLE [TBL_GIDER_BAKIYE] ADD CONSTRAINT [PK_TBL_GIDER_BAKIYE_1] PRIMARY KEY ([TBL_GIDER_BAKIYE_ID]);
GO
ALTER TABLE [TBL_FATURA_TURU] ADD CONSTRAINT [PK_TBL_FATURA_TURU] PRIMARY KEY ([TBL_FATURA_TURU_ID]);
GO
ALTER TABLE [TBL_DEPO_TRANSFER] ADD CONSTRAINT [PK_TBL_DEPO_TRANSFER] PRIMARY KEY ([TBL_DEPO_TRANSFER_ID]);
GO
ALTER TABLE [TBL_DEPO] ADD CONSTRAINT [PK_TBL_DEPO] PRIMARY KEY ([TBL_DEPO_ID]);
GO
ALTER TABLE [TBL_URUN_STOK] ADD CONSTRAINT [PK_TBL_URUN_STOK] PRIMARY KEY ([TBL_URUN_STOK_ID]);
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [PK_TBL_SPARIS] PRIMARY KEY ([TBL_SPARIS_ID]);
GO
ALTER TABLE [TBL_URUN_SPARIS] ADD CONSTRAINT [PK_TBL_URUN_SPARIS] PRIMARY KEY ([TBL_URUN_SPARIS_ID]);
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [PK_TBL_FATURA] PRIMARY KEY ([TBL_FATURA_ID]);
GO
ALTER TABLE [TBL_URUN_FATURA] ADD CONSTRAINT [PK_TBL_URUN_FATURA] PRIMARY KEY ([TBL_URUN_FATURA_ID]);
GO
ALTER TABLE [TBL_DEPO_ISLEM] ADD CONSTRAINT [PK_TBL_DEPO_ISLEM] PRIMARY KEY ([TBL_DEPO_ISLEM_ID]);
GO
ALTER TABLE [TBL_BANKA] ADD CONSTRAINT [PK_TBL_BANKA] PRIMARY KEY ([TBL_BANKA_ID]);
GO
ALTER TABLE [TBL_BANKA_BAKIYE] ADD CONSTRAINT [PK_TBL_BANKA_BAKIYE_1] PRIMARY KEY ([TBL_BANKA_BAKIYE_ID]);
GO
ALTER TABLE [TBL_URUN_CINSI] ADD CONSTRAINT [FK_TBL_URUN_CINSI_TBL_URUN_TIPI] FOREIGN KEY ([TBL_URUN_TIPI_ID]) REFERENCES [TBL_URUN_TIPI]([TBL_URUN_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_MARKA] ADD CONSTRAINT [FK_TBL_URUN_MARKA_TBL_URUN_CINSI] FOREIGN KEY ([TBL_URUN_CINSI_ID]) REFERENCES [TBL_URUN_CINSI]([TBL_URUN_CINSI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_MARKA] ADD CONSTRAINT [FK_TBL_URUN_MARKA_TBL_URUN_TIPI] FOREIGN KEY ([TBL_URUN_TIPI_ID]) REFERENCES [TBL_URUN_TIPI]([TBL_URUN_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SIRKET] ADD CONSTRAINT [FK_TBL_SIRKET_TBL_SIRKET_GRUB] FOREIGN KEY ([TBL_SIRKET_GRUB_ID]) REFERENCES [TBL_SIRKET_GRUB]([TBL_SIRKET_GRUB_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SIRKET] ADD CONSTRAINT [FK_TBL_SIRKET_TBL_SIRKET_SINIF] FOREIGN KEY ([TBL_SIRKET_SINIF_ID]) REFERENCES [TBL_SIRKET_SINIF]([TBL_SIRKET_SINIF_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SIRKET] ADD CONSTRAINT [FK_TBL_SIRKET_TBL_SIRKET_TIPI] FOREIGN KEY ([TBL_SIRKET_TIPI_ID]) REFERENCES [TBL_SIRKET_TIPI]([TBL_SIRKET_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [FK_TBL_URUN_TBL_KDV] FOREIGN KEY ([TBL_KDV_ID]) REFERENCES [TBL_KDV]([TBL_KDV_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [FK_TBL_URUN_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [FK_TBL_URUN_TBL_URUN_BIRIM] FOREIGN KEY ([TBL_URUN_BIRIM_ID]) REFERENCES [TBL_URUN_BIRIM]([TBL_URUN_BIRIM_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [FK_TBL_URUN_TBL_URUN_CINSI] FOREIGN KEY ([TBL_URUN_CINSI_ID]) REFERENCES [TBL_URUN_CINSI]([TBL_URUN_CINSI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [FK_TBL_URUN_TBL_URUN_MARKA] FOREIGN KEY ([TBL_URUN_MARKA_ID]) REFERENCES [TBL_URUN_MARKA]([TBL_URUN_MARKA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN] ADD CONSTRAINT [FK_TBL_URUN_TBL_URUN_TIPI] FOREIGN KEY ([TBL_URUN_TIPI_ID]) REFERENCES [TBL_URUN_TIPI]([TBL_URUN_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_KASA] ADD CONSTRAINT [FK_TBL_KASA_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_ODEME] ADD CONSTRAINT [FK_TBL_ODEME_TBL_KASA] FOREIGN KEY ([TBL_KASA_ID]) REFERENCES [TBL_KASA]([TBL_KASA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_ODEME] ADD CONSTRAINT [FK_TBL_ODEME_TBL_ODEME_TIPI] FOREIGN KEY ([TBL_ODEME_TIPI_ID]) REFERENCES [TBL_ODEME_TIPI]([TBL_ODEME_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_ODEME] ADD CONSTRAINT [FK_TBL_ODEME_TBL_ODEME_TURU] FOREIGN KEY ([TBL_ODEME_TURU_ID]) REFERENCES [TBL_ODEME_TURU]([TBL_ODEME_TURU_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_ODEME] ADD CONSTRAINT [FK_TBL_ODEME_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_ODEME] ADD CONSTRAINT [FK_TBL_ODEME_TBL_SIRKET] FOREIGN KEY ([TBL_SIRKET_ID]) REFERENCES [TBL_SIRKET]([TBL_SIRKET_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_GIDER] ADD CONSTRAINT [FK_TBL_GIDER_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SIRKET_BAKIYE] ADD CONSTRAINT [FK_TBL_SIRKET_BAKIYE_TBL_FIS] FOREIGN KEY ([TBL_FIS_ID]) REFERENCES [TBL_FIS]([TBL_FIS_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SIRKET_BAKIYE] ADD CONSTRAINT [FK_TBL_SIRKET_BAKIYE_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SIRKET_BAKIYE] ADD CONSTRAINT [FK_TBL_SIRKET_BAKIYE_TBL_SIRKET] FOREIGN KEY ([TBL_SIRKET_ID]) REFERENCES [TBL_SIRKET]([TBL_SIRKET_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_KASA_BAKIYE] ADD CONSTRAINT [FK_TBL_KASA_BAKIYE_TBL_FIS] FOREIGN KEY ([TBL_FIS_ID]) REFERENCES [TBL_FIS]([TBL_FIS_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_KASA_BAKIYE] ADD CONSTRAINT [FK_TBL_KASA_BAKIYE_TBL_KASA] FOREIGN KEY ([TBL_KASA_ID]) REFERENCES [TBL_KASA]([TBL_KASA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_KASA_BAKIYE] ADD CONSTRAINT [FK_TBL_KASA_BAKIYE_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_GIDER_BAKIYE] ADD CONSTRAINT [FK_TBL_GIDER_BAKIYE_TBL_FIS] FOREIGN KEY ([TBL_FIS_ID]) REFERENCES [TBL_FIS]([TBL_FIS_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_GIDER_BAKIYE] ADD CONSTRAINT [FK_TBL_GIDER_BAKIYE_TBL_GIDER] FOREIGN KEY ([TBL_GIDER_ID]) REFERENCES [TBL_GIDER]([TBL_GIDER_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_GIDER_BAKIYE] ADD CONSTRAINT [FK_TBL_GIDER_BAKIYE_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_DEPO_TRANSFER] ADD CONSTRAINT [FK_TBL_DEPO_TRANSFER_TBL_URUN] FOREIGN KEY ([TBL_URUN_ID]) REFERENCES [TBL_URUN]([TBL_URUN_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_STOK] ADD CONSTRAINT [FK_TBL_URUN_STOK_TBL_DEPO] FOREIGN KEY ([TBL_DEPO_ID]) REFERENCES [TBL_DEPO]([TBL_DEPO_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_STOK] ADD CONSTRAINT [FK_TBL_URUN_STOK_TBL_URUN] FOREIGN KEY ([TBL_URUN_ID]) REFERENCES [TBL_URUN]([TBL_URUN_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_DEPO] FOREIGN KEY ([TBL_DEPO_ID]) REFERENCES [TBL_DEPO]([TBL_DEPO_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_KASA] FOREIGN KEY ([TBL_KASA_ID]) REFERENCES [TBL_KASA]([TBL_KASA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_ODEME_TIPI] FOREIGN KEY ([TBL_ODEME_TIPI_ID]) REFERENCES [TBL_ODEME_TIPI]([TBL_ODEME_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_PERSONEL] FOREIGN KEY ([TBL_PERSONEL_ID]) REFERENCES [TBL_PERSONEL]([TBL_PERSONEL_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_SIRKET] FOREIGN KEY ([TBL_SIRKET_ID]) REFERENCES [TBL_SIRKET]([TBL_SIRKET_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_SPARIS] ADD CONSTRAINT [FK_TBL_SPARIS_TBL_SPARIS_TURU] FOREIGN KEY ([TBL_SPARIS_TURU_ID]) REFERENCES [TBL_SPARIS_TURU]([TBL_SPARIS_TURU_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_SPARIS] ADD CONSTRAINT [FK_TBL_URUN_SPARIS_TBL_SPARIS] FOREIGN KEY ([TBL_SIPARIS_ID]) REFERENCES [TBL_SPARIS]([TBL_SPARIS_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_SPARIS] ADD CONSTRAINT [FK_TBL_URUN_SPARIS_TBL_URUN1] FOREIGN KEY ([TBL_URUN_ID]) REFERENCES [TBL_URUN]([TBL_URUN_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_DEPO] FOREIGN KEY ([TBL_DEPO_ID]) REFERENCES [TBL_DEPO]([TBL_DEPO_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_FATURA_TURU] FOREIGN KEY ([TBL_FATURA_TURU_ID]) REFERENCES [TBL_FATURA_TURU]([TBL_FATURA_TURU_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_KASA] FOREIGN KEY ([TBL_KASA_ID]) REFERENCES [TBL_KASA]([TBL_KASA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_ODEME_TIPI] FOREIGN KEY ([TBL_ODEME_TIPI_ID]) REFERENCES [TBL_ODEME_TIPI]([TBL_ODEME_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_PERSONEL] FOREIGN KEY ([TBL_PERSONEL_ID]) REFERENCES [TBL_PERSONEL]([TBL_PERSONEL_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_SIRKET] FOREIGN KEY ([TBL_SIRKET_ID]) REFERENCES [TBL_SIRKET]([TBL_SIRKET_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_FATURA] ADD CONSTRAINT [FK_TBL_FATURA_TBL_SPARIS] FOREIGN KEY ([TBL_SPARIS_ID]) REFERENCES [TBL_SPARIS]([TBL_SPARIS_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_FATURA] ADD CONSTRAINT [FK_TBL_URUN_FATURA_TBL_FATURA] FOREIGN KEY ([TBL_FATURA_ID]) REFERENCES [TBL_FATURA]([TBL_FATURA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_URUN_FATURA] ADD CONSTRAINT [FK_TBL_URUN_FATURA_TBL_URUN1] FOREIGN KEY ([TBL_URUN_ID]) REFERENCES [TBL_URUN]([TBL_URUN_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_DEPO_ISLEM] ADD CONSTRAINT [FK_TBL_DEPO_ISLEM_TBL_DEPO] FOREIGN KEY ([TBL_DEPO_ID]) REFERENCES [TBL_DEPO]([TBL_DEPO_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_DEPO_ISLEM] ADD CONSTRAINT [FK_TBL_DEPO_ISLEM_TBL_URUN] FOREIGN KEY ([TBL_URUN_ID]) REFERENCES [TBL_URUN]([TBL_URUN_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_BANKA] ADD CONSTRAINT [FK_TBL_BANKA_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_BANKA_BAKIYE] ADD CONSTRAINT [FK_TBL_BANKA_BAKIYE_TBL_BANKA] FOREIGN KEY ([TBL_BANKA_ID]) REFERENCES [TBL_BANKA]([TBL_BANKA_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_BANKA_BAKIYE] ADD CONSTRAINT [FK_TBL_BANKA_BAKIYE_TBL_FIS] FOREIGN KEY ([TBL_FIS_ID]) REFERENCES [TBL_FIS]([TBL_FIS_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO
ALTER TABLE [TBL_BANKA_BAKIYE] ADD CONSTRAINT [FK_TBL_BANKA_BAKIYE_TBL_PARA_TIPI] FOREIGN KEY ([TBL_PARA_TIPI_ID]) REFERENCES [TBL_PARA_TIPI]([TBL_PARA_TIPI_ID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO