【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了kfgl.sql提供大家参考,希望对大家有所帮助!
CREATE TABLE AccountTable (
AccountName CHAR ( 10 ) NOT NULL,
AccountPass
word CHAR ( 10 ) NOT NULL,
AccountRight CHAR ( 10 ) NOT NULL,
CONSTRAINT PK_AccountTable7 PRIMARY KEY NONCLUSTERED (AccountName)
)
GO
/*保存库存记录的数据表类*/
CREATE TABLE StockTable (
itemName CHAR ( 10 ) NOT NULL,
ItemNumber INT NOT NULL,
Price FLOAT ( 2 ) NOT NULL,
Position CHAR ( 30 ) NOT NULL,
ItemNo CHAR ( 10 ) NOT NULL,
CONSTRAINT PK_StockTable9 PRIMARY KEY NONCLUSTERED (ItemNo)
)
GO
/*保存入库记录的数据表类*/
CREATE TABLE InStockTable (
InNo CHAR ( 10 ) NOT NULL,
inBuier CHAR ( 10 ),
InDate DATETIME NOT NULL,
inChecker CHAR ( 10 ),
StockName CHAR ( 10 ) NOT NULL,
InPrice FLOAT ( 2 ),
inNumber INT,
inPosition CHAR ( 40 ),
Type CHAR ( 10 ) NOT NULL,
Note TEXT,
ItemNo CHAR ( 10 ) NOT NULL,
Status CHAR ( 10 ) DEFAULT '未入库' NOT NULL
)
GO
/*保存物品编号信息的数据表类*/
CREATE TABLE ItemTable (
ItemName CHAR ( 10 ) NOT NULL,
ItemType CHAR ( 30 ) NOT NULL,
Note TEXT,
upLimit INT,
DownLimit INT,
ItemNo CHAR ( 10 ) NOT NULL,
CONSTRAINT PK_ItemTable8 PRIMARY KEY NONCLUSTERED (ItemNo)
)
GO
/*保存出库记录的*/
CREATE TABLE OutStockTable (
OutNo CHAR ( 10 ) NOT NULL,
Supplier CHAR ( 10 ) NOT NULL,
OutDate DATETIME NOT NULL,
outPrice FLOAT ( 2 ),
outNumber INT,
ItemName CHAR ( 10 ),
type CHAR ( 10 ) NOT NULL,
OutNote TEXT,
ItemNo CHAR ( 10 ) NOT NULL,
Status CHAR ( 10 ) DEFAULT '未出库' NOT NULL
)
GO
ALTER TABLE StockTable ADD CONSTRAINT FK_StockTable7 FOREIGN KEY (ItemNo) REFERENCES ItemTable (ItemNo)
GO
ALTER TABLE InStockTable ADD CONSTRAINT FK_InStockTable6 FOREIGN KEY (ItemNo) REFERENCES ItemTable (ItemNo)
GO
ALTER TABLE OutStockTable ADD CONSTRAINT FK_OutStockTable5 FOREIGN KEY (ItemNo) REFERENCES ItemTable (ItemNo)
GO