CREATE TABLE [dbo].[DimOrderPriority](
    [order_priority_id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](50) NULL,
 CONSTRAINT [PK_DimOrderPriority] PRIMARY KEY CLUSTERED
(
    [order_priority_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DimShipMode](
    [ship_mode_id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](50) NULL,
 CONSTRAINT [PK_DimShipMode] PRIMARY KEY CLUSTERED
(
    [ship_mode_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[FactOrderDetails](
    [order_detail_id] [INT] IDENTITY(1,1) NOT NULL,
    [order_id] [INT] NULL,
    [quantity] [INT] NULL,
    [sales] [FLOAT] NULL,
    [discount] [FLOAT] NULL,
    [ship_mode_id] [INT] NULL,
    [profit] [FLOAT] NULL,
    [shipping_cost] [FLOAT] NULL,
    [ship_date_id] [INT] NULL,
 CONSTRAINT [PK_FactOrderDetails] PRIMARY KEY CLUSTERED
(
    [order_detail_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[FactOrders](
    [order_id] [INT] NOT NULL,
    [order_date_id] [INT] NULL,
    [order_priority_id] [INT] NULL,
    [customer_id] [INT] NULL,
    [province_id] [INT] NULL,
    [customer_segment_id] [INT] NULL,
 CONSTRAINT [PK_FactOrders] PRIMARY KEY CLUSTERED
(
    [order_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DimOrderDate](
    [order_date_id] [INT] IDENTITY(1,1) NOT NULL,
    [YEAR] [INT] NULL,
    [MONTH] [INT] NULL,
    [DAY] [INT] NULL,
 CONSTRAINT [PK_DimOrderDate] PRIMARY KEY CLUSTERED
(
    [order_date_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DimShipDate](
    [ship_date_id] [INT] IDENTITY(1,1) NOT NULL,
    [YEAR] [INT] NULL,
    [MONTH] [INT] NULL,
    [DAY] [INT] NULL,
 CONSTRAINT [PK_DimShipDate] PRIMARY KEY CLUSTERED
(
    [ship_date_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO