Zi 字媒體

[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;