dbmyshop - lethaiduy/MY-SHOP GitHub Wiki

USE [myshopdb] GO /****** Object: Table [dbo].[Admin] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Admin]( [admin_id] [int] NOT NULL, [full_name] nvarchar NULL, [cellphone] [int] NULL, [address] nvarchar NULL, [email] nvarchar NULL, [username] nvarchar NULL, [password] nvarchar NULL, CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED ( [admin_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Cart_Prod] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Cart_Prod]( [id] [int] NOT NULL, [cart_id] [int] NOT NULL, [prod_id] [int] NULL, [quantity] [int] NULL, CONSTRAINT [PK_Cart_Prod] PRIMARY KEY CLUSTERED ( [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 /****** Object: Table [dbo].[Cart_Shoping] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Cart_Shoping]( [cart_id] [int] NOT NULL, CONSTRAINT [PK_Cart_Shoping] PRIMARY KEY CLUSTERED ( [cart_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 /****** Object: Table [dbo].[Customer] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Customer]( [customer_id] [int] NOT NULL, [fullname] nvarchar NULL, [address] nvarchar NULL, [cellphone] [int] NULL, [email] nvarchar NULL, [username] nvarchar NULL, [password] nvarchar NULL, CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED ( [customer_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Detail_Order] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Detail_Order]( [detail_id] [int] NOT NULL, [prod_id] [int] NULL, [order_id] [int] NULL, [quantity] [int] NULL, CONSTRAINT [PK_Detail_Order] PRIMARY KEY CLUSTERED ( [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]

GO /****** Object: Table [dbo].[method_payment] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[method_payment]( [method_id] [int] NOT NULL, [method_name] nvarchar NULL, CONSTRAINT [PK_method_payment] PRIMARY KEY CLUSTERED ( [method_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[News] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[News]( [news_id] [int] NOT NULL, [title] nvarchar NULL, [date_sub] [datetime] NULL, [detail] [text] NULL, CONSTRAINT [PK_News] PRIMARY KEY CLUSTERED ( [news_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Order] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Order]( [order_id] [int] NOT NULL, [total_money] [decimal](18, 0) NULL, [date_order] [datetime] NULL, [status] nvarchar NULL, [method_delivery_id] [int] NULL, [cutomer_id] [int] NOT NULL, [cart_id] [int] NULL, CONSTRAINT [PK_Order] 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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Prod_Prom] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Prod_Prom]( [id] [int] NOT NULL, [prom_id] [int] NOT NULL, [prod_id] [int] NOT NULL, CONSTRAINT [PK_Prod_Prom_1] PRIMARY KEY CLUSTERED ( [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 /****** Object: Table [dbo].[Prod_Size] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Prod_Size]( [size_id] [int] NOT NULL, [prod_id] [int] NULL, CONSTRAINT [PK_Prod_Size] PRIMARY KEY CLUSTERED ( [size_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 /****** Object: Table [dbo].[Product] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product]( [prod_id] [int] NOT NULL, [prod_name] nvarchar NULL, [pic] binary NULL, [brand] nvarchar NULL, [fabric] nvarchar NULL, [price] [decimal](18, 0) NULL, [quantity] nvarchar NULL, [Prod_Grp_Id] [int] NULL, CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED ( [prod_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Product_Grp] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_Grp]( [pro_grp_id] [int] NOT NULL, [pro_Grp_name] nvarchar NULL, CONSTRAINT [PK_Product_Grp] PRIMARY KEY CLUSTERED ( [pro_grp_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Promotion] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Promotion]( [prom_Id] [int] NOT NULL, [prom_Name] nvarchar NULL, [date_Start] [datetime] NULL, [date_Finish] [datetime] NULL, [pers_disc] [int] NULL, CONSTRAINT [PK_Promotion] PRIMARY KEY CLUSTERED ( [prom_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] TEXTIMAGE_ON [PRIMARY]

GO /****** Object: Table [dbo].[Size] Script Date: 10/26/2018 11:27:57 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Size]( [size_id] [int] NOT NULL, [size_name] nvarchar NULL, CONSTRAINT [PK_Size] PRIMARY KEY CLUSTERED ( [size_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] TEXTIMAGE_ON [PRIMARY]

GO ALTER TABLE [dbo].[Cart_Prod] WITH CHECK ADD CONSTRAINT [FK_Cart_Prod_Cart_Shoping] FOREIGN KEY([cart_id]) REFERENCES [dbo].[Cart_Shoping] ([cart_id]) GO ALTER TABLE [dbo].[Cart_Prod] CHECK CONSTRAINT [FK_Cart_Prod_Cart_Shoping] GO ALTER TABLE [dbo].[Cart_Prod] WITH CHECK ADD CONSTRAINT [FK_Cart_Prod_Product] FOREIGN KEY([prod_id]) REFERENCES [dbo].[Product] ([prod_id]) GO ALTER TABLE [dbo].[Cart_Prod] CHECK CONSTRAINT [FK_Cart_Prod_Product] GO ALTER TABLE [dbo].[Detail_Order] WITH CHECK ADD CONSTRAINT [FK_Detail_Order_Order] FOREIGN KEY([order_id]) REFERENCES [dbo].[Order] ([order_id]) GO ALTER TABLE [dbo].[Detail_Order] CHECK CONSTRAINT [FK_Detail_Order_Order] GO ALTER TABLE [dbo].[Detail_Order] WITH CHECK ADD CONSTRAINT [FK_Detail_Order_Product] FOREIGN KEY([prod_id]) REFERENCES [dbo].[Product] ([prod_id]) GO ALTER TABLE [dbo].[Detail_Order] CHECK CONSTRAINT [FK_Detail_Order_Product] GO ALTER TABLE [dbo].[Order] WITH CHECK ADD CONSTRAINT [FK_Order_Cart_Shoping] FOREIGN KEY([cart_id]) REFERENCES [dbo].[Cart_Shoping] ([cart_id]) GO ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Cart_Shoping] GO ALTER TABLE [dbo].[Order] WITH CHECK ADD CONSTRAINT [FK_Order_Customer] FOREIGN KEY([cutomer_id]) REFERENCES [dbo].[Customer] ([customer_id]) GO ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Customer] GO ALTER TABLE [dbo].[Order] WITH CHECK ADD CONSTRAINT [FK_Order_method_payment] FOREIGN KEY([method_delivery_id]) REFERENCES [dbo].[method_payment] ([method_id]) GO ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_method_payment] GO ALTER TABLE [dbo].[Prod_Prom] WITH CHECK ADD CONSTRAINT [FK_Prod_Prom_Product] FOREIGN KEY([id]) REFERENCES [dbo].[Product] ([prod_id]) GO ALTER TABLE [dbo].[Prod_Prom] CHECK CONSTRAINT [FK_Prod_Prom_Product] GO ALTER TABLE [dbo].[Prod_Prom] WITH CHECK ADD CONSTRAINT [FK_Prod_Prom_Promotion] FOREIGN KEY([prom_id]) REFERENCES [dbo].[Promotion] ([prom_Id]) GO ALTER TABLE [dbo].[Prod_Prom] CHECK CONSTRAINT [FK_Prod_Prom_Promotion] GO ALTER TABLE [dbo].[Prod_Size] WITH CHECK ADD CONSTRAINT [FK_Prod_Size_Product] FOREIGN KEY([prod_id]) REFERENCES [dbo].[Product] ([prod_id]) GO ALTER TABLE [dbo].[Prod_Size] CHECK CONSTRAINT [FK_Prod_Size_Product] GO ALTER TABLE [dbo].[Prod_Size] WITH CHECK ADD CONSTRAINT [FK_Prod_Size_Size] FOREIGN KEY([size_id]) REFERENCES [dbo].[Size] ([size_id]) GO ALTER TABLE [dbo].[Prod_Size] CHECK CONSTRAINT [FK_Prod_Size_Size] GO ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_Product_Grp] FOREIGN KEY([Prod_Grp_Id]) REFERENCES [dbo].[Product_Grp] ([pro_grp_id]) GO ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Product_Grp] GO