Stok_Takip Sql Veritabanı

CREATE TABLE [dbo].[faturadetaybil](
[faturaId] [nvarchar](max) NULL,
[urunId] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE TABLE [dbo].[firmabil](
[firmaId] [bigint] IDENTITY(1,1) NOT NULL,
[firmaAdi] [nvarchar](max) NULL,
[firmaAdresi] [nvarchar](max) NULL,
 CONSTRAINT [PK_firmabil] PRIMARY KEY CLUSTERED
(
[firmaId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [dbo].[kasiyergorevbil](
[kasiyerId] [nvarchar](max) NULL,
[gorevBaslangici] [nvarchar](max) NULL,
[gorevBitimi] [nvarchar](max) NULL,
[kasaNo] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [dbo].[kasiyerbil](
[kasiyerId] [bigint] IDENTITY(1,1) NOT NULL,
[ad] [nvarchar](max) NULL,
[soyad] [nvarchar](max) NULL,
[tcKimlik] [nvarchar](max) NULL,
[cepTel] [nvarchar](max) NULL,
[evTel] [nvarchar](max) NULL,
[adres] [nvarchar](max) NULL,
[maas] [nvarchar](max) NULL,
[kasaNo] [nvarchar](max) NULL,
[gorevBaslangici] [nvarchar](max) NULL,
[gorevBitimi] [nvarchar](max) NULL,
 CONSTRAINT [PK_kasiyerbil] PRIMARY KEY CLUSTERED
(
[kasiyerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE TABLE [dbo].[kategoribil](
[kategoriId] [bigint] IDENTITY(1,1) NOT NULL,
[kategoriAdi] [nvarchar](max) NULL,
 CONSTRAINT [PK_kategoribil] PRIMARY KEY CLUSTERED
(
[kategoriId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [dbo].[urunbil](
[urunId] [bigint] IDENTITY(1,1) NOT NULL,
[urunAdi] [nvarchar](max) NULL,
[urunKodu] [nvarchar](max) NULL,
[firmaAdi] [nvarchar](max) NULL,
[alisFiyati] [nvarchar](max) NULL,
[satisFiyati] [nvarchar](max) NULL,
[kategori] [nvarchar](max) NULL,
 CONSTRAINT [PK_urunbil] PRIMARY KEY CLUSTERED
(
[urunId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE TABLE [dbo].[stokbil](
[stokId] [bigint] IDENTITY(1,1) NOT NULL,
[urunAdi] [nvarchar](max) NULL,
[adet] [int] NULL,
[birimFiyat] [nvarchar](max) NULL,
[kdv] [nvarchar](max) NULL,
[satisFiyat] [nvarchar](max) NULL,
 CONSTRAINT [PK_stokbil] PRIMARY KEY CLUSTERED
(
[stokId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE TABLE [dbo].[satisbil](
[faturaId] [bigint] IDENTITY(1,1) NOT NULL,
[faturaNo] [nvarchar](max) NULL,
[musteriAdi] [nvarchar](max) NULL,
[musteriSoyadi] [nvarchar](max) NULL,
[tcKimlik] [nvarchar](max) NULL,
[urunAdi] [nvarchar](max) NULL,
[satisFiyat] [nvarchar](max) NULL,
[adet] [nvarchar](max) NULL,
[toplamTutar] [nvarchar](max) NULL,
[kasaNo] [nvarchar](max) NULL,
[tarih] [nvarchar](max) NULL,
 CONSTRAINT [PK_satisbil_1] PRIMARY KEY CLUSTERED
(
[faturaId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE TABLE [dbo].[musteribil](
[musteriId] [bigint] IDENTITY(1,1) NOT NULL,
[musteriAdi] [nvarchar](max) NULL,
[musteriSoyadi] [nvarchar](max) NULL,
[tcKimlik] [nvarchar](max) NULL,
[cepTel] [nvarchar](max) NULL,
[evTel] [nvarchar](max) NULL,
[adres] [nvarchar](max) NULL,
 CONSTRAINT [PK_musteribil] PRIMARY KEY CLUSTERED
(
[musteriId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO