ETL_DWH_ARI/schema/GC_TRANSIT_ARI/tables/import.Employee_T.sql

CREATE TABLE [import].[Employee_T] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Last Name] [varchar](50) NOT NULL,
   [First Name] [varchar](50) NOT NULL,
   [Leaving Date] [datetime] NOT NULL,
   [Department No_] [varchar](10) NOT NULL,
   [Company No_] [varchar](10) NOT NULL,
   [Group No_ 1] [varchar](20) NOT NULL,
   [Group No_ 2] [varchar](20) NOT NULL,
   [Group No_ 3] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Employee_T$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)

CREATE UNIQUE NONCLUSTERED INDEX [$16] ON [import].[Employee_T] ([Client_DB], [Company No_], [Name], [No_])

GO