text: ﻿CREATE TABLE [dbo].[Employee] (
      [EmployeeId] INT           IDENTITY (1, 1) NOT NULL,
      [LastName]   NVARCHAR (20) NOT NULL,
      [FirstName]  NVARCHAR (20) NOT NULL,
      [Title]      NVARCHAR (30) NULL,
      [ReportsTo]  INT           NULL,
      [BirthDate]  DATETIME      NULL,
      [HireDate]   DATETIME      NULL,
      [Address]    NVARCHAR (70) NULL,
      [City]       NVARCHAR (40) NULL,
      [State]      NVARCHAR (40) NULL,
      [Country]    NVARCHAR (40) NULL,
      [PostalCode] NVARCHAR (10) NULL,
      [Phone]      NVARCHAR (24) NULL,
      [Fax]        NVARCHAR (24) NULL,
      [Email]      NVARCHAR (60) NULL,
      PRIMARY KEY CLUSTERED ([EmployeeId] ASC),
      FOREIGN KEY ([ReportsTo]) REFERENCES [dbo].[Employee] ([EmployeeId])
  );
  
  
  GO
  CREATE NONCLUSTERED INDEX [IPK_Employee]
      ON [dbo].[Employee]([EmployeeId] ASC);
  
  
  GO
  CREATE NONCLUSTERED INDEX [IFK_Employee_ReportsTo]
      ON [dbo].[Employee]([ReportsTo] ASC);
  
  