Sql
CREATE TABLE [dbo].[EmployeeTBL] (
[id] INT IDENTITY (1, 1) NOT NULL,
[codeMeli] NVARCHAR (20) NULL,
[name] NVARCHAR (100) NULL,
[family] NVARCHAR (150) NULL,
[fatherName] NVARCHAR (100) NULL,
[dob] NVARCHAR (10) NULL,
[telephone] NVARCHAR (20) NULL,
[address] NVARCHAR (500) NULL,
[tarikhEstekhdam] NVARCHAR (10) NULL,
CONSTRAINT [PK_EmployeeTBL] PRIMARY KEY CLUSTERED ([id] ASC)
);
CREATE TABLE [dbo].[DarajeVahedTBL] (
[id] INT IDENTITY (1, 1) NOT NULL,
[title] NVARCHAR (50) NOT NULL,
CONSTRAINT [PK_DarajeVahedTBL] PRIMARY KEY CLUSTERED ([id] ASC)
);
CREATE TABLE [dbo].[CustomerTBL] (
[id] INT IDENTITY (1, 1) NOT NULL,
[codeShenasaee] INT NOT NULL,
[darajeVahed] INT NOT NULL,
[noeFaliat] NVARCHAR (50) NULL,
[nameVahed] NVARCHAR (100) NULL,
[nameMoshtari] NVARCHAR (100) NOT NULL,
[telephone] NVARCHAR (20) NULL,
[address] NVARCHAR (500) NULL,
[rangPooshe] INT NULL,
[copyCartMeli] BIT NULL,
[copyPayanKhedmat] BIT NULL,
[copyShenasname] BIT NULL,
[copySanad] BIT NULL,
[madrakTahsili] NVARCHAR (50) NULL,
[madrakShoghli] NVARCHAR (50) NULL,
[ezharnazar] BIT NULL,
[mafasahesab] BIT NULL,
[ax] BIT NULL,
[dayereAmaken] BIT NULL,
[behdasht] BIT NULL,
[etiad] BIT NULL,
[tashkhisHoviat] BIT NULL,
[ebtalTambr] BIT NULL,
[fishVarizi] BIT NULL,
[otaghasnafIran] BIT NULL,
[otaghAsnafHamedan] BIT NULL,
[sodoorParvane] BIT NULL,
[fishShoraAsnaf] BIT NULL,
[haghOzviat] BIT NULL,
CONSTRAINT [PK_CustomerTBL] PRIMARY KEY CLUSTERED ([id] ASC)
);