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

p7-6

報價資料表:

 

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

 

CREATE TABLE `quotationwork` (
`quwkno` varchar(10) NOT NULL,
`quwkprod` varchar(10) NOT NULL,
`quwkcust` varchar(10) NOT NULL,
`quwktype` varchar(10) NOT NULL,
`quwkpric` int(6) NOT NULL,
`quwkqty` int(6) NOT NULL,
`quwksqty` int(6) NOT NULL,
`quwksdate` date NOT NULL,
`quwkunit` varchar(10) NOT NULL,
`quwkprodname` varchar(40) NOT NULL,
`quwkcustname` varchar(40) NOT NULL,
PRIMARY KEY (`quwkno`,`quwkprod`,`quwkcust`),
KEY `quwkcust` (`quwkcust`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;