[PHP與進銷存管理系統]-MySQL資料表介紹整理(06)

p9-7

 

 

採購產品資料表：

—
— 資料表格式： `purchase`
—

CREATE TABLE `purchase` (
`purchtranno` varchar(10) NOT NULL,
`purchprodno` varchar(10) NOT NULL,
`purchprodqty` int(6) NOT NULL,
`purchinqty` int(6) NOT NULL,
`purchpric` int(6) NOT NULL,
`purchunit` varchar(10) NOT NULL,
`purchprodname` varchar(40) NOT NULL,
PRIMARY KEY (`purchtranno`,`purchprodno`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

 

 

採購資料表：

—
— 資料表格式： `purchmst`
—

CREATE TABLE `purchmst` (
`purcmtranno` varchar(10) NOT NULL,
`purcmvend` varchar(10) NOT NULL,
`purcmdate` date NOT NULL,
`purcmtype` varchar(10) NOT NULL,
`purcmvendname` varchar(40) NOT NULL,
PRIMARY KEY (`purcmtranno`)
) ENGINE=MyISAM DEFAULT CHARSET=big5