数据库课程设计再续(二)
IMARY KEY CLUSTERED
(
[Goods_num] ASC,
[BILL_num] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[bill2] ([Goods_num], [BILL_num], [bill_sum]) VALUES (N'1 ', N'2010010101', 1)
INSERT [dbo].[bill2] ([Goods_num], [BILL_num], [bill_sum]) VALUES (N'1 ', N'2010010102', 3)
INSERT [dbo].[bill2] ([Goods_num], [BILL_num], [bill_sum]) VALUES (N'2 ', N'2010010101', 2)
INSERT [dbo].[bill2] ([Goods_num], [BILL_num], [bill_sum]) VALUES (N'3 ', N'2010010102', 4)
/****** Object: Check [MemberSex] Script Date: 12/26/2014 17:54:54 ******/
ALTER TABLE [dbo].[Member] WITH CHECK ADD CONSTRAINT [MemberSex] CHECK (([MemberSex]='男' OR [MemberSex]='女'))
GO
ALTER TABLE [dbo].[Member] CHECK CONSTRAINT [MemberSex]
GO
/****** Object: ForeignKey [FK__BILL__MemberID__060DEAE8] Script Date: 12/26/2014 17:54:54 ******/
ALTER TABLE [dbo].[BILL] WITH CHECK ADD FOREIGN KEY([MemberID])
REFERENCES [dbo].[Member] ([MemberID])
GO
/****** Object: ForeignKey [FK__bill2__BILL_num__1273C1CD] Script Date: 12/26/2014 17:54:54 ******/
ALTER TABLE [dbo].[bill2] WITH CHECK ADD FOREIGN KEY([BILL_num])
REFERENCES [dbo].[BILL] ([BILL_num])
GO
/****** Object: ForeignKey [FK__bill2__Goods_num__117F9D94] Script Date: 12/26/2014 17:54:54 ******/
ALTER TABLE [dbo].[bill2] WITH CHECK ADD FOREIGN KEY([Goods_num])
REFERENCES [dbo].[Goods] ([Goods_num])
GO
/****** Object: ForeignKey [FK__Customers__BILL___0AD2A005] Script Date: 12/26/2014 17:54:54 ******/
ALTER TABLE [dbo].[Customers] WITH CHECK ADD FOREIGN KEY([BILL_num])
REFERENCES [dbo].[BILL] ([BILL_num])
GO
截图如下：