CREATE TABLE OnlineRetailStage(
StageKey INT IDENTITY(1,1) NOT NULL,
SalesKey INT NULL,
DateKey INT NULL,
LocationKey INT NULL,
CustomerKey INT NULL,
ProductKey INT null,
StoreKey INT null,
PromotionKey INT null,
Source_ID int NULL,
customer_id nvarchar(max) NULL,
tran_amount_2022 float NULL,
tran_amount_2023 float NULL,
tran_amount_2024 float NULL,
transactions_2022 float NULL,
transactions_2023 float NULL,
transactions_2024 float NULL,
First_Transaction date NULL,
Last_Transaction date NULL,
SalesRep nvarchar(max) NULL,
Region nvarchar(max) NULL,
Month nvarchar(max) NULL,
Sales float NULL,
Units_Sold float NULL,
Gender nvarchar(max) NULL,
Age INT NULL,
Annual_Income float NULL,
Spending_Score int NULL,
product_Name nvarchar(max) NULL,
mrp float NULL,
price float NULL,
brand_name nvarchar(max) NULL,
product_category nvarchar(max) NULL,
retailer nvarchar(max) NULL,
description nvarchar(max) NULL,
rating float NULL,
review_Count int NULL,
style_Attributes nvarchar(max) NULL,
total_Sizes nvarchar(max) NULL,
available_Size nvarchar(max) NULL,
color nvarchar(max) NULL,
Store_id int NULL,
sitename nvarchar(max) NULL,
location nvarchar(max) NULL,
Region2 nvarchar(max) NULL,
Address nvarchar(max) NULL,
zipcode int NULL,
PromotionType nvarchar(max) NULL,
Promotion_ID int NULL,
Promotion_Begin_Date date NULL,
Promotion_End_Date date NULL,
Order_Numer int NULL,
Invoice_Number int NULL);