Zi 字媒體
2017-07-25T20:27:27+00:00
[PHP與進銷存管理系統]-MySQL資料表介紹整理(02)
p5-11
客戶類別代碼:
— — 資料表格式: `cuty`—
CREATE TABLE `cuty` ( `cutyno` varchar(10) NOT NULL, `cutyname` varchar(40) NOT NULL, PRIMARY KEY (`cutyno`)) ENGINE=MyISAM DEFAULT CHARSET=big5;
廠商類別代碼:
— — 資料表格式: `vety`—
CREATE TABLE `vety` ( `vetyno` varchar(10) NOT NULL, `vetyname` varchar(40) NOT NULL, PRIMARY KEY (`vetyno`)) ENGINE=MyISAM DEFAULT CHARSET=big5;
產品類別代碼:
— — 資料表格式: `prty`—
CREATE TABLE `prty` ( `prtyno` varchar(10) NOT NULL, `prtyname` varchar(40) NOT NULL, PRIMARY KEY (`prtyno`)) ENGINE=MyISAM DEFAULT CHARSET=big5;
產品單位代碼:
— — 資料表格式: `prun`—
CREATE TABLE `prun` ( `prunno` varchar(10) NOT NULL, `prunname` varchar(40) NOT NULL, PRIMARY KEY (`prunno`)) ENGINE=MyISAM DEFAULT CHARSET=big5;
銷售類別代碼:
— — 資料表格式: `saty`—
CREATE TABLE `saty` ( `satyno` varchar(10) NOT NULL, `satyname` varchar(40) NOT NULL, PRIMARY KEY (`satyno`)) ENGINE=MyISAM DEFAULT CHARSET=big5;
計數器資料表:
— — 資料表格式: `counter`—
CREATE TABLE `counter` ( `counterid` varchar(2) NOT NULL default ‘1’, `vendcnt` int(6) NOT NULL default ‘1’, `custcnt` int(6) NOT NULL default ‘1’, `prodcnt` int(6) NOT NULL default ‘1’, `outicnt` int(6) NOT NULL default ‘1’, `trancnt` int(6) NOT NULL default ‘1’, `quotcnt` int(6) NOT NULL default ‘1’, `purccnt` int(6) NOT NULL default ‘1’, PRIMARY KEY (`counterid`)) ENGINE=MyISAM DEFAULT CHARSET=big5;
寫了
5860316篇文章,獲得
23313次喜歡