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,
[地點(diǎn)] nchar NOT NULL,
[聯(lián)系人] 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](
[商品號(hào)] nchar NOT NULL,
[供應(yīng)商] nchar NULL,
[價(jià)格] nchar NULL,
[商品名] nchar NULL,
CONSTRAINT [PK_Table_2] PRIMARY KEY CLUSTERED
(
[商品號(hào)] 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](
[工號(hào)] nchar NOT NULL,
[姓名] nchar NULL,
[密碼] nchar NULL,
[電話] nchar NULL,
CONSTRAINT [PK_Table_3] PRIMARY KEY CLUSTERED
(
[工號(hào)] 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([工號(hào)])
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](
[流水號(hào)] nchar NOT NULL,
[收銀員工號(hào)] nchar NULL,
[商品名] nchar NULL,
[銷售時(shí)間] nchar NULL,
CONSTRAINT [PK_Table_4] PRIMARY KEY CLUSTERED
(
[商品號(hào)] 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([流水號(hào)])
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](
[工號(hào)] nchar NOT NULL,
[姓名] nchar NULL,
[密碼] nchar NULL,
[電話] nchar NULL,
CONSTRAINT [PK_Table_5] PRIMARY KEY CLUSTERED
(
[商品號(hào)] 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([工號(hào)])
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](
[流水號(hào)] nchar NOT NULL,
[庫管員工號(hào)] nchar NULL,
[銷售時(shí)間] nchar NULL,
[商品號(hào)] nchar NULL,
CONSTRAINT [PK_Table_6] PRIMARY KEY CLUSTERED
(
[商品號(hào)] 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([流水號(hào)])
REFERENCES [dbo].[Table_1] ([商品名])
GO
ALTER TABLE [dbo].[Table_2] CHECK CONSTRAINT [FK_Table_6_Table_1]
GO
