【正文】 REFERENCES [dbo].[emplyees] ([Empl_NO]) 表格 depository CREATE TABLE [dbo].[depository]( [Depo_Id] [char](5) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_NO] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Size_Depo] [float] NOT NULL, [Depo_Tel] [varchar](9) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_depository] PRIMARY KEY CLUSTERED ( [Depo_Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[depository] WITH CHECK ADD CONSTRAINT [FK_depository_emplyees] FOREIGN KEY([Empl_NO]) REFERENCES [dbo].[emplyees] ([Empl_NO]) ON UPDATE CASCADE 表格 emplyees CREATE TABLE [dbo].[emplyees]( [Name] [varchar](15) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_NO] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_Sex] [char](5) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_emplyees_Empl_Sex] DEFAULT (39。), [IsAdmin] [bit] NOT NULL CONSTRAINT [DF_emplyees_IsAdmin] DEFAULT ((1)), [Accounts] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [IsInsur] [bit] NOT NULL CONSTRAINT [DF_emplyees_IsInsur] DEFAULT ((1)), CONSTRAINT [PK_emplyees] PRIMARY KEY CLUSTERED ( [Empl_NO] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[emplyees] WITH CHECK ADD CONSTRAINT [FK_emplyees_deparment] FOREIGN KEY([Depar_Id]) REFERENCES [dbo].[deparment] ([Depar_Id]) 表格 material REATE TABLE [dbo].[material]( [Mater_Na] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Mater_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Mater_Pr] [float] NOT NULL, [Depos_Id] [varchar](4) COLLATE Chinese_PRC_CI_AS NOT NULL, [Stor_Date] [datetime] NOT NULL, [OutLib_Date] [datetime] NOT NULL, [Pro_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_NO] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Mater_Storage] [bigint] NOT NULL, [Mater_Shortage] [bigint] NOT NULL, CONSTRAINT [PK_material] PRIMARY KEY CLUSTERED ( [Mater_Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[material] WITH CHECK ADD CONSTRAINT [FK_material_providers] FOREIGN KEY([Pro_Id]) REFERENCES [dbo].[providers] ([Pro_Id]) 表格 products CREATE TABLE [dbo].[products]( [Prod_Na] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Prod_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Eml_No] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Area] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Prod_Model] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Prod_Class] [varchar](8) COLLATE Chinese_PRC_CI_AS NOT NULL, [Facto_Date] [datetime] NOT NULL, [Stor_Date] [datetime] NOT NULL, [Lib_Date] [datetime] NOT NULL, [Storage] [bigint] NOT NULL, [Shortage] [bigint] NOT NULL, [Sell_Id] [char](15) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_products] PRIMARY KEY CLUSTERED ( [Prod_Id] ASC XXXXXX 管理系統(tǒng) 數(shù)據(jù)庫設計者： XXXXX 20 )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [FK_products_emplyees1] FOREIGN KEY([Eml_No]) REFERENCES [dbo].[emplyees] ([Empl_NO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [FK_products_sell_ord] FOREIGN KEY([Sell_Id]) REFERENCES [dbo].[sell_ord] ([Sell_Id]) 表格 providers CREATE TABLE [dbo].[providers]( [Pro_Na] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Id] [char](20) COLLATE Chinese_PRC_CI_AS