[PHP與進銷存管理系統]-MySQL資料表介紹整理(06)
[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