【正文】 男 39。 c) 字段 命名：全部采用英文結(jié)合數(shù)字，字母在前，數(shù)字在后，單詞首字母采用英文大寫字母，長單詞取單詞縮寫，縮寫單詞之間采用下劃線連接，名稱取 _Na,編號 _Id，時(shí)間取 _Ti 等。), [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ù)庫設(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 NOT NULL, [Pro_Area] [char](15) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Addr] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Tel] [text] COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Site] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Fax] [varchar](9) COLLATE Chinese_PRC_CI_AS NOT NULL, [Mater_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_providers] PRIMARY KEY CLUSTERED ( [Pro_Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[providers] WITH CHECK ADD CONSTRAINT [FK_providers_material] FOREIGN KEY([Mater_Id]) REFERENCES [dbo].[material] ([Mater_Id]) 表格 purchase_ord CREATE TABLE [dbo].[purchase_ord]( [Purch_Id] [char](15) COLLATE Chinese_PRC_CI_AS NOT