USE [STON]
GO
/****** Object: Table [dbo].[Table_1] Script Date: 04/16/2018 20:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
[代码] nchar NOT NULL,
[名称] nchar NOT NULL,
[地点] nchar NOT NULL,
[联系人] nchar NOT NULL,
[电话] nchar NOT NULL,
CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED
(
[代码] 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].[Table_2] Script Date: 04/16/2018 20:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_2](
[商品号] nchar NOT NULL,
[供应商] nchar NULL,
[价格] nchar NULL,
[商品名] nchar NULL,
CONSTRAINT [PK_Table_2] PRIMARY KEY CLUSTERED
(
[商品号] 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: ForeignKey [FK_Table_2_Table_1] Script Date: 04/16/2018 20:05:11 ******/
ALTER TABLE [dbo].[Table_2] WITH CHECK ADD CONSTRAINT [FK_Table_2_Table_1] FOREIGN KEY([代码])
REFERENCES [dbo].[Table_1] ([商品名])
GO
ALTER TABLE [dbo].[Table_2] CHECK CONSTRAINT [FK_Table_2_Table_1]
GO
/****** Object: Table [dbo].[Table_3] Script Date: 04/16/2018 20:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_3](
[工号] nchar NOT NULL,
[姓名] nchar NULL,
[密码] nchar NULL,
[电话] nchar NULL,
CONSTRAINT [PK_Table_3] PRIMARY KEY CLUSTERED
(
[工号] 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: ForeignKey [FK_Table_3_Table_1] Script Date: 04/16/2018 20:05:11 ******/
ALTER TABLE [dbo].[Table_3] WITH CHECK ADD CONSTRAINT [FK_Table_3_Table_1] FOREIGN KEY([工号])
REFERENCES [dbo].[Table_1] ([商品名])
GO
ALTER TABLE [dbo].[Table_3] CHECK CONSTRAINT [FK_Table_3_Table_1]
GO
/****** Object: Table [dbo].[Table_4] Script Date: 04/16/2018 20:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_4](
[流水号] nchar NOT NULL,
[收银员工号] nchar NULL,
[商品名] nchar NULL,
[销售时间] nchar NULL,
CONSTRAINT [PK_Table_4] PRIMARY KEY CLUSTERED
(
[商品号] 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: ForeignKey [FK_Table_4_Table_1] Script Date: 04/16/2018 20:05:11 ******/
ALTER TABLE [dbo].[Table_4] WITH CHECK ADD CONSTRAINT [FK_Table_4_Table_1] FOREIGN KEY([流水号])
REFERENCES [dbo].[Table_1] ([商品名])
GO
ALTER TABLE [dbo].[Table_4] CHECK CONSTRAINT [FK_Table_4_Table_1]
GO
/****** Object: Table [dbo].[Table_5] Script Date: 04/16/2018 20:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_5](
[工号] nchar NOT NULL,
[姓名] nchar NULL,
[密码] nchar NULL,
[电话] nchar NULL,
CONSTRAINT [PK_Table_5] PRIMARY KEY CLUSTERED
(
[商品号] 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: ForeignKey [FK_Table_5_Table_1] Script Date: 04/16/2018 20:05:11 ******/
ALTER TABLE [dbo].[Table_2] WITH CHECK ADD CONSTRAINT [FK_Table_5_Table_1] FOREIGN KEY([工号])
REFERENCES [dbo].[Table_1] ([商品名])
GO
ALTER TABLE [dbo].[Table_5] CHECK CONSTRAINT [FK_Table_5_Table_1]
GO
/****** Object: Table [dbo].[Table_5] Script Date: 04/16/2018 20:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_6](
[流水号] nchar NOT NULL,
[库管员工号] nchar NULL,
[销售时间] nchar NULL,
[商品号] nchar NULL,
CONSTRAINT [PK_Table_6] PRIMARY KEY CLUSTERED
(
[商品号] 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: ForeignKey [FK_Table_6_Table_1] Script Date: 04/16/2018 20:05:11 ******/
ALTER TABLE [dbo].[Table_6] WITH CHECK ADD CONSTRAINT [FK_Table_6_Table_1] FOREIGN KEY([流水号])
REFERENCES [dbo].[Table_1] ([商品名])
GO
ALTER TABLE [dbo].[Table_2] CHECK CONSTRAINT [FK_Table_6_Table_1]
GO
