CREATE TABLE [dbo].[Check_Dim] (
	[CheckKey] [int] NOT NULL ,
	[CheckID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Employee_Dim] (
	[EmployeeKey] [int] NOT NULL ,
	[EmployeeID] [int] NOT NULL ,
	[EmployeeName] [char] ( 25 ) COLLATE Cyrillic_General_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Hour_dim] (
	[TimeKey] [int] NOT NULL ,
	[DHour] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Mode_Dim] (
	[ModeKey] [int] NOT NULL ,
	[ModeID] [int] NOT NULL ,
	[ModeName] [char] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Product_Dim] (
	[ProductKey] [int] NOT NULL ,
	[ProductID] [int] NOT NULL ,
	[ProductName] [char] ( 20 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[CategoryName] [char] ( 20 ) COLLATE Cyrillic_General_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Sales_Fact] (
	[StoreNo] [tinyint] NULL ,
	[DOB] [datetime] NOT NULL ,
	[ModeKey] [int] NOT NULL ,
	[CheckKey] [int] NOT NULL ,
	[EmployeeKey] [int] NOT NULL ,
	[EmployeeKey2] [int] NOT NULL ,
	[ProductKey] [int] NOT NULL ,
	[Price] [money] NOT NULL ,
	[DiscPrice] [money] NOT NULL ,
	[Hour] [int] NOT NULL ,
	[Diff] [bigint] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Time_Dim] (
	[TheDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO