【文章內(nèi)容簡介】 nt8主鍵NOT NULL供應(yīng)商編號PrNameVarchar100否NULL供應(yīng)商名稱PrPeopleVarchar20否NULL聯(lián)系人PrPhoneVarchar20否NULL聯(lián)系電話PrFaxVarchar20否NULL傳真PrRemarkVarchar100否NULL備注EditerVarchar20否NULL記錄修改人EditDatedatetime8否NULL修改日期，即為供應(yīng)商實體的基本屬性。其中供應(yīng)商編號PrID為候選碼(Candidate key)，根據(jù)實體完整性規(guī)則，它不能為空且唯一標(biāo)識一個供應(yīng)商元組。由于只有一個候選碼，故PrID為主碼(Primary key)。由于選擇了供應(yīng)商編號PrID為主碼，則不允許供應(yīng)商編號重復(fù)。其它七個屬性為非碼屬性，是可以為空的。建表程序代碼如下：CREATE TABLE [dbo].[tb_Provider]( [PrID] [bigint] IDENTITY(1,1) NOT NULL, [PrName] [varchar](100) NOT NULL, [PrPeople] [varchar](20) NULL, [PrPhone] [varchar](20) NULL, [PrFax] [varchar](20) NULL, [PrRemark] [varchar](1000) NULL, [Editer] [varchar](20) NULL, [EditDate] [datetime] NULL, CONSTRAINT [PK_tb_Provider] PRIMARY KEY CLUSTERED ( [PrID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]:表 列名數(shù)據(jù)類型長度主外鍵可否為空說明GoodsIDbigint8主鍵NOT NULL貨物編號GoodsNameVarchar50否NULL貨物名稱StoreNameVarchar100否NULL倉庫名稱GoodsSpecvarchar50否NULL貨物規(guī)格GoodsUnitchar8否NULL計量單位GoodsNumbigint8否NULL貨物數(shù)量GoodsInPricemoney8否NULL貨物入庫價格GoodsOutPricemoney8否NULL貨物出庫價格GoodsLeastbigint8否NULL貨物底線存儲GoodsMostbigint8否NULL貨物頂線存儲 Editervarchar20否NULL記錄修改人EditDatedatetime8否NULL修改日期，即為貨物實體的基本屬性。其中GoodsID(貨物編號)為候選碼， 它不能為空且它們唯一標(biāo)識一個貨物信息元組。由于只有一個候選碼， GoodsID即為主碼。由于選擇了公司名稱GoodsID為主碼，則不允許貨物編號重復(fù)。其它十一個屬性為非碼屬性，是可以為空的。建表程序代碼如下：CREATE TABLE [dbo].[tb_GoodsInfo]( [GoodsName] [varchar](50) NULL, [StoreName] [varchar](100) NULL, [GoodsSpec] [varchar](50) NULL, [GoodsUnit] [char](8) NULL, [GoodsNum] [bigint] NULL, [GoodsInPrice] [money] NULL, [GoodsOutPrice] [money] NULL, [GoodsLeast] [bigint] NULL, [GoodsMost] [bigint] NULL, [Editer] [varchar](20) NULL, [EditDate] [datetime] NULL) ON [PRIMARY]: 表 列名數(shù)據(jù)類型長度主外鍵可否為空說明StoreIDbigint8主鍵NOT NULL倉庫編號StoreNameVarchar100主鍵NULL倉庫名稱StorePeopleVarchar20否NULL負(fù)責(zé)人StorePhoneVarchar20否NULL倉庫電話StoreUnitVarchar1000否NULL所屬單位StoreDatedatetime8否NULL操作日期StoreRemarkVarchar1000否NULL備注EditerVarchar20否NULL記錄修改人EditDatedatetime8否NULL修改日期，即為倉庫實體的基本屬性。其中StoreID (倉庫編號)為候選碼，它唯一標(biāo)識一個倉庫信息元組，不能夠為空。由于只有一個候選碼StoreID即為主碼。由于StoreID為主碼，倉庫編號不能夠重復(fù)。其它七個屬性為非碼屬性，可以為空。建表程序代碼如下：CREATE TABLE [dbo].[tb_Storage]( [StoreID] [bigint] IDENTITY(1,1) NOT NULL, [StoreName] [varchar](100) NOT NULL, [StorePeople] [varchar](20) NULL, [StorePhone] [varchar](20) NULL, [StoreUnit] [varchar](100) NULL, [StoreDate] [datetime] NULL, [StoreRemark] [varchar](1000) NULL, [Editer] [varchar](20) NULL, [EditDate] [datetime] NULL, CONSTRAINT [PK_tb_Storage] PRIMARY KEY CLUSTERED ( [StoreID] ASC, [StoreName] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]表 列名數(shù)據(jù)類型長度主外鍵可否為空說明ISIDbigint8主鍵NOT NULL入庫編號GoodsIDbigint8否NULL貨物編號GoodsNameVarchar50否NULL貨物名稱PrNameVarchar100否NULL供應(yīng)商名稱StoreNameVarchar100否NULL倉庫名稱GoodsSpecVarchar50否NULL貨物規(guī)格GoodsUnitchar8否NULL計量單位GoodsNumbigint8否NULL入庫數(shù)量GoodsPricemoney8否NULL入庫價格GoodsAPricemoney8否NULL入庫總金額ISDatedatetime8否NULL入庫日期HandlePeopleVarchar20否NULL經(jīng)手人ISRemarkVarchar1000否NULL備注，分別表示入庫編號，貨物編號，貨物名稱，供應(yīng)商名稱，倉庫名稱，貨物規(guī)格，計量單位，入庫數(shù)量，入庫價格，入庫總金額，入庫日期，經(jīng)手人和備注。其中ISID (入庫編號)為主碼，不能夠為空。其它12項為非碼屬性，可以為空。建表程序如下：CREATE TABLE [dbo].[tb_InStore]( [ISID] [bigint] IDENTITY(1,1) NOT NULL, [GoodsID] [bigint] NULL, [GoodsName] [varchar](50) NULL, [PrName] [varchar](100) NULL, [StoreName] [varchar](100) NULL, [GoodsSpec] [varchar](50) NULL, [GoodsUnit] [char](8) NULL, [GoodsNum] [bigint] NULL, [GoodsPrice] [money] NULL, [GoodsAPrice] AS ([GoodsNum] * [GoodsPrice]), [ISDate] [datetime] NULL, [HandlePeople] [varchar](20) NULL, [ISRemark] [varchar](1000) NULL, CONSTRAINT [PK_tb_InStore] PRIMARY KEY CLUSTERED ( [ISID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]: 表 列名數(shù)據(jù)類型長度主外鍵可否為空說明OSIDbigint8主鍵NOT NULL出庫編號StoreNameVarchar100否NULL倉庫名稱GoodsNameVarchar50否NULL貨物名稱GoodsSpecVarchar50否NULL貨物規(guī)格GoodsUnitchar8否NULL計量單位GoodsNumbigint8否NULL出庫數(shù)量GoodsPricemoney8否NULL出庫價格GoodsAPricebigint8否NULL出庫總金額OSDatedatetime8否NULL出庫日期PGProviderVarchar100否NULL提貨單位PGPeopleVarchar20否NULL提貨人HandlePeopleVarchar20否NULL經(jīng)手人OSRemarkVarchar1000否NULL備注，分別表示出庫編號，倉庫名稱，貨物名稱，貨物規(guī)格，計量單位，出庫數(shù)量，出庫價格，出庫總金額，出庫日期，提貨單位，提貨人，經(jīng)手人，備注。其中OSID (出庫編號)為主碼。不能夠為空。其它12項為非碼屬性，可以為空。建表程序如下：CREATE TABLE [dbo].[tb_OutStore]( [OSID] [bigint] IDENTITY(1,1) NOT NULL, [StoreName] [varchar](100) NULL, [GoodsName] [varchar](50) NULL, [GoodsSpec] [varchar](50) NULL, [GoodsUnit] [char](8) NULL, [GoodsNum] [bigint] NULL, [GoodsPrice] [money] NULL, [GoodsAPrice] AS ([GoodsNum] * [GoodsPrice]), [OSDate] [datetime] NULL, [PGProvider] [varchar](100) NULL, [PGPeople] [varchar](20) NULL, [HandlePeople] [varchar](20) NULL, [OSRemark] [varchar](1000) NULL, CONSTRAINT [PK_tb_OutStore] PRIMARY KEY CLUSTERED ( [OSID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]表 列名數(shù)據(jù)類型長度主外鍵可否為空說明BGIDbigint8主鍵NOT NULL借貨編號GoodsNameVarchar50否NULL