ETL_DWH_LOCOSOFT/schema/LOCOSOFT/tables/times.sql

CREATE TABLE [dbo].[times] (
   [employee_number] [int] NOT NULL,
   [order_number] [int] NOT NULL,
   [start_time] [datetime] NOT NULL,
   [type] [int] NULL,
   [order_positions] [varchar](50) NOT NULL
      CONSTRAINT [DF_times_order_positions] DEFAULT (''),
   [end_time] [datetime] NULL,
   [duration_minutes] [int] NULL,
   [exact_duration_seconds] [int] NULL,
   [client_db] [varchar](20) NOT NULL

   ,CONSTRAINT [times$0] PRIMARY KEY CLUSTERED ([employee_number], [order_number], [start_time], [order_positions], [client_db])
)


GO