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)

);