ari.Mitarbeiter.sql 622 B

1234567891011121314151617181920
  1. CREATE TABLE [ari].[Mitarbeiter] (
  2. [Client_DB] [varchar](20) NOT NULL,
  3. [Employee No_] [varchar](20) NOT NULL,
  4. [Name] [varchar](100) NULL,
  5. [First Name] [varchar](100) NULL,
  6. [Last Name] [varchar](100) NULL,
  7. [Leaving Date] [varchar](20) NULL,
  8. [Task Type Group] [varchar](20) NULL,
  9. [Function Code] [varchar](20) NULL,
  10. [Group No_ 1] [varchar](20) NULL,
  11. [Group No_ 2] [varchar](20) NULL,
  12. [Group No_ 3] [varchar](20) NULL,
  13. [Monteur_Gruppe] [varchar](50) NULL,
  14. [Monteur_Gruppe_2] [varchar](50) NULL
  15. ,CONSTRAINT [PK_Mitarbeiter] PRIMARY KEY CLUSTERED ([Client_DB], [Employee No_])
  16. )
  17. GO